http://www.datastax.com/support-forums/topic/cassandra-hive-storage-handler-sample-for-map-data-type Software, Support, and Training for Apache Cassandra en-US Tue, 21 May 2013 17:10:32 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/cassandra-hive-storage-handler-sample-for-map-data-type#post-1957 Tue, 22 May 2012 07:23:19 +0000 Anonymous 1957@http://www.datastax.com/support-forums/ <p>My use case is to have a Hive table definition with MAP Hive data type so that it can support varying set of key value properties per each row which is allowed in Cassandra. Some thing like what's given below.</p> <p>CREATE EXTERNAL TABLE mapExample (foo INT, bar STRING, properties MAP&lt;STRING,STRING&gt;) STORED BY 'org.apache.hadoop.hive.cassandra.CassandraStorageHandler'<br /> WITH SERDEPROPERTIES ("cassandra.host" = "127.0.0.1","cassandra.port" = "9160","cassandra.ks.name" = "examples","cassandra.cf.name" = "map" );</p> <p>But I am not sure how to provide the cassandra.column.mappings etc. since there is little documentation on how to use map data type with Hive, specially with Cassandra Storage handler. Any pointers regarding this are greatly appreciated.</p> <p>Regards<br /> Buddhika </p>