Questions tagged [datastax-enterprise]

DataStax Enterprise is big data platform consisting of open source tools such as Apache Cassandra, Solr and Hadoop (and several others).

DataStax Enterprise is big data platform consisting of open source tools such as Apache, Cassandra, Solr and DSE Graph (and others):

  • Cassandra
  • Spark
  • Hive
  • Mahout
  • Pig
  • Solr
  • Sqoop
  • DSE Graph

DSE is designed to manage real-time, enterprise search data in the same database cluster. It also comes with OpsCenter Enterprise, which allows for the management DSE Clusters via a central web interface.

While comprised of open-source tools, paid customers of DataStax receive 24x7 support, certified updates, and data migration tools. As support contracts can be pricey, DataStax also offers a program for (qualifying) startups to use DSE on a startup-friendly budget.

DataStax Enterprise website: http://www.datastax.com/products/enterprise

1650 questions
43
votes
7 answers

Results pagination in Cassandra (CQL)

I am wondering how can I achieve pagination using Cassandra. Let us say that I have a blog. The blog lists max 10 posts per page. To access next posts a user must click on pagination menu to access page 2 (posts 11-20), page 3 (posts 21-30),…
kazy
  • 1,111
  • 2
  • 14
  • 24
41
votes
6 answers

How can I find out which version of Cassandra a specific DSE is running?

So far, I haven't found a place on Datastax documentation website that sums this up. Can I easily check the version some other way on a server?
Ztyx
  • 14,100
  • 15
  • 78
  • 114
28
votes
6 answers

How to load Spark Cassandra Connector in the shell?

I am trying to use Spark Cassandra Connector in Spark 1.1.0. I have successfully built the jar file from the master branch on GitHub and have gotten the included demos to work. However, when I try to load the jar files into the spark-shell I can't…
egerhard
  • 1,089
  • 1
  • 9
  • 18
20
votes
1 answer

Coordinator node timed out waiting for replica nodes in Cassandra Datastax while insert data

When I try to Insert data in Cassandra using the below query I am getting the below mentioned error cqlsh:assign> insert into tblFiles1(rec_no,clientid,contenttype,datafiles,filename) values(1,2,'gd','dgfsdg','aww'); WriteTimeout: code=1100…
karthi
  • 243
  • 1
  • 2
  • 8
20
votes
3 answers

Prepared Statement with collection in IN clause in Datastax Cassandra CQL driver

I am trying to run the following query SELECT edge_id, b_id FROM booking_by_edge WHERE edge_id IN ? I bind Java list of Long's as a parameter and I get an exception SyntaxError: line 0:-1 mismatched input '' expecting ')'…
i.petruk
  • 1,276
  • 1
  • 13
  • 18
17
votes
3 answers

How do I set the consistency level of an individual CQL query in CQL3?

In the earlier beta releases of CQL, there was a command I could use to set the read / write consistency of an individual CQL operation. It looked like this: SELECT * FROM users WHERE state='TX' USING CONSISTENCY QUORUM; I use CQL3 regularly and…
Aaronontheweb
  • 8,224
  • 6
  • 32
  • 61
16
votes
1 answer

Can I force cleanup of old tombstones?

I have recently lowered gc_grace_seconds for a CQL table. I am running LeveledCompactionStrategy. Is it possible for me to force purging of old tombstones from my SSTables?
Ztyx
  • 14,100
  • 15
  • 78
  • 114
15
votes
3 answers

How to solve this error org.apache.spark.sql.catalyst.errors.package$TreeNodeException

I have two procesess each process do 1) connect oracle db read a specific table 2) form dataframe and process it. 3) save the df to cassandra. If I am running both process parallelly , both try to read from oracle and I am getting below error…
13
votes
2 answers

How is Cassandra designed to avoid the need for load balancers?

I read this from the official DSE doc but it did not go in depth in to how. Can someone explain or provide any links to how?
user2345093
  • 623
  • 6
  • 13
13
votes
2 answers

Cassandra Allow filtering

I have a table as below CREATE TABLE test ( day int, id varchar, start int, action varchar, PRIMARY KEY((day),start,id) ); I want to run this query Select * from test where day=1 and start > 1475485412 and start < 1485785654 and…
Bharathi
  • 451
  • 1
  • 6
  • 17
12
votes
4 answers

cassandra cql shell window got disappears after installation in windows

cassandra cql shell window got disappears after installation in windows? this was installed using MSI installer availalbe in planet cassandra. Why this happens ? please help me.. Thanks in advance.
12
votes
2 answers

What is role of bloom filter in cassandra?

From two different links of the Cassandra's documentation, I found: link 1 A structure stored in memory that checks if row data exists in the memtable before accessing SSTables on disk and link2 Cassandra checks the Bloom filter to discover…
Mayank Raghav
  • 640
  • 1
  • 7
  • 17
12
votes
1 answer

How to completely clear down, reset and restart a Cassandra cluster?

I have an old Cassandra cluster that needs to be brought back into life. I would like to clear out all the user and system data, all stored tokens, everything and start from a clean slate - is there a recommended way of doing this?
jimmy_terra
  • 1,430
  • 2
  • 18
  • 36
12
votes
1 answer

Should I call session.close() and cluster. close() after each web API call

I have an webservice API allowing client to insert into Cassandra. I read the document on the page of datastax (http://www.datastax.com/drivers/java/2.0/com/datastax/driver/core/Session.html) stating that we should keep the session and cluster…
Minh Vu
  • 211
  • 1
  • 3
  • 10
11
votes
3 answers

Hive Query Execution Error, return code 3 from MapredLocalTask

I am getting this error while performing a simple join between two tables. I run this query in Hive command line. I am naming table as a & b. Table a is Hive internal table and b is External table (in Cassandra). Table a has only 1610 rows and Table…
user3517633
  • 111
  • 1
  • 1
  • 4
1
2 3
99 100