hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abhishek Pratap Singh <manu.i...@gmail.com>
Subject Re: Hive Basic question
Date Tue, 13 Dec 2011 06:05:08 GMT
Mapping an existing table requires the Hive EXTERNAL keyword, which is also
used in other places to access data stored in *unmanaged* Hive tables,
i.e., those that are not under Hive's control:

Add a comment <http://ofps.oreilly.com/titles/9781449396107/clients.html#>

hive> *CREATE EXTERNAL TABLE hbase_table_2(key int, value string)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf1:val")
TBLPROPERTIES("hbase.table.name" = "<existing-table-name>");*


Regards,
Abhishek
On Tue, Dec 13, 2011 at 12:56 AM, Aditya Kumar <adityakumar345@yahoo.com>wrote:

> 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.infy@gmail.com>
> To: Aditya Kumar <adityakumar345@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 <adityakumar345@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.infy@gmail.com>
> >To: user@hive.apache.org; Aditya Kumar <adityakumar345@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 <adityakumar345@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
> >>
> >
>

Mime
View raw message