- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Cannot connect to beeline
- Labels:
-
Apache Hadoop
-
Apache Hive
Created on 02-06-2014 07:16 AM - edited 09-16-2022 01:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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..
Created 02-07-2014 08:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
!connect jdbc:hive2://hostname:10000/default;principal=hive/hostname@PRINCIPAL.COM
username and password blank....
Thanks for helping me out zhang...
Created 02-06-2014 10:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It seems you're using the wrong JDBC driver. For HiveServer2, the JDBC driver class is org.apache.hive.jdbc.HiveDriver.
Created 02-06-2014 10:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
!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)
Created 02-06-2014 10:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
For thrift, need to use a different URL ?
Created 02-06-2014 11:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created 02-06-2014 11:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created 02-06-2014 12:09 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Created 02-06-2014 12:18 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HiverServer2 instance is running with the default, then just leave them
blank.
Created 02-06-2014 12:19 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Created 02-06-2014 12:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
