You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Michael Styles <Mi...@ca.ibm.com> on 2010/09/14 15:47:26 UTC

Windows JDBC Connection to Hive

I am new to Hive. I am trying to connect to Hive from a Windows JDBC 
client. The Hive server is running on a Linux machine. I'm getting the 
following error:

Caused by: java.sql.SQLException: Invalid URL: 
jdbc:hive//myserver:10000/default
                 at 
org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:70)
                 at 
org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:108

Any ideas on what the problem is?
Thanks.

Re: Windows JDBC Connection to Hive

Posted by Michael Styles <Mi...@ca.ibm.com>.
I just realized I was missing a ':' in the URL specification - everything 
is fine now.





Michael Styles
Senior Software Developer 
Business Analytics

Tel: (613) 356-6483, T/L 315-6483
Email: michael.styles@ca.ibm.com






From:   Michael Styles/Ottawa/IBM@IBMCA
To:     hive-user@hadoop.apache.org
Date:   09/14/2010 10:47 AM
Subject:        Re: Windows JDBC Connection to Hive



telnet myserver 10000 does not work. I get the following error: 

Could not open connection to the host, on port 10000: Connect failed 

The following works: 

ssh myserver




Michael Styles
Senior Software Developer 
Business Analytics

Tel: (613) 356-6483, T/L 315-6483
Email: michael.styles@ca.ibm.com 







From:        Ariel Leiva <ar...@gmail.com> 
To:        hive-user@hadoop.apache.org 
Date:        09/14/2010 09:54 AM 
Subject:        Re: Windows JDBC Connection to Hive 



Hi Michael, could you give more details about this exception? 

What happen if you do a 

telnet myserver 10000 

Ariel

On Tue, Sep 14, 2010 at 10:47 AM, Michael Styles <
Michael.Styles@ca.ibm.com> wrote: 
I am new to Hive. I am trying to connect to Hive from a Windows JDBC 
client. The Hive server is running on a Linux machine. I'm getting the 
following error: 

Caused by: java.sql.SQLException: Invalid URL: 
jdbc:hive//myserver:10000/default
                at 
org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:70)
                at 
org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:108 

Any ideas on what the problem is? 
Thanks.

Re: Windows JDBC Connection to Hive

Posted by Michael Styles <Mi...@ca.ibm.com>.
telnet myserver 10000 does not work. I get the following error:

Could not open connection to the host, on port 10000: Connect failed

The following works:

ssh myserver





Michael Styles
Senior Software Developer 
Business Analytics

Tel: (613) 356-6483, T/L 315-6483
Email: michael.styles@ca.ibm.com






From:   Ariel Leiva <ar...@gmail.com>
To:     hive-user@hadoop.apache.org
Date:   09/14/2010 09:54 AM
Subject:        Re: Windows JDBC Connection to Hive



Hi Michael, could you give more details about this exception?

What happen if you do a 

telnet myserver 10000

Ariel

On Tue, Sep 14, 2010 at 10:47 AM, Michael Styles <
Michael.Styles@ca.ibm.com> wrote:
I am new to Hive. I am trying to connect to Hive from a Windows JDBC 
client. The Hive server is running on a Linux machine. I'm getting the 
following error: 

Caused by: java.sql.SQLException: Invalid URL: 
jdbc:hive//myserver:10000/default
                at 
org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:70)
                at 
org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:108 

Any ideas on what the problem is? 
Thanks.

Re: Windows JDBC Connection to Hive

Posted by Ariel Leiva <ar...@gmail.com>.
Hi Michael, could you give more details about this exception?

What happen if you do a

telnet myserver 10000

Ariel

On Tue, Sep 14, 2010 at 10:47 AM, Michael Styles
<Mi...@ca.ibm.com>wrote:

> I am new to Hive. I am trying to connect to Hive from a Windows JDBC
> client. The Hive server is running on a Linux machine. I'm getting the
> following error:
>
> Caused by: java.sql.SQLException: Invalid URL:
> jdbc:hive//myserver:10000/default
>                 at
> org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:70)
>                 at
> org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:108
>
> Any ideas on what the problem is?
> Thanks.
>