hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hari Sankar Sivarama Subramaniyan (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-10753) hs2 jdbc url - wrong connection string cause error on beeline/jdbc/odbc client, misleading message
Date Tue, 19 May 2015 23:17:59 GMT

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

Hari Sankar Sivarama Subramaniyan commented on HIVE-10753:
----------------------------------------------------------

[~thejas] Thanks for the review, I noticed that OOM does not happen with master branch and
it happens only with 0.14.0, most likely the OOM error was resolved with HIVE-6468.  However,
I still get a connection error message like this :

{code}
localhost:bin hsubramaniyan$ ./beeline --verbose=true
Beeline version 1.3.0-SNAPSHOT by Apache Hive
beeline> !connect jdbc:hive2://localhost:10001/default?httpPath=/;transportMode=http
Connecting to jdbc:hive2://localhost:10001/default?httpPath=/;transportMode=http
Enter username for jdbc:hive2://localhost:10001/default?httpPath=/;transportMode=http: scott
Enter password for jdbc:hive2://localhost:10001/default?httpPath=/;transportMode=http: *****
Error: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:10001/default?httpPath=/;transportMode=http:
Invalid status 72 (state=08S01,code=0)
java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:10001/default?httpPath=/;transportMode=http:
Invalid status 72
	at org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:228)
	at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:175)
	at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)
	at java.sql.DriverManager.getConnection(DriverManager.java:571)
	at java.sql.DriverManager.getConnection(DriverManager.java:187)
	at org.apache.hive.beeline.DatabaseConnection.connect(DatabaseConnection.java:142)
	at org.apache.hive.beeline.DatabaseConnection.getConnection(DatabaseConnection.java:207)
	at org.apache.hive.beeline.Commands.connect(Commands.java:1139)
	at org.apache.hive.beeline.Commands.connect(Commands.java:1060)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.apache.hive.beeline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:52)
	at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:976)
	at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:815)
	at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:772)
	at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:485)
	at org.apache.hive.beeline.BeeLine.main(BeeLine.java:468)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
	at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
Caused by: org.apache.thrift.transport.TTransportException: Invalid status 72
	at org.apache.thrift.transport.TSaslTransport.sendAndThrowMessage(TSaslTransport.java:232)
	at org.apache.thrift.transport.TSaslTransport.receiveSaslMessage(TSaslTransport.java:184)
	at org.apache.thrift.transport.TSaslTransport.open(TSaslTransport.java:307)
	at org.apache.thrift.transport.TSaslClientTransport.open(TSaslClientTransport.java:37)
	at org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:203)
	... 24 more
{code}

I will upload a new patch which improves the error message i.e. the point 1 you mentioned
above.

Thanks
Hari

> 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
>         Attachments: HIVE-10753.1.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)> ^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)

Mime
View raw message