Reply
Cloudera Employee
Posts: 14
Registered: ‎08-06-2013

Re: Cannot connect to beeline

Also leave it blank.

Expert Contributor
Posts: 126
Registered: ‎11-01-2013

Re: Cannot connect to beeline

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)
Em Jay
Cloudera Employee
Posts: 14
Registered: ‎08-06-2013

Re: Cannot connect to beeline

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

Expert Contributor
Posts: 126
Registered: ‎11-01-2013

Re: Cannot connect to beeline

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)
Em Jay
Cloudera Employee
Posts: 14
Registered: ‎08-06-2013

Re: Cannot connect to beeline

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

Expert Contributor
Posts: 126
Registered: ‎11-01-2013

Re: Cannot connect to beeline

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>

Em Jay
Cloudera Employee
Posts: 14
Registered: ‎08-06-2013

Re: Cannot connect to beeline

I meant you literally try "beeline -u jdbc:hive2://"...
Expert Contributor
Posts: 126
Registered: ‎11-01-2013

Re: Cannot connect to beeline

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://>

Em Jay
Cloudera Employee
Posts: 14
Registered: ‎08-06-2013

Re: Cannot connect to beeline

can you show the result of the following:

env | grep HIVE

Expert Contributor
Posts: 126
Registered: ‎11-01-2013

Re: Cannot connect to beeline

Command returned nothing...

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