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 >> Problem when trying to connect to hive server using jdbc


Copy link to this message
-
Re: Problem when trying to connect to hive server using jdbc
Ok I found out that there is a CDH users Google group and I have joined it
This thread can be found here
https://groups.google.com/a/cloudera.org/forum/#!search/Problem$20when$20trying$20to$20connect$20to$20hive$20server$20using$20jdbc/cdh-user/bzlMmLIEqA8/xSrUT0rugbcJ
Thanks
sanjay

From: Sanjay Subramanian <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Reply-To: "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Date: Wednesday, April 3, 2013 11:52 AM
To: "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>, "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Cc: "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Subject: Re: Problem when trying to connect to hive server using jdbc

Is there a google group for Hive like cdh-user group ?

To calrify do I need to subscribe to the [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]> like I did for Hive ?

Thanks
Sanjay

From: Mark Grover <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Reply-To: "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Date: Wednesday, April 3, 2013 11:20 AM
To: "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Cc: "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Subject: Re: Problem when trying to connect to hive server using jdbc

(bcc: [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>)

Moving to cdh-user since this is CDH specific

On Wed, Apr 3, 2013 at 10:40 AM, demian rosas <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> wrote:
No worries,

All the opposite, thanks a lot for you help. After looking at those places you told me, now I have less places to look at.

Cheers,
Demian
On 2 April 2013 20:06, Sanjay Subramanian <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> wrote:
Wow..I think I am out of ideas for today… :-)
sorry could not make that work for u.
I know how frustrating that can be…
From: demian rosas <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Reply-To: "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Date: Tuesday, April 2, 2013 7:50 PM
To: "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Subject: Re: Problem when trying to connect to hive server using jdbc

Done, unfortunately the output remain the same.

with both,

<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:mysql://localhost/metastore?createDatabaseIfNotExist=true</value>
  <description>JDBC connect string for a JDBC metastore</description>
</property>

commented and uncommented.
On 2 April 2013 19:38, Sanjay Subramanian <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> wrote:
Add
127.0.0.1       localhost

Comment
#127.0.0.1 localhost.localdomainloghost

So the file should look like

127.0.0.1       localhost
#127.0.0.1 localhost.localdomainloghost
10.240.81.72 myhost.myemployer.com<http://myemployer.com> myhost

From: demian rosas <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Reply-To: "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Date: Tuesday, April 2, 2013 7:33 PM
To: "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Subject: Re: Problem when trying to connect to hive server using jdbc

# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomainloghost
10.240.81.72 myhost.myemployer.com<http://myemployer.com> myhost
On 2 April 2013 19:27, Sanjay Subramanian <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> wrote:
Whats in your /etc/hosts ?

From: demian rosas <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Reply-To: "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Date: Tuesday, April 2, 2013 7:24 PM
To: "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Subject: Re: Problem when trying to connect to hive server using jdbc

I did it. It seems to get connected to the metastore at least for a moment, but then the connection is lost.

This is the output:

hive> show tables;
13/04/02 19:22:37 INFO ql.Driver: <PERFLOG method=Driver.run>
13/04/02 19:22:37 INFO ql.Driver: <PERFLOG method=TimeToSubmit>
13/04/02 19:22:37 INFO ql.Driver: <PERFLOG method=compile>
13/04/02 19:22:37 INFO parse.ParseDriver: Parsing command: show tables
13/04/02 19:22:37 INFO parse.ParseDriver: Parse Completed
13/04/02 19:22:37 INFO ql.Driver: Semantic Analysis Completed
13/04/02 19:22:37 INFO exec.ListSinkOperator: Initializing Self 0 OP
13/04/02 19:22:37 INFO exec.ListSinkOperator: Operator 0 OP initialized
13/04/02 19:22:37 INFO exec.ListSinkOperator: Initialization Done 0 OP
13/04/02 19:22:37 INFO ql.Driver: Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:tab_name, type:string, comment:from deserializer)], properties:null)
13/04/02 19:22:37 INFO ql.Driver: </PERFLOG method=compile start=1364955757591 end=1364955757956 duration=365>
13/04/02 19:22:37 INFO ql.Driver: <PERFLOG method=Driver.execute>
13/04/02 19:22:37 INFO ql.Driver: Starting command: show tables
13/04/02 19:22:37 INFO ql.Driver: </PERFLOG method=TimeToSubmit start=1364955757591 end=1364955757969 duration=378>
13/04/02 19:22:38 INFO hive.metastore: Trying to connect to metastore with URI thrift://10.240.81.72:3306<http://10.240.81.72:3306>
13/04/02 19:22:38 INFO hive.metastore: Waiting 1 seconds before next connection attempt.
13/04/02 19:22:39
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