[jira] [Commented] (HIVE-28567) Hive4 compatibility issues with lower versions of MariaDb

["Jintong Jiang (Jira)" <ji...@apache.org>]

    [ 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)