[HIVE-10753] hs2 jdbc url - wrong connection string cause error on beeline/jdbc/odbc client, misleading message

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.2.1
• Component/s: Beeline, JDBC
• Assignee: Hari Sankar Sivarama Subramaniyan
• Reporter: Hari Sankar Sivarama Subramaniyan
• Created: 19/May/15 18:14
• Updated: 05/Jun/15 20:57
• Resolved: 27/May/15 07:13

Description

beeline -u 'jdbc:hive2://localhost:10001/default?httpPath=/;transportMode=http' -n hdiuser
scan complete in 15ms
Connecting to jdbc:hive2://localhost:10001/default?httpPath=/;transportMode=http

Java heap space
Beeline version 0.14.0.2.2.4.1-1 by Apache Hive
0: jdbc:hive2://localhost:10001/default (closed)> ^C
hdiuser@headnode0:~$ 

But it works if I use the deprecated param -

hdiuser@headnode0:~$ beeline -u 'jdbc:hive2://localhost:10001/default?hive.server2.transport.mode=http;httpPath=/' -n hdiuser
scan complete in 12ms
Connecting to jdbc:hive2://localhost:10001/default?hive.server2.transport.mode=http;httpPath=/
15/04/28 23:16:46 [main]: WARN jdbc.Utils: ***** JDBC param deprecation *****
15/04/28 23:16:46 [main]: WARN jdbc.Utils: The use of hive.server2.transport.mode is deprecated.
15/04/28 23:16:46 [main]: WARN jdbc.Utils: Please use transportMode like so: jdbc:hive2://<host>:<port>/dbName;transportMode=<transport_mode_value>
Connected to: Apache Hive (version 0.14.0.2.2.4.1-1)
Driver: Hive JDBC (version 0.14.0.2.2.4.1-1)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 0.14.0.2.2.4.1-1 by Apache Hive
0: jdbc:hive2://localhost:10001/default> show tables;
+------------------+--+
|     tab_name     |
+------------------+--+
| hivesampletable  |
+------------------+--+
1 row selected (18.181 seconds)
0: jdbc:hive2://localhost:10001/default> ^C
hdiuser@headnode0:~$ ^C

The reason for the above message is :
The url is wrong. Correct one:

beeline -u 'jdbc:hive2://localhost:10001/default;httpPath=/;transportMode=http' -n hdiuser

Note the ";" instead of "?". The deprecation msg prints the format as well:

Please use transportMode like so: jdbc:hive2://<host>:<port>/dbName;transportMode=<transport_mode_value>