Re: Mapping HBase column qualifier with a ':' in it

2014-02-19 Thread Den
it can be queried as: select cf['q1:q2'] from t On Mon, Feb 17, 2014 at 6:16 PM, Den wrote: > I assume by 'escape' you mean something like: > > "hbase.columns.mapping" = ":key,cf:q1\:q2" > > That gave the same error as before. If that&#x

Re: Mapping HBase column qualifier with a ':' in it

2014-02-17 Thread Den
not be any way to map my columns without renaming them first. Thoughts? On Fri, Feb 14, 2014 at 10:50 AM, kulkarni.swar...@gmail.com < kulkarni.swar...@gmail.com> wrote: > Hi Den, > > Have you tried escaping the additional colon in the qualifier name? > > > On Fri, Feb 14,

Mapping HBase column qualifier with a ':' in it

2014-02-14 Thread Den
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.col