You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hadoop.apache.org by Sathish Kumar <sa...@gmail.com> on 2013/10/23 04:52:51 UTC
Fwd: External Table creation in hive fails on impala integration with hive
---------- Forwarded message ----------
From: Sathish Kumar <sa...@gmail.com>
Date: Tue, Oct 22, 2013 at 4:59 PM
Subject: External Table creation in hive fails on impala integration with
hive
To: cdh-user@cloudera.org
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
Fwd: External Table creation in hive fails on impala integration with hive
Posted by Sathish Kumar <sa...@gmail.com>.
---------- Forwarded message ----------
From: Sathish Kumar <sa...@gmail.com>
Date: Wed, Oct 23, 2013 at 10:28 AM
Subject: Re: External Table creation in hive fails on impala integration
with hive
To: cdh-user@cloudera.org
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 <sa...@gmail.com>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 <sa...@gmail.com> wrote:
>
>>
>>
>> ---------- Forwarded message ----------
>> From: Sathish Kumar <sa...@gmail.com>
>> Date: Tue, Oct 22, 2013 at 4:59 PM
>> Subject: External Table creation in hive fails on impala integration with
>> hive
>> To: cdh-user@cloudera.org
>>
>>
>> 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 cdh-user+unsubscribe@cloudera.org.
>> 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 cdh-user+unsubscribe@cloudera.org.
> For more options, visit
> https://groups.google.com/a/cloudera.org/groups/opt_out.
>
Fwd: External Table creation in hive fails on impala integration with hive
Posted by Sathish Kumar <sa...@gmail.com>.
---------- Forwarded message ----------
From: Sathish Kumar <sa...@gmail.com>
Date: Wed, Oct 23, 2013 at 10:28 AM
Subject: Re: External Table creation in hive fails on impala integration
with hive
To: cdh-user@cloudera.org
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 <sa...@gmail.com>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 <sa...@gmail.com> wrote:
>
>>
>>
>> ---------- Forwarded message ----------
>> From: Sathish Kumar <sa...@gmail.com>
>> Date: Tue, Oct 22, 2013 at 4:59 PM
>> Subject: External Table creation in hive fails on impala integration with
>> hive
>> To: cdh-user@cloudera.org
>>
>>
>> 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 cdh-user+unsubscribe@cloudera.org.
>> 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 cdh-user+unsubscribe@cloudera.org.
> For more options, visit
> https://groups.google.com/a/cloudera.org/groups/opt_out.
>
Fwd: External Table creation in hive fails on impala integration with hive
Posted by Sathish Kumar <sa...@gmail.com>.
---------- Forwarded message ----------
From: Sathish Kumar <sa...@gmail.com>
Date: Wed, Oct 23, 2013 at 10:28 AM
Subject: Re: External Table creation in hive fails on impala integration
with hive
To: cdh-user@cloudera.org
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 <sa...@gmail.com>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 <sa...@gmail.com> wrote:
>
>>
>>
>> ---------- Forwarded message ----------
>> From: Sathish Kumar <sa...@gmail.com>
>> Date: Tue, Oct 22, 2013 at 4:59 PM
>> Subject: External Table creation in hive fails on impala integration with
>> hive
>> To: cdh-user@cloudera.org
>>
>>
>> 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 cdh-user+unsubscribe@cloudera.org.
>> 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 cdh-user+unsubscribe@cloudera.org.
> For more options, visit
> https://groups.google.com/a/cloudera.org/groups/opt_out.
>
Fwd: External Table creation in hive fails on impala integration with hive
Posted by Sathish Kumar <sa...@gmail.com>.
---------- Forwarded message ----------
From: Sathish Kumar <sa...@gmail.com>
Date: Wed, Oct 23, 2013 at 10:28 AM
Subject: Re: External Table creation in hive fails on impala integration
with hive
To: cdh-user@cloudera.org
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 <sa...@gmail.com>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 <sa...@gmail.com> wrote:
>
>>
>>
>> ---------- Forwarded message ----------
>> From: Sathish Kumar <sa...@gmail.com>
>> Date: Tue, Oct 22, 2013 at 4:59 PM
>> Subject: External Table creation in hive fails on impala integration with
>> hive
>> To: cdh-user@cloudera.org
>>
>>
>> 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 cdh-user+unsubscribe@cloudera.org.
>> 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 cdh-user+unsubscribe@cloudera.org.
> For more options, visit
> https://groups.google.com/a/cloudera.org/groups/opt_out.
>