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)