[
https://issues.apache.org/jira/browse/HIVE-17429?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16449955#comment-16449955
]
Mark Smith commented on HIVE-17429:
-----------------------------------
[~aihuaxu] thank you very much for backporting it, I'm sorry it's taken me some
time to circle back and try upgrading again.
Unfortunately, I'm still seeing the same problem with 2.2.1 and 2.3.3 with an
exception being thrown from here:
https://github.com/apache/hive/blob/rel/release-2.3.3/jdbc/src/java/org/apache/hive/jdbc/HiveStatement.java#L477
so I think there must be some other issue with how GetOperationStatus() is
being built in the underlying TCLIService.Iface client:
[https://github.com/apache/hive/blob/rel/release-2.3.3/jdbc/src/java/org/apache/hive/jdbc/HiveStatement.java#L254
https://github.com/apache/hive/blob/rel/release-2.3.3/jdbc/src/java/org/apache/hive/jdbc/HiveStatement.java#L367|https://github.com/apache/hive/blob/rel/release-2.3.3/jdbc/src/java/org/apache/hive/jdbc/HiveStatement.java#L367]
Unless the underlying client's response is fixed, I think the 2.2.x and 2.3.x
branches will need to do the same workaround/fix as master, also checking the
`stmtHandle` for a resultSet:
[https://github.com/apache/hive/blob/master/jdbc/src/java/org/apache/hive/jdbc/HiveStatement.java#L269]
In case you want to test the same queries as I'm running against Impala via
JDBC, I'm doing the following:
* "SHOW TABLE STATS foo.oldTable"
* "CREATE EXTERNAL TABLE foo.newTable LIKE foo.oldTable STORED AS PARQUET
LOCATION 'hdfs://MyNameServer/location/newFooDir'"
* "SHOW CREATE TABLE foo.TEMP_newTable"
I admit that the two "SHOW" ones are a little unusual as 'queries', but they
seem to work fine with the 2.1.1 driver.
> Hive JDBC doesn't return rows when querying Impala
> --------------------------------------------------
>
> Key: HIVE-17429
> URL: https://issues.apache.org/jira/browse/HIVE-17429
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 2.1.0, 2.2.0, 2.3.0, 2.3.1, 2.3.2
> Reporter: Zach Amsden
> Assignee: Zach Amsden
> Priority: Major
> Fix For: 2.1.0, 2.1.1, 3.0.0, 2.2.1, 2.3.3
>
> Attachments: HIVE-17429.1.patch, HIVE-17429.2.patch
>
>
> The Hive JDBC driver used to return a result set when querying Impala. Now,
> instead, it gets data back but interprets the data as query logs instead of a
> resultSet. This causes many issues (we see complaints about beeline as well
> as test failures).
> This appears to be a regression introduced with asynchronous operation
> against Hive.
> Ideally, we could make both behaviors work. I have a simple patch that
> should fix the problem.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
