Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Issue with creating table in hbase


Copy link to this message
-
Re: Issue with creating table in hbase
It seems like your Map reduce job is failing. Refer to the logs in the
tracking URL "
http://hadoop001:50030/jobdetails.jsp?jobid=job_201207251201_0678" to see
why exactly it is failing.

On Tue, Aug 14, 2012 at 11:35 AM, Omer, Farah <[EMAIL PROTECTED]>wrote:

>  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 | [EMAIL PROTECTED]****
>
> 1850 Towers Crescent Plaza | Tysons Corner, VA 22182****
>
> www.microstrategy.com****
>
> ** **
>
> *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> *Sent:* Tuesday, August 14, 2012 11:11 AM
> *To:* [EMAIL PROTECTED]
> *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 <[EMAIL PROTECTED]>
> 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" = "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" = "xyz")****
>
>                                               ^****
>
>  ****
>
> hbase(main):002:0>****
>
>  ****
>
> Hive version is 0.7, hbase version is 0.90****

Swarnim
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB