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
(bcc: [EMAIL PROTECTED])

Moving to cdh-user since this is CDH specific

On Wed, Apr 3, 2013 at 10:40 AM, demian rosas <[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]> 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]>
>> Reply-To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
>> Date: Tuesday, April 2, 2013 7:50 PM
>> To: "[EMAIL PROTECTED]" <[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]> 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 myhost
>>>
>>>
>>>
>>>    From: demian rosas <[EMAIL PROTECTED]>
>>> Reply-To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
>>> Date: Tuesday, April 2, 2013 7:33 PM
>>> To: "[EMAIL PROTECTED]" <[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 myhost
>>>
>>>
>>> On 2 April 2013 19:27, Sanjay Subramanian <
>>> [EMAIL PROTECTED]> wrote:
>>>
>>>>  Whats in your /etc/hosts ?
>>>>
>>>>   From: demian rosas <[EMAIL PROTECTED]>
>>>> Reply-To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
>>>> Date: Tuesday, April 2, 2013 7:24 PM
>>>> To: "[EMAIL PROTECTED]" <[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
>>>> 13/04/02 19:22:38 INFO hive.metastore: Waiting 1 seconds before next
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