[
https://issues.apache.org/jira/browse/HIVE-28588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17984966#comment-17984966
]
Stamatis Zampetakis commented on HIVE-28588:
--------------------------------------------
Thanks for the info [~InvisibleProgrammer] ! I didn't realize that PR#4913
modified the table names of external_jdbc_rowcount.q. This rename is completely
irrelevant with the context of HIVE-27791 so it shouldn't have happened as part
of that PR in the first place. Anyways, it explains why this specific failure
is not present anymore in master.
> JDBC table related flakiness
> ----------------------------
>
> Key: HIVE-28588
> URL: https://issues.apache.org/jira/browse/HIVE-28588
> Project: Hive
> Issue Type: Bug
> Components: HiveServer2
> Reporter: Zsolt Miskolczi
> Priority: Major
> Fix For: Not Applicable
>
>
> 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)
