[
https://issues.apache.org/jira/browse/HIVE-28436?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17871516#comment-17871516
]
Zhihua Deng commented on HIVE-28436:
------------------------------------
Were there steps for replicating the case? I tried myself but it went all right
> 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
> Fix For: 4.1.0
>
>
> 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
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
