You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Prasad Mujumdar (JIRA)" <ji...@apache.org> on 2013/03/15 20:36:13 UTC
[jira] [Commented] (HIVE-4185) Document HiveServer2 JDBC and
Beeline CLI in the user documentation
[ https://issues.apache.org/jira/browse/HIVE-4185?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13603741#comment-13603741 ]
Prasad Mujumdar commented on HIVE-4185:
---------------------------------------
JDBC -
Hive includes a new JDBC client driver for HiveServer2. It supports both embedded and remote access to HiveServer2.
The JDBC connection URL format has prefix is jdbc:hive2:// and the Driver class is org.apache.hive.jdbc.HiveDriver. Note that this is different from the old hiveserver. For remote server, the URL format is jdbc:hive2://<host>:<port>/<db>. For embedded server, the URL format is jdbc:hive2:// (no host or port)
When connecting to HiveServer2 with kerberos authentication, the URL format is jdbc:hive2://<host>:<port>/<db>;principal=<Server_Principal_of_HiveServer2>. The client needs to have a valid Kerberos ticket in the ticket cache before connecting. In case of LDAP or customer pass through authentication, the client needs to pass the valid user name and password to JDBC connection API.
Beeline Shell -
Hive includes a new command shell Beeline that works with HiveServer2. Its a JDBC client that is based on SQLLine CLI (http://sqlline.sourceforge.net/). There’s an detailed documentation of the SQLLine options available at http://sqlline.sourceforge.net/#manual which is applicable to Beeline.
> Document HiveServer2 JDBC and Beeline CLI in the user documentation
> --------------------------------------------------------------------
>
> Key: HIVE-4185
> URL: https://issues.apache.org/jira/browse/HIVE-4185
> Project: Hive
> Issue Type: Bug
> Components: Documentation, HiveServer2
> Reporter: Prasad Mujumdar
> Assignee: Prasad Mujumdar
>
> The user documentation https://cwiki.apache.org/confluence/display/Hive/HiveClient includes information about client connection to thrift server.
> We need to include HiveServer2 client details (JDBC, Beeline)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira