Hi Guys
When doing hive to hbase integration, we have observed that current Apache
Hive 2.x is not able to recognise 'NULL::character varying' (Variant data type
of NULL in prostgres) properly and throws the java.lang.ClassNotFoundException
exception.
Exception:
FAILED: RuntimeException j
p{margin-top:0px;margin-bottom:0px;} Hi, Hive user mailing list memebers,
I am testing Hive-HBase integration on a Hadoop cluster.
The cluster uses CDH5.4.4 with Kerberos enabled.
Following the documentation of Cloudera and Apache HiveHBaseIntegration, I
installed
hive-hbase package on a
Now my hbase is working fine now, but i am still getting the same error
[127.0.0.1:1] hive> CREATE TABLE hbase_table_1(key int, value string)
> STORED BY 'org.apache.hadoop.hive.hbase.
HBaseStorageHandler'
> WITH SERDEPROPERTIES ("hbase.columns.mapp
Seems you are right, Sometime I got this error while running hbase shell
command.
ibrar@ibrar-virtual-machine:/usr/local/hbase/bin$ ./hbase shell
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in
[jar:file:/usr/local/hbase/lib/slf4j-log4j12-1.7.7.jar!/org/slf4j/impl/Sta
Ibrar,
This seems to be an issue with the cluster rather than the integration
itself. Can you make sure that HBase is happy and healthy and all RS are up
and running?
On Wed, May 13, 2015 at 1:58 PM, Ibrar Ahmed wrote:
> Hi,
>
> I am creating a table using hive and getting this error.
>
> [127.
Here is my hbase-site.xml
hbase.rootdir
file:///usr/local/hbase
hbase.zookeeper.property.dataDir
/usr/local/hbase/zookeeperdata
And hive-site.xml
hive.aux.jars.path
file:///usr/local/hive/lib/zookeeper-3.4.5.jar,file:/usr/local/hive/lib/hive-hbase-handler-0
Hi,
I am creating a table using hive and getting this error.
[127.0.0.1:1] hive> CREATE TABLE hbase_table_1(key int, value string)
> STORED BY
'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
> WITH SERDEPROPERTIES ("hbase.columns.mapping" =
":key
:
>
>> Hi all,
>>
>> Could I get edit access to the hive wiki in order to update the
>> hive/hbase integration docs (
>> https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration).
>> Specifically I'd like to:
>>
>> 1. Add documentation
ThisWiki-Howtogetpermissiontoedit>).
-- Lefty
On Thu, Apr 30, 2015 at 7:07 PM, Andrew Mains
mailto:andrew.ma...@kontagent.com>> wrote:
Hi all,
Could I get edit access to the hive wiki in order to update the
hive/hbase integration docs
(https://cwiki.apache.org/conflu
gt; Could I get edit access to the hive wiki in order to update the hive/hbase
> integration docs (
> https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration).
> Specifically I'd like to:
>
> 1. Add documentation about compound key support
> (the only statement o
Hi all,
Could I get edit access to the hive wiki in order to update the
hive/hbase integration docs
(https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration).
Specifically I'd like to:
1. Add documentation about compound key support
(the only statement on the wiki right n
Hey Mohan,
Could you detail your question a little bit more? Hopefully the wiki
here[1] solves your queries.
[1] https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration
On Thu, Jan 1, 2015 at 2:38 PM, Mohan Krishna
wrote:
> Any body know Hive-HBase Integration proc
Any body know Hive-HBase Integration process?
Thanks
Mohan
The url for the hbase-hive integration:
https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration
has old versions: Hbase 0.92.0 and hadoop 0.20.x
Are there any significant changes to these docs that anyone might (a) have
pointers to or (b) be able/willing to mention here as important
This did work, though specifying the same list in the HIVE_AUX_JARS_PATH
environment variable
or in a ‘set hive.aux.jars.path’ command does not work.
Thanks, I can work with this.
Brian
On Jun 24, 2014, at 11:49 PM, D K wrote:
> If the MR job is failing can you try the following on Hive CLI
If the MR job is failing can you try the following on Hive CLI before
running the query?
add jar $HBASE_HOME/lib/hbase-client--hadoop2.jar;
add jar $HBASE_HOME/lib/hbase-protocol--hadoop2.jar;
add jar $HBASE_HOME/lib/hbase-server--hadoop2.jar;
add jar $HBASE_HOME/lib/htrace-core-2.01.jar
replace
Brian,
I'm successfully using Hive/Hbase integration on CDH5 (Hive 0.12.0 and
Hbase 0.96.1)
Can you explain your setup and configuration in details?
Cheers,
Andre'
On 24 June 2014 02:14, Brian Jeltema wrote:
> I’m running Hive 0.12 on Hadoop V2 (Ambari installation) and have
I’m running Hive 0.12 on Hadoop V2 (Ambari installation) and have been trying
to use HBase integration. Hive generated Map/Reduce jobs
are failing with:
Error: java.lang.ClassNotFoundException:
org.apache.hadoop.hbase.mapreduce.TableSplit
this is discussed in several discussion threads, but
For the first question, it's hive-hbase-handler, for the second question,
you can refer to
https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration
On Fri, Apr 18, 2014 at 1:05 AM, Shushant Arora
wrote:
> what is hive storage handlers?
> What are the best practices for
what is hive storage handlers?
What are the best practices for hive hbase integration?
Hi Guys,
Eventually, i got success to solve that issue. As you know, issue was
related with map-reduce jobs. Error was clearing saying, there was some
jar(class) is missing. So, i have create a temporary folder and copied some
jars file there. Fortunately, it's work for me. Kindly fine below steps
Hi buddy,
have gone through with given link. But no luck..
Actually i am working on HDP. Might be, there is some issue with yarn and
MR.
On Thu, Dec 26, 2013 at 10:10 PM, kulkarni.swar...@gmail.com <
kulkarni.swar...@gmail.com> wrote:
> Seems like you are running hive on yarn instead of mr1. I
Seems like you are running hive on yarn instead of mr1. I have had some
issues in the past doing so. The post here[1] has some solutions on how to
configure hive ot work with yarn. Hope that helps.
[1]
https://groups.google.com/a/cloudera.org/forum/#!topic/cdh-user/gHVq9C5H6RE
On Thu, Dec 26, 20
Hi,
I am integrating hive(0.12) with hbase(0.96). Everything is working fine
there but get stuck between two quires.
When i create table or select * from table then it's working fine .
but in case of select count(*) from table it give me below error.
2013-12-26 13:25:01,864 ERROR ql.Driver (Ses
Update:
When I remove *client_list Array*in both tables, it works fine.
So, the problem is how to join a shark table and a hbase table with
Array, Struct or Map ?
Any workaround here ?
Thank you.
Hao
Le 07/08/2013 10:09, Hao Ren a écrit :
Hi,
I have integrated hbase with Hive.
When join
Hi,
I have integrated hbase with Hive.
When joining a shark table with a hbase table.
It throws an exception:
java.lang.ClassCastException:
org.apache.hadoop.hive.serde2.lazybinary.LazyBinaryArray cannot be cast
to [Ljava.lang.Object;
at
org.apache.hadoop.hive.serde2.objectinspector.St
Hi, all.
>
> I have a hive + hbase integration cluster. I met a performance issue.
> I executed some complicated hql, but only the first one is actually running.
> The rests are showed "running" on the job track web ui, but task
> attempt failed with exceptions be
ux_lib.
>> > See
>> > this thread for reference:
>> >
>> > http://mail-archives.apache.org/mod_mbox/hive-user/201103.mbox/%3caanlktingqlgknqmizgoi+szfnexgcat8caqtovf8j...@mail.gmail.com%3E
>> >
>> > Mark
>> >
>> >
>&g
d(s) or put it in aux_lib. See
> this thread for reference:
> http://mail-archives.apache.org/mod_mbox/hive-user/201103.mbox/%3caanlktingqlgknqmizgoi+szfnexgcat8caqtovf8j...@mail.gmail.com%3E
>
> Mark
>
>
> On Mon, Nov 5, 2012 at 6:53 AM, Cheng Su wrote:
>>
>>
8caqtovf8j...@mail.gmail.com%3E
Mark
On Mon, Nov 5, 2012 at 6:53 AM, Cheng Su wrote:
> Hi, all. I have a hive+hbase integration cluster.
>
> When I try to execute query through the java client of hive, sometimes
> a ClassNotFoundException happens.
>
> My java code
Hi, all. I have a hive+hbase integration cluster.
When I try to execute query through the java client of hive, sometimes
a ClassNotFoundException happens.
My java code :
final Connection conn = DriverManager.getConnection(URL);
final ResultSet rs = conn.executeQuery("SELECT count(*)
apache.org
Subject: Re: Performance: hive+hbase integration query against the row_key
Hi Ashok
'LOAD DATA INPATH ..' issues a hdfs move under the hood, that is why the
original data in hdfs is not present after the load operation. If you want
to preserve the data in some hdfs location a
Yes bejoy i did it today and it's working. But i was thinking by setting some
property we can achieve it.
Is there anything like that?
Thanks
Ashok
From: Bejoy KS [mailto:bejoy...@yahoo.com]
Sent: 13 September 2012 02:40
To: user@hive.apache.org
Subject: Re: Performance: hive+hbase integr
uired hdfs location.
Regards,
Bejoy KS
From: "ashok.sa...@wipro.com"
To: user@hive.apache.org
Sent: Wednesday, September 12, 2012 8:55 AM
Subject: RE: Performance: hive+hbase integration query against the row_key
after loading the data into hi
after loading the data into hive tables, the files gets automatically deleted
from HDFS...how to stop that?
Thanks
Ashok
-Original Message-
From: Alan Gates [mailto:ga...@hortonworks.com]
Sent: 12 September 2012 06:51
To: user@hive.apache.org
Subject: Re: Performance: hive+hbase
On Sep 11, 2012, at 7:00 AM, bharath vissapragada wrote:
> Hey,
>
> Hive does all kinds of parsing , metadata lookups, query tree building and
> stuff before executing the query. Not sure if this all was included in those
> 36 seconds !
>
> Also what hive does is, it builds a scan object wi
Hey,
Hive does all kinds of parsing , metadata lookups, query tree building and
stuff before executing the query. Not sure if this all was included in
those 36 seconds !
Also what hive does is, it builds a scan object with ranges based on
predicates (and mappers too ) on key column and not a dire
Hi,
I am trying to get hive working on top of my hbase table following the
guide below:
https://cwiki.apache.org/Hive/hbaseintegration.html
CREATE EXTERNAL TABLE hive_hbase_test (key string, a string, b string, c
string)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPE
Hi,
Now the Job Tracker log's
java.lang.RuntimeException:
org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error
while processing row {"foo":98,"bar":"abc"}
at org.apache.hadoop.hive.ql.exec.ExecMapper.map(ExecMapper.java:161)
at org.apache.hadoop.mapred.MapRunner.run
Hi,
I want to integrate Hive and Hbase Tables. I created a table in hive using
Stored By.
When i try to load data into that table using
INSERT OVERWRITE TABLE hbase_table_1 SELECT * FROM pokes;
I got the following exceptions,
FAILED: Execution Error, return code 2 from
org.apache.hadoop.hive.ql.ex
From: "Garg, Rinku"
To: "user@hive.apache.org" ; Bejoy Ks
Sent: Thursday, March 1, 2012 11:19 AM
Subject: RE: Hive | HBase Integration
Hi Bejoy,
We want to insert data into Hbase cluster. We are having data in CSV files. We
want to insert large number of CSV’s file
e. Are you looking st some specific operation here?
· If we have to use hbase through hive then how can we proceed?
AFAIK, the hive Hbase integration is meant to query data from Hbase alone. For
inserts and updates in Hbase tables you need to use the Hbase APIs itself.
Regards
p.
Thanks
Rinku Garg
From: bejoy...@yahoo.com [mailto:bejoy...@yahoo.com]
Sent: 29 February 2012 11:08
To: user@hive.apache.org
Subject: Re: Hive | HBase Integration
Hi Rinku
Were you able to create a normal table within your hive without any issues? By
Normal table I mean the one that has d
2012 05:29:12
To: user@hive.apache.org; Bejoy Ks
Reply-To: user@hive.apache.org
Subject: RE: Hive | HBase Integration
Hi ,
We tried the same also by issuing the below mentioned command but command does
not executes completely and a new command line is shown with an asterisk (*),
and table doe
From: "Savant, Keshav"
mailto:keshav.c.sav...@fisglobal.com>>
To: "user@hive.apache.org<mailto:user@hive.apache.org>"
mailto:user@hive.apache.org>>
Sent: Tuesday, February 28, 2012 5:58 PM
Subject: Hive | HBase Integration
Hi All,
To: "user@hive.apache.org"
Sent: Tuesday, February 28, 2012 5:58 PM
Subject: Hive | HBase Integration
Hi All,
We did a successful setup of hadoop-0.20.203.0 and hive-0.7.1.
In our next step we are eyeing HBase integration with Hive. As far as we
understand from articles avail
Hi All,
We did a successful setup of hadoop-0.20.203.0 and hive-0.7.1.
In our next step we are eyeing HBase integration with Hive. As far as we
understand from articles available on internet and apache site, we can use
HBase instead of derby as a metastore of Hive, this gives us more flexibilit
caller_name,
cf_cdr:caller_number")
> TBLPROPERTIES("hbase.table.name" = "hb_cdr");
Hope It Helps,
Chinna Rao Lalam
From: Madhusudhana Rao Podila [madhusudhana_pod...@infosys.com]
Sent: Friday, January 27, 2012 3:01 PM
To: user@hive.apache.o
)
Regards
Madhusudhana Rao. Podila
From: shashwat shriparv [mailto:dwivedishash...@gmail.com]
Sent: Friday, January 27, 2012 11:17 AM
To: user@hive.apache.org
Subject: Re: Problem with Hive/HBase integration
http://dl.dropbox.com/u/19454506/HadoopHIveHbaseReady.tar.gz
Download this its pre connfigured
http://dl.dropbox.com/u/19454506/HadoopHIveHbaseReady.tar.gz
Download this its pre connfigured hive and hbase. you need to change some
settings accordingly specific to your linux settings...
On Fri, Jan 27, 2012 at 11:07 AM, Madhusudhana Rao Podila <
madhusudhana_pod...@infosys.com> wrote:
> Hi
Hi
I have a problem in create a Hive table using existing HBase table (using
External Table concept) with multiple columns from column family (not using as
Map)
Case-1 :
I have created a table in HBase and able to map to Hive as an external table
just using only one column from the column fami
>
> Hope it helps!...
>
> Regards
> Bejoy.K.S
>
>
>
> From: Mohammad Tariq
> To: user
> Sent: Saturday, December 17, 2011 11:32 PM
> Subject: Hive-Hbase integration
>
> Hello list,
>
> I
__
From: Mohammad Tariq
To: user
Sent: Saturday, December 17, 2011 11:32 PM
Subject: Hive-Hbase integration
Hello list,
I have a small demo table in Hbase and I want to operate it
through Hive.Here is my table in Hbase -
hbase(main):021:0> scan 'em
Hello list,
I have a small demo table in Hbase and I want to operate it
through Hive.Here is my table in Hbase -
hbase(main):021:0> scan 'employee'
ROWCOLUMN+CELL
emp1 column=address:,
timestamp=1324119715536, value=#12-ban
Gotcha. Thanks John. If I getting running I will let you know.
Original Message
Subject: Re: Hive-Hbase integration require Hbase in Pseudo
distributed??
From: John Sichi
Date: Fri, December 02, 2011 4:51 pm
To: ""
As you can guess from the 0.89 depende
ording to the Hive documentation (see below) it doesn't
> work with any version of HBase other than 0.89, but there are three 0.89
> versions of HBase at archive.apache.org and the lib directories for Hive
> contain 0.89-SNAPSHOT.
>
>
> FYI: There's an official Hive/HBa
rg and the lib directories for Hive
contain 0.89-SNAPSHOT.
FYI: There's an official Hive/HBase integration page at the Confluence
wiki, but that doesn't work either:
https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration
It contains the instruction:
"The handler requir
pl.java:39)
>>>>> at
>>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>>>> at java.lang.reflect.Method.invoke(Method.java:597)
>>>>> at org.apache.hadoop.util.RunJar.main(RunJar.java:156)
>
Caused by: org.apache.hadoop.hbase.ZooKeeperConnectionException:
>>>> org.apache.zookeeper.KeeperException$ConnectionLossException:
>>>> KeeperErrorCode = ConnectionLoss for /hbase
>>>> at
>>>> org.apache.hadoop.hbase.zookeeper.ZooKeeperWatc
onManager.java:983)
>>> ... 25 more
>>> Caused by: org.apache.zookeeper.KeeperException$ConnectionLossException:
>>> KeeperErrorCode = ConnectionLoss for /hbase
>>> at
>>> org.apache.zookeeper.KeeperException.create(KeeperException.java:90)
>>&
ption.java:90)
>> at
>> org.apache.zookeeper.KeeperException.create(KeeperException.java:42)
>> at org.apache.zookeeper.ZooKeeper.create(ZooKeeper.java:637)
>> at
>> org.apache.hadoop.hbase.zookeeper.ZKUtil.createAndFailSilent(ZKUtil.java:886)
>> at
apache.hadoop.hbase.zookeeper.ZKUtil.createAndFailSilent(ZKUtil.java:886)
> at
> org.apache.hadoop.hbase.zookeeper.ZooKeeperWatcher.(ZooKeeperWatcher.java:133)
> ... 26 more
>
> )
> FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask
&
return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
On Fri, Dec 2, 2011 at 2:03 PM, Ankit Jain wrote:
> I think your hbase master is not running.
>
> Open the hive shell and run command :
> hbase> status
>
>
>
> On Fri, Dec 2, 2011 at 2:00 PM, Alok Kumar wrote:
, 2011 at 2:03 PM, Ankit Jain wrote:
> I think your hbase master is not running.
>
> Open the hive shell and run command :
> hbase> status
>
>
>
> On Fri, Dec 2, 2011 at 2:00 PM, Alok Kumar wrote:
>>
>> Hi,
>>
>> Does Hive-Hbase integration
I think your hbase master is not running.
Open the hive shell and run command :
hbase> status
On Fri, Dec 2, 2011 at 2:00 PM, Alok Kumar wrote:
> Hi,
>
> Does Hive-Hbase integration require Hbase running in pseudo-distributed
> mode?
>
> I've build my Hadoop fol
Hi,
Does Hive-Hbase integration require Hbase running in pseudo-distributed
mode?
I've build my Hadoop following this article
http://www.michael-noll.com/blog/2011/04/14/building-an-hadoop-0-20-x-version-for-hbase-0-90-2/
and have already replaced Hbase jar files accordingly..
I'm ge
Hello list,
Could anyone tell me the basic (and must) requirements for
integrating Hive and Hbase??? I have followed the " Hive HBase
Integration " link on cwiki but I am not able to do it. Need some
urgent help.Many thanks in advance.
Regards,
Mohammad Tariq
Please go through this blog ..
http://ankitasblogger.blogspot.com/2011/01/installing-hbase-in-cluster-complete.html
On Tue, Nov 29, 2011 at 2:11 PM, shashwat shriparv <
dwivedishash...@gmail.com> wrote:
> Hey Ankit, Thanks. my host file i tried using 127.0.0.1 still same
> problem, can you please
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.1localhost
#192.168.2.125ubuntu.
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 <
dwivedishash...@gmail.com> wrote:
> I have followed
> https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration my
> hbase is
yes !
I used the Cloudera CDH3 distribution whcih already includes HBase, Hive,
Pig, Hadoop tested & integrated !
Works like a charm !
It saved my day :)
https://ccp.cloudera.com/display/CDHDOC/CDH3+Installation+Guide
hope it will save your day too ;-)
shazz
On Wed, Sep 14, 2011 at 7:32 AM, Na
Hello !
Since one week I'm trying to integrate Hive with my current HBase instance
but whatever the results, all the stuff I follow to build it seems
unconsistent... So before I go mad, maybe somebody can help :)
What I have :
- HBase 0.9.3 running OpenTSDB (http://opentsdb.net/setup-hbase.html u
Hi Carl,
Thank you very much!
Cheers, Neerja
On Tue, Aug 2, 2011 at 11:31 PM, Carl Steinbach wrote:
> Hi Neerja,
>
> Ordinarily a POM for the hive-hbase-handler would be available
> from Cloudera's Maven repository, but it looks like we haven't
> generated one. We will get this resolved in CDH
Hi Neerja,
Ordinarily a POM for the hive-hbase-handler would be available
from Cloudera's Maven repository, but it looks like we haven't
generated one. We will get this resolved in CDH3u2. You can
track progress on this issue here:
https://issues.cloudera.org/browse/DISTRO-286
thrift-fb303-0.5.
Hi,
I am using
hive-hbase-handler-0.7.0-cdh3u0.jar (under hive-0.7.0-cdh3u0/lib)
thrift-fb303-0.5.0.jar (under hive-0.7.0-cdh3u0/lib)
thrift-0.2.0.jar (under hbase-0.90.1-cdh3u0/lib)
in my project.
We use Maven; could anyone please tell me where I can get the pom
information for these jars?
--
and hbase0.20.3)
without patch and copy the hive directory to my prod environment?
Thanks
Michael Sun
From: Sun, Michael
Sent: Friday, May 06, 2011 5:16 PM
To: 'user@hive.apache.org'
Subject: hive/hbase integration with rebuilt handler
Hi, can any of you he
Hi,
I am also trying the same but don't know the exact build steps. Someone please
tell the same.
-regards
Amit
From: Jean-Charles Thomas
To: Hive mailing list
Sent: Tue, 22 March, 2011 11:40:18 AM
Subject: Hive/hbase integration - Rebuild the St
> Hi,
>
>
>
> I am using hbase 0.90 and Hive 0.7 and would like to try the hive/hbase
> integration. From the Wiki Doc I could see that I have to rebuild the the
> handler:
>
>
>
> “If you are not using hbase-0.89.0, you will need to rebuild the handler
> wit
Hi,
I am using hbase 0.90 and Hive 0.7 and would like to try the hive/hbase
integration. From the Wiki Doc I could see that I have to rebuild the the
handler:
"If you are not using hbase-0.89.0, you will need to rebuild the handler with
the HBase jar matching your version, and chang
table in hbase from remote Hive shell. I am also
>> > passing the auxpath parameter to the shell (specifying the Hive/HBase
>> > integration related jars). In addition I have copied over these files to
>> > HDFS as well (I am using the user name hadoop - so the jars are
on my laptop to a remote
> > hadoop / hbase cluster and test out the HBase/Hive integration. I manage
> to
> > connect and create the table in hbase from remote Hive shell. I am also
> > passing the auxpath parameter to the shell (specifying the Hive/HBase
> > integration
so
> passing the auxpath parameter to the shell (specifying the Hive/HBase
> integration related jars). In addition I have copied over these files to
> HDFS as well (I am using the user name hadoop - so the jars are stored in
> HDFS under /user/hadoop).
> However when I fire a query
Hi,
I am trying to connect the hive shell running on my laptop to a remote
hadoop / hbase cluster and test out the HBase/Hive integration. I manage to
connect and create the table in hbase from remote Hive shell. I am also
passing the auxpath parameter to the shell (specifying the Hive/HBase
Jean-Daniel Cryans wrote:
Can you confirm that the machine you're running hive from can "telnet
192.168.1.101 2181" and pals? Can it even ping? If not, then either
the problem is that the machine cannot reach your zookeeper servers or
they aren't running. There's not that many other options.
J-D
Can you confirm that the machine you're running hive from can "telnet
192.168.1.101 2181" and pals? Can it even ping? If not, then either
the problem is that the machine cannot reach your zookeeper servers or
they aren't running. There's not that many other options.
J-D
Jean-Daniel Cryans wrote:
Sorry it that wasn't obvious, but you need to run hive using this command:
I am extremely Sorry Sir.
As per your instructions I am sending you the output of the create table
command.
Please check the attachment.
Thanks & Warm Regards
Adarsh Sharma
bin/hive
Jean-Daniel Cryans wrote:
Sorry it that wasn't obvious, but you need to run hive using this command:
bin/hive -hiveconf hive.root.logger=INFO,console
AND in the same shell create the table in order to have more
information. What we're trying to get looks like this:
http://pastebin.com/gvTXDxtE
Sorry it that wasn't obvious, but you need to run hive using this command:
bin/hive -hiveconf hive.root.logger=INFO,console
AND in the same shell create the table in order to have more
information. What we're trying to get looks like this:
http://pastebin.com/gvTXDxtE
Specifically, this line is
Dear all,
Sorry I am replying my own question because I found the cause and want
to discuss if anyone have an idea about it.
From the wiki's page I found that :
http://wiki.apache.org/hadoop/Hive/HBaseIntegration
*
Jean-Daniel Cryans wrote:
You also need to create the table in order to see the relevant debug
information, it won't create it until it needs it.
Sir
Check the output :
hive> CREATE TABLE hive_hbasetable_k(key int, value string)
> STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandl
You also need to create the table in order to see the relevant debug
information, it won't create it until it needs it.
J-D
On Jan 9, 2011 9:30 PM, "Adarsh Sharma" wrote:
> Jean-Daniel Cryans wrote:
>> Just figured that running the shell with this command will give all
>> the info you need:
>>
>>
Jean-Daniel Cryans wrote:
Just figured that running the shell with this command will give all
the info you need:
bin/hive -hiveconf hive.root.logger=INFO,console
Thanks JD, below is the output of this command :
had...@s2-ratw-1:~/project/hive-0.6.0/build/dist$ bin/hive -hiveconf
hive.roo
s the HMaster through the Web UI ? I think the
default port is 60010 (or you can check in your hbase-site.xml)
*I am able to connect Hbase through Web Ui and also able to create
tables in it. But error occurs when Hive/Hbase Integration comes into Play.*
Thanks,
Viral
On Thu, Jan 6, 2011 at 9:
est Regards
>
> Adarsh Sharma
>
>
> 4) Use your new Hive build
>
>
>
> And use this new Hive build but I am sorry but the error remains the same.
>
>
> JVS
>
> On Jan 6, 2011, at 2:34 AM, Adarsh Sharma wrote:
>
>
>
> Dear all,
>
> I am sorry I
Just figured that running the shell with this command will give all
the info you need:
bin/hive -hiveconf hive.root.logger=INFO,console
J-D
On Fri, Jan 7, 2011 at 9:57 AM, Jean-Daniel Cryans wrote:
> While testing other things yesterday on my local machine, I
> encountered the same stack traces
While testing other things yesterday on my local machine, I
encountered the same stack traces. Like I said the other day, which
you seem to have discarded while debugging your issue, is that it's
not able to connect to Zookeeper.
Following the cue, I added these lines in HBaseStorageHandler.setCon
John Sichi wrote:
On Jan 6, 2011, at 9:53 PM, Adarsh Sharma wrote:
I want to know why it occurs in hive.log
2011-01-05 15:19:36,783 ERROR DataNucleus.Plugin (Log4JLogger.java:error(115)) - Bundle
"org.eclipse.jdt.core" requires "org.eclipse.core.resources" but it cannot be
resolved.
On Jan 6, 2011, at 9:53 PM, Adarsh Sharma wrote:
> I want to know why it occurs in hive.log
>
> 2011-01-05 15:19:36,783 ERROR DataNucleus.Plugin
> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
> "org.eclipse.core.resources" but it cannot be resolved.
>
That is a bogus
And use this new Hive build but I am sorry but the error remains the same.
JVS
On Jan 6, 2011, at 2:34 AM, Adarsh Sharma wrote:
Dear all,
I am sorry I am posting this message again but I can't able to locate the root
cause after googled a lot.
I am trying Hive/Hbase Integration f
am sorry I am posting this message again but I can't able to locate the
> root cause after googled a lot.
>
> I am trying Hive/Hbase Integration from the past 2 days. I am facing the
> below issue while creating external table in Hive.
>
> I am using hadoop-0.20.2, hba
1 - 100 of 107 matches
Mail list logo
