Hello, I am trying to run Hive 4 with Mariadb version 10.5.25 as metastore but getting below error
hive> show tables ; 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) However the same query runs with MariaDb version 10.11.8. Same behaviour is observed when I run the query directly on MariaDb. I tried to search around but couldn't find any known backward compatibility issues for MariaDB related to this. This seems to be somehow related to the datanucleus upgrade in Hive4 as the same query runs fine with Hive 3.1.3. Wanted to check if this is an already known issue ? and if there's any workaround possible. Thanks in advance for any help around this. Best, Ratnesh
