cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dinusha Dilrukshi <>
Subject Re: Any improvements in Cassandra JDBC driver ?
Date Thu, 29 Mar 2012 17:19:30 GMT
What I want to tell was this driver does not use INSERT key word.  Since
CQL support for using INSERT keyword and it is more generic key word used
to add new records, it's more user friendly to  use INSERT key word  to add
new record set rather using UPDATE keyword.


On Thu, Mar 29, 2012 at 8:34 PM, Jeremiah Jordan <> wrote:

>  There is no such thing as pure insert which will give an error if the
> thing already exists.  Everything is really "UPDATE OR INSERT".  Whether
> you say UPDATE, or INSERT, it will all act like "UPDATE OR INSERT", if the
> thing is there it get over written, if it isn't there it gets inserted.
> -Jeremiah
>  ------------------------------
> *From:* Dinusha Dilrukshi []
> *Sent:* Wednesday, March 28, 2012 11:41 PM
> *To:*
> *Subject:* Any improvements in Cassandra JDBC driver ?
>  Hi,
>  We are using Cassandra JDBC driver (found in [1]) to call to Cassandra
> sever using CQL and JDBC calls.  One of the main disadvantage is, this
> driver is not available in maven repository where people can publicly
> access. Currently we have to checkout the source and build ourselves. Is
> there any possibility to host this driver in a maven repository ?
>  And one of the other limitation in driver is, it does not support for the
> insert query. If we need to do a insert , then it can be done using the
> "update" statement. So basically it will be same query used for both UPDATE
> and INSERT. As an example, if you execute following query:
> "update USER set 'username'=?, 'password'=? where key = ?"
> and if the provided 'KEY' already exist in the Column family then it will
> do a update to existing  columns. If the provided KEY does not already
> exist, then it will do a insert..
> Is that the INSERT query option is now available in latest driver?
>  Are there any other improvements/supports added to this driver recently
> ?
>  Is this driver compatible with Cassandra-1.1.0 and is that the changes
> done for driver will be backward compatible with older Cassandra versions
> (1.0.0) ?
>  [1].<>
>  Regards,
> ~Dinusha~

View raw message