How to query Cassandra dynamic columns using DataStax Java driver?

Question

I have a schema that stores values in Cassandra in the following format.

RowKey: one

   => (name=field1, value=ABC, timestamp=1223232)

   => (name=field2, value=XYZ, timestamp=1223232121)

   => (name=field3, value=ADS, timestamp=122323222323)

When I query fields (field1, field2, field3) using DataStax java driver, I am getting undefined column error. I heard that CQL 3 does not support dynamic columns. That being the case, how can I make it work with new version without making schema change?

Mikhail Stepura · Accepted Answer · 2014-02-28 02:14:34Z

0

http://www.datastax.com/dev/blog/does-cql-support-dynamic-columns-wide-rows

Your query should be something like SELECT * FROM <your cf> WHERE key=<key>. Those field will become cells' values, not the column names, in CQL

answered Feb 28, 2014 at 2:14

Mikhail Stepura

3,37422 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Pani Dhakshnamurthy Over a year ago

Thanks. I found a solution for my problem by altering column family.stackoverflow.com/questions/14456720/…

Collectives™ on Stack Overflow

How to query Cassandra dynamic columns using DataStax Java driver?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related