question Re: Cannot connect to beeline in Archives of Support Questions (Read Only)

Cannot connect to beeline

Manikumar Juttukonda — Fri, 16 Sep 2022 08:53:38 GMT

I am trying to connect beeline from client system but I am not able to...

Beeline version 0.10.0-cdh4.5.0 by Apache Hive
beeline> !connect jdbc:hive2://hostname.com:10000 org.apache.hadoop.hive.jdbc.HiveDriver
scan complete in 6ms
Connecting to jdbc:hive2://hostname.com:10000
Enter password for jdbc:hive2://hostname.com:10000: ********
Error: Invalid URL: jdbc:hive2://hostname.com:10000 (state=08S01,code=0)

Am I missing anything here...Please advice..

Re: Cannot connect to beeline

xzhang — Thu, 06 Feb 2014 18:28:26 GMT

It seems you're using the wrong JDBC driver. For HiveServer2, the JDBC driver class is org.apache.hive.jdbc.HiveDriver.

Re: Cannot connect to beeline

Manikumar Juttukonda — Thu, 06 Feb 2014 18:41:57 GMT

I also tried using org.apache.hive.jdbc.HiveDriver but no luck

!connect jdbc:hive2://hostname:10000 org.apache.hive.jdbc.HiveDriver
scan complete in 6ms
Connecting to jdbc:hive2://hostname:10000
Enter password for jdbc:hive2://hostname:10000: ********
Error: Invalid URL: jdbc:hive2://hostname:10000 (state=08S01,code=0)

Re: Cannot connect to beeline

Manikumar Juttukonda — Thu, 06 Feb 2014 18:54:38 GMT

We are using thrift service to connect to our hive metastore...
For thrift, need to use a different URL ?

Re: Cannot connect to beeline

xzhang — Thu, 06 Feb 2014 19:03:04 GMT

I must be misunderstanding the issue. If you need to connect HiveServer2
via JDBC, then the URL given for beeline should be one that has
HiveServer2's hostname/port.

If you need to connect to MetaStore via thrift, then you need to give
MetaStore server's hostname and port number to your thrift client.

HiveServer2 server and MetaStore server are two different servers running
on different host/port.

Re: Cannot connect to beeline

Manikumar Juttukonda — Thu, 06 Feb 2014 19:49:52 GMT

Sorry for confusing you...
I need to connect to the hiveserver2 using beeline and create a database.
the URL would be jdbc:hive2://hiveserver2_hostname:10000 org.apache.hive.jdbc.HiveDriver ?
I tried this too, got the same error.

Re: Cannot connect to beeline

Manikumar Juttukonda — Thu, 06 Feb 2014 20:09:31 GMT

What would be the username and password that I need to supply while executing this command ?

Re: Cannot connect to beeline

xzhang — Thu, 06 Feb 2014 20:18:04 GMT

Those would be what you're given by the HiverServer2 admin. If your
HiverServer2 instance is running with the default, then just leave them
blank.

Re: Cannot connect to beeline

Manikumar Juttukonda — Thu, 06 Feb 2014 20:19:26 GMT

When I leave it blank it is asking me for the password. I am not sure which password to supply...

Re: Cannot connect to beeline

Manikumar Juttukonda — Thu, 06 Feb 2014 20:22:58 GMT

I tried with all the hiveserver2 running hosts...still the same problem.
when I do !list i see below output
scan complete in 1211ms
9 driver classes found
Compliant Version Driver Class
yes 1.0 org.apache.commons.dbcp.PoolingDriver
yes 10.4 org.apache.derby.jdbc.AutoloadedDriver
yes 10.4 org.apache.derby.jdbc.EmbeddedDriver
no 0.10 org.apache.hadoop.hive.jdbc.HiveDriver
no 0.10 org.apache.hive.jdbc.HiveDriver
yes 1.0 org.datanucleus.store.rdbms.datasource.dbcp.PoolingDriver
no 1.8 org.hsqldb.jdbcDriver
no 9.0 org.postgresql.Driver
yes 2.1 sun.jdbc.odbc.JdbcOdbcDriver

For the driver you recommended me to use says Compliant "no". Do I need to worry about this ?

Re: Cannot connect to beeline

xzhang — Thu, 06 Feb 2014 20:26:04 GMT

Also leave it blank.

Re: Cannot connect to beeline

Manikumar Juttukonda — Thu, 06 Feb 2014 20:27:50 GMT

no luck same error...

!connect jdbc:hive2://hostname:10000 org.apache.hive.jdbc.HiveDriver
Connecting to jdbc:hive2://hostname:10000
Enter password for jdbc:hive2://hostname:10000:
Error: Invalid URL: jdbc:hive2://hostname:10000 (state=08S01,code=0)

Re: Cannot connect to beeline

xzhang — Thu, 06 Feb 2014 20:29:04 GMT

Could you try not specifying the driver class and let the system take the
default?

Re: Cannot connect to beeline

Manikumar Juttukonda — Thu, 06 Feb 2014 20:31:23 GMT

Still same error...

Connecting to jdbc:hive2://hostname:10000
Enter username for jdbc:hive2://hostname:10000:
Enter password for jdbc:hive2://hostname:10000:
Error: Invalid URL: jdbc:hive2://hostname:10000 (state=08S01,code=0)

Re: Cannot connect to beeline

xzhang — Thu, 06 Feb 2014 20:40:04 GMT

Could you try "beeline -u jdbc:hive2://" to see if this work for you?

Re: Cannot connect to beeline

Manikumar Juttukonda — Thu, 06 Feb 2014 20:43:22 GMT

Still the same...

$ beeline -u jdbc:hive2://hostname:10000
scan complete in 10ms
Connecting to jdbc:hive2://hostname:10000
Error: Invalid URL: jdbc:hive2://hostname:10000 (state=08S01,code=0)
Beeline version 0.10.0-cdh4.5.0 by Apache Hive
0: jdbc:hive2://hostname.c>

Re: Cannot connect to beeline

xzhang — Thu, 06 Feb 2014 20:47:07 GMT

I meant you literally try "beeline -u jdbc:hive2://"...

Re: Cannot connect to beeline

Manikumar Juttukonda — Thu, 06 Feb 2014 20:49:11 GMT

I see a different message now...

beeline -u jdbc:hive2://
scan complete in 10ms
Connecting to jdbc:hive2://
14/02/06 15:48:18 WARN conf.HiveConf: DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.
Unable to login to kerberos with given principal/keytab
Beeline version 0.10.0-cdh4.5.0 by Apache Hive
0: jdbc:hive2://>

Re: Cannot connect to beeline

xzhang — Thu, 06 Feb 2014 21:06:04 GMT

can you show the result of the following:

env | grep HIVE

Re: Cannot connect to beeline

Manikumar Juttukonda — Thu, 06 Feb 2014 21:08:07 GMT

Command returned nothing...

I don't have anything in env that match pattern "HIVE"