Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Hive/Hbase integration Problem


Copy link to this message
-
Re: Hive/Hbase integration Problem
shashwat shriparv 2011-11-29, 08:41
Hey Ankit, Thanks. my host file i tried using 127.0.0.1 still same problem,
can you please tell me what should be there in the host file now my host
file contains following entries:
192.168.2.125 shashwat.pointcrossblr ubuntu
127.0.0.1 localhost
#127.0.0.1    localhost
#192.168.2.125    ubuntu.ubuntu-domain    ubuntu
#127.0.1.1    ubuntu.ubuntu-domain    ubuntu
#127.0.0.1    loalhost
#192.168.2.125    shashwat@ubuntu ubuntu
#192.168.2.125   bhase-masterserver
#127.0.0.1    localhost.localdomain   localhost       ubuntu
#127.0.0.1       localhost

# The following lines are desirable for IPv6 capable hosts
::1     ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters

what exactly should be the host file entries.
I have gone through this post where they said to modify the host file

http://ria101.wordpress.com/2010/01/28/setup-hbase-in-pseudo-distributed-mode-and-connect-java-client/

127.0.0.1 localhost
23.201.99.100 hbase.mycompany.com hbase

so i made the host file at my machine as such. is the host file
configuration is correct.
On Tue, Nov 29, 2011 at 1:42 PM, Ankit Jain <[EMAIL PROTECTED]> wrote:

> Hi,
> Please use 127.0.0.1 instead of  ubuntu.ubuntu-domain .
>
> or Open the Hbase shell and run command 'status'.
>
> On Tue, Nov 29, 2011 at 1:34 PM, shashwat shriparv <
> [EMAIL PROTECTED]> wrote:
>
>> I have followed
>> https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration my
>> hbase is running finne
>>
>> here is the screen shot attachments
>>
>> for integrating hive with hbase. as i a trying to create table i am
>> getting following error
>>
>>
>> shashwat@ubuntu:~/hive$ bin/hive --auxpath
>> /home/shashwat/hive/lib/hive_hbase-handler-0.7.1.jar,/home/shashwat/hive/lib/hbase-0.89.0.jar,/home/shashwat/hive/lib/zookeeper-3.3.1.jar
>> -hiveconf hbase.master=ubuntu.ubuntu-domain:60000
>>
>> WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please
>> use org.apache.hadoop.log.metrics.EventCounter in all the log4j.properties
>> files.
>> Hive history
>> file=/tmp/shashwat/hive_job_log_shashwat_201111291314_1466942791.txt
>>
>> hive> CREATE EXTERNAL TABLE hbase_table_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");
>>
>> FAILED: Error in metadata:
>> MetaException(message:org.apache.hadoop.hbase.MasterNotRunningException:
>> ubuntu.ubuntu-domain:58680
>>     at
>> org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.getMaster(HConnectionManager.java:394)
>>     at
>> org.apache.hadoop.hbase.client.HBaseAdmin.<init>(HBaseAdmin.java:83)
>>     at
>> org.apache.hadoop.hive.hbase.HBaseStorageHandler.getHBaseAdmin(HBaseStorageHandler.java:74)
>>     at
>> org.apache.hadoop.hive.hbase.HBaseStorageHandler.preCreateTable(HBaseStorageHandler.java:158)
>>     at
>> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:344)
>>     at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:470)
>>     at
>> org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3146)
>>     at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:213)
>>     at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:130)
>>     at
>> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
>>     at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1063)
>>     at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:900)
>>     at org.apache.hadoop.hive.ql.Driver.run(Driver.java:748)
>>     at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:164)
>>     at
>> org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:241)
>>     at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:456)
>>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>     at
Shashwat Shriparv
09900059620
09663531241

<iframe src="
http://rcm.amazon.com/e/cm?t=shriparv-20&o=1&p=48&l=ur1&category=kindlerotating&f=ifr"
width="728" height="90" scrolling="no" border="0" marginwidth="0"
style="border:none;" frameborder="0"></iframe>