[
https://issues.apache.org/jira/browse/HIVE-28567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ratnesh Mishra updated HIVE-28567:
----------------------------------
Description:
{{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.
was:
{{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.
> 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
> 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)
