CREATE EXTERNAL TABLE IF NOT EXISTS mapExample (key string, quantity INT, value map<string,string>, total INT, ts BIGINT)
STORED BY 'org.apache.hadoop.hive.cassandra.CassandraStorageHandler'
WITH SERDEPROPERTIES (
 	"cassandra.host" = "127.0.0.1" ,
	"cassandra.port" = "9160" ,
	"cassandra.ks.name" = "EVENT_KS" ,
	"cassandra.ks.username" = "admin" ,
	"cassandra.ks.password" = "admin" ,
	"cassandra.cf.name" = "org_wso2_bam_phone_retail_store_kpi" ,
	"cassandra.columns.mapping" =
	":key, payload_quantity, cf:, payload_total, Timestamp" );
select quantity, value['payload_user'] from mapExample;
select * from mapExample;