[jira] [Commented] (IMPALA-11992) Support setting query options in JDBC's connection URL

["ASF subversion and git services (Jira)" <ji...@apache.org>]

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

ASF subversion and git services commented on IMPALA-11992:
----------------------------------------------------------

Commit d12c05d5da36fb124869e360fc29392dfd03a064 in impala's branch refs/heads/master from Xiang Yang
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=d12c05d5d ]

IMPALA-11992: Support setting query options in Hive JDBC's connection URL

Hive JDBC support setting hive configurations in Connection URL's query
part, thus we can map impala's query options to hive configurations to
support setting query options on the hive JDBC client side. But hive
JDBC will add a "set:hiveconf:" prefix to the configuration key when
request OpenSession() thrift API, we should remove the configuration
key prefix in OpenSession() so that we can set valid query options.

Testing:
 - update the 'TestHS2::test_open_session_query_options' EE test.
 - add a FE test 'testSetQueryOptionsInConnectionURL' to JdbcTest.

Change-Id: Ie184a0c2404f36a3ee28296336f6545615a5c6ca
Reviewed-on: http://gerrit.cloudera.org:8080/19612
Reviewed-by: Impala Public Jenkins <im...@cloudera.com>
Tested-by: Impala Public Jenkins <im...@cloudera.com>


> Support setting query options in JDBC's connection URL
> ------------------------------------------------------
>
>                 Key: IMPALA-11992
>                 URL: https://issues.apache.org/jira/browse/IMPALA-11992
>             Project: IMPALA
>          Issue Type: Improvement
>            Reporter: yx91490
>            Assignee: yx91490
>            Priority: Major
>
> Hive JDBC support setting hive confs in Connection URL: 
> {code:java}
> jdbc:hive2://<host1>:<port1>/dbName;sess_var_list?hive_conf_list#hive_var_list {code}
> it will add a "set:hiveconf:" prefix to the configuration key when request openSession: [https://github.com/apache/hive/blob/master/jdbc/src/java/org/apache/hive/jdbc/HiveConnection.java#L1110.]
> But impala will directly map the configuration's key value pair to query option, without cut the key's prefix: [https://github.com/apache/impala/blob/4.2.0/be/src/service/impala-hs2-server.cc#L365] , we can modify this behavior to satisfy hive jdbc's expectation, and then support setting query options in hive jdbc's connection URL.
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org