hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Den <dennis.lipov...@gmail.com>
Subject Mapping HBase column qualifier with a ':' in it
Date Fri, 14 Feb 2014 15:47:18 GMT
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?

Mime
View raw message