Browsing through Cassandra tables in Hive
If a keyspace and table exists in Cassandra, you can query the keyspace and table in Hive.
If a keyspace exists in Cassandra, you can use the keyspace in Hive. For example, create a keyspace in Cassandra using cqlsh. Add some data to the table using cqlsh, and then access the data in Hive by simply issuing a USE command on the Hive command line.
cqlsh> CREATE KEYSPACE cassandra_keyspace WITH replication = {'class': 'NetworkTopologyStrategy', 'Analytics': 1}; cqlsh> USE cassandra_keyspace; cqlsh:cassandra_keyspace> CREATE TABLE exampletable ( key int PRIMARY KEY , data text ); cqlsh:cassandra_keyspace> INSERT INTO exampletable (key, data ) VALUES ( 1, 'This data can be read automatically in hive'); cqlsh:cassandra_keyspace> quit;
At this point, you can start Hive and use the keyspace in Hive.
hive> USE cassandra_keyspace; hive> SHOW TABLES; OK exampletable hive> SELECT * FROM exampletable; OK 1 This data can be read automatically in hive