I'm working with an HBase database with a column of the form 'cf:q1:q2'
where 'cf' is the column family 'q1:q2' is the column qualifier. When
trying to map this in Hive I'm using a statement like the following:
CREATE EXTERNAL TABLE t (
id string
q1_q2 string
) WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:q1:q2")
I get an error saying
Error: the HBase columns mapping contains a badly formed column family,
column qualifier specification.
This seems to be due to the colon in the column qualifier. It seems to
demand that there be exactly on colon in the field name and it has to be
the one separating the column family from the column qualifier.
Is there a reason that is the case? Is there any way around it so I can map
the columns from the HBase DB to Hive?
