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

Switch to Plain View
Hive, mail # user - Problem when trying to connect to hive server using jdbc


+
demian rosas 2013-04-01, 20:43
+
Sanjay Subramanian 2013-04-02, 01:08
+
demian rosas 2013-04-02, 01:36
+
Sanjay Subramanian 2013-04-02, 01:47
+
demian rosas 2013-04-03, 00:26
+
demian rosas 2013-04-03, 00:30
+
Sanjay Subramanian 2013-04-03, 00:38
+
demian rosas 2013-04-03, 00:56
+
Sanjay Subramanian 2013-04-03, 01:09
+
demian rosas 2013-04-03, 01:18
+
Sanjay Subramanian 2013-04-03, 01:36
+
demian rosas 2013-04-03, 01:48
+
Sanjay Subramanian 2013-04-03, 01:55
+
demian rosas 2013-04-03, 02:06
+
Sanjay Subramanian 2013-04-03, 02:12
+
demian rosas 2013-04-03, 02:24
+
Sanjay Subramanian 2013-04-03, 02:27
+
demian rosas 2013-04-03, 02:33
+
Sanjay Subramanian 2013-04-03, 02:38
+
demian rosas 2013-04-03, 02:50
+
Sanjay Subramanian 2013-04-03, 03:06
+
demian rosas 2013-04-03, 17:40
Copy link to this message
-
Re: Problem when trying to connect to hive server using jdbc
Mark Grover 2013-04-03, 18:20
(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
+
Sanjay Subramanian 2013-04-03, 18:52
+
Sanjay Subramanian 2013-04-03, 20:19
+
demian rosas 2013-04-03, 03:05
+
demian rosas 2013-04-03, 01:31
+
Sanjay Subramanian 2013-04-03, 01:38
+
Sanjay Subramanian 2013-04-03, 00:34