firebrand icon indicating copy to clipboard operation
firebrand copied to clipboard

Add support to CQL3 to create compound primary key

Open sunmoonone opened this issue 12 years ago • 7 comments

can I use firebrand to create compound primary key? I read the datastax doc for cassandra 1.2, and find that compound primary key is efficient to query sequencial data from one node.

sunmoonone avatar Jan 28 '13 08:01 sunmoonone

maybe an overload method QueryBuilder.primarykey(ColumnParenthesis) will be great

sunmoonone avatar Jan 28 '13 08:01 sunmoonone

@sunmoonone it's a good idea. Feel free to contribute a pull request with a test and I'll be happy to add it to the current snapshot. Cheers!

raulraja avatar Jan 31 '13 11:01 raulraja

I build a snapshot of :https://github.com/datastax/java-driver which support cql3. The java-driver is great but lack of a mapper.I use pure sql at present due to the deadline of the project I involved. I just migrated to java, so I need time to master some basic trick of java to contribute code. Thanks

sunmoonone avatar Jan 31 '13 11:01 sunmoonone

@sunmoonone I'm closing this one for now until there is enough interest to add this feature, feel free to send over a pull request for it anytime if you end implementing it.

raulraja avatar Feb 13 '13 22:02 raulraja

Hi Raul. I'm also looking for a Cassandra client library that supports CQL3... I'm doing some research on it now.

jamesm-vt avatar Feb 20 '13 19:02 jamesm-vt

@jamesm-vt I'm torn regarding CQL3 because of the semantics it introduces. There are incompatibilities when using thrift and CQL3 over the same column families. I'd love to hear from your findings, I have yet to find a clean migration path without dropping support for Hector / Thrift. Perhaps a Persistence Factory based on the JDBC driver that supports CQL 3.0. would be enough to bring such support to Firebrand. I'll be happy to work on that support as time permits or merge in any pull requests if any of you want to join forces and help wit it.

raulraja avatar Feb 20 '13 20:02 raulraja

Any progress on compound primary key?

AtticusNotFinch avatar Feb 26 '13 18:02 AtticusNotFinch