---------- Forwarded message ----------
From: Sathish Kumar <[email protected]>
Date: Tue, Oct 22, 2013 at 4:59 PM
Subject: External Table creation in hive fails on impala integration with
hive
To: [email protected]
Hi All,
I am trying to integrate impala with hbase, Received a syntax error as
mention below.
ERROR: AnalysisException: Syntax error at:
create EXTERNAL TABLE hbase_table_2(key int, value int, value2 string)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH
SERDEPROPERTIES ("hbase.columns.mapping" = "d:val") TBLPROPERTIES("
hbase.table.name" = "xyz")
In the above command, I suspect the column name "val" is wrong, by giving
the "describe tablename" command I am able find the column family name but
not sure about how to find the column name.
Please help me if you find any thing wrong in my command.
Regards
Sathish
