Zsolt Miskolczi created HIVE-28588:
--------------------------------------
Summary: JDBC table related flakiness
Key: HIVE-28588
URL: https://issues.apache.org/jira/browse/HIVE-28588
Project: Hive
Issue Type: Bug
Security Level: Public (Viewable by anyone)
Components: HiveServer2
Reporter: Zsolt Miskolczi
There are couple of test failures on downstream, like:
authorization_privilege_objects.q, external_jdbc_rowcount.q
The pattern is similar:
* Create a Derby db using GenericUDFDBOutput
* Create an external table on top of that using
org.apache.derby.jdbc.EmbeddedDriver
Creating the Derby db returns with an error: table already exist. So that
GenericUDFDBOutput returns with 1 instead of 0. And the qtest fails with diff
in output.
Example:
HS2 log:
{noformat}
2024-10-21T05:51:51,249 ERROR [1d2e8bd2-f184-472a-8f9a-44daabc9dd36 main]
example.GenericUDFDBOutput: Underlying SQL exception
java.sql.SQLException: Table/View 'SIMPLE_DERBY_TABLE1' already exists in
Schema 'APP'.{noformat}
Test output:
{noformat}
Client Execution succeeded but contained differences (error code = 1) after
executing authorization_privilege_objects.q
246c246
< 1
---
> 0{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
