[
https://issues.apache.org/jira/browse/HIVE-28567?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17897122#comment-17897122
]
Ratnesh Mishra edited comment on HIVE-28567 at 11/11/24 8:36 AM:
-----------------------------------------------------------------
Hi [~hazeljiang] thanks for checking this issue. Actually I was *also not able*
to repro this with the latest Hive master or the version *4.0.0* and on
debugging this further I realised that the issue was caused as a side effect of
one of my local changes to [this
block|https://github.com/apache/hive/blob/master/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/DatabaseProduct.java#L314]
of code where I had modified
{code:java}
SET @@session.sql_mode=ANSI_QUOTES;
{code}
to
{code:java}
"SET @@session.sql_mode=CONCAT(@@sql_mode, ',ANSI_QUOTES')"
{code}
in order to preserve other Sql modes(if any) from being overridden.
Due to this sql mode option *NO_BACKSLASH_ESCAPES* which is the cause of this
error is getting overridden to ANSI_QUOTES in OSS Hive but not in my local
branch and thus causing this issue.
Thanks again for looking into this. We should be good to close this issue
was (Author: JIRAUSER302120):
Hi [~hazeljiang] thanks for checking this issue. Actually I was *also not able*
to repro this with the latest Hive master or the version *4.0.0* and on
debugging this further I realised that the issue was caused as a side effect of
one of my local changes to [this
block|https://github.com/apache/hive/blob/master/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/DatabaseProduct.java#L314]
of code where I had modified
{code:java}
SET @@session.sql_mode=ANSI_QUOTES;
{code}
to
{code:java}
"SET @@session.sql_mode=CONCAT(@@sql_mode, ',ANSI_QUOTES')"
{code}
in order to preserve other Sql modes(if any) from being overridden.
Due to this sql mode option *NO_BACKSLASH_ESCAPES* which is the cause of this
error is getting overridden to ANSI_QUOTES in OSS Hive but not in my local
branch and thus causing this issue.
Thanks again for looking into this.
> 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)
