no luck..
here is the Error I am getting:
hive>
> CREATE TABLE hbase_table_1(key int, event string)
> STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
> WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf1:val")
> TBLPROPERTIES ("hbase.table.name" = 'USER_DETAILS');
FAILED: Error in metadata: MetaException(message:Table USER_DETAILS already
exists within HBase; use CREATE EXTERNAL TABLE instead to register it in Hive.)
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask.
I dont want to create a external table ..but to access the data from hbase
________________________________
From: Abhishek Pratap Singh <manu.i...@gmail.com>
To: Aditya Kumar <adityakumar...@yahoo.com>
Cc: "user@hive.apache.org" <user@hive.apache.org>
Sent: Monday, December 12, 2011 9:44 PM
Subject: Re: Hive Basic question
it will work, as you will provide the Serde properties related to HBase. Just
create the hive table, map it with HBase table and try to access it.
~Abhishek
On Tue, Dec 13, 2011 at 12:41 AM, Aditya Kumar <adityakumar...@yahoo.com> wrote:
>Thanks Abhishek for the response.
>I did see that link but that is telling more creating HIVE table and than
>check in HBAse.
>my case is I have the data in tables in Hbase. i can view them in HBase.
>but want to do access them from HIVE.
>
>btn I am new to Hadoop world.
>
>Can yoyu pl let me know if I am missing anything and how to proceed
>
>
>
>________________________________
>From: Abhishek Pratap Singh <manu.i...@gmail.com>
>To: user@hive.apache.org; Aditya Kumar <adityakumar...@yahoo.com>
>Sent: Monday, December 12, 2011 9:32 PM
>Subject: Re: Hive Basic question
>
>
>
>Here you go, check this link
>
>https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration
>
>Regards,
>Abhishek
>
>On Tue, Dec 13, 2011 at 12:30 AM, Aditya Kumar <adityakumar...@yahoo.com>
>wrote:
>
>Hi,
>>I have a Hbase table that I am able to insert data and do scan.
>>I want to have use HIVE,.
>>
>>I was able to install HIVE and login to Hive Console.
>>Can you please tell me the way I can access the HBASE Table fgrom HIVE.
>>I want to use HQL Commands on HBase table...
>>
>>please let me know how to do that .
>>
>>Thanks in Advance
>>-Adi
>>
>
