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 >> Hive/Hbase integration Problem


Copy link to this message
-
Re: Hive/Hbase integration Problem
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>
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