[
https://issues.apache.org/jira/browse/HIVE-28567?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17892631#comment-17892631
]
Jintong Jiang commented on HIVE-28567:
--------------------------------------
Hi [~naivcit19] , I am working on the ticket and I tried to reproduce the issue.
I am running Mariadb 10.5 with docker container and run with the following hive
4.1.0.
When I run:
{code:java}
0: jdbc:hive2://localhost:10000/default> show tables ;{code}
The query passed successfully.
{code:java}
0: jdbc:hive2://localhost:10000/default> show tables ;
INFO : Compiling
command(queryId=jintong.jiang_20241024154047_9f13f639-41dd-4eb2-a76b-3ae280967902):
show tables
INFO : Semantic Analysis Completed (retrial = false)
INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:tab_name,
type:string, comment:from deserializer)], properties:null)
INFO : Completed compiling
command(queryId=jintong.jiang_20241024154047_9f13f639-41dd-4eb2-a76b-3ae280967902);
Time taken: 0.044 seconds
INFO : Concurrency mode is disabled, not creating a lock manager
INFO : Executing
command(queryId=jintong.jiang_20241024154047_9f13f639-41dd-4eb2-a76b-3ae280967902):
show tables
INFO : Starting task [Stage-0:DDL] in serial mode
INFO : Completed executing
command(queryId=jintong.jiang_20241024154047_9f13f639-41dd-4eb2-a76b-3ae280967902);
Time taken: 0.112 seconds
+-----------+
| tab_name |
+-----------+
+-----------+
No rows selected (0.169 seconds) {code}
Could you share more information about how to reproduce it? Thanks a lot
> Hive4 compatibility issues with lower versions of MariaDb
> ----------------------------------------------------------
>
> Key: HIVE-28567
> URL: https://issues.apache.org/jira/browse/HIVE-28567
> Project: Hive
> Issue Type: Bug
> Security Level: Public(Viewable by anyone)
> Components: Metastore, Standalone Metastore
> Affects Versions: 4.0.0
> Reporter: Ratnesh Mishra
> Assignee: Jintong Jiang
> Priority: Major
>
> {{Trying to run Hive4 with Mariadb version 10.5.25 as metastore but getting
> below error }}
> {{ }}
> {code:java}
> hive> show tables ;{code}
> {code:java}
> FAILED: Execution Error, return code 40000 from
> org.apache.hadoop.hive.ql.ddl.DDLTask. MetaException(message:Got exception:
> org.apache.hadoop.hive.metastore.api.MetaException JDOException: Exception
> thrown when executing query : SELECT
> B0.`NAME`,A0.TBL_NAME,A0.OWNER,A0.OWNER_TYPE FROM TBLS A0 LEFT OUTER JOIN DBS
> B0 ON A0.DB_ID = B0.DB_ID WHERE LOWER(B0.`NAME`) LIKE 'default' ESCAPE '\\'
> AND B0.CTLG_NAME = ? AND LOWER(A0.TBL_NAME) LIKE '_%' ESCAPE '\\'
> Root cause: java.sql.SQLException: Incorrect arguments to ESCAPE){code}
> However the same query runs fine with MariaDb version {*}10.11.8{*}.
> Same behaviour is observed when we run the query directly on MariaDb.
> This seems to be somehow related to the datanucleus upgrade in Hive4 as the
> same query runs fine with Hive 3.1.3.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
