Ratnesh Mishra created HIVE-28567:
-------------------------------------
Summary: 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
Environment: {quote}
{quote}
Reporter: Ratnesh Mishra
{{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)
