You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Zoltan Haindrich (Jira)" <ji...@apache.org> on 2019/10/15 15:49:00 UTC
[jira] [Created] (HIVE-22349) Running sysdb initialization against
mysql database results in exception relating to '{LIMIT 1}'
Zoltan Haindrich created HIVE-22349:
---------------------------------------
Summary: Running sysdb initialization against mysql database results in exception relating to '{LIMIT 1}'
Key: HIVE-22349
URL: https://issues.apache.org/jira/browse/HIVE-22349
Project: Hive
Issue Type: Bug
Affects Versions: 3.1.2
Reporter: Zoltan Haindrich
Running it against 3.1.2 results in:
{code}
ERROR : 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 MariaDB server version for the right syntax to use near '{LIMIT 1}' at line 1)
DEBUG : Shutting down query CREATE EXTERNAL TABLE IF NOT EXISTS `BUCKETING_COLS` ( `SD_ID` bigint, `BUCKET_COL_NAME` string, `INTEGER_IDX` int, CONSTRAINT `SYS_PK_BUCKETING_COLS` PRIMARY KEY (`SD_ID`,`INTEGER_IDX`) DISABLE ) STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler' TBLPROPERTIES ( "hive.sql.database.type" = "METASTORE", "hive.sql.query" = "SELECT `SD_ID`, `BUCKET_COL_NAME`, `INTEGER_IDX` FROM `BUCKETING_COLS`" )
INFO : Completed executing command(queryId=dev_20191015154644_c16d4f1f-e0cf-44ee-86ee-c9fa76b4dfce); Time taken: 0.246 seconds
INFO : Concurrency mode is disabled, not creating a lock manager
DEBUG : Shutting down query CREATE EXTERNAL TABLE IF NOT EXISTS `BUCKETING_COLS` ( `SD_ID` bigint, `BUCKET_COL_NAME` string, `INTEGER_IDX` int, CONSTRAINT `SYS_PK_BUCKETING_COLS` PRIMARY KEY (`SD_ID`,`INTEGER_IDX`) DISABLE ) STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler' TBLPROPERTIES ( "hive.sql.database.type" = "METASTORE", "hive.sql.query" = "SELECT `SD_ID`, `BUCKET_COL_NAME`, `INTEGER_IDX` FROM `BUCKETING_COLS`" )
2019-10-15 15:46:45,211 f2e4e01c-4026-4b44-98cc-17192ddbcfe8 main DEBUG Deleting route with dev_20191015154644_c16d4f1f-e0cf-44ee-86ee-c9fa76b4dfce key
2019-10-15 15:46:45,211 f2e4e01c-4026-4b44-98cc-17192ddbcfe8 main DEBUG Stopping route with dev_20191015154644_c16d4f1f-e0cf-44ee-86ee-c9fa76b4dfce key
2019-10-15 15:46:45,212 f2e4e01c-4026-4b44-98cc-17192ddbcfe8 main DEBUG Shutting down RandomAccessFileManager /tmp/dev/operation_logs/f2e4e01c-4026-4b44-98cc-17192ddbcfe8/dev_20191015154644_c16d4f1f-e0cf-44ee-86ee-c9fa76b4dfce
2019-10-15 15:46:45,212 f2e4e01c-4026-4b44-98cc-17192ddbcfe8 main DEBUG Shut down RandomAccessFileManager /tmp/dev/operation_logs/f2e4e01c-4026-4b44-98cc-17192ddbcfe8/dev_20191015154644_c16d4f1f-e0cf-44ee-86ee-c9fa76b4dfce, all resources released: true
2019-10-15 15:46:45,212 f2e4e01c-4026-4b44-98cc-17192ddbcfe8 main DEBUG Appender query-file-appender stopped with status true
2019-10-15 15:46:45,212 f2e4e01c-4026-4b44-98cc-17192ddbcfe8 main DEBUG Deleting route with dev_20191015154644_c16d4f1f-e0cf-44ee-86ee-c9fa76b4dfce key
2019-10-15 15:46:45,212 f2e4e01c-4026-4b44-98cc-17192ddbcfe8 main DEBUG Stopping route with dev_20191015154644_c16d4f1f-e0cf-44ee-86ee-c9fa76b4dfce key
2019-10-15 15:46:45,212 f2e4e01c-4026-4b44-98cc-17192ddbcfe8 main DEBUG Shutting down RandomAccessFileManager /tmp/dev/operation_logs/f2e4e01c-4026-4b44-98cc-17192ddbcfe8/dev_20191015154644_c16d4f1f-e0cf-44ee-86ee-c9fa76b4dfce.test
2019-10-15 15:46:45,212 f2e4e01c-4026-4b44-98cc-17192ddbcfe8 main DEBUG Shut down RandomAccessFileManager /tmp/dev/operation_logs/f2e4e01c-4026-4b44-98cc-17192ddbcfe8/dev_20191015154644_c16d4f1f-e0cf-44ee-86ee-c9fa76b4dfce.test, all resources released: true
2019-10-15 15:46:45,212 f2e4e01c-4026-4b44-98cc-17192ddbcfe8 main DEBUG Appender test-query-file-appender stopped with status true
2019-10-15 15:46:45,213 f2e4e01c-4026-4b44-98cc-17192ddbcfe8 main DEBUG Building Plugin[name=filter, class=org.apache.hadoop.hive.ql.log.LogDivertAppender$NameFilter].
2019-10-15 15:46:45,213 f2e4e01c-4026-4b44-98cc-17192ddbcfe8 main DEBUG createFilter(loggingLevel="EXECUTION")
2019-10-15 15:46:45,213 f2e4e01c-4026-4b44-98cc-17192ddbcfe8 main DEBUG Building Plugin[name=layout, class=org.apache.logging.log4j.core.layout.PatternLayout].
2019-10-15 15:46:45,213 f2e4e01c-4026-4b44-98cc-17192ddbcfe8 main DEBUG PatternLayout$Builder(pattern="%-5p : %m%n", PatternSelector=null, Configuration(HiveLog4j2), Replace=null, charset="null", alwaysWriteExceptions="null", disableAnsi="null", noConsoleNoAnsi="null", header="null", footer="null")
2019-10-15 15:46:45,214 f2e4e01c-4026-4b44-98cc-17192ddbcfe8 main DEBUG Building Plugin[name=appender, class=org.apache.hadoop.hive.ql.log.HushableRandomAccessFileAppender].
2019-10-15 15:46:45,214 f2e4e01c-4026-4b44-98cc-17192ddbcfe8 main DEBUG createAppender(fileName="/tmp/dev/operation_logs/f2e4e01c-4026-4b44-98cc-17192ddbcfe8/dev_20191015154644_c16d4f1f-e0cf-44ee-86ee-c9fa76b4dfce", append="null", name="query-file-appender", immediateFlush="null", bufferSize="null", ignoreExceptions="null", PatternLayout(org.apache.logging.log4j.core.layout.PatternLayout with name PatternLayout), NameFilter(org.apache.hadoop.hive.ql.log.LogDivertAppender$NameFilter with name NameFilter), advertise="null", advertiseURI="null", Configuration(HiveLog4j2))
2019-10-15 15:46:45,214 f2e4e01c-4026-4b44-98cc-17192ddbcfe8 main DEBUG Starting RandomAccessFileManager /tmp/dev/operation_logs/f2e4e01c-4026-4b44-98cc-17192ddbcfe8/dev_20191015154644_c16d4f1f-e0cf-44ee-86ee-c9fa76b4dfce
2019-10-15 15:46:45,214 f2e4e01c-4026-4b44-98cc-17192ddbcfe8 main DEBUG Building Plugin[name=, class=org.apache.hadoop.hive.ql.log.LogDivertAppenderForTest$TestFilter].
2019-10-15 15:46:45,215 f2e4e01c-4026-4b44-98cc-17192ddbcfe8 main DEBUG createFilter()
2019-10-15 15:46:45,215 f2e4e01c-4026-4b44-98cc-17192ddbcfe8 main DEBUG Building Plugin[name=, class=org.apache.logging.log4j.core.layout.PatternLayout].
2019-10-15 15:46:45,215 f2e4e01c-4026-4b44-98cc-17192ddbcfe8 main DEBUG PatternLayout$Builder(pattern="%-5p : %m%n", PatternSelector=null, Configuration(HiveLog4j2), Replace=null, charset="null", alwaysWriteExceptions="null", disableAnsi="null", noConsoleNoAnsi="null", header="null", footer="null")
2019-10-15 15:46:45,215 f2e4e01c-4026-4b44-98cc-17192ddbcfe8 main DEBUG Building Plugin[name=appender, class=org.apache.hadoop.hive.ql.log.HushableRandomAccessFileAppender].
2019-10-15 15:46:45,215 f2e4e01c-4026-4b44-98cc-17192ddbcfe8 main DEBUG createAppender(fileName="/tmp/dev/operation_logs/f2e4e01c-4026-4b44-98cc-17192ddbcfe8/dev_20191015154644_c16d4f1f-e0cf-44ee-86ee-c9fa76b4dfce.test", append="null", name="test-query-file-appender", immediateFlush="null", bufferSize="null", ignoreExceptions="null", PatternLayout(org.apache.logging.log4j.core.layout.PatternLayout with name PatternLayout), test-filter(org.apache.hadoop.hive.ql.log.LogDivertAppenderForTest$TestFilter with name test-filter), advertise="null", advertiseURI="null", Configuration(HiveLog4j2))
2019-10-15 15:46:45,216 f2e4e01c-4026-4b44-98cc-17192ddbcfe8 main DEBUG Starting RandomAccessFileManager /tmp/dev/operation_logs/f2e4e01c-4026-4b44-98cc-17192ddbcfe8/dev_20191015154644_c16d4f1f-e0cf-44ee-86ee-c9fa76b4dfce.test
Error: Error while processing statement: 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 MariaDB server version for the right syntax to use near '{LIMIT 1}' at line 1) (state=08S01,code=1)
Closing: 0: jdbc:hive2://?hive.conf.restricted.list=;hive.security.authorization.sqlstd.confwhitelist=.*;hive.security.authorization.sqlstd.confwhitelist.append=.*;hive.security.authorization.enabled=false;hive.metastore.uris=;hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdConfOnlyAuthorizerFactory;hive.support.concurrency=false;hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DummyTxnManager;hive.metastore.rawstore.impl=org.apache.hadoop.hive.metastore.ObjectStore
org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore state would be inconsistent !!
Underlying cause: java.io.IOException : Schema script failed, errorcode 2
org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore state would be inconsistent !!
at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:594)
at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:567)
at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:1517)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.util.RunJar.run(RunJar.java:318)
at org.apache.hadoop.util.RunJar.main(RunJar.java:232)
Caused by: java.io.IOException: Schema script failed, errorcode 2
at org.apache.hive.beeline.HiveSchemaTool.runBeeLine(HiveSchemaTool.java:1226)
at org.apache.hive.beeline.HiveSchemaTool.runBeeLine(HiveSchemaTool.java:1204)
at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:590)
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)