Cassandra Handler usage in Hive 0.7 with Cassandra 0.7

You can use Cassandra Handler in Hive 0.7 against Cassandra 0.7 cluster. To use it, please following the instructions as below:

Download hive-cassandra-handler-0.7.0-beta1.jar from https://github.com/riptano/hive/downloads.
Copy the following jars from your cassandra libraray into a folder where your Hive client can access. In the instruction, I am using the cassandra 0.7.6. These jars have been uploaded under https://github.com/riptano/hive/downloads for your convenience.

apache-cassandra-0.7.6.jar (or the apache cassandra of the version that you are using.)
guava-r05 .jar
commons-lang-2.4.jar

Define a property in your hive-site.xml and add your jars from there. For more details, please refer to this link:
[[http://mail-archives.apache.org/mod_mbox/hive-user/201011.mbox/%3CAANLkTimLwT++92gLu9-puekXh9_g7aX=[email protected]%3E|http://mail-archives.apache.org/mod_mbox/hive-user/201011.mbox/%3CAANLkTimLwT++92gLu9-puekXh9_g7aX=[email protected]%3E]]
<property> <name>hive.aux.jars.path</name> <value>file:///path/to/guava-r05.jar,file:///path/to/commons-lang-2.4.jar,file:///path/to/apache-cassandra-0.7.6.jar,file:///path/to/hive-cassandra-handler-0.7.0-beta1.jar</value> </property>
Now you can use the CREATE EXTERNAL TABLE ... STROED BY '' to create the external table in Hive and start accessing it.

hive> CREATE TABLE invites (foo INT, bar STRING);
hive> LOAD DATA LOCAL INPATH '/root/kv1.txt' OVERWRITE INTO TABLE invites;
hive> CREATE EXTERNAL TABLE invites2 (foo INT, bar STRING)
STORED BY 'org.apache.hadoop.hive.cassandra.CassandraStorageHandler'
WITH SERDEPROPERTIES (
"cassandra.host" = "127.0.0.1",
"cassandra.port" = "9160",
"cassandra.ks.name" = "examples",
"cassandra.cf.name" = "invites2" );
hive> select count(*) from invites2;
hive> INSERT OVERWRITE TABLE invites2 select foo, bar from invites;
hive> select foo, bar from invite2s;

Provide feedback