---------- Forwarded message ---------- From: Sathish Kumar <[email protected]> Date: Wed, Oct 23, 2013 at 10:28 AM Subject: Re: External Table creation in hive fails on impala integration with hive To: [email protected]
Hi All, Thanks Saro, It worked. I have small doubt if my my Row Key and Value is as below what will be the data type we suppose to use next to TABLE *(create external TABLE hbase_table(key int, value string) * ROW COLUMN+CELL \x00\x00\x01As\xBDJ column=d:a, timestamp=1380629572482, value=\x1F\x8B\x08\x08cn Regards Sathish* * On Wed, Oct 23, 2013 at 1:26 AM, Saro saravanan <[email protected]>wrote: > hi > > set hbase.zookeeper.quorum=localhost; > > create external TABLE hbase_table(key int, value string) STORED BY > 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH > SERDEPROPERTIES("hbase.columns.mapping" = ":key,datahive1:name") > TBLPROPERTIES("hbase.table.name" = "tablename"); > > > > On Wed, Oct 23, 2013 at 8:22 AM, Sathish Kumar <[email protected]> wrote: > >> >> >> ---------- 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 >> >> >> -- >> >> --- >> You received this message because you are subscribed to the Google Groups >> "CDH Users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> For more options, visit >> https://groups.google.com/a/cloudera.org/groups/opt_out. >> > > > > -- > Thanks > *saravanan* > *9095260692* > > > -- > > --- > You received this message because you are subscribed to the Google Groups > "CDH Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit > https://groups.google.com/a/cloudera.org/groups/opt_out. >
