hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Damien Carol (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-10753) hs2 jdbc url - wrong connection string cause error on beeline/jdbc/odbc client, misleading message
Date Wed, 27 May 2015 10:28:17 GMT

     [ https://issues.apache.org/jira/browse/HIVE-10753?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Damien Carol updated HIVE-10753:
--------------------------------
    Description: 
{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)> ^C
hdiuser@headnode0:~$ 
{noformat}

But it works if I use the deprecated param - 

{noformat}
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
{noformat}

The reason for the above message is :
The url is wrong. Correct one:
{noformat}
beeline -u 'jdbc:hive2://localhost:10001/default;httpPath=/;transportMode=http' -n hdiuser
{noformat}
Note the ";" instead of "?". The deprecation msg prints the format as well: 
{noformat}
Please use transportMode like so: jdbc:hive2://<host>:<port>/dbName;transportMode=<transport_mode_value>
{noformat}



  was:
{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}




> hs2 jdbc url - wrong connection string cause  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
>             Fix For: 1.3.0, 1.2.1
>
>         Attachments: HIVE-10753.1.patch, HIVE-10753.2.patch
>
>
> {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)> ^C
> hdiuser@headnode0:~$ 
> {noformat}
> But it works if I use the deprecated param - 
> {noformat}
> 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
> {noformat}
> The reason for the above message is :
> The url is wrong. Correct one:
> {noformat}
> beeline -u 'jdbc:hive2://localhost:10001/default;httpPath=/;transportMode=http' -n hdiuser
> {noformat}
> Note the ";" instead of "?". The deprecation msg prints the format as well: 
> {noformat}
> Please use transportMode like so: jdbc:hive2://<host>:<port>/dbName;transportMode=<transport_mode_value>
> {noformat}



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

Mime
View raw message