[ https://issues.apache.org/jira/browse/HIVE-6972?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vaibhav Gumashta updated HIVE-6972: ----------------------------------- Release Note: (was: The JDBC Uri for HiveServer2 has the form: {code} jdbc:hive2://host1:port1,host2:port2/dbName;sess_var_list?hive_conf_list#hive_var_list {code} Ideally, sess_var_list is supposed to be used to pass parameters that will be used within the JDBC Driver. However, some of the http mode parameters were being passed in the hive_conf_list which we've fixed now (in a backward compatible way). Additionally, JDBC Driver has a naming convention for the parameters in the JDBC Uri which were not followed to the sasl.qop parameter. We've renamed it in a backward compatible way. Details: *1. HTTP Mode params:* *Old example uri:* {code} jdbc:hive2://host:port/dbName;user=username;password=password?hive.server2.transport.mode=http;hive.server2.thrift.http.path=httpEndpoint {code} *New example uri:* {code} jdbc:hive2://host:port/dbName;user=username;password=password;transportMode=http;httpPath=httpEndpoint?hive.server2.logging.operation.enabled=false {code} As you can see above, {{hive.server2.transport.mode}} has been renamed to {{transportMode}}, {{hive.server2.thrift.http.path}} has been renamed to {{httpPath}} and both have been moved from {{hive_conf_list}} to {{sess_var_list}}. *2. Sasl qop renaming:* *Old example uri:* {code} jdbc:hive2://host:port/dbName;principal=hiveserver2KerberosPrincipal;sasl.qop=qopValue {code} *New example uri:* {code} jdbc:hive2://host:port/dbName;principal=hiveserver2KerberosPrincipal;saslQop=qopValue {code} As you can see {{sasl.qop}} has been renamed to {{saslQop}}. Note: all changes are backward compatible and print a deprecation message like the following: {code} 0: jdbc:hive2://localhost:10001> !connect jdbc:hive2://localhost:10001/;sasl.qop=auth?hive.server2.transport.mode=http;hive.server2.thrift.http.path=cliservice username password org.apache.hive.jdbc.HiveDriver Connecting to jdbc:hive2://localhost:10007/;sasl.qop=auth?hive.server2.transport.mode=http;hive.server2.thrift.http.path=cliservice 14/10/07 16:22:24 INFO jdbc.Utils: Supplied authorities: localhost:10001 14/10/07 16:22:24 WARN jdbc.Utils: ***** JDBC param deprecation ***** 14/10/07 16:22:24 WARN jdbc.Utils: The use of sasl.qop is deprecated. 14/10/07 16:22:24 WARN jdbc.Utils: Please use saslQop like so: jdbc:hive2://<host>:<port>/dbName;saslQop=<qop_value> 14/10/07 16:22:24 WARN jdbc.Utils: ***** JDBC param deprecation ***** 14/10/07 16:22:24 WARN jdbc.Utils: The use of hive.server2.transport.mode is deprecated. 14/10/07 16:22:24 WARN jdbc.Utils: Please use transportMode like so: jdbc:hive2://<host>:<port>/dbName;transportMode=<transport_mode_value> 14/10/07 16:22:24 WARN jdbc.Utils: ***** JDBC param deprecation ***** 14/10/07 16:22:24 WARN jdbc.Utils: The use of hive.server2.thrift.http.path is deprecated. 14/10/07 16:22:24 WARN jdbc.Utils: Please use httpPath like so: jdbc:hive2://<host>:<port>/dbName;httpPath=<http_path_value> Connected to: Apache Hive (version 0.14.0-SNAPSHOT) Driver: Hive JDBC (version 0.14.0-SNAPSHOT) Transaction isolation: TRANSACTION_REPEATABLE_READ {code} ) > jdbc HTTP configuration options should be part of sessionConf part of > connection string > --------------------------------------------------------------------------------------- > > Key: HIVE-6972 > URL: https://issues.apache.org/jira/browse/HIVE-6972 > Project: Hive > Issue Type: Bug > Components: HiveServer2, JDBC > Affects Versions: 0.13.0 > Reporter: Thejas M Nair > Assignee: Vaibhav Gumashta > Fix For: 0.14.0 > > Attachments: HIVE-6972.1.patch, HIVE-6972.2.patch, HIVE-6972.3.patch, > HIVE-6972.4.patch > > > The http connection parameters are currently part of the HiveConf section of > the connection string. It should ideally be part of SessionConf section, as > that is where rest of the connection parameters are. > HTTP transport parameters are not part of the hiveconfiguration parameters > that need to be set. > ie > instead of > jdbc:hive2://<host>:<port>/<db>?hive.server2.transport.mode=http;hive.server2.thrift.http.path=<http_endpoint> > it should be - > jdbc:hive2://<host>:<port>/<db>;transportMode=http;httpPath=<http_endpoint> -- This message was sent by Atlassian JIRA (v6.3.4#6332)