You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Zhihua Deng (Jira)" <ji...@apache.org> on 2024/08/07 02:26:00 UTC
[jira] [Commented] (HIVE-28436) Incorrect syntax in Hive schema file for table MIN_HISTORY_LEVEL
[ 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)