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
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,
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