Hi Den,
Have you tried escaping the additional colon in the qualifier name?
On Fri, Feb 14, 2014 at 9:47 AM, Den <dennis.lipov...@gmail.com> wrote:
> 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?
>
--
Swarnim
