Thanks. That helped.
Another related question:
I created this table on HIVE:
hive> CREATE TABLE hbase_mstr_1(key int, value string) STORED BY
'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES
("hbase.columns.mapping" = ":key,cf1:val") TBLPROPERTIES ("hbase.table.name" =
"hbase_mstr_1_xyz");
My intention is to load it and then access it via HIVE. But I am not able to
insert values into this table:
hive> insert overwrite table hbase_mstr_1 select * from eatwh1_ft1;
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_201207251201_0678, Tracking URL =
http://hadoop001:50030/jobdetails.jsp?jobid=job_201207251201_0678
Kill Command = /usr/lib/hadoop/bin/hadoop job
-Dmapred.job.tracker=hadoop001:6932 -kill job_201207251201_0678
2012-08-14 12:30:20,977 Stage-0 map = 0%, reduce = 0%
2012-08-14 12:30:47,110 Stage-0 map = 100%, reduce = 100%
Ended Job = job_201207251201_0678 with errors
FAILED: Execution Error, return code 2 from
org.apache.hadoop.hive.ql.exec.MapRedTask
The hive.log doesn't tell a lot of useful information.
2012-08-14 11:55:51,893 WARN hbase.HBaseConfiguration
(HBaseConfiguration.java:<init>(45)) - instantiating HBaseConfiguration() is
deprecated. Please use HBaseConfiguration#create() to construct a plain
Configuration
2012-08-14 11:55:52,302 WARN mapred.JobClient
(JobClient.java:copyAndConfigureFiles(649)) - Use GenericOptionsParser for
parsing the arguments. Applications should implement Tool for the same.
2012-08-14 11:56:21,132 ERROR exec.MapRedTask
(SessionState.java:printError(365)) - Ended Job = job_201207251201_0677 with
errors
2012-08-14 11:56:21,151 ERROR ql.Driver (SessionState.java:printError(365)) -
FAILED: Execution Error, return code 2 from
org.apache.hadoop.hive.ql.exec.MapRedTask
Any ideas?
Thank you.
Farah Omer
Sr. DB Engineer | MicroStrategy, Inc.
Tel 703.270.2230 | fo...@microstrategy.com
1850 Towers Crescent Plaza | Tysons Corner, VA 22182
www.microstrategy.com
From: kulkarni.swar...@gmail.com [mailto:kulkarni.swar...@gmail.com]
Sent: Tuesday, August 14, 2012 11:11 AM
To: user@hive.apache.org
Subject: Re: Issue with creating table in hbase
> hbase(main):001:0> CREATE TABLE hbase_mstr_1.....
Are you running the CREATE TABLE from the hbase shell? You should run it from
the hive shell. You can start it from "$HIVE_HOME/bin/hive"
On Tue, Aug 14, 2012 at 10:05 AM, Omer, Farah
<fo...@microstrategy.com<mailto:fo...@microstrategy.com>> wrote:
Hi all,
I was testing hbase integrated with hive, and running into an issue. Would
anyone has an idea what it means?
hbase(main):001:0> CREATE TABLE hbase_mstr_1(key int, value string) STORED BY
'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES
("hbase.columns.mapping" = ":key,cf1:val") TBLPROPERTIES
("hbase.table.name<http://hbase.table.name>" = "xyz")
SyntaxError: (hbase):1: syntax error, unexpected tIDENTIFIER
CREATE TABLE hbase_mstr_1(key int, value string) STORED BY
'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES
("hbase.columns.mapping" = ":key,cf1:val") TBLPROPERTIES
("hbase.table.name<http://hbase.table.name>" = "xyz")
^
hbase(main):002:0>
Hive version is 0.7, hbase version is 0.90
Thanks.
Farah Omer
Sr. DB Engineer | MicroStrategy, Inc.
Tel 703.270.2230<tel:703.270.2230> |
fo...@microstrategy.com<http://fo...@microstrategy.com>
1850 Towers Crescent Plaza | Tysons Corner, VA 22182
www.microstrategy.com<http://www.microstrategy.com>
--
Swarnim
