[
https://issues.apache.org/jira/browse/HIVE-28436?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Indhumathi Muthumurugesh updated HIVE-28436:
--------------------------------------------
Description:
Steps to Reproduce:
Install latest hive 4.1.0 version.
Run the below query in SYS DB.
select * from sys.MIN_HISTORY_LEVEL;
Exception:
ERROR : Failed with exception java.io.IOException:java.io.IOException:
org.apache.hive.storage.jdbc.exception.HiveJdbcDatabaseAccessException: Caught
exception while trying to execute query: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the right
syntax to use near 'FROM "MIN_HISTORY_LEVEL"' at line 4
java.io.IOException: java.io.IOException:
org.apache.hive.storage.jdbc.exception.HiveJdbcDatabaseAccessException: Caught
exception while trying to execute query: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the right
syntax to use near 'FROM "MIN_HISTORY_LEVEL"' at line 4
at
org.apache.hadoop.hive.ql.exec.FetchOperator.getNextRow(FetchOperator.java:628)
at org.apache.hadoop.hive.ql.exec.FetchOperator.pushRow(FetchOperator.java:535)
at org.apache.hadoop.hive.ql.exec.FetchTask.executeInner(FetchTask.java:194)
at org.apache.hadoop.hive.ql.exec.FetchTask.execute(FetchTask.java:95)
at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:201)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:142)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:137)
at org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:185)
at
org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:236)
at
org.apache.hive.service.cli.operation.SQLOperation.access$500(SQLOperation.java:90)
at
org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork$1.run(SQLOperation.java:336)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:422)
at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1953)
at
org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork.run(SQLOperation.java:356)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
was:
CREATE EXTERNAL TABLE IF NOT EXISTS `MIN_HISTORY_LEVEL` ( `MHL_TXNID` bigint,
`MHL_MIN_OPEN_TXNID` bigint ) STORED BY
'org.apache.hive.storage.jdbc.JdbcStorageHandler' TBLPROPERTIES (
"hive.sql.database.type" = "METASTORE", "hive.sql.query" = "SELECT `MHL_TXNID`,
`MHL_MIN_OPEN_TXNID`, FROM `MIN_HISTORY_LEVEL`" )
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException:
MetaException(message:org.apache.hadoop.hive.serde2.SerDeException
org.apache.hive.storage.jdbc.exception.HiveJdbcDatabaseAccessException: Error
while trying to get column names: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right syntax
to use near 'FROM `MIN_HISTORY_LEVEL` LIMIT 1' at line 1)
INFO : Compiling
command(queryId=hive_20240805174353_0c743113-4f53-4174-916f-4a2d2085888e):
CREATE EXTERNAL TABLE IF NOT EXISTS `MIN_HISTORY_LEVEL` ( `MHL_TXNID` bigint,
`MHL_MIN_OPEN_TXNID` bigint ) STORED BY
'org.apache.hive.storage.jdbc.JdbcStorageHandler' TBLPROPERTIES (
"hive.sql.database.type" = "METASTORE", "hive.sql.query" = "SELECT `MHL_TXNID`,
`MHL_MIN_OPEN_TXNID`, FROM `MIN_HISTORY_LEVEL`" )
INFO : Concurrency mode is disabled, not creating a lock manager
> Incorrect syntax in Hive schema file for table MIN_HISTORY_LEVEL
> ----------------------------------------------------------------
>
> Key: HIVE-28436
> URL: https://issues.apache.org/jira/browse/HIVE-28436
> Project: Hive
> Issue Type: Bug
> Reporter: Indhumathi Muthumurugesh
> Assignee: Indhumathi Muthumurugesh
> Priority: Major
> Labels: pull-request-available
> Fix For: 4.1.0
>
>
> Steps to Reproduce:
> Install latest hive 4.1.0 version.
> Run the below query in SYS DB.
> select * from sys.MIN_HISTORY_LEVEL;
> Exception:
> ERROR : Failed with exception java.io.IOException:java.io.IOException:
> org.apache.hive.storage.jdbc.exception.HiveJdbcDatabaseAccessException:
> Caught exception while trying to execute query: You have an error in your SQL
> syntax; check the manual that corresponds to your MySQL server version for
> the right syntax to use near 'FROM "MIN_HISTORY_LEVEL"' at line 4
> java.io.IOException: java.io.IOException:
> org.apache.hive.storage.jdbc.exception.HiveJdbcDatabaseAccessException:
> Caught exception while trying to execute query: You have an error in your SQL
> syntax; check the manual that corresponds to your MySQL server version for
> the right syntax to use near 'FROM "MIN_HISTORY_LEVEL"' at line 4
> at
> org.apache.hadoop.hive.ql.exec.FetchOperator.getNextRow(FetchOperator.java:628)
> at
> org.apache.hadoop.hive.ql.exec.FetchOperator.pushRow(FetchOperator.java:535)
> at org.apache.hadoop.hive.ql.exec.FetchTask.executeInner(FetchTask.java:194)
> at org.apache.hadoop.hive.ql.exec.FetchTask.execute(FetchTask.java:95)
> at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:201)
> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:142)
> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:137)
> at org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:185)
> at
> org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:236)
> at
> org.apache.hive.service.cli.operation.SQLOperation.access$500(SQLOperation.java:90)
> at
> org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork$1.run(SQLOperation.java:336)
> at java.security.AccessController.doPrivileged(Native Method)
> at javax.security.auth.Subject.doAs(Subject.java:422)
> at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1953)
> at
> org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork.run(SQLOperation.java:356)
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> at java.lang.Thread.run(Thread.java:750)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
