Hi,
I've to map Cassandra columns families on Hive tables.
Since I've dynamic fields in Cassandra, I use the following string
CREATE EXTERNAL TABLE Table1
(keyName string, columnName string, value string)
STORED BY 'org.apache.hadoop.hive.cassandra.CassandraStorageHandler'
WITH SERDEPROPERTIES ("cassandra.columns.mapping" = ":key,:column,:value" );
in order to create the external table on Hive. The result is a table where each row is as follows:
rowName1 columnName1 value1
rowName2 columnName2 value2
...
Since I use composite column names in Cassandra (Composite(columnNameA, columnNameB)), is it possible to map them into two different columns on Hive?
What I want is as follows:
rowName1 columnNameA1 columnNameB1 value1.
How can I map these columns on Hive?
Thanks in advance.
