[jira] [Commented] (HIVE-11106) HiveServer2 JDBC (greater than v0.13.1) cannot connect to non-default database

["Chen Xin Yu (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-11106?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14903988#comment-14903988 ] 

Chen Xin Yu commented on HIVE-11106:
------------------------------------

It works for me with hive-jdbs-standalone.jar, and the version is 1.2.1.
jdbc connection: "jdbc:hive2://xxx:10000/testdb", I select data from a table testdb_t1 in database testdb, it works well. 


> HiveServer2 JDBC (greater than v0.13.1) cannot connect to non-default database
> ------------------------------------------------------------------------------
>
>                 Key: HIVE-11106
>                 URL: https://issues.apache.org/jira/browse/HIVE-11106
>             Project: Hive
>          Issue Type: Improvement
>          Components: JDBC
>    Affects Versions: 0.14.0
>            Reporter: Tom Coleman
>
> Using HiveServer 0.14.0 or greater, I cannot connect a non-default database.
> For example when connecting to HiveServer to via the following URLs, the session uses the 'default' database, instead of the intended database.
> jdbc://localhost:10000/customDb
> This exact issue was fixed in 0.13.1 of HiveServer from https://issues.apache.org/jira/browse/HIVE-5904 but for some reason this fix was not ported to v0.14.0 or greater. From looking at the source, it looks as if this fix was overriden by another change to the HiveConnection class, was this intentional or a defect reintroduced from another defect fix?
> This means that we need to use 0.13.1 in order to connect to a non-default database via JDBC and we cannot upgrade Hive versions. We don't want placing a JDBC interceptor to inject "use customDb" each time a connection is borrowed from the pool on production code. One should be able to connect straight to the non-default database via the JDBC URL.
> Now it perhaps could be a simple oversight on my behalf in which the syntax to connect to a non-default database has changed from 0.14.0 onwards but I'd be grateful is this could be confirmed.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)