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

9
votes
1answer
9k views

Get current date in cassandra cql select

In SQL, I am able to do:select getdate(), getdate() - 7Which returns the current date as well as current date - 7 days. I want to achieve the same in Cassandra CQL. I tried:select dateof(now())...
27
votes
6answers
17k views

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 ...
19
votes
6answers
27k views

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 ...
6
votes
1answer
349 views

Spark JoinWithCassandraTable on TimeStamp partition key STUCK

I'm trying to filter on a small part of a huge C* table by using:val snapshotsFiltered=sc.parallelize(startDate to endDate).map(TableKey(_)).joinWithCassandraTable("listener","snapshots_tspark"...
0
votes
1answer
274 views

how to return subgraph from gremlin that is in an easily consumable format for Java

I am very frustrated about very simple things when I try to do a single traversal and bring a lot of stuff from DSE Graph 5.0 at once using Gremlin..In my simplified case I have:1 entity with ...
12
votes
3answers
21k views

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' ...
11
votes
3answers
7k views

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 exceptionSyntaxError: line 0:-1 ...
9
votes
1answer
6k views

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,'...
3
votes
2answers
7k views

Starting cassandra as a service does not work for 2.0.5, sudo cassandra -f works

When I try to start cassandra on ubuntu 12.04 (installed via Datastax's dsc20 package) as a service as follows :$ sudo service cassandra startit says *could not access pidfile for Cassandra...
2
votes
1answer
230 views

IAM Policy for OpsCenter backup to S3 user

Using OpsCenter 5.1.0 and trying to add S3 as a location for snapshot backups. What are the necessary permissions in AWS IAM for the opscenter user? So far, I have the following policy:"Statement": [...
6
votes
1answer
8k views

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?
4
votes
3answers
593 views

Pig & Cassandra & DataStax Splits Control

I have been using Pig with my Cassandra data to do all kinds of amazing feats of groupings that would be almost impossible to write imperatively. I am using DataStax's integration of Hadoop & ...
1
vote
1answer
833 views

Can't connect to CFS node

I removed (or decommisioned, can't remember) a DSE analytics node (with IP 10.14.5.50) a couple of months ago. When I now try to execute a dse shark (CREATE TABLE ccc AS SELECT ...) query I now ...
0
votes
3answers
484 views

Can't backup to S3 with OpsCenter 5.2.1

I upgraded OpsCenter from 5.1.3 to 5.2.0 (and then to 5.2.1). I had a scheduled backup to local server and an S3 location configured before the upgrade, which worked fine with OpsCenter 5.1.3. I made ...
2
votes
2answers
617 views

DSE Solr nodes and vnodes

The following documentation pages say that it is not recommended to use vnodes for Solr/Hadoop nodes:http://www.datastax.com/documentation/datastax_enterprise/4.0/datastax_enterprise/srch/srchIntro....

153050per page
angop.ao, elkhabar.com, noa.al, afghanpaper.com, bbc.com, time.com, cdc.gov, nih.gov, xnxx.com, github.com,