[
https://issues.apache.org/jira/browse/HIVE-28567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Stamatis Zampetakis resolved HIVE-28567.
----------------------------------------
Fix Version/s: Not Applicable
Resolution: Not A Problem
> 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
> Fix For: Not Applicable
>
>
> {{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)
