Hari Sankar Sivarama Subramaniyan created HIVE-10753:
--------------------------------------------------------
Summary: hs2 jdbc url - wrong connection string cause OOM error on
beeline/jdbc/odbc client, misleading message
Key: HIVE-10753
URL: https://issues.apache.org/jira/browse/HIVE-10753
Project: Hive
Issue Type: Bug
Components: Beeline, JDBC
Reporter: Hari Sankar Sivarama Subramaniyan
Assignee: Hari Sankar Sivarama Subramaniyan
{noformat}
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)> ^Chdiuser@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> ^Chdiuser@headnode0:~$ ^C
{noformat}
The reason for the above message is :
The url is wrong. Correct one:
{code}
beeline -u 'jdbc:hive2://localhost:10001/default;httpPath=/;transportMode=http'
-n hdiuser
{code}
Note the ";" instead of "?". The deprecation msg prints the format as well:
{code}
Please use transportMode like so:
jdbc:hive2://<host>:<port>/dbName;transportMode=<transport_mode_value>
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
