Client Execution succeeded but contained differences (error code = 1) after executing temp_table_multi_insert_partitioned.q 175,186c175,186 < 0 456 2 < 10 456 2 < 97 455 2 < 98 455 2 < 100 457 2 < 103 457 2 < 455 97 1 < 455 98 1 < 456 0 1 < 456 10 1 < 457 100 1 < 457 103 1 --- > 0 456 1 > 10 456 1 > 97 455 1 > 98 455 1 > 100 457 1 > 103 457 1 > 455 97 2 > 455 98 2 > 456 0 2 > 456 10 2 > 457 100 2 > 457 103 2 263d262 < 0 456 2 265d263 < 10 456 2 267d264 < 97 455 2 269d265 < 98 455 2 271d266 < 100 457 2 273d267 < 103 457 2 274a269,270 > 455 97 2 > 455 98 2 276a273 > 456 0 2 277a275,276 > 456 10 2 > 457 100 2 279a279 > 457 103 2 369d368 < 0 456 2 372d370 < 10 456 2 375d372 < 97 455 2 378d374 < 98 455 2 381d376 < 100 457 2 384c379 < 103 457 2 --- > 455 97 2 387a383 > 455 98 2 389a386 > 456 0 2 391a389 > 456 10 2 393a392 > 457 100 2 395a395 > 457 103 2 480d479 < 0 456 2 484d482 < 10 456 2 488d485 < 97 455 2 492d488 < 98 455 2 496d491 < 100 457 2 500d494 < 103 457 2 502a497 > 455 97 2 505a501 > 455 98 2 508a505 > 456 0 2 511a509 > 456 10 2 514a513 > 457 100 2 516a516 > 457 103 2 Stacktrace java.lang.AssertionError: Client Execution succeeded but contained differences (error code = 1) after executing temp_table_multi_insert_partitioned.q 175,186c175,186 < 0 456 2 < 10 456 2 < 97 455 2 < 98 455 2 < 100 457 2 < 103 457 2 < 455 97 1 < 455 98 1 < 456 0 1 < 456 10 1 < 457 100 1 < 457 103 1 --- > 0 456 1 > 10 456 1 > 97 455 1 > 98 455 1 > 100 457 1 > 103 457 1 > 455 97 2 > 455 98 2 > 456 0 2 > 456 10 2 > 457 100 2 > 457 103 2 263d262 < 0 456 2 265d263 < 10 456 2 267d264 < 97 455 2 269d265 < 98 455 2 271d266 < 100 457 2 273d267 < 103 457 2 274a269,270 > 455 97 2 > 455 98 2 276a273 > 456 0 2 277a275,276 > 456 10 2 > 457 100 2 279a279 > 457 103 2 369d368 < 0 456 2 372d370 < 10 456 2 375d372 < 97 455 2 378d374 < 98 455 2 381d376 < 100 457 2 384c379 < 103 457 2 --- > 455 97 2 387a383 > 455 98 2 389a386 > 456 0 2 391a389 > 456 10 2 393a392 > 457 100 2 395a395 > 457 103 2 480d479 < 0 456 2 484d482 < 10 456 2 488d485 < 97 455 2 492d488 < 98 455 2 496d491 < 100 457 2 500d494 < 103 457 2 502a497 > 455 97 2 505a501 > 455 98 2 508a505 > 456 0 2 511a509 > 456 10 2 514a513 > 457 100 2 516a516 > 457 103 2 at org.junit.Assert.fail(Assert.java:88) at org.apache.hadoop.hive.ql.QTestUtil.failedDiff(QTestUtil.java:1021) at org.apache.hadoop.hive.cli.control.CoreCliDriver.runTest(CoreCliDriver.java:182) at org.apache.hadoop.hive.cli.control.CliAdapter.runTest(CliAdapter.java:157) at org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver(TestMiniLlapLocalCliDriver.java:59) 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.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) at org.apache.hadoop.hive.cli.control.CliAdapter$2$1.evaluate(CliAdapter.java:135) at org.junit.rules.RunRules.evaluate(RunRules.java:20) at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229) at org.junit.runners.ParentRunner.run(ParentRunner.java:309) at org.junit.runners.Suite.runChild(Suite.java:127) at org.junit.runners.Suite.runChild(Suite.java:26) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229) at org.apache.hadoop.hive.cli.control.CliAdapter$1$1.evaluate(CliAdapter.java:95) at org.junit.rules.RunRules.evaluate(RunRules.java:20) at org.junit.runners.ParentRunner.run(ParentRunner.java:309) at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365) at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159) at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:379) at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:340) at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:125) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:413) Standard Output detected hiveRoot: /home/hiveptest/35.238.102.117-hiveptest-1/apache-github-source-source property: qfile used as override with val: temp_table_multi_insert_partitioned.q property: run_disabled used as override with val: false Setting hive-site: file:/home/hiveptest/35.238.102.117-hiveptest-1/apache-github-source-source/data/conf/llap//hive-site.xml Initializing the schema to: 4.0.0 Metastore connection URL: jdbc:derby:memory:/home/hiveptest/35.238.102.117-hiveptest-1/apache-github-source-source/itests/qtest/target/tmp/junit_metastore_db;create=true Metastore connection Driver : org.apache.derby.jdbc.EmbeddedDriver Metastore connection User: APP Metastore connection Password: mine Starting metastore schema initialization to 4.0.0 Initialization script hive-schema-4.0.0.derby.sql Initialization script completed 2020-04-20 03:44:05 Running Dag: dag_1587379439418_0001_1 2020-04-20 03:44:06 Completed running task attempt: attempt_1587379439418_0001_1_00_000000_0 2020-04-20 03:44:06 Completed Dag: dag_1587379439418_0001_1 2020-04-20 03:44:07 Running Dag: dag_1587379439418_0001_2 2020-04-20 03:44:07 Completed running task attempt: attempt_1587379439418_0001_2_00_000000_0 2020-04-20 03:44:08 Completed running task attempt: attempt_1587379439418_0001_2_01_000000_0 2020-04-20 03:44:08 Completed Dag: dag_1587379439418_0001_2 2020-04-20 03:44:11 Running Dag: dag_1587379439418_0001_3 2020-04-20 03:44:11 Completed running task attempt: attempt_1587379439418_0001_3_00_000000_0 2020-04-20 03:44:11 Completed running task attempt: attempt_1587379439418_0001_3_01_000001_0 2020-04-20 03:44:11 Completed running task attempt: attempt_1587379439418_0001_3_01_000000_0 2020-04-20 03:44:12 Completed running task attempt: attempt_1587379439418_0001_3_02_000000_0 2020-04-20 03:44:12 Completed Dag: dag_1587379439418_0001_3 2020-04-20 03:44:12 Running Dag: dag_1587379439418_0001_4 2020-04-20 03:44:12 Completed running task attempt: attempt_1587379439418_0001_4_00_000000_0 2020-04-20 03:44:12 Completed running task attempt: attempt_1587379439418_0001_4_01_000001_0 2020-04-20 03:44:12 Completed running task attempt: attempt_1587379439418_0001_4_01_000000_0 2020-04-20 03:44:12 Completed running task attempt: attempt_1587379439418_0001_4_02_000000_0 2020-04-20 03:44:12 Completed Dag: dag_1587379439418_0001_4 2020-04-20 03:44:13 Running Dag: dag_1587379439418_0001_5 2020-04-20 03:44:13 Completed running task attempt: attempt_1587379439418_0001_5_00_000000_0 2020-04-20 03:44:13 Completed running task attempt: attempt_1587379439418_0001_5_01_000001_0 2020-04-20 03:44:13 Completed running task attempt: attempt_1587379439418_0001_5_01_000000_0 2020-04-20 03:44:13 Completed running task attempt: attempt_1587379439418_0001_5_02_000000_0 2020-04-20 03:44:13 Completed Dag: dag_1587379439418_0001_5 2020-04-20 03:44:13 Running Dag: dag_1587379439418_0001_6 2020-04-20 03:44:14 Completed running task attempt: attempt_1587379439418_0001_6_00_000000_0 2020-04-20 03:44:14 Completed Dag: dag_1587379439418_0001_6 2020-04-20 03:44:14 Running Dag: dag_1587379439418_0001_7 2020-04-20 03:44:14 Completed running task attempt: attempt_1587379439418_0001_7_00_000000_0 2020-04-20 03:44:14 Completed running task attempt: attempt_1587379439418_0001_7_01_000000_0 2020-04-20 03:44:14 Completed Dag: dag_1587379439418_0001_7 2020-04-20 03:44:14 Running Dag: dag_1587379439418_0001_8 2020-04-20 03:44:14 Completed running task attempt: attempt_1587379439418_0001_8_00_000000_0 2020-04-20 03:44:14 Completed Dag: dag_1587379439418_0001_8 2020-04-20 03:44:15 Running Dag: dag_1587379439418_0001_9 2020-04-20 03:44:15 Completed running task attempt: attempt_1587379439418_0001_9_00_000000_0 2020-04-20 03:44:15 Completed running task attempt: attempt_1587379439418_0001_9_01_000000_0 2020-04-20 03:44:15 Completed Dag: dag_1587379439418_0001_9 2020-04-20 03:44:15 Running Dag: dag_1587379439418_0001_10 2020-04-20 03:44:15 Completed running task attempt: attempt_1587379439418_0001_10_00_000000_0 2020-04-20 03:44:15 Completed Dag: dag_1587379439418_0001_10 2020-04-20 03:44:15 Running Dag: dag_1587379439418_0001_11 2020-04-20 03:44:16 Completed running task attempt: attempt_1587379439418_0001_11_00_000000_0 2020-04-20 03:44:16 Completed running task attempt: attempt_1587379439418_0001_11_01_000000_0 2020-04-20 03:44:16 Completed Dag: dag_1587379439418_0001_11 2020-04-20 03:44:16 Running Dag: dag_1587379439418_0001_12 2020-04-20 03:44:16 Completed running task attempt: attempt_1587379439418_0001_12_00_000000_0 2020-04-20 03:44:16 Completed Dag: dag_1587379439418_0001_12 2020-04-20 03:44:16 Running Dag: dag_1587379439418_0001_13 2020-04-20 03:44:16 Completed running task attempt: attempt_1587379439418_0001_13_00_000000_0 2020-04-20 03:44:16 Completed running task attempt: attempt_1587379439418_0001_13_01_000000_0 2020-04-20 03:44:16 Completed Dag: dag_1587379439418_0001_13 2020-04-20 03:44:16 Running Dag: dag_1587379439418_0001_14 2020-04-20 03:44:17 Completed running task attempt: attempt_1587379439418_0001_14_00_000000_0 2020-04-20 03:44:17 Completed Dag: dag_1587379439418_0001_14 2020-04-20 03:44:17 Running Dag: dag_1587379439418_0001_15 2020-04-20 03:44:17 Completed running task attempt: attempt_1587379439418_0001_15_00_000000_0 2020-04-20 03:44:17 Completed running task attempt: attempt_1587379439418_0001_15_01_000000_0 2020-04-20 03:44:17 Completed Dag: dag_1587379439418_0001_15 Running: diff -a /home/hiveptest/35.238.102.117-hiveptest-1/apache-github-source-source/itests/qtest/target/qfile-results/clientpositive/temp_table_multi_insert_partitioned.q.out /home/hiveptest/35.238.102.117-hiveptest-1/apache-github-source-source/ql/src/test/results/clientpositive/llap/temp_table_multi_insert_partitioned.q.out 175,186c175,186 < 0 456 2 < 10 456 2 < 97 455 2 < 98 455 2 < 100 457 2 < 103 457 2 < 455 97 1 < 455 98 1 < 456 0 1 < 456 10 1 < 457 100 1 < 457 103 1 --- > 0 456 1 > 10 456 1 > 97 455 1 > 98 455 1 > 100 457 1 > 103 457 1 > 455 97 2 > 455 98 2 > 456 0 2 > 456 10 2 > 457 100 2 > 457 103 2 263d262 < 0 456 2 265d263 < 10 456 2 267d264 < 97 455 2 269d265 < 98 455 2 271d266 < 100 457 2 273d267 < 103 457 2 274a269,270 > 455 97 2 > 455 98 2 276a273 > 456 0 2 277a275,276 > 456 10 2 > 457 100 2 279a279 > 457 103 2 369d368 < 0 456 2 372d370 < 10 456 2 375d372 < 97 455 2 378d374 < 98 455 2 381d376 < 100 457 2 384c379 < 103 457 2 --- > 455 97 2 387a383 > 455 98 2 389a386 > 456 0 2 391a389 > 456 10 2 393a392 > 457 100 2 395a395 > 457 103 2 480d479 < 0 456 2 484d482 < 10 456 2 488d485 < 97 455 2 492d488 < 98 455 2 496d491 < 100 457 2 500d494 < 103 457 2 502a497 > 455 97 2 505a501 > 455 98 2 508a505 > 456 0 2 511a509 > 456 10 2 514a513 > 457 100 2 516a516 > 457 103 2 Standard Error SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/home/hiveptest/35.238.102.117-hiveptest-1/maven/org/apache/logging/log4j/log4j-slf4j-impl/2.12.1/log4j-slf4j-impl-2.12.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/home/hiveptest/35.238.102.117-hiveptest-1/maven/org/slf4j/slf4j-log4j12/1.7.25/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/home/hiveptest/35.238.102.117-hiveptest-1/maven/org/apache/hive/hive-it-druid/4.0.0-SNAPSHOT/hive-it-druid-4.0.0-SNAPSHOT.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] DEBUG StatusLogger Using ShutdownCallbackRegistry class org.apache.logging.log4j.core.util.DefaultShutdownCallbackRegistry DEBUG StatusLogger Took 0.147720 seconds to load 222 plugins from sun.misc.Launcher$AppClassLoader@135fbaa4 DEBUG StatusLogger PluginManager 'Converter' found 44 plugins DEBUG StatusLogger Starting OutputStreamManager SYSTEM_OUT.false.false-1 DEBUG StatusLogger Starting LoggerContext[name=135fbaa4, org.apache.logging.log4j.core.LoggerContext@62ddbd7e]... DEBUG StatusLogger Reconfiguration started for context[name=135fbaa4] at URI null (org.apache.logging.log4j.core.LoggerContext@62ddbd7e) with optional ClassLoader: null DEBUG StatusLogger PluginManager 'ConfigurationFactory' found 4 plugins DEBUG StatusLogger Using configurationFactory org.apache.logging.log4j.core.config.ConfigurationFactory$Factory@b2c9a9c DEBUG StatusLogger Apache Log4j Core 2.12.1 initializing configuration org.apache.logging.log4j.core.config.properties.PropertiesConfiguration@4c39bec8 DEBUG StatusLogger Installed 2 script engines DEBUG StatusLogger Groovy Scripting Engine version: 2.0, language: Groovy, threading: MULTITHREADED, compile: true, names: [groovy, Groovy], factory class: org.codehaus.groovy.jsr223.GroovyScriptEngineFactory DEBUG StatusLogger Oracle Nashorn version: 1.8.0_102, language: ECMAScript, threading: Not Thread Safe, compile: true, names: [nashorn, Nashorn, js, JS, JavaScript, javascript, ECMAScript, ecmascript], factory class: jdk.nashorn.api.scripting.NashornScriptEngineFactory INFO StatusLogger Scanning for classes in '/home/hiveptest/35.238.102.117-hiveptest-1/maven/org/apache/hive/hive-common/4.0.0-SNAPSHOT/hive-common-4.0.0-SNAPSHOT.jar' matching criteria annotated with @Plugin DEBUG StatusLogger Checking to see if class org.apache.hadoop.hive.ql.log.PerfLogger matches criteria annotated with @Plugin INFO StatusLogger Scanning for classes in '/home/hiveptest/35.238.102.117-hiveptest-1/maven/org/apache/hive/hive-exec/4.0.0-SNAPSHOT/hive-exec-4.0.0-SNAPSHOT.jar' matching criteria annotated with @Plugin DEBUG StatusLogger Checking to see if class org.apache.hadoop.hive.ql.log.HiveEventCounter$1 matches criteria annotated with @Plugin DEBUG StatusLogger Checking to see if class org.apache.hadoop.hive.ql.log.LogDivertAppenderForTest matches criteria annotated with @Plugin DEBUG StatusLogger Checking to see if class org.apache.hadoop.hive.ql.log.syslog.SyslogSerDe matches criteria annotated with @Plugin DEBUG StatusLogger Checking to see if class org.apache.hadoop.hive.ql.log.syslog.SyslogInputFormat$Location matches criteria annotated with @Plugin DEBUG StatusLogger Checking to see if class org.apache.hadoop.hive.ql.log.syslog.SyslogInputFormat matches criteria annotated with @Plugin DEBUG StatusLogger Checking to see if class org.apache.hadoop.hive.ql.log.syslog.SyslogParser matches criteria annotated with @Plugin DEBUG StatusLogger Checking to see if class org.apache.hadoop.hive.ql.log.syslog.SyslogStorageHandler matches criteria annotated with @Plugin DEBUG StatusLogger Checking to see if class org.apache.hadoop.hive.ql.log.LogDivertAppenderForTest$TestFilter matches criteria annotated with @Plugin DEBUG StatusLogger Checking to see if class org.apache.hadoop.hive.ql.log.LogDivertAppender matches criteria annotated with @Plugin DEBUG StatusLogger Checking to see if class org.apache.hadoop.hive.ql.log.PidFilePatternConverter matches criteria annotated with @Plugin DEBUG StatusLogger Checking to see if class org.apache.hadoop.hive.ql.log.HiveEventCounter matches criteria annotated with @Plugin DEBUG StatusLogger Checking to see if class org.apache.hadoop.hive.ql.log.HiveEventCounter$EventCounts matches criteria annotated with @Plugin DEBUG StatusLogger Checking to see if class org.apache.hadoop.hive.ql.log.NullAppender matches criteria annotated with @Plugin DEBUG StatusLogger Checking to see if class org.apache.hadoop.hive.ql.log.HushableRandomAccessFileAppender$1 matches criteria annotated with @Plugin DEBUG StatusLogger Checking to see if class org.apache.hadoop.hive.ql.log.LogDivertAppender$NameFilter matches criteria annotated with @Plugin DEBUG StatusLogger Checking to see if class org.apache.hadoop.hive.ql.log.SlidingFilenameRolloverStrategy$1 matches criteria annotated with @Plugin DEBUG StatusLogger Checking to see if class org.apache.hadoop.hive.ql.log.SlidingFilenameRolloverStrategy matches criteria annotated with @Plugin DEBUG StatusLogger Checking to see if class org.apache.hadoop.hive.ql.log.HushableRandomAccessFileAppender matches criteria annotated with @Plugin DEBUG StatusLogger Checking to see if class org.apache.hadoop.hive.ql.log.PerfLogger matches criteria annotated with @Plugin INFO StatusLogger Scanning for classes in '/home/hiveptest/35.238.102.117-hiveptest-1/maven/org/apache/hive/hive-exec/4.0.0-SNAPSHOT/hive-exec-4.0.0-SNAPSHOT-tests.jar' matching criteria annotated with @Plugin DEBUG StatusLogger Checking to see if class org.apache.hadoop.hive.ql.log.TestLog4j2Appenders matches criteria annotated with @Plugin DEBUG StatusLogger Checking to see if class org.apache.hadoop.hive.ql.log.TestSlidingFilenameRolloverStrategy matches criteria annotated with @Plugin DEBUG StatusLogger Checking to see if class org.apache.hadoop.hive.ql.log.TestSyslogInputFormat matches criteria annotated with @Plugin DEBUG StatusLogger Took 0.070252 seconds to load 7 plugins from package org.apache.hadoop.hive.ql.log DEBUG StatusLogger PluginManager 'Core' found 129 plugins DEBUG StatusLogger PluginManager 'Level' found 0 plugins DEBUG StatusLogger Building Plugin[name=property, class=org.apache.logging.log4j.core.config.Property]. TRACE StatusLogger TypeConverterRegistry initializing. DEBUG StatusLogger PluginManager 'TypeConverter' found 26 plugins DEBUG StatusLogger createProperty(name="hive.log.file", value="hive.log") DEBUG StatusLogger Building Plugin[name=property, class=org.apache.logging.log4j.core.config.Property]. DEBUG StatusLogger createProperty(name="hive.log.dir", value="/home/hiveptest/35.238.102.117-hiveptest-1/apache-github-source-source/itests/qtest/target/tmp/log") DEBUG StatusLogger Building Plugin[name=property, class=org.apache.logging.log4j.core.config.Property]. DEBUG StatusLogger createProperty(name="hive.root.logger", value="DRFA") DEBUG StatusLogger Building Plugin[name=property, class=org.apache.logging.log4j.core.config.Property]. DEBUG StatusLogger createProperty(name="hive.log.level", value="DEBUG") DEBUG StatusLogger Building Plugin[name=property, class=org.apache.logging.log4j.core.config.Property]. DEBUG StatusLogger createProperty(name="hive.test.console.log.level", value="INFO") DEBUG StatusLogger Building Plugin[name=properties, class=org.apache.logging.log4j.core.config.PropertiesPlugin]. DEBUG StatusLogger configureSubstitutor(={hive.log.file=hive.log, hive.log.dir=/home/hiveptest/35.238.102.117-hiveptest-1/apache-github-source-source/itests/qtest/target/tmp/log, hive.root.logger=DRFA, hive.log.level=DEBUG, hive.test.console.log.level=INFO}, Configuration(HiveLog4j2Test)) DEBUG StatusLogger PluginManager 'Lookup' found 14 plugins DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="WARN", name="org.apache.hadoop.ipc", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="INFO", name="org.apache.hadoop.security", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="INFO", name="org.apache.hadoop.hdfs", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="WARN", name="org.apache.hadoop.hdfs.server", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="INFO", name="org.apache.hadoop.metrics2", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="INFO", name="org.mortbay", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="INFO", name="org.apache.hadoop.yarn", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="WARN", name="org.apache.hadoop.yarn.server", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="INFO", name="org.apache.tez", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="ERROR", name="org.apache.hadoop.conf.Configuration", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="INFO", name="org.apache.zookeeper", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="WARN", name="org.apache.zookeeper.server.ServerCnxn", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="WARN", name="org.apache.zookeeper.server.NIOServerCnxn", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="WARN", name="org.apache.zookeeper.ClientCnxn", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="WARN", name="org.apache.zookeeper.ClientCnxnSocket", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="WARN", name="org.apache.zookeeper.ClientCnxnSocketNIO", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="ERROR", name="DataNucleus", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="ERROR", name="Datastore", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="ERROR", name="JPOX", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="INFO", name="org.apache.hadoop.hive.ql.exec.Operator", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="INFO", name="org.apache.hadoop.hive.serde2.lazy", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="INFO", name="org.apache.hadoop.hive.metastore.ObjectStore", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="INFO", name="org.apache.calcite.plan.RelOptPlanner", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="INFO", name="com.amazonaws", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="INFO", name="org.apache.http", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="WARN", name="org.apache.thrift", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="WARN", name="org.eclipse.jetty", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=logger, class=org.apache.logging.log4j.core.config.LoggerConfig]. DEBUG StatusLogger createLogger(additivity="true", level="WARN", name="BlockStateChange", includeLocation="null", ={}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=AppenderRef, class=org.apache.logging.log4j.core.config.AppenderRef]. DEBUG StatusLogger createAppenderRef(ref="console", level="OFF", Filter=null) DEBUG StatusLogger Building Plugin[name=AppenderRef, class=org.apache.logging.log4j.core.config.AppenderRef]. DEBUG StatusLogger createAppenderRef(ref="DRFA", level="null", Filter=null) DEBUG StatusLogger Building Plugin[name=root, class=org.apache.logging.log4j.core.config.LoggerConfig$RootLogger]. DEBUG StatusLogger createLogger(additivity="null", level="DEBUG", includeLocation="null", ={console, DRFA}, ={}, Configuration(HiveLog4j2Test), Filter=null) DEBUG StatusLogger Building Plugin[name=loggers, class=org.apache.logging.log4j.core.config.LoggersPlugin]. DEBUG StatusLogger createLoggers(={org.apache.hadoop.ipc, org.apache.hadoop.security, org.apache.hadoop.hdfs, org.apache.hadoop.hdfs.server, org.apache.hadoop.metrics2, org.mortbay, org.apache.hadoop.yarn, org.apache.hadoop.yarn.server, org.apache.tez, org.apache.hadoop.conf.Configuration, org.apache.zookeeper, org.apache.zookeeper.server.ServerCnxn, org.apache.zookeeper.server.NIOServerCnxn, org.apache.zookeeper.ClientCnxn, org.apache.zookeeper.ClientCnxnSocket, org.apache.zookeeper.ClientCnxnSocketNIO, DataNucleus, Datastore, JPOX, org.apache.hadoop.hive.ql.exec.Operator, org.apache.hadoop.hive.serde2.lazy, org.apache.hadoop.hive.metastore.ObjectStore, org.apache.calcite.plan.RelOptPlanner, com.amazonaws, org.apache.http, org.apache.thrift, org.eclipse.jetty, BlockStateChange, root}) DEBUG StatusLogger Building Plugin[name=layout, class=org.apache.logging.log4j.core.layout.PatternLayout]. DEBUG StatusLogger PatternLayout$Builder(pattern="%d{ISO8601} %5p [%t] %c{2}: %m%n", PatternSelector=null, Configuration(HiveLog4j2Test), Replace=null, charset="null", alwaysWriteExceptions="null", disableAnsi="null", noConsoleNoAnsi="null", header="null", footer="null") DEBUG StatusLogger PluginManager 'Converter' found 44 plugins DEBUG StatusLogger Building Plugin[name=appender, class=org.apache.logging.log4j.core.appender.ConsoleAppender]. DEBUG StatusLogger ConsoleAppender$Builder(target="SYSTEM_ERR", follow="null", direct="null", bufferedIo="null", bufferSize="null", immediateFlush="null", ignoreExceptions="null", PatternLayout(%d{ISO8601} %5p [%t] %c{2}: %m%n), name="console", Configuration(HiveLog4j2Test), Filter=null, ={}) DEBUG StatusLogger Starting OutputStreamManager SYSTEM_ERR.false.false DEBUG StatusLogger Building Plugin[name=layout, class=org.apache.logging.log4j.core.layout.PatternLayout]. DEBUG StatusLogger PatternLayout$Builder(pattern="%d{ISO8601} %5p [%t] %c{2}: %m%n", PatternSelector=null, Configuration(HiveLog4j2Test), Replace=null, charset="null", alwaysWriteExceptions="null", disableAnsi="null", noConsoleNoAnsi="null", header="null", footer="null") DEBUG StatusLogger Building Plugin[name=TimeBasedTriggeringPolicy, class=org.apache.logging.log4j.core.appender.rolling.TimeBasedTriggeringPolicy]. DEBUG StatusLogger TimeBasedTriggeringPolicy$Builder(interval="1", modulate="true", maxRandomDelay="null") DEBUG StatusLogger Building Plugin[name=Policies, class=org.apache.logging.log4j.core.appender.rolling.CompositeTriggeringPolicy]. DEBUG StatusLogger createPolicy(={TimeBasedTriggeringPolicy(nextRolloverMillis=0, interval=1, modulate=true)}) DEBUG StatusLogger Building Plugin[name=DefaultRolloverStrategy, class=org.apache.logging.log4j.core.appender.rolling.DefaultRolloverStrategy]. DEBUG StatusLogger DefaultRolloverStrategy$Builder(max="30", min="null", fileIndex="null", compressionLevel="null", ={}, stopCustomActionsOnError="null", tempCompressedFilePattern="null", Configuration(HiveLog4j2Test)) DEBUG StatusLogger Building Plugin[name=appender, class=org.apache.logging.log4j.core.appender.RollingRandomAccessFileAppender]. DEBUG StatusLogger RollingRandomAccessFileAppender$Builder(fileName="/home/hiveptest/35.238.102.117-hiveptest-1/apache-github-source-source/itests/qtest/target/tmp/log/hive.log", filePattern="/home/hiveptest/35.238.102.117-hiveptest-1/apache-github-source-source/itests/qtest/target/tmp/log/hive.log.%d{yyyy-MM-dd}", append="null", Policies(CompositeTriggeringPolicy(policies=[TimeBasedTriggeringPolicy(nextRolloverMillis=0, interval=1, modulate=true)])), DefaultRolloverStrategy(DefaultRolloverStrategy(min=1, max=30, useMax=true)), advertise="null", advertiseURI="null", filePermissions="null", fileOwner="null", fileGroup="null", bufferedIo="null", bufferSize="null", immediateFlush="null", ignoreExceptions="null", PatternLayout(%d{ISO8601} %5p [%t] %c{2}: %m%n), name="DRFA", Configuration(HiveLog4j2Test), Filter=null, ={}) TRACE StatusLogger RandomAccessFile /home/hiveptest/35.238.102.117-hiveptest-1/apache-github-source-source/itests/qtest/target/tmp/log/hive.log seek to 0 DEBUG StatusLogger Starting RollingRandomAccessFileManager /home/hiveptest/35.238.102.117-hiveptest-1/apache-github-source-source/itests/qtest/target/tmp/log/hive.log DEBUG StatusLogger PluginManager 'FileConverter' found 3 plugins DEBUG StatusLogger Setting prev file time to 2020-04-20T03:43:39.202-0700 DEBUG StatusLogger Initializing triggering policy CompositeTriggeringPolicy(policies=[TimeBasedTriggeringPolicy(nextRolloverMillis=0, interval=1, modulate=true)]) DEBUG StatusLogger Initializing triggering policy TimeBasedTriggeringPolicy(nextRolloverMillis=0, interval=1, modulate=true) TRACE StatusLogger PatternProcessor.getNextTime returning 2020/04/21-00:00:00.000, nextFileTime=2020/04/20-00:00:00.000, prevFileTime=1969/12/31-16:00:00.000, current=2020/04/20-03:43:39.214, freq=DAILY TRACE StatusLogger PatternProcessor.getNextTime returning 2020/04/21-00:00:00.000, nextFileTime=2020/04/20-00:00:00.000, prevFileTime=2020/04/20-00:00:00.000, current=2020/04/20-03:43:39.215, freq=DAILY DEBUG StatusLogger Building Plugin[name=appenders, class=org.apache.logging.log4j.core.config.AppendersPlugin]. DEBUG StatusLogger createAppenders(={console, DRFA}) DEBUG StatusLogger Configuration org.apache.logging.log4j.core.config.properties.PropertiesConfiguration@4c39bec8 initialized DEBUG StatusLogger Starting configuration org.apache.logging.log4j.core.config.properties.PropertiesConfiguration@4c39bec8 DEBUG StatusLogger Started configuration org.apache.logging.log4j.core.config.properties.PropertiesConfiguration@4c39bec8 OK. TRACE StatusLogger Stopping org.apache.logging.log4j.core.config.DefaultConfiguration@69930714... TRACE StatusLogger DefaultConfiguration notified 1 ReliabilityStrategies that config will be stopped. TRACE StatusLogger DefaultConfiguration stopping root LoggerConfig. TRACE StatusLogger DefaultConfiguration notifying ReliabilityStrategies that appenders will be stopped. TRACE StatusLogger DefaultConfiguration stopping remaining Appenders. DEBUG StatusLogger Shutting down OutputStreamManager SYSTEM_OUT.false.false-1 DEBUG StatusLogger Shut down OutputStreamManager SYSTEM_OUT.false.false-1, all resources released: true DEBUG StatusLogger Appender DefaultConsole-1 stopped with status true TRACE StatusLogger DefaultConfiguration stopped 1 remaining Appenders. TRACE StatusLogger DefaultConfiguration cleaning Appenders from 1 LoggerConfigs. DEBUG StatusLogger Stopped org.apache.logging.log4j.core.config.DefaultConfiguration@69930714 OK TRACE StatusLogger Reregistering MBeans after reconfigure. Selector=org.apache.logging.log4j.core.selector.ClassLoaderContextSelector@7daa0fbd TRACE StatusLogger Reregistering context (1/1): '135fbaa4' org.apache.logging.log4j.core.LoggerContext@62ddbd7e TRACE StatusLogger Unregistering but no MBeans found matching 'org.apache.logging.log4j2:type=135fbaa4' TRACE StatusLogger Unregistering but no MBeans found matching 'org.apache.logging.log4j2:type=135fbaa4,component=StatusLogger' TRACE StatusLogger Unregistering but no MBeans found matching 'org.apache.logging.log4j2:type=135fbaa4,component=ContextSelector' TRACE StatusLogger Unregistering but no MBeans found matching 'org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=*' TRACE StatusLogger Unregistering but no MBeans found matching 'org.apache.logging.log4j2:type=135fbaa4,component=Appenders,name=*' TRACE StatusLogger Unregistering but no MBeans found matching 'org.apache.logging.log4j2:type=135fbaa4,component=AsyncAppenders,name=*' TRACE StatusLogger Unregistering but no MBeans found matching 'org.apache.logging.log4j2:type=135fbaa4,component=AsyncLoggerRingBuffer' TRACE StatusLogger Unregistering but no MBeans found matching 'org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=*,subtype=RingBuffer' DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4 DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=StatusLogger DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=ContextSelector DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name= DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=org.apache.tez DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=com.amazonaws DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=org.apache.thrift DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=org.eclipse.jetty DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=BlockStateChange DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=org.apache.hadoop.metrics2 DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=org.apache.zookeeper.ClientCnxn DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=org.apache.zookeeper DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=org.apache.hadoop.security DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=JPOX DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=org.apache.hadoop.yarn.server DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=org.apache.hadoop.conf.Configuration DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=org.apache.hadoop.yarn DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=org.apache.zookeeper.ClientCnxnSocketNIO DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=org.apache.zookeeper.server.ServerCnxn DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=org.apache.hadoop.hdfs DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=org.apache.hadoop.hdfs.server DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=org.apache.hadoop.hive.serde2.lazy DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=org.apache.zookeeper.ClientCnxnSocket DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=org.mortbay DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=org.apache.http DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=org.apache.hadoop.hive.ql.exec.Operator DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=DataNucleus DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=Datastore DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=org.apache.hadoop.hive.metastore.ObjectStore DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=org.apache.hadoop.ipc DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=org.apache.zookeeper.server.NIOServerCnxn DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Loggers,name=org.apache.calcite.plan.RelOptPlanner DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Appenders,name=console DEBUG StatusLogger Registering MBean org.apache.logging.log4j2:type=135fbaa4,component=Appenders,name=DRFA TRACE StatusLogger Using default SystemClock for timestamps. DEBUG StatusLogger org.apache.logging.log4j.core.util.SystemClock does not support precise timestamps. TRACE StatusLogger Using DummyNanoClock for nanosecond timestamps. DEBUG StatusLogger Reconfiguration complete for context[name=135fbaa4] at URI /home/hiveptest/35.238.102.117-hiveptest-1/apache-github-source-source/itests/qtest/target/testconf/hive-log4j2.properties (org.apache.logging.log4j.core.LoggerContext@62ddbd7e) with optional ClassLoader: null DEBUG StatusLogger Shutdown hook enabled. Registering a new one. DEBUG StatusLogger LoggerContext[name=135fbaa4, org.apache.logging.log4j.core.LoggerContext@62ddbd7e] started OK. DEBUG StatusLogger AsyncLogger.ThreadNameStrategy=UNCACHED (user specified null, default is UNCACHED) TRACE StatusLogger Using default SystemClock for timestamps. DEBUG StatusLogger org.apache.logging.log4j.core.util.SystemClock does not support precise timestamps. Starting org.apache.hadoop.hive.cli.control.CoreCliDriver run at 1587379419354 2020-04-20T03:43:40.999-0700 Attempting to start LlapDaemon with the following configuration: maxJvmMemory=2147483648 (2.00GB), requestedExecutorMemory=1610612736 (1.50GB), llapIoCacheSize=322122560 (307.20MB), xmxHeadRoomMemory=107374182 (102.40MB), adjustedExecutorMemory=1503238554 (1.40GB), numExecutors=4, llapIoEnabled=true, llapIoCacheIsDirect=false, rpcListenerPort=0, mngListenerPort=0, webPort=0, outputFormatSvcPort=0, workDirs=[/home/hiveptest/35.238.102.117-hiveptest-1/apache-github-source-source/itests/qtest/target/llap_MiniLlapCluster/localDir], shufflePort=0, waitQueueSize= 4, enablePreemption= true, timedWindowAverageDataPoints= 0, timedWindowAverageWindowLength= 60000000000, simpleAverageWindowDataSize= 0, versionInfo= (4.0.0-SNAPSHOT from 7b6bacb3e3f9f47e7d6e702d23cf2c909842b993 by tomcat source checksum da6a40ffd5238add30dedbde5976260a) QtestUtil instance created ElapsedTime(ms)=6179 Apr 20, 2020 3:43:46 AM org.jline.utils.Log logr WARNING: Unable to create a system terminal, creating a dumb terminal (enable debug logging for more information) Warning: Database 'memory:/home/hiveptest/35.238.102.117-hiveptest-1/apache-github-source-source/itests/qtest/target/tmp/junit_metastore_db' not created, connection made to existing database instead. (state=01J01,code=10000) java.sql.SQLWarning: Database 'memory:/home/hiveptest/35.238.102.117-hiveptest-1/apache-github-source-source/itests/qtest/target/tmp/junit_metastore_db' not created, connection made to existing database instead. at org.apache.derby.iapi.error.SQLWarningFactory.newSQLWarning(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.(Unknown Source) at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source) at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown Source) at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) at sqlline.DatabaseConnection.connect(DatabaseConnection.java:135) at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:192) at sqlline.Commands.connect(Commands.java:1364) at sqlline.Commands.connect(Commands.java:1244) 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 sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38) at sqlline.SqlLine.dispatch(SqlLine.java:730) at sqlline.SqlLine.initArgs(SqlLine.java:410) at sqlline.SqlLine.begin(SqlLine.java:515) at org.apache.hadoop.hive.metastore.tools.schematool.MetastoreSchemaTool.execSql(MetastoreSchemaTool.java:324) at org.apache.hadoop.hive.metastore.tools.schematool.MetastoreSchemaTool.execSql(MetastoreSchemaTool.java:301) at org.apache.hadoop.hive.metastore.tools.schematool.SchemaToolTaskInit.execute(SchemaToolTaskInit.java:62) at org.apache.hadoop.hive.metastore.tools.schematool.MetastoreSchemaTool.run(MetastoreSchemaTool.java:463) at org.apache.hadoop.hive.metastore.tools.schematool.MetastoreSchemaTool.run(MetastoreSchemaTool.java:423) at org.apache.hadoop.hive.metastore.dbinstall.rules.DatabaseRule.installLatest(DatabaseRule.java:240) at org.apache.hadoop.hive.metastore.dbinstall.rules.DatabaseRule.install(DatabaseRule.java:290) at org.apache.hadoop.hive.cli.control.CliAdapter$1$1.evaluate(CliAdapter.java:84) at org.junit.rules.RunRules.evaluate(RunRules.java:20) at org.junit.runners.ParentRunner.run(ParentRunner.java:309) at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365) at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159) at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:379) at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:340) at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:125) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:413) 1/265 -- Timestamp: 2011-09-22 15:32:02.024 2/265 -- Source database is: /home/carl/Work/repos/hive1/metastore/scripts/upgrade/derby/mdb 3/265 -- Connection URL is: jdbc:derby:/home/carl/Work/repos/hive1/metastore/scripts/upgrade/derby/mdb 4/265 -- Specified schema is: APP 5/265 -- appendLogs: false 6/265 -- ---------------------------------------------- 7/265 -- DDL Statements for functions 8/265 -- ---------------------------------------------- 9/265 CREATE FUNCTION "APP"."NUCLEUS_ASCII" (C CHAR(1)) RETURNS INTEGER LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA CALLED ON NULL INPUT EXTERNAL NAME 'org.datanucleus.store.rdbms.adapter.DerbySQLFunction.ascii' ; No rows affected (0.136 seconds) 10/265 CREATE FUNCTION "APP"."NUCLEUS_MATCHES" (TEXT VARCHAR(8000),PATTERN VARCHAR(8000)) RETURNS INTEGER LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA CALLED ON NULL INPUT EXTERNAL NAME 'org.datanucleus.store.rdbms.adapter.DerbySQLFunction.matches' ; No rows affected (0.003 seconds) 11/265 -- ---------------------------------------------- 12/265 -- DDL Statements for tables 13/265 -- ---------------------------------------------- 14/265 CREATE TABLE "APP"."DBS" ( "DB_ID" BIGINT NOT NULL, "DESC" VARCHAR(4000), "DB_LOCATION_URI" VARCHAR(4000) NOT NULL, "NAME" VARCHAR(128), "OWNER_NAME" VARCHAR(128), "OWNER_TYPE" VARCHAR(10), "CTLG_NAME" VARCHAR(256) NOT NULL DEFAULT 'hive', "CREATE_TIME" INTEGER, "DB_MANAGED_LOCATION_URI" VARCHAR(4000) ); No rows affected (0.038 seconds) 15/265 CREATE TABLE "APP"."TBL_PRIVS" ("TBL_GRANT_ID" BIGINT NOT NULL, "CREATE_TIME" INTEGER NOT NULL, "GRANT_OPTION" SMALLINT NOT NULL, "GRANTOR" VARCHAR(128), "GRANTOR_TYPE" VARCHAR(128), "PRINCIPAL_NAME" VARCHAR(128), "PRINCIPAL_TYPE" VARCHAR(128), "TBL_PRIV" VARCHAR(128), "TBL_ID" BIGINT, "AUTHORIZER" VARCHAR(128)); No rows affected (0.019 seconds) 16/265 CREATE TABLE "APP"."DATABASE_PARAMS" ("DB_ID" BIGINT NOT NULL, "PARAM_KEY" VARCHAR(180) NOT NULL, "PARAM_VALUE" VARCHAR(4000)); No rows affected (0.004 seconds) 17/265 CREATE TABLE "APP"."TBL_COL_PRIVS" ("TBL_COLUMN_GRANT_ID" BIGINT NOT NULL, "COLUMN_NAME" VARCHAR(767), "CREATE_TIME" INTEGER NOT NULL, "GRANT_OPTION" SMALLINT NOT NULL, "GRANTOR" VARCHAR(128), "GRANTOR_TYPE" VARCHAR(128), "PRINCIPAL_NAME" VARCHAR(128), "PRINCIPAL_TYPE" VARCHAR(128), "TBL_COL_PRIV" VARCHAR(128), "TBL_ID" BIGINT, "AUTHORIZER" VARCHAR(128)); No rows affected (0.005 seconds) 18/265 CREATE TABLE "APP"."SERDE_PARAMS" ("SERDE_ID" BIGINT NOT NULL, "PARAM_KEY" VARCHAR(256) NOT NULL, "PARAM_VALUE" CLOB); No rows affected (0.008 seconds) 19/265 CREATE TABLE "APP"."COLUMNS_V2" ("CD_ID" BIGINT NOT NULL, "COMMENT" VARCHAR(4000), "COLUMN_NAME" VARCHAR(767) NOT NULL, "TYPE_NAME" CLOB, "INTEGER_IDX" INTEGER NOT NULL); No rows affected (0.005 seconds) 20/265 CREATE TABLE "APP"."SORT_COLS" ("SD_ID" BIGINT NOT NULL, "COLUMN_NAME" VARCHAR(767), "ORDER" INTEGER NOT NULL, "INTEGER_IDX" INTEGER NOT NULL); No rows affected (0.004 seconds) 21/265 CREATE TABLE "APP"."CDS" ("CD_ID" BIGINT NOT NULL); No rows affected (0.003 seconds) 22/265 CREATE TABLE "APP"."PARTITION_KEY_VALS" ("PART_ID" BIGINT NOT NULL, "PART_KEY_VAL" VARCHAR(256), "INTEGER_IDX" INTEGER NOT NULL); No rows affected (0.003 seconds) 23/265 CREATE TABLE "APP"."DB_PRIVS" ("DB_GRANT_ID" BIGINT NOT NULL, "CREATE_TIME" INTEGER NOT NULL, "DB_ID" BIGINT, "GRANT_OPTION" SMALLINT NOT NULL, "GRANTOR" VARCHAR(128), "GRANTOR_TYPE" VARCHAR(128), "PRINCIPAL_NAME" VARCHAR(128), "PRINCIPAL_TYPE" VARCHAR(128), "DB_PRIV" VARCHAR(128), "AUTHORIZER" VARCHAR(128)); No rows affected (0.005 seconds) 24/265 CREATE TABLE "APP"."IDXS" ("INDEX_ID" BIGINT NOT NULL, "CREATE_TIME" INTEGER NOT NULL, "DEFERRED_REBUILD" CHAR(1) NOT NULL, "INDEX_HANDLER_CLASS" VARCHAR(4000), "INDEX_NAME" VARCHAR(128), "INDEX_TBL_ID" BIGINT, "LAST_ACCESS_TIME" INTEGER NOT NULL, "ORIG_TBL_ID" BIGINT, "SD_ID" BIGINT); No rows affected (0.006 seconds) 25/265 CREATE TABLE "APP"."INDEX_PARAMS" ("INDEX_ID" BIGINT NOT NULL, "PARAM_KEY" VARCHAR(256) NOT NULL, "PARAM_VALUE" VARCHAR(4000)); No rows affected (0.003 seconds) 26/265 CREATE TABLE "APP"."PARTITIONS" ("PART_ID" BIGINT NOT NULL, "CREATE_TIME" INTEGER NOT NULL, "LAST_ACCESS_TIME" INTEGER NOT NULL, "PART_NAME" VARCHAR(767), "SD_ID" BIGINT, "TBL_ID" BIGINT, "WRITE_ID" BIGINT DEFAULT 0); No rows affected (0.006 seconds) 27/265 CREATE TABLE "APP"."SERDES" ("SERDE_ID" BIGINT NOT NULL, "NAME" VARCHAR(128), "SLIB" VARCHAR(4000), "DESCRIPTION" VARCHAR(4000), "SERIALIZER_CLASS" VARCHAR(4000), "DESERIALIZER_CLASS" VARCHAR(4000), SERDE_TYPE INTEGER); No rows affected (0.005 seconds) 28/265 CREATE TABLE "APP"."PART_PRIVS" ("PART_GRANT_ID" BIGINT NOT NULL, "CREATE_TIME" INTEGER NOT NULL, "GRANT_OPTION" SMALLINT NOT NULL, "GRANTOR" VARCHAR(128), "GRANTOR_TYPE" VARCHAR(128), "PART_ID" BIGINT, "PRINCIPAL_NAME" VARCHAR(128), "PRINCIPAL_TYPE" VARCHAR(128), "PART_PRIV" VARCHAR(128), "AUTHORIZER" VARCHAR(128)); No rows affected (0.004 seconds) 29/265 CREATE TABLE "APP"."ROLE_MAP" ("ROLE_GRANT_ID" BIGINT NOT NULL, "ADD_TIME" INTEGER NOT NULL, "GRANT_OPTION" SMALLINT NOT NULL, "GRANTOR" VARCHAR(128), "GRANTOR_TYPE" VARCHAR(128), "PRINCIPAL_NAME" VARCHAR(128), "PRINCIPAL_TYPE" VARCHAR(128), "ROLE_ID" BIGINT); No rows affected (0.006 seconds) 30/265 CREATE TABLE "APP"."TYPES" ("TYPES_ID" BIGINT NOT NULL, "TYPE_NAME" VARCHAR(128), "TYPE1" VARCHAR(767), "TYPE2" VARCHAR(767)); No rows affected (0.003 seconds) 31/265 CREATE TABLE "APP"."GLOBAL_PRIVS" ("USER_GRANT_ID" BIGINT NOT NULL, "CREATE_TIME" INTEGER NOT NULL, "GRANT_OPTION" SMALLINT NOT NULL, "GRANTOR" VARCHAR(128), "GRANTOR_TYPE" VARCHAR(128), "PRINCIPAL_NAME" VARCHAR(128), "PRINCIPAL_TYPE" VARCHAR(128), "USER_PRIV" VARCHAR(128), "AUTHORIZER" VARCHAR(128)); No rows affected (0.006 seconds) 32/265 CREATE TABLE "APP"."PARTITION_PARAMS" ("PART_ID" BIGINT NOT NULL, "PARAM_KEY" VARCHAR(256) NOT NULL, "PARAM_VALUE" CLOB); No rows affected (0.003 seconds) 33/265 CREATE TABLE "APP"."PARTITION_EVENTS" ( "PART_NAME_ID" BIGINT NOT NULL, "CAT_NAME" VARCHAR(256), "DB_NAME" VARCHAR(128), "EVENT_TIME" BIGINT NOT NULL, "EVENT_TYPE" INTEGER NOT NULL, "PARTITION_NAME" VARCHAR(767), "TBL_NAME" VARCHAR(256) ); No rows affected (0.012 seconds) 34/265 CREATE TABLE "APP"."COLUMNS" ("SD_ID" BIGINT NOT NULL, "COMMENT" VARCHAR(256), "COLUMN_NAME" VARCHAR(128) NOT NULL, "TYPE_NAME" VARCHAR(4000) NOT NULL, "INTEGER_IDX" INTEGER NOT NULL); No rows affected (0.004 seconds) 35/265 CREATE TABLE "APP"."ROLES" ("ROLE_ID" BIGINT NOT NULL, "CREATE_TIME" INTEGER NOT NULL, "OWNER_NAME" VARCHAR(128), "ROLE_NAME" VARCHAR(128)); No rows affected (0.006 seconds) 36/265 CREATE TABLE "APP"."TBLS" ("TBL_ID" BIGINT NOT NULL, "CREATE_TIME" INTEGER NOT NULL, "DB_ID" BIGINT, "LAST_ACCESS_TIME" INTEGER NOT NULL, "OWNER" VARCHAR(767), "OWNER_TYPE" VARCHAR(10), "RETENTION" INTEGER NOT NULL, "SD_ID" BIGINT, "TBL_NAME" VARCHAR(256), "TBL_TYPE" VARCHAR(128), "VIEW_EXPANDED_TEXT" LONG VARCHAR, "VIEW_ORIGINAL_TEXT" LONG VARCHAR, "IS_REWRITE_ENABLED" CHAR(1) NOT NULL DEFAULT 'N', "WRITE_ID" BIGINT DEFAULT 0); No rows affected (0.016 seconds) 37/265 CREATE TABLE "APP"."PARTITION_KEYS" ("TBL_ID" BIGINT NOT NULL, "PKEY_COMMENT" VARCHAR(4000), "PKEY_NAME" VARCHAR(128) NOT NULL, "PKEY_TYPE" VARCHAR(767) NOT NULL, "INTEGER_IDX" INTEGER NOT NULL); No rows affected (0.003 seconds) 38/265 CREATE TABLE "APP"."PART_COL_PRIVS" ("PART_COLUMN_GRANT_ID" BIGINT NOT NULL, "COLUMN_NAME" VARCHAR(767), "CREATE_TIME" INTEGER NOT NULL, "GRANT_OPTION" SMALLINT NOT NULL, "GRANTOR" VARCHAR(128), "GRANTOR_TYPE" VARCHAR(128), "PART_ID" BIGINT, "PRINCIPAL_NAME" VARCHAR(128), "PRINCIPAL_TYPE" VARCHAR(128), "PART_COL_PRIV" VARCHAR(128), "AUTHORIZER" VARCHAR(128)); No rows affected (0.006 seconds) 39/265 CREATE TABLE "APP"."SDS" ("SD_ID" BIGINT NOT NULL, "INPUT_FORMAT" VARCHAR(4000), "IS_COMPRESSED" CHAR(1) NOT NULL, "LOCATION" VARCHAR(4000), "NUM_BUCKETS" INTEGER NOT NULL, "OUTPUT_FORMAT" VARCHAR(4000), "SERDE_ID" BIGINT, "CD_ID" BIGINT, "IS_STOREDASSUBDIRECTORIES" CHAR(1) NOT NULL); No rows affected (0.005 seconds) 40/265 CREATE TABLE "APP"."SEQUENCE_TABLE" ("SEQUENCE_NAME" VARCHAR(256) NOT NULL, "NEXT_VAL" BIGINT NOT NULL); No rows affected (0.002 seconds) 41/265 CREATE TABLE "APP"."TAB_COL_STATS"( "CAT_NAME" VARCHAR(256) NOT NULL, "DB_NAME" VARCHAR(128) NOT NULL, "TABLE_NAME" VARCHAR(256) NOT NULL, "COLUMN_NAME" VARCHAR(767) NOT NULL, "COLUMN_TYPE" VARCHAR(128) NOT NULL, "LONG_LOW_VALUE" BIGINT, "LONG_HIGH_VALUE" BIGINT, "DOUBLE_LOW_VALUE" DOUBLE, "DOUBLE_HIGH_VALUE" DOUBLE, "BIG_DECIMAL_LOW_VALUE" VARCHAR(4000), "BIG_DECIMAL_HIGH_VALUE" VARCHAR(4000), "NUM_DISTINCTS" BIGINT, "NUM_NULLS" BIGINT NOT NULL, "AVG_COL_LEN" DOUBLE, "MAX_COL_LEN" BIGINT, "NUM_TRUES" BIGINT, "NUM_FALSES" BIGINT, "LAST_ANALYZED" BIGINT, "CS_ID" BIGINT NOT NULL, "TBL_ID" BIGINT NOT NULL, "BIT_VECTOR" BLOB, "ENGINE" VARCHAR(128) NOT NULL ); No rows affected (0.021 seconds) 42/265 CREATE TABLE "APP"."TABLE_PARAMS" ("TBL_ID" BIGINT NOT NULL, "PARAM_KEY" VARCHAR(256) NOT NULL, "PARAM_VALUE" CLOB); No rows affected (0.003 seconds) 43/265 CREATE TABLE "APP"."BUCKETING_COLS" ("SD_ID" BIGINT NOT NULL, "BUCKET_COL_NAME" VARCHAR(256), "INTEGER_IDX" INTEGER NOT NULL); No rows affected (0.005 seconds) 44/265 CREATE TABLE "APP"."TYPE_FIELDS" ("TYPE_NAME" BIGINT NOT NULL, "COMMENT" VARCHAR(256), "FIELD_NAME" VARCHAR(128) NOT NULL, "FIELD_TYPE" VARCHAR(767) NOT NULL, "INTEGER_IDX" INTEGER NOT NULL); No rows affected (0.009 seconds) 45/265 CREATE TABLE "APP"."NUCLEUS_TABLES" ("CLASS_NAME" VARCHAR(128) NOT NULL, "TABLE_NAME" VARCHAR(128) NOT NULL, "TYPE" VARCHAR(4) NOT NULL, "OWNER" VARCHAR(2) NOT NULL, "VERSION" VARCHAR(20) NOT NULL, "INTERFACE_NAME" VARCHAR(256) DEFAULT NULL); No rows affected (0.003 seconds) 46/265 CREATE TABLE "APP"."SD_PARAMS" ("SD_ID" BIGINT NOT NULL, "PARAM_KEY" VARCHAR(256) NOT NULL, "PARAM_VALUE" CLOB); No rows affected (0.017 seconds) 47/265 CREATE TABLE "APP"."SKEWED_STRING_LIST" ("STRING_LIST_ID" BIGINT NOT NULL); No rows affected (0.019 seconds) 48/265 CREATE TABLE "APP"."SKEWED_STRING_LIST_VALUES" ("STRING_LIST_ID" BIGINT NOT NULL, "STRING_LIST_VALUE" VARCHAR(256), "INTEGER_IDX" INTEGER NOT NULL); No rows affected (0.005 seconds) 49/265 CREATE TABLE "APP"."SKEWED_COL_NAMES" ("SD_ID" BIGINT NOT NULL, "SKEWED_COL_NAME" VARCHAR(256), "INTEGER_IDX" INTEGER NOT NULL); No rows affected (0.003 seconds) 50/265 CREATE TABLE "APP"."SKEWED_COL_VALUE_LOC_MAP" ("SD_ID" BIGINT NOT NULL, "STRING_LIST_ID_KID" BIGINT NOT NULL, "LOCATION" VARCHAR(4000)); No rows affected (0.003 seconds) 51/265 CREATE TABLE "APP"."SKEWED_VALUES" ("SD_ID_OID" BIGINT NOT NULL, "STRING_LIST_ID_EID" BIGINT NOT NULL, "INTEGER_IDX" INTEGER NOT NULL); No rows affected (0.005 seconds) 52/265 CREATE TABLE "APP"."MASTER_KEYS" ("KEY_ID" INTEGER NOT NULL generated always as identity (start with 1), "MASTER_KEY" VARCHAR(767)); No rows affected (0.007 seconds) 53/265 CREATE TABLE "APP"."DELEGATION_TOKENS" ( "TOKEN_IDENT" VARCHAR(767) NOT NULL, "TOKEN" VARCHAR(767)); No rows affected (0.011 seconds) 54/265 CREATE TABLE "APP"."PART_COL_STATS"( "CAT_NAME" VARCHAR(256) NOT NULL, "DB_NAME" VARCHAR(128) NOT NULL, "TABLE_NAME" VARCHAR(256) NOT NULL, "PARTITION_NAME" VARCHAR(767) NOT NULL, "COLUMN_NAME" VARCHAR(767) NOT NULL, "COLUMN_TYPE" VARCHAR(128) NOT NULL, "LONG_LOW_VALUE" BIGINT, "LONG_HIGH_VALUE" BIGINT, "DOUBLE_LOW_VALUE" DOUBLE, "DOUBLE_HIGH_VALUE" DOUBLE, "BIG_DECIMAL_LOW_VALUE" VARCHAR(4000), "BIG_DECIMAL_HIGH_VALUE" VARCHAR(4000), "NUM_DISTINCTS" BIGINT, "BIT_VECTOR" BLOB, "NUM_NULLS" BIGINT NOT NULL, "AVG_COL_LEN" DOUBLE, "MAX_COL_LEN" BIGINT, "NUM_TRUES" BIGINT, "NUM_FALSES" BIGINT, "LAST_ANALYZED" BIGINT, "CS_ID" BIGINT NOT NULL, "PART_ID" BIGINT NOT NULL, "ENGINE" VARCHAR(128) NOT NULL ); No rows affected (0.005 seconds) 55/265 CREATE TABLE "APP"."VERSION" ("VER_ID" BIGINT NOT NULL, "SCHEMA_VERSION" VARCHAR(127) NOT NULL, "VERSION_COMMENT" VARCHAR(255)); No rows affected (0.003 seconds) 56/265 CREATE TABLE "APP"."FUNCS" ("FUNC_ID" BIGINT NOT NULL, "CLASS_NAME" VARCHAR(4000), "CREATE_TIME" INTEGER NOT NULL, "DB_ID" BIGINT, "FUNC_NAME" VARCHAR(128), "FUNC_TYPE" INTEGER NOT NULL, "OWNER_NAME" VARCHAR(128), "OWNER_TYPE" VARCHAR(10)); No rows affected (0.008 seconds) 57/265 CREATE TABLE "APP"."FUNC_RU" ("FUNC_ID" BIGINT NOT NULL, "RESOURCE_TYPE" INTEGER NOT NULL, "RESOURCE_URI" VARCHAR(4000), "INTEGER_IDX" INTEGER NOT NULL); No rows affected (0.028 seconds) 58/265 CREATE TABLE "APP"."NOTIFICATION_LOG" ( "NL_ID" BIGINT NOT NULL, "CAT_NAME" VARCHAR(256), "DB_NAME" VARCHAR(128), "EVENT_ID" BIGINT NOT NULL, "EVENT_TIME" INTEGER NOT NULL, "EVENT_TYPE" VARCHAR(32) NOT NULL, "MESSAGE" CLOB, "TBL_NAME" VARCHAR(256), "MESSAGE_FORMAT" VARCHAR(16) ); No rows affected (0.004 seconds) 59/265 CREATE UNIQUE INDEX "APP"."NOTIFICATION_LOG_EVENT_ID" ON "APP"."NOTIFICATION_LOG" ("EVENT_ID"); No rows affected (0.047 seconds) 60/265 CREATE TABLE "APP"."NOTIFICATION_SEQUENCE" ("NNI_ID" BIGINT NOT NULL, "NEXT_EVENT_ID" BIGINT NOT NULL); No rows affected (0.004 seconds) 61/265 CREATE TABLE "APP"."KEY_CONSTRAINTS" ( "CHILD_CD_ID" BIGINT, "CHILD_INTEGER_IDX" INTEGER, "CHILD_TBL_ID" BIGINT, "PARENT_CD_ID" BIGINT, "PARENT_INTEGER_IDX" INTEGER, "PARENT_TBL_ID" BIGINT NOT NULL, "POSITION" BIGINT NOT NULL, "CONSTRAINT_NAME" VARCHAR(400) NOT NULL, "CONSTRAINT_TYPE" SMALLINT NOT NULL, "UPDATE_RULE" SMALLINT, "DELETE_RULE" SMALLINT, "ENABLE_VALIDATE_RELY" SMALLINT NOT NULL, "DEFAULT_VALUE" VARCHAR(400) ); No rows affected (0.013 seconds) 62/265 CREATE TABLE "APP"."METASTORE_DB_PROPERTIES" ("PROPERTY_KEY" VARCHAR(255) NOT NULL, "PROPERTY_VALUE" VARCHAR(1000) NOT NULL, "DESCRIPTION" VARCHAR(1000)); No rows affected (0.003 seconds) 63/265 CREATE TABLE "APP"."WM_RESOURCEPLAN" (RP_ID BIGINT NOT NULL, NS VARCHAR(128), NAME VARCHAR(128) NOT NULL, QUERY_PARALLELISM INTEGER, STATUS VARCHAR(20) NOT NULL, DEFAULT_POOL_ID BIGINT); No rows affected (0.003 seconds) 64/265 CREATE TABLE "APP"."WM_POOL" (POOL_ID BIGINT NOT NULL, RP_ID BIGINT NOT NULL, PATH VARCHAR(1024) NOT NULL, ALLOC_FRACTION DOUBLE, QUERY_PARALLELISM INTEGER, SCHEDULING_POLICY VARCHAR(1024)); No rows affected (0.009 seconds) 65/265 CREATE TABLE "APP"."WM_TRIGGER" (TRIGGER_ID BIGINT NOT NULL, RP_ID BIGINT NOT NULL, NAME VARCHAR(128) NOT NULL, TRIGGER_EXPRESSION VARCHAR(1024), ACTION_EXPRESSION VARCHAR(1024), IS_IN_UNMANAGED INTEGER NOT NULL DEFAULT 0); No rows affected (0.013 seconds) 66/265 CREATE TABLE "APP"."WM_POOL_TO_TRIGGER" (POOL_ID BIGINT NOT NULL, TRIGGER_ID BIGINT NOT NULL); No rows affected (0.007 seconds) 67/265 CREATE TABLE "APP"."WM_MAPPING" (MAPPING_ID BIGINT NOT NULL, RP_ID BIGINT NOT NULL, ENTITY_TYPE VARCHAR(128) NOT NULL, ENTITY_NAME VARCHAR(128) NOT NULL, POOL_ID BIGINT, ORDERING INTEGER); No rows affected (0.006 seconds) 68/265 CREATE TABLE "APP"."MV_CREATION_METADATA" ( "MV_CREATION_METADATA_ID" BIGINT NOT NULL, "CAT_NAME" VARCHAR(256) NOT NULL, "DB_NAME" VARCHAR(128) NOT NULL, "TBL_NAME" VARCHAR(256) NOT NULL, "TXN_LIST" CLOB, "MATERIALIZATION_TIME" BIGINT NOT NULL ); No rows affected (0.003 seconds) 69/265 CREATE TABLE "APP"."MV_TABLES_USED" ( "MV_CREATION_METADATA_ID" BIGINT NOT NULL, "TBL_ID" BIGINT NOT NULL ); No rows affected (0.005 seconds) 70/265 CREATE TABLE "APP"."CTLGS" ( "CTLG_ID" BIGINT NOT NULL, "NAME" VARCHAR(256) UNIQUE, "DESC" VARCHAR(4000), "LOCATION_URI" VARCHAR(4000) NOT NULL, "CREATE_TIME" INTEGER); No rows affected (0.025 seconds) 71/265 -- Insert a default value. The location is TBD. Hive will fix this when it starts 72/265 INSERT INTO "APP"."CTLGS" VALUES (1, 'hive', 'Default catalog for Hive', 'TBD', NULL); 1 row affected (0.091 seconds) 73/265 -- ---------------------------------------------- 74/265 -- DML Statements 75/265 -- ---------------------------------------------- 76/265 INSERT INTO "APP"."NOTIFICATION_SEQUENCE" ("NNI_ID", "NEXT_EVENT_ID") SELECT * FROM (VALUES (1,1)) tmp_table WHERE NOT EXISTS ( SELECT "NEXT_EVENT_ID" FROM "APP"."NOTIFICATION_SEQUENCE"); 1 row affected (0.055 seconds) 77/265 INSERT INTO "APP"."SEQUENCE_TABLE" ("SEQUENCE_NAME", "NEXT_VAL") SELECT * FROM (VALUES ('org.apache.hadoop.hive.metastore.model.MNotificationLog', 1)) tmp_table WHERE NOT EXISTS ( SELECT "NEXT_VAL" FROM "APP"."SEQUENCE_TABLE" WHERE "SEQUENCE_NAME" = 'org.apache.hadoop.hive.metastore.model.MNotificationLog'); 1 row affected (0.023 seconds) 78/265 -- ---------------------------------------------- 79/265 -- DDL Statements for indexes 80/265 -- ---------------------------------------------- 81/265 CREATE UNIQUE INDEX "APP"."UNIQUEINDEX" ON "APP"."IDXS" ("INDEX_NAME", "ORIG_TBL_ID"); No rows affected (0.004 seconds) 82/265 CREATE INDEX "APP"."TABLECOLUMNPRIVILEGEINDEX" ON "APP"."TBL_COL_PRIVS" ("AUTHORIZER", "TBL_ID", "COLUMN_NAME", "PRINCIPAL_NAME", "PRINCIPAL_TYPE", "TBL_COL_PRIV", "GRANTOR", "GRANTOR_TYPE"); No rows affected (0.004 seconds) 83/265 CREATE UNIQUE INDEX "APP"."DBPRIVILEGEINDEX" ON "APP"."DB_PRIVS" ("AUTHORIZER", "DB_ID", "PRINCIPAL_NAME", "PRINCIPAL_TYPE", "DB_PRIV", "GRANTOR", "GRANTOR_TYPE"); No rows affected (0.005 seconds) 84/265 CREATE INDEX "APP"."PCS_STATS_IDX" ON "APP"."PART_COL_STATS" ("CAT_NAME", "DB_NAME","TABLE_NAME","COLUMN_NAME","PARTITION_NAME"); No rows affected (0.005 seconds) 85/265 CREATE INDEX "APP"."TAB_COL_STATS_IDX" ON "APP"."TAB_COL_STATS" ("CAT_NAME", "DB_NAME", "TABLE_NAME", "COLUMN_NAME"); No rows affected (0.005 seconds) 86/265 CREATE INDEX "APP"."PARTPRIVILEGEINDEX" ON "APP"."PART_PRIVS" ("AUTHORIZER", "PART_ID", "PRINCIPAL_NAME", "PRINCIPAL_TYPE", "PART_PRIV", "GRANTOR", "GRANTOR_TYPE"); No rows affected (0.003 seconds) 87/265 CREATE UNIQUE INDEX "APP"."ROLEENTITYINDEX" ON "APP"."ROLES" ("ROLE_NAME"); No rows affected (0.005 seconds) 88/265 CREATE INDEX "APP"."TABLEPRIVILEGEINDEX" ON "APP"."TBL_PRIVS" ("AUTHORIZER", "TBL_ID", "PRINCIPAL_NAME", "PRINCIPAL_TYPE", "TBL_PRIV", "GRANTOR", "GRANTOR_TYPE"); No rows affected (0.003 seconds) 89/265 CREATE UNIQUE INDEX "APP"."UNIQUETABLE" ON "APP"."TBLS" ("TBL_NAME", "DB_ID"); No rows affected (0.002 seconds) 90/265 CREATE UNIQUE INDEX "APP"."UNIQUE_DATABASE" ON "APP"."DBS" ("NAME", "CTLG_NAME"); No rows affected (0.003 seconds) 91/265 CREATE UNIQUE INDEX "APP"."USERROLEMAPINDEX" ON "APP"."ROLE_MAP" ("PRINCIPAL_NAME", "ROLE_ID", "GRANTOR", "GRANTOR_TYPE"); No rows affected (0.016 seconds) 92/265 CREATE UNIQUE INDEX "APP"."GLOBALPRIVILEGEINDEX" ON "APP"."GLOBAL_PRIVS" ("AUTHORIZER", "PRINCIPAL_NAME", "PRINCIPAL_TYPE", "USER_PRIV", "GRANTOR", "GRANTOR_TYPE"); No rows affected (0.005 seconds) 93/265 CREATE UNIQUE INDEX "APP"."UNIQUE_TYPE" ON "APP"."TYPES" ("TYPE_NAME"); No rows affected (0.004 seconds) 94/265 CREATE INDEX "APP"."PARTITIONCOLUMNPRIVILEGEINDEX" ON "APP"."PART_COL_PRIVS" ("AUTHORIZER", "PART_ID", "COLUMN_NAME", "PRINCIPAL_NAME", "PRINCIPAL_TYPE", "PART_COL_PRIV", "GRANTOR", "GRANTOR_TYPE"); No rows affected (0.004 seconds) 95/265 CREATE UNIQUE INDEX "APP"."UNIQUEPARTITION" ON "APP"."PARTITIONS" ("PART_NAME", "TBL_ID"); No rows affected (0.009 seconds) 96/265 CREATE UNIQUE INDEX "APP"."UNIQUEFUNCTION" ON "APP"."FUNCS" ("FUNC_NAME", "DB_ID"); No rows affected (0.014 seconds) 97/265 CREATE INDEX "APP"."FUNCS_N49" ON "APP"."FUNCS" ("DB_ID"); No rows affected (0.008 seconds) 98/265 CREATE INDEX "APP"."FUNC_RU_N49" ON "APP"."FUNC_RU" ("FUNC_ID"); No rows affected (0.011 seconds) 99/265 CREATE INDEX "APP"."CONSTRAINTS_PARENT_TBL_ID_INDEX" ON "APP"."KEY_CONSTRAINTS"("PARENT_TBL_ID"); No rows affected (0.004 seconds) 100/265 CREATE INDEX "APP"."CONSTRAINTS_CONSTRAINT_TYPE_INDEX" ON "APP"."KEY_CONSTRAINTS"("CONSTRAINT_TYPE"); No rows affected (0.016 seconds) 101/265 CREATE UNIQUE INDEX "APP"."UNIQUE_WM_RESOURCEPLAN" ON "APP"."WM_RESOURCEPLAN" ("NS", "NAME"); No rows affected (0.016 seconds) 102/265 CREATE UNIQUE INDEX "APP"."UNIQUE_WM_POOL" ON "APP"."WM_POOL" ("RP_ID", "PATH"); No rows affected (0.011 seconds) 103/265 CREATE UNIQUE INDEX "APP"."UNIQUE_WM_TRIGGER" ON "APP"."WM_TRIGGER" ("RP_ID", "NAME"); No rows affected (0.009 seconds) 104/265 CREATE UNIQUE INDEX "APP"."UNIQUE_WM_MAPPING" ON "APP"."WM_MAPPING" ("RP_ID", "ENTITY_TYPE", "ENTITY_NAME"); No rows affected (0.005 seconds) 105/265 CREATE UNIQUE INDEX "APP"."MV_UNIQUE_TABLE" ON "APP"."MV_CREATION_METADATA" ("TBL_NAME", "DB_NAME"); No rows affected (0.009 seconds) 106/265 CREATE UNIQUE INDEX "APP"."UNIQUE_CATALOG" ON "APP"."CTLGS" ("NAME"); No rows affected (0.003 seconds) 107/265 -- ---------------------------------------------- 108/265 -- DDL Statements for keys 109/265 -- ---------------------------------------------- 110/265 -- primary/unique 111/265 ALTER TABLE "APP"."IDXS" ADD CONSTRAINT "IDXS_PK" PRIMARY KEY ("INDEX_ID"); No rows affected (0.012 seconds) 112/265 ALTER TABLE "APP"."TBL_COL_PRIVS" ADD CONSTRAINT "TBL_COL_PRIVS_PK" PRIMARY KEY ("TBL_COLUMN_GRANT_ID"); No rows affected (0.006 seconds) 113/265 ALTER TABLE "APP"."CDS" ADD CONSTRAINT "SQL110922153006460" PRIMARY KEY ("CD_ID"); No rows affected (0.004 seconds) 114/265 ALTER TABLE "APP"."DB_PRIVS" ADD CONSTRAINT "DB_PRIVS_PK" PRIMARY KEY ("DB_GRANT_ID"); No rows affected (0.006 seconds) 115/265 ALTER TABLE "APP"."INDEX_PARAMS" ADD CONSTRAINT "INDEX_PARAMS_PK" PRIMARY KEY ("INDEX_ID", "PARAM_KEY"); No rows affected (0.004 seconds) 116/265 ALTER TABLE "APP"."PARTITION_KEYS" ADD CONSTRAINT "PARTITION_KEY_PK" PRIMARY KEY ("TBL_ID", "PKEY_NAME"); No rows affected (0.01 seconds) 117/265 ALTER TABLE "APP"."SEQUENCE_TABLE" ADD CONSTRAINT "SEQUENCE_TABLE_PK" PRIMARY KEY ("SEQUENCE_NAME"); No rows affected (0.014 seconds) 118/265 ALTER TABLE "APP"."PART_PRIVS" ADD CONSTRAINT "PART_PRIVS_PK" PRIMARY KEY ("PART_GRANT_ID"); No rows affected (0.021 seconds) 119/265 ALTER TABLE "APP"."SDS" ADD CONSTRAINT "SDS_PK" PRIMARY KEY ("SD_ID"); No rows affected (0.012 seconds) 120/265 ALTER TABLE "APP"."SERDES" ADD CONSTRAINT "SERDES_PK" PRIMARY KEY ("SERDE_ID"); No rows affected (0.005 seconds) 121/265 ALTER TABLE "APP"."COLUMNS" ADD CONSTRAINT "COLUMNS_PK" PRIMARY KEY ("SD_ID", "COLUMN_NAME"); No rows affected (0.008 seconds) 122/265 ALTER TABLE "APP"."PARTITION_EVENTS" ADD CONSTRAINT "PARTITION_EVENTS_PK" PRIMARY KEY ("PART_NAME_ID"); No rows affected (0.013 seconds) 123/265 ALTER TABLE "APP"."TYPE_FIELDS" ADD CONSTRAINT "TYPE_FIELDS_PK" PRIMARY KEY ("TYPE_NAME", "FIELD_NAME"); No rows affected (0.005 seconds) 124/265 ALTER TABLE "APP"."ROLES" ADD CONSTRAINT "ROLES_PK" PRIMARY KEY ("ROLE_ID"); No rows affected (0.004 seconds) 125/265 ALTER TABLE "APP"."TBL_PRIVS" ADD CONSTRAINT "TBL_PRIVS_PK" PRIMARY KEY ("TBL_GRANT_ID"); No rows affected (0.035 seconds) 126/265 ALTER TABLE "APP"."SERDE_PARAMS" ADD CONSTRAINT "SERDE_PARAMS_PK" PRIMARY KEY ("SERDE_ID", "PARAM_KEY"); No rows affected (0.015 seconds) 127/265 ALTER TABLE "APP"."NUCLEUS_TABLES" ADD CONSTRAINT "NUCLEUS_TABLES_PK" PRIMARY KEY ("CLASS_NAME"); No rows affected (0.02 seconds) 128/265 ALTER TABLE "APP"."TBLS" ADD CONSTRAINT "TBLS_PK" PRIMARY KEY ("TBL_ID"); No rows affected (0.006 seconds) 129/265 ALTER TABLE "APP"."SD_PARAMS" ADD CONSTRAINT "SD_PARAMS_PK" PRIMARY KEY ("SD_ID", "PARAM_KEY"); No rows affected (0.009 seconds) 130/265 ALTER TABLE "APP"."DATABASE_PARAMS" ADD CONSTRAINT "DATABASE_PARAMS_PK" PRIMARY KEY ("DB_ID", "PARAM_KEY"); No rows affected (0.005 seconds) 131/265 ALTER TABLE "APP"."DBS" ADD CONSTRAINT "DBS_PK" PRIMARY KEY ("DB_ID"); No rows affected (0.017 seconds) 132/265 ALTER TABLE "APP"."ROLE_MAP" ADD CONSTRAINT "ROLE_MAP_PK" PRIMARY KEY ("ROLE_GRANT_ID"); No rows affected (0.006 seconds) 133/265 ALTER TABLE "APP"."GLOBAL_PRIVS" ADD CONSTRAINT "GLOBAL_PRIVS_PK" PRIMARY KEY ("USER_GRANT_ID"); No rows affected (0.016 seconds) 134/265 ALTER TABLE "APP"."BUCKETING_COLS" ADD CONSTRAINT "BUCKETING_COLS_PK" PRIMARY KEY ("SD_ID", "INTEGER_IDX"); No rows affected (0.007 seconds) 135/265 ALTER TABLE "APP"."SORT_COLS" ADD CONSTRAINT "SORT_COLS_PK" PRIMARY KEY ("SD_ID", "INTEGER_IDX"); No rows affected (0.02 seconds) 136/265 ALTER TABLE "APP"."PARTITION_KEY_VALS" ADD CONSTRAINT "PARTITION_KEY_VALS_PK" PRIMARY KEY ("PART_ID", "INTEGER_IDX"); No rows affected (0.003 seconds) 137/265 ALTER TABLE "APP"."TYPES" ADD CONSTRAINT "TYPES_PK" PRIMARY KEY ("TYPES_ID"); No rows affected (0.019 seconds) 138/265 ALTER TABLE "APP"."COLUMNS_V2" ADD CONSTRAINT "SQL110922153006740" PRIMARY KEY ("CD_ID", "COLUMN_NAME"); No rows affected (0.004 seconds) 139/265 ALTER TABLE "APP"."PART_COL_PRIVS" ADD CONSTRAINT "PART_COL_PRIVS_PK" PRIMARY KEY ("PART_COLUMN_GRANT_ID"); No rows affected (0.004 seconds) 140/265 ALTER TABLE "APP"."PARTITION_PARAMS" ADD CONSTRAINT "PARTITION_PARAMS_PK" PRIMARY KEY ("PART_ID", "PARAM_KEY"); No rows affected (0.003 seconds) 141/265 ALTER TABLE "APP"."PARTITIONS" ADD CONSTRAINT "PARTITIONS_PK" PRIMARY KEY ("PART_ID"); No rows affected (0.004 seconds) 142/265 ALTER TABLE "APP"."TABLE_PARAMS" ADD CONSTRAINT "TABLE_PARAMS_PK" PRIMARY KEY ("TBL_ID", "PARAM_KEY"); No rows affected (0.003 seconds) 143/265 ALTER TABLE "APP"."SKEWED_STRING_LIST" ADD CONSTRAINT "SKEWED_STRING_LIST_PK" PRIMARY KEY ("STRING_LIST_ID"); No rows affected (0.005 seconds) 144/265 ALTER TABLE "APP"."SKEWED_STRING_LIST_VALUES" ADD CONSTRAINT "SKEWED_STRING_LIST_VALUES_PK" PRIMARY KEY ("STRING_LIST_ID", "INTEGER_IDX"); No rows affected (0.015 seconds) 145/265 ALTER TABLE "APP"."SKEWED_COL_NAMES" ADD CONSTRAINT "SKEWED_COL_NAMES_PK" PRIMARY KEY ("SD_ID", "INTEGER_IDX"); No rows affected (0.012 seconds) 146/265 ALTER TABLE "APP"."SKEWED_COL_VALUE_LOC_MAP" ADD CONSTRAINT "SKEWED_COL_VALUE_LOC_MAP_PK" PRIMARY KEY ("SD_ID", "STRING_LIST_ID_KID"); No rows affected (0.013 seconds) 147/265 ALTER TABLE "APP"."SKEWED_VALUES" ADD CONSTRAINT "SKEWED_VALUES_PK" PRIMARY KEY ("SD_ID_OID", "INTEGER_IDX"); No rows affected (0.005 seconds) 148/265 ALTER TABLE "APP"."TAB_COL_STATS" ADD CONSTRAINT "TAB_COL_STATS_PK" PRIMARY KEY ("CS_ID"); No rows affected (0.014 seconds) 149/265 ALTER TABLE "APP"."PART_COL_STATS" ADD CONSTRAINT "PART_COL_STATS_PK" PRIMARY KEY ("CS_ID"); No rows affected (0.004 seconds) 150/265 ALTER TABLE "APP"."FUNCS" ADD CONSTRAINT "FUNCS_PK" PRIMARY KEY ("FUNC_ID"); No rows affected (0.004 seconds) 151/265 ALTER TABLE "APP"."FUNC_RU" ADD CONSTRAINT "FUNC_RU_PK" PRIMARY KEY ("FUNC_ID", "INTEGER_IDX"); No rows affected (0.002 seconds) 152/265 ALTER TABLE "APP"."NOTIFICATION_LOG" ADD CONSTRAINT "NOTIFICATION_LOG_PK" PRIMARY KEY ("NL_ID"); No rows affected (0.002 seconds) 153/265 ALTER TABLE "APP"."NOTIFICATION_SEQUENCE" ADD CONSTRAINT "NOTIFICATION_SEQUENCE_PK" PRIMARY KEY ("NNI_ID"); No rows affected (0.003 seconds) 154/265 ALTER TABLE "APP"."KEY_CONSTRAINTS" ADD CONSTRAINT "CONSTRAINTS_PK" PRIMARY KEY ("PARENT_TBL_ID", "CONSTRAINT_NAME", "POSITION"); No rows affected (0.003 seconds) 155/265 ALTER TABLE "APP"."METASTORE_DB_PROPERTIES" ADD CONSTRAINT "PROPERTY_KEY_PK" PRIMARY KEY ("PROPERTY_KEY"); No rows affected (0.003 seconds) 156/265 ALTER TABLE "APP"."MV_CREATION_METADATA" ADD CONSTRAINT "MV_CREATION_METADATA_PK" PRIMARY KEY ("MV_CREATION_METADATA_ID"); No rows affected (0.002 seconds) 157/265 ALTER TABLE "APP"."CTLGS" ADD CONSTRAINT "CTLG_PK" PRIMARY KEY ("CTLG_ID"); No rows affected (0.002 seconds) 158/265 -- foreign 159/265 ALTER TABLE "APP"."IDXS" ADD CONSTRAINT "IDXS_FK1" FOREIGN KEY ("ORIG_TBL_ID") REFERENCES "APP"."TBLS" ("TBL_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.012 seconds) 160/265 ALTER TABLE "APP"."IDXS" ADD CONSTRAINT "IDXS_FK2" FOREIGN KEY ("SD_ID") REFERENCES "APP"."SDS" ("SD_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.007 seconds) 161/265 ALTER TABLE "APP"."IDXS" ADD CONSTRAINT "IDXS_FK3" FOREIGN KEY ("INDEX_TBL_ID") REFERENCES "APP"."TBLS" ("TBL_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.006 seconds) 162/265 ALTER TABLE "APP"."TBL_COL_PRIVS" ADD CONSTRAINT "TBL_COL_PRIVS_FK1" FOREIGN KEY ("TBL_ID") REFERENCES "APP"."TBLS" ("TBL_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.005 seconds) 163/265 ALTER TABLE "APP"."DB_PRIVS" ADD CONSTRAINT "DB_PRIVS_FK1" FOREIGN KEY ("DB_ID") REFERENCES "APP"."DBS" ("DB_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.005 seconds) 164/265 ALTER TABLE "APP"."INDEX_PARAMS" ADD CONSTRAINT "INDEX_PARAMS_FK1" FOREIGN KEY ("INDEX_ID") REFERENCES "APP"."IDXS" ("INDEX_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.008 seconds) 165/265 ALTER TABLE "APP"."PARTITION_KEYS" ADD CONSTRAINT "PARTITION_KEYS_FK1" FOREIGN KEY ("TBL_ID") REFERENCES "APP"."TBLS" ("TBL_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.008 seconds) 166/265 ALTER TABLE "APP"."PART_PRIVS" ADD CONSTRAINT "PART_PRIVS_FK1" FOREIGN KEY ("PART_ID") REFERENCES "APP"."PARTITIONS" ("PART_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.008 seconds) 167/265 ALTER TABLE "APP"."SDS" ADD CONSTRAINT "SDS_FK1" FOREIGN KEY ("SERDE_ID") REFERENCES "APP"."SERDES" ("SERDE_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.014 seconds) 168/265 ALTER TABLE "APP"."SDS" ADD CONSTRAINT "SDS_FK2" FOREIGN KEY ("CD_ID") REFERENCES "APP"."CDS" ("CD_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.008 seconds) 169/265 ALTER TABLE "APP"."COLUMNS" ADD CONSTRAINT "COLUMNS_FK1" FOREIGN KEY ("SD_ID") REFERENCES "APP"."SDS" ("SD_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.006 seconds) 170/265 ALTER TABLE "APP"."TYPE_FIELDS" ADD CONSTRAINT "TYPE_FIELDS_FK1" FOREIGN KEY ("TYPE_NAME") REFERENCES "APP"."TYPES" ("TYPES_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.005 seconds) 171/265 ALTER TABLE "APP"."TBL_PRIVS" ADD CONSTRAINT "TBL_PRIVS_FK1" FOREIGN KEY ("TBL_ID") REFERENCES "APP"."TBLS" ("TBL_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.005 seconds) 172/265 ALTER TABLE "APP"."SERDE_PARAMS" ADD CONSTRAINT "SERDE_PARAMS_FK1" FOREIGN KEY ("SERDE_ID") REFERENCES "APP"."SERDES" ("SERDE_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.004 seconds) 173/265 ALTER TABLE "APP"."TBLS" ADD CONSTRAINT "TBLS_FK2" FOREIGN KEY ("SD_ID") REFERENCES "APP"."SDS" ("SD_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.006 seconds) 174/265 ALTER TABLE "APP"."TBLS" ADD CONSTRAINT "TBLS_FK1" FOREIGN KEY ("DB_ID") REFERENCES "APP"."DBS" ("DB_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.006 seconds) 175/265 ALTER TABLE "APP"."DBS" ADD CONSTRAINT "DBS_FK1" FOREIGN KEY ("CTLG_NAME") REFERENCES "APP"."CTLGS" ("NAME") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.007 seconds) 176/265 ALTER TABLE "APP"."SD_PARAMS" ADD CONSTRAINT "SD_PARAMS_FK1" FOREIGN KEY ("SD_ID") REFERENCES "APP"."SDS" ("SD_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.004 seconds) 177/265 ALTER TABLE "APP"."DATABASE_PARAMS" ADD CONSTRAINT "DATABASE_PARAMS_FK1" FOREIGN KEY ("DB_ID") REFERENCES "APP"."DBS" ("DB_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.005 seconds) 178/265 ALTER TABLE "APP"."ROLE_MAP" ADD CONSTRAINT "ROLE_MAP_FK1" FOREIGN KEY ("ROLE_ID") REFERENCES "APP"."ROLES" ("ROLE_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.005 seconds) 179/265 ALTER TABLE "APP"."BUCKETING_COLS" ADD CONSTRAINT "BUCKETING_COLS_FK1" FOREIGN KEY ("SD_ID") REFERENCES "APP"."SDS" ("SD_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.005 seconds) 180/265 ALTER TABLE "APP"."SORT_COLS" ADD CONSTRAINT "SORT_COLS_FK1" FOREIGN KEY ("SD_ID") REFERENCES "APP"."SDS" ("SD_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.006 seconds) 181/265 ALTER TABLE "APP"."PARTITION_KEY_VALS" ADD CONSTRAINT "PARTITION_KEY_VALS_FK1" FOREIGN KEY ("PART_ID") REFERENCES "APP"."PARTITIONS" ("PART_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.005 seconds) 182/265 ALTER TABLE "APP"."COLUMNS_V2" ADD CONSTRAINT "COLUMNS_V2_FK1" FOREIGN KEY ("CD_ID") REFERENCES "APP"."CDS" ("CD_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.006 seconds) 183/265 ALTER TABLE "APP"."PART_COL_PRIVS" ADD CONSTRAINT "PART_COL_PRIVS_FK1" FOREIGN KEY ("PART_ID") REFERENCES "APP"."PARTITIONS" ("PART_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.005 seconds) 184/265 ALTER TABLE "APP"."PARTITION_PARAMS" ADD CONSTRAINT "PARTITION_PARAMS_FK1" FOREIGN KEY ("PART_ID") REFERENCES "APP"."PARTITIONS" ("PART_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.004 seconds) 185/265 ALTER TABLE "APP"."PARTITIONS" ADD CONSTRAINT "PARTITIONS_FK1" FOREIGN KEY ("TBL_ID") REFERENCES "APP"."TBLS" ("TBL_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.007 seconds) 186/265 ALTER TABLE "APP"."PARTITIONS" ADD CONSTRAINT "PARTITIONS_FK2" FOREIGN KEY ("SD_ID") REFERENCES "APP"."SDS" ("SD_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.007 seconds) 187/265 ALTER TABLE "APP"."TABLE_PARAMS" ADD CONSTRAINT "TABLE_PARAMS_FK1" FOREIGN KEY ("TBL_ID") REFERENCES "APP"."TBLS" ("TBL_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.005 seconds) 188/265 ALTER TABLE "APP"."SKEWED_STRING_LIST_VALUES" ADD CONSTRAINT "SKEWED_STRING_LIST_VALUES_FK1" FOREIGN KEY ("STRING_LIST_ID") REFERENCES "APP"."SKEWED_STRING_LIST" ("STRING_LIST_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.004 seconds) 189/265 ALTER TABLE "APP"."SKEWED_COL_NAMES" ADD CONSTRAINT "SKEWED_COL_NAMES_FK1" FOREIGN KEY ("SD_ID") REFERENCES "APP"."SDS" ("SD_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.005 seconds) 190/265 ALTER TABLE "APP"."SKEWED_COL_VALUE_LOC_MAP" ADD CONSTRAINT "SKEWED_COL_VALUE_LOC_MAP_FK1" FOREIGN KEY ("SD_ID") REFERENCES "APP"."SDS" ("SD_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.004 seconds) 191/265 ALTER TABLE "APP"."SKEWED_COL_VALUE_LOC_MAP" ADD CONSTRAINT "SKEWED_COL_VALUE_LOC_MAP_FK2" FOREIGN KEY ("STRING_LIST_ID_KID") REFERENCES "APP"."SKEWED_STRING_LIST" ("STRING_LIST_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.005 seconds) 192/265 ALTER TABLE "APP"."SKEWED_VALUES" ADD CONSTRAINT "SKEWED_VALUES_FK1" FOREIGN KEY ("SD_ID_OID") REFERENCES "APP"."SDS" ("SD_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.005 seconds) 193/265 ALTER TABLE "APP"."SKEWED_VALUES" ADD CONSTRAINT "SKEWED_VALUES_FK2" FOREIGN KEY ("STRING_LIST_ID_EID") REFERENCES "APP"."SKEWED_STRING_LIST" ("STRING_LIST_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.004 seconds) 194/265 ALTER TABLE "APP"."TAB_COL_STATS" ADD CONSTRAINT "TAB_COL_STATS_FK" FOREIGN KEY ("TBL_ID") REFERENCES TBLS("TBL_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.006 seconds) 195/265 ALTER TABLE "APP"."PART_COL_STATS" ADD CONSTRAINT "PART_COL_STATS_FK" FOREIGN KEY ("PART_ID") REFERENCES PARTITIONS("PART_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.007 seconds) 196/265 ALTER TABLE "APP"."VERSION" ADD CONSTRAINT "VERSION_PK" PRIMARY KEY ("VER_ID"); No rows affected (0.003 seconds) 197/265 ALTER TABLE "APP"."FUNCS" ADD CONSTRAINT "FUNCS_FK1" FOREIGN KEY ("DB_ID") REFERENCES "APP"."DBS" ("DB_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.002 seconds) 198/265 ALTER TABLE "APP"."FUNC_RU" ADD CONSTRAINT "FUNC_RU_FK1" FOREIGN KEY ("FUNC_ID") REFERENCES "APP"."FUNCS" ("FUNC_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.004 seconds) 199/265 ALTER TABLE "APP"."WM_RESOURCEPLAN" ADD CONSTRAINT "WM_RESOURCEPLAN_PK" PRIMARY KEY ("RP_ID"); No rows affected (0.004 seconds) 200/265 ALTER TABLE "APP"."WM_POOL" ADD CONSTRAINT "WM_POOL_PK" PRIMARY KEY ("POOL_ID"); No rows affected (0.002 seconds) 201/265 ALTER TABLE "APP"."WM_POOL" ADD CONSTRAINT "WM_POOL_FK1" FOREIGN KEY ("RP_ID") REFERENCES "APP"."WM_RESOURCEPLAN" ("RP_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.01 seconds) 202/265 ALTER TABLE "APP"."WM_RESOURCEPLAN" ADD CONSTRAINT "WM_RESOURCEPLAN_FK1" FOREIGN KEY ("DEFAULT_POOL_ID") REFERENCES "APP"."WM_POOL" ("POOL_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.004 seconds) 203/265 ALTER TABLE "APP"."WM_TRIGGER" ADD CONSTRAINT "WM_TRIGGER_PK" PRIMARY KEY ("TRIGGER_ID"); No rows affected (0.002 seconds) 204/265 ALTER TABLE "APP"."WM_TRIGGER" ADD CONSTRAINT "WM_TRIGGER_FK1" FOREIGN KEY ("RP_ID") REFERENCES "APP"."WM_RESOURCEPLAN" ("RP_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.006 seconds) 205/265 ALTER TABLE "APP"."WM_POOL_TO_TRIGGER" ADD CONSTRAINT "WM_POOL_TO_TRIGGER_FK1" FOREIGN KEY ("POOL_ID") REFERENCES "APP"."WM_POOL" ("POOL_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.004 seconds) 206/265 ALTER TABLE "APP"."WM_POOL_TO_TRIGGER" ADD CONSTRAINT "WM_POOL_TO_TRIGGER_FK2" FOREIGN KEY ("TRIGGER_ID") REFERENCES "APP"."WM_TRIGGER" ("TRIGGER_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.005 seconds) 207/265 ALTER TABLE "APP"."WM_MAPPING" ADD CONSTRAINT "WM_MAPPING_PK" PRIMARY KEY ("MAPPING_ID"); No rows affected (0.003 seconds) 208/265 ALTER TABLE "APP"."WM_MAPPING" ADD CONSTRAINT "WM_MAPPING_FK1" FOREIGN KEY ("RP_ID") REFERENCES "APP"."WM_RESOURCEPLAN" ("RP_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.005 seconds) 209/265 ALTER TABLE "APP"."WM_MAPPING" ADD CONSTRAINT "WM_MAPPING_FK2" FOREIGN KEY ("POOL_ID") REFERENCES "APP"."WM_POOL" ("POOL_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.005 seconds) 210/265 ALTER TABLE "APP"."MV_TABLES_USED" ADD CONSTRAINT "MV_TABLES_USED_FK1" FOREIGN KEY ("MV_CREATION_METADATA_ID") REFERENCES "APP"."MV_CREATION_METADATA" ("MV_CREATION_METADATA_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.004 seconds) 211/265 ALTER TABLE "APP"."MV_TABLES_USED" ADD CONSTRAINT "MV_TABLES_USED_FK2" FOREIGN KEY ("TBL_ID") REFERENCES "APP"."TBLS" ("TBL_ID") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.006 seconds) 212/265 ALTER TABLE "APP"."DBS" ADD CONSTRAINT "DBS_CTLG_FK" FOREIGN KEY ("CTLG_NAME") REFERENCES "APP"."CTLGS" ("NAME") ON DELETE NO ACTION ON UPDATE NO ACTION; No rows affected (0.004 seconds) 213/265 -- ---------------------------------------------- 214/265 -- DDL Statements for checks 215/265 -- ---------------------------------------------- 216/265 ALTER TABLE "APP"."IDXS" ADD CONSTRAINT "SQL110318025504980" CHECK (DEFERRED_REBUILD IN ('Y','N')); No rows affected (0.006 seconds) 217/265 ALTER TABLE "APP"."SDS" ADD CONSTRAINT "SQL110318025505550" CHECK (IS_COMPRESSED IN ('Y','N')); No rows affected (0.002 seconds) 218/265 -- ---------------------------- 219/265 -- Transaction and Lock Tables 220/265 -- ---------------------------- 221/265 CREATE TABLE TXNS ( TXN_ID bigint PRIMARY KEY, TXN_STATE char(1) NOT NULL, TXN_STARTED bigint NOT NULL, TXN_LAST_HEARTBEAT bigint NOT NULL, TXN_USER varchar(128) NOT NULL, TXN_HOST varchar(128) NOT NULL, TXN_AGENT_INFO varchar(128), TXN_META_INFO varchar(128), TXN_HEARTBEAT_COUNT integer, TXN_TYPE integer ); No rows affected (0.005 seconds) 222/265 CREATE TABLE TXN_COMPONENTS ( TC_TXNID bigint NOT NULL REFERENCES TXNS (TXN_ID), TC_DATABASE varchar(128) NOT NULL, TC_TABLE varchar(128), TC_PARTITION varchar(767), TC_OPERATION_TYPE char(1) NOT NULL, TC_WRITEID bigint ); No rows affected (0.007 seconds) 223/265 CREATE INDEX TC_TXNID_INDEX ON TXN_COMPONENTS (TC_TXNID); Warning: 'TC_TXNID_INDEX' index not created because it is a duplicate of an existing index: 'SQL200420034348951'. (state=01504,code=10000) java.sql.SQLWarning: 'TC_TXNID_INDEX' index not created because it is a duplicate of an existing index: 'SQL200420034348951'. at org.apache.derby.iapi.error.StandardException.newWarning(Unknown Source) at org.apache.derby.impl.sql.execute.CreateIndexConstantAction.executeConstantAction(Unknown Source) at org.apache.derby.impl.sql.execute.MiscResultSet.open(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) at sqlline.Commands.executeSingleQuery(Commands.java:1054) at sqlline.Commands.execute(Commands.java:1003) at sqlline.Commands.sql(Commands.java:967) at sqlline.SqlLine.dispatch(SqlLine.java:734) at sqlline.SqlLine.runCommands(SqlLine.java:1736) at sqlline.Commands.run(Commands.java:1593) 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 sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38) at sqlline.SqlLine.dispatch(SqlLine.java:730) at sqlline.SqlLine.initArgs(SqlLine.java:459) at sqlline.SqlLine.begin(SqlLine.java:515) at org.apache.hadoop.hive.metastore.tools.schematool.MetastoreSchemaTool.execSql(MetastoreSchemaTool.java:324) at org.apache.hadoop.hive.metastore.tools.schematool.MetastoreSchemaTool.execSql(MetastoreSchemaTool.java:301) at org.apache.hadoop.hive.metastore.tools.schematool.SchemaToolTaskInit.execute(SchemaToolTaskInit.java:62) at org.apache.hadoop.hive.metastore.tools.schematool.MetastoreSchemaTool.run(MetastoreSchemaTool.java:463) at org.apache.hadoop.hive.metastore.tools.schematool.MetastoreSchemaTool.run(MetastoreSchemaTool.java:423) at org.apache.hadoop.hive.metastore.dbinstall.rules.DatabaseRule.installLatest(DatabaseRule.java:240) at org.apache.hadoop.hive.metastore.dbinstall.rules.DatabaseRule.install(DatabaseRule.java:290) at org.apache.hadoop.hive.cli.control.CliAdapter$1$1.evaluate(CliAdapter.java:84) at org.junit.rules.RunRules.evaluate(RunRules.java:20) at org.junit.runners.ParentRunner.run(ParentRunner.java:309) at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365) at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159) at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:379) at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:340) at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:125) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:413) No rows affected (0.008 seconds) 224/265 CREATE TABLE COMPLETED_TXN_COMPONENTS ( CTC_TXNID bigint NOT NULL, CTC_DATABASE varchar(128) NOT NULL, CTC_TABLE varchar(256), CTC_PARTITION varchar(767), CTC_TIMESTAMP timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL, CTC_WRITEID bigint, CTC_UPDATE_DELETE char(1) NOT NULL ); No rows affected (0.003 seconds) 225/265 CREATE INDEX COMPLETED_TXN_COMPONENTS_IDX ON COMPLETED_TXN_COMPONENTS (CTC_DATABASE, CTC_TABLE, CTC_PARTITION); No rows affected (0.002 seconds) 226/265 CREATE TABLE NEXT_TXN_ID ( NTXN_NEXT bigint NOT NULL ); No rows affected (0.002 seconds) 227/265 INSERT INTO NEXT_TXN_ID VALUES(1); 1 row affected (0.004 seconds) 228/265 CREATE TABLE HIVE_LOCKS ( HL_LOCK_EXT_ID bigint NOT NULL, HL_LOCK_INT_ID bigint NOT NULL, HL_TXNID bigint NOT NULL, HL_DB varchar(128) NOT NULL, HL_TABLE varchar(128), HL_PARTITION varchar(767), HL_LOCK_STATE char(1) NOT NULL, HL_LOCK_TYPE char(1) NOT NULL, HL_LAST_HEARTBEAT bigint NOT NULL, HL_ACQUIRED_AT bigint, HL_USER varchar(128) NOT NULL, HL_HOST varchar(128) NOT NULL, HL_HEARTBEAT_COUNT integer, HL_AGENT_INFO varchar(128), HL_BLOCKEDBY_EXT_ID bigint, HL_BLOCKEDBY_INT_ID bigint, PRIMARY KEY(HL_LOCK_EXT_ID, HL_LOCK_INT_ID) ); No rows affected (0.005 seconds) 229/265 CREATE INDEX HL_TXNID_INDEX ON HIVE_LOCKS (HL_TXNID); No rows affected (0.003 seconds) 230/265 CREATE TABLE NEXT_LOCK_ID ( NL_NEXT bigint NOT NULL ); No rows affected (0.002 seconds) 231/265 INSERT INTO NEXT_LOCK_ID VALUES(1); 1 row affected (0.004 seconds) 232/265 CREATE TABLE COMPACTION_QUEUE ( CQ_ID bigint PRIMARY KEY, CQ_DATABASE varchar(128) NOT NULL, CQ_TABLE varchar(128) NOT NULL, CQ_PARTITION varchar(767), CQ_STATE char(1) NOT NULL, CQ_TYPE char(1) NOT NULL, CQ_TBLPROPERTIES varchar(2048), CQ_WORKER_ID varchar(128), CQ_START bigint, CQ_RUN_AS varchar(128), CQ_HIGHEST_WRITE_ID bigint, CQ_META_INFO varchar(2048) for bit data, CQ_HADOOP_JOB_ID varchar(32), CQ_ERROR_MESSAGE clob, CQ_NEXT_TXN_ID bigint ); No rows affected (0.009 seconds) 233/265 CREATE TABLE NEXT_COMPACTION_QUEUE_ID ( NCQ_NEXT bigint NOT NULL ); No rows affected (0.002 seconds) 234/265 INSERT INTO NEXT_COMPACTION_QUEUE_ID VALUES(1); 1 row affected (0.004 seconds) 235/265 CREATE TABLE COMPLETED_COMPACTIONS ( CC_ID bigint PRIMARY KEY, CC_DATABASE varchar(128) NOT NULL, CC_TABLE varchar(128) NOT NULL, CC_PARTITION varchar(767), CC_STATE char(1) NOT NULL, CC_TYPE char(1) NOT NULL, CC_TBLPROPERTIES varchar(2048), CC_WORKER_ID varchar(128), CC_START bigint, CC_END bigint, CC_RUN_AS varchar(128), CC_HIGHEST_WRITE_ID bigint, CC_META_INFO varchar(2048) for bit data, CC_HADOOP_JOB_ID varchar(32), CC_ERROR_MESSAGE clob ); No rows affected (0.005 seconds) 236/265 CREATE INDEX COMPLETED_COMPACTIONS_RES ON COMPLETED_COMPACTIONS (CC_DATABASE,CC_TABLE,CC_PARTITION); No rows affected (0.002 seconds) 237/265 CREATE TABLE AUX_TABLE ( MT_KEY1 varchar(128) NOT NULL, MT_KEY2 bigint NOT NULL, MT_COMMENT varchar(255), PRIMARY KEY(MT_KEY1, MT_KEY2) ); No rows affected (0.003 seconds) 238/265 --1st 4 cols make up a PK but since WS_PARTITION is nullable we can't declare such PK 239/265 --This is a good candidate for Index orgainzed table 240/265 CREATE TABLE WRITE_SET ( WS_DATABASE varchar(128) NOT NULL, WS_TABLE varchar(128) NOT NULL, WS_PARTITION varchar(767), WS_TXNID bigint NOT NULL, WS_COMMIT_ID bigint NOT NULL, WS_OPERATION_TYPE char(1) NOT NULL ); No rows affected (0.001 seconds) 241/265 CREATE TABLE TXN_TO_WRITE_ID ( T2W_TXNID bigint NOT NULL, T2W_DATABASE varchar(128) NOT NULL, T2W_TABLE varchar(256) NOT NULL, T2W_WRITEID bigint NOT NULL ); No rows affected (0.001 seconds) 242/265 CREATE UNIQUE INDEX TBL_TO_TXN_ID_IDX ON TXN_TO_WRITE_ID (T2W_DATABASE, T2W_TABLE, T2W_TXNID); No rows affected (0.002 seconds) 243/265 CREATE UNIQUE INDEX TBL_TO_WRITE_ID_IDX ON TXN_TO_WRITE_ID (T2W_DATABASE, T2W_TABLE, T2W_WRITEID); No rows affected (0.002 seconds) 244/265 CREATE TABLE NEXT_WRITE_ID ( NWI_DATABASE varchar(128) NOT NULL, NWI_TABLE varchar(256) NOT NULL, NWI_NEXT bigint NOT NULL ); No rows affected (0.002 seconds) 245/265 CREATE UNIQUE INDEX NEXT_WRITE_ID_IDX ON NEXT_WRITE_ID (NWI_DATABASE, NWI_TABLE); No rows affected (0.002 seconds) 246/265 CREATE TABLE MATERIALIZATION_REBUILD_LOCKS ( MRL_TXN_ID BIGINT NOT NULL, MRL_DB_NAME VARCHAR(128) NOT NULL, MRL_TBL_NAME VARCHAR(256) NOT NULL, MRL_LAST_HEARTBEAT BIGINT NOT NULL, PRIMARY KEY(MRL_TXN_ID) ); No rows affected (0.002 seconds) 247/265 CREATE TABLE "APP"."I_SCHEMA" ( "SCHEMA_ID" bigint primary key, "SCHEMA_TYPE" integer not null, "NAME" varchar(256) unique, "DB_ID" bigint references "APP"."DBS" ("DB_ID"), "COMPATIBILITY" integer not null, "VALIDATION_LEVEL" integer not null, "CAN_EVOLVE" char(1) not null, "SCHEMA_GROUP" varchar(256), "DESCRIPTION" varchar(4000) ); No rows affected (0.008 seconds) 248/265 CREATE TABLE "APP"."SCHEMA_VERSION" ( "SCHEMA_VERSION_ID" bigint primary key, "SCHEMA_ID" bigint references "APP"."I_SCHEMA" ("SCHEMA_ID"), "VERSION" integer not null, "CREATED_AT" bigint not null, "CD_ID" bigint references "APP"."CDS" ("CD_ID"), "STATE" integer not null, "DESCRIPTION" varchar(4000), "SCHEMA_TEXT" clob, "FINGERPRINT" varchar(256), "SCHEMA_VERSION_NAME" varchar(256), "SERDE_ID" bigint references "APP"."SERDES" ("SERDE_ID") ); No rows affected (0.014 seconds) 249/265 CREATE UNIQUE INDEX "APP"."UNIQUE_SCHEMA_VERSION" ON "APP"."SCHEMA_VERSION" ("SCHEMA_ID", "VERSION"); No rows affected (0.002 seconds) 250/265 CREATE TABLE REPL_TXN_MAP ( RTM_REPL_POLICY varchar(256) NOT NULL, RTM_SRC_TXN_ID bigint NOT NULL, RTM_TARGET_TXN_ID bigint NOT NULL, PRIMARY KEY (RTM_REPL_POLICY, RTM_SRC_TXN_ID) ); No rows affected (0.003 seconds) 251/265 CREATE TABLE "APP"."RUNTIME_STATS" ( "RS_ID" bigint primary key, "CREATE_TIME" integer not null, "WEIGHT" integer not null, "PAYLOAD" BLOB ); No rows affected (0.003 seconds) 252/265 CREATE INDEX IDX_RUNTIME_STATS_CREATE_TIME ON RUNTIME_STATS(CREATE_TIME); No rows affected (0.003 seconds) 253/265 CREATE TABLE TXN_WRITE_NOTIFICATION_LOG ( WNL_ID bigint NOT NULL, WNL_TXNID bigint NOT NULL, WNL_WRITEID bigint NOT NULL, WNL_DATABASE varchar(128) NOT NULL, WNL_TABLE varchar(128) NOT NULL, WNL_PARTITION varchar(767) NOT NULL, WNL_TABLE_OBJ clob NOT NULL, WNL_PARTITION_OBJ clob, WNL_FILES clob, WNL_EVENT_TIME integer NOT NULL, PRIMARY KEY (WNL_TXNID, WNL_DATABASE, WNL_TABLE, WNL_PARTITION) ); No rows affected (0.004 seconds) 254/265 INSERT INTO SEQUENCE_TABLE (SEQUENCE_NAME, NEXT_VAL) VALUES ('org.apache.hadoop.hive.metastore.model.MTxnWriteNotificationLog', 1); 1 row affected (0.004 seconds) 255/265 CREATE TABLE "APP"."SCHEDULED_QUERIES" ( "SCHEDULED_QUERY_ID" bigint primary key not null, "SCHEDULE_NAME" varchar(256) not null, "ENABLED" CHAR(1) NOT NULL DEFAULT 'N', "CLUSTER_NAMESPACE" varchar(256) not null, "USER" varchar(128) not null, "SCHEDULE" varchar(256) not null, "QUERY" varchar(4000) not null, "NEXT_EXECUTION" integer not null, "ACTIVE_EXECUTION_ID" bigint ); No rows affected (0.004 seconds) 256/265 CREATE INDEX NEXTEXECUTIONINDEX ON APP.SCHEDULED_QUERIES (ENABLED,CLUSTER_NAMESPACE,NEXT_EXECUTION); No rows affected (0.002 seconds) 257/265 CREATE UNIQUE INDEX UNIQUE_SCHEDULED_QUERIES_NAME ON APP.SCHEDULED_QUERIES (SCHEDULE_NAME,CLUSTER_NAMESPACE); No rows affected (0.002 seconds) 258/265 CREATE TABLE APP.SCHEDULED_EXECUTIONS ( SCHEDULED_EXECUTION_ID bigint primary key not null, EXECUTOR_QUERY_ID VARCHAR(256), SCHEDULED_QUERY_ID bigint not null, START_TIME integer not null, END_TIME INTEGER, LAST_UPDATE_TIME INTEGER, ERROR_MESSAGE VARCHAR(2000), STATE VARCHAR(256), CONSTRAINT SCHEDULED_EXECUTIONS_SCHQ_FK FOREIGN KEY (SCHEDULED_QUERY_ID) REFERENCES APP.SCHEDULED_QUERIES(SCHEDULED_QUERY_ID) ON DELETE CASCADE ); No rows affected (0.006 seconds) 259/265 CREATE INDEX LASTUPDATETIMEINDEX ON APP.SCHEDULED_EXECUTIONS (LAST_UPDATE_TIME); No rows affected (0.002 seconds) 260/265 CREATE INDEX SCHEDULED_EXECUTIONS_SCHQID ON APP.SCHEDULED_EXECUTIONS (SCHEDULED_QUERY_ID); Warning: 'SCHEDULED_EXECUTIONS_SCHQID' index not created because it is a duplicate of an existing index: 'SQL200420034349101'. (state=01504,code=10000) java.sql.SQLWarning: 'SCHEDULED_EXECUTIONS_SCHQID' index not created because it is a duplicate of an existing index: 'SQL200420034349101'. at org.apache.derby.iapi.error.StandardException.newWarning(Unknown Source) at org.apache.derby.impl.sql.execute.CreateIndexConstantAction.executeConstantAction(Unknown Source) at org.apache.derby.impl.sql.execute.MiscResultSet.open(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) at sqlline.Commands.executeSingleQuery(Commands.java:1054) at sqlline.Commands.execute(Commands.java:1003) at sqlline.Commands.sql(Commands.java:967) at sqlline.SqlLine.dispatch(SqlLine.java:734) at sqlline.SqlLine.runCommands(SqlLine.java:1736) at sqlline.Commands.run(Commands.java:1593) 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 sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38) at sqlline.SqlLine.dispatch(SqlLine.java:730) at sqlline.SqlLine.initArgs(SqlLine.java:459) at sqlline.SqlLine.begin(SqlLine.java:515) at org.apache.hadoop.hive.metastore.tools.schematool.MetastoreSchemaTool.execSql(MetastoreSchemaTool.java:324) at org.apache.hadoop.hive.metastore.tools.schematool.MetastoreSchemaTool.execSql(MetastoreSchemaTool.java:301) at org.apache.hadoop.hive.metastore.tools.schematool.SchemaToolTaskInit.execute(SchemaToolTaskInit.java:62) at org.apache.hadoop.hive.metastore.tools.schematool.MetastoreSchemaTool.run(MetastoreSchemaTool.java:463) at org.apache.hadoop.hive.metastore.tools.schematool.MetastoreSchemaTool.run(MetastoreSchemaTool.java:423) at org.apache.hadoop.hive.metastore.dbinstall.rules.DatabaseRule.installLatest(DatabaseRule.java:240) at org.apache.hadoop.hive.metastore.dbinstall.rules.DatabaseRule.install(DatabaseRule.java:290) at org.apache.hadoop.hive.cli.control.CliAdapter$1$1.evaluate(CliAdapter.java:84) at org.junit.rules.RunRules.evaluate(RunRules.java:20) at org.junit.runners.ParentRunner.run(ParentRunner.java:309) at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365) at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159) at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:379) at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:340) at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:125) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:413) No rows affected (0.003 seconds) 261/265 CREATE UNIQUE INDEX SCHEDULED_EXECUTIONS_UNIQUE_ID ON APP.SCHEDULED_EXECUTIONS (SCHEDULED_EXECUTION_ID); Warning: 'SCHEDULED_EXECUTIONS_UNIQUE_ID' index not created because it is a duplicate of an existing index: 'SQL200420034349100'. (state=01504,code=10000) java.sql.SQLWarning: 'SCHEDULED_EXECUTIONS_UNIQUE_ID' index not created because it is a duplicate of an existing index: 'SQL200420034349100'. at org.apache.derby.iapi.error.StandardException.newWarning(Unknown Source) at org.apache.derby.impl.sql.execute.CreateIndexConstantAction.executeConstantAction(Unknown Source) at org.apache.derby.impl.sql.execute.MiscResultSet.open(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) at sqlline.Commands.executeSingleQuery(Commands.java:1054) at sqlline.Commands.execute(Commands.java:1003) at sqlline.Commands.sql(Commands.java:967) at sqlline.SqlLine.dispatch(SqlLine.java:734) at sqlline.SqlLine.runCommands(SqlLine.java:1736) at sqlline.Commands.run(Commands.java:1593) 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 sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38) at sqlline.SqlLine.dispatch(SqlLine.java:730) at sqlline.SqlLine.initArgs(SqlLine.java:459) at sqlline.SqlLine.begin(SqlLine.java:515) at org.apache.hadoop.hive.metastore.tools.schematool.MetastoreSchemaTool.execSql(MetastoreSchemaTool.java:324) at org.apache.hadoop.hive.metastore.tools.schematool.MetastoreSchemaTool.execSql(MetastoreSchemaTool.java:301) at org.apache.hadoop.hive.metastore.tools.schematool.SchemaToolTaskInit.execute(SchemaToolTaskInit.java:62) at org.apache.hadoop.hive.metastore.tools.schematool.MetastoreSchemaTool.run(MetastoreSchemaTool.java:463) at org.apache.hadoop.hive.metastore.tools.schematool.MetastoreSchemaTool.run(MetastoreSchemaTool.java:423) at org.apache.hadoop.hive.metastore.dbinstall.rules.DatabaseRule.installLatest(DatabaseRule.java:240) at org.apache.hadoop.hive.metastore.dbinstall.rules.DatabaseRule.install(DatabaseRule.java:290) at org.apache.hadoop.hive.cli.control.CliAdapter$1$1.evaluate(CliAdapter.java:84) at org.junit.rules.RunRules.evaluate(RunRules.java:20) at org.junit.runners.ParentRunner.run(ParentRunner.java:309) at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365) at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159) at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:379) at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:340) at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:125) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:413) No rows affected (0.003 seconds) 262/265 -- ----------------------------------------------------------------- 263/265 -- Record schema version. Should be the last step in the init script 264/265 -- ----------------------------------------------------------------- 265/265 INSERT INTO "APP"."VERSION" (VER_ID, SCHEMA_VERSION, VERSION_COMMENT) VALUES (1, '4.0.0', 'Hive release version 4.0.0'); 1 row affected (0.003 seconds) sqlline version 1.9.0 Hive Session ID = d4d863fc-4561-4f4c-9ab1-f5cf36a0e530 ivysettings.xml file not found in HIVE_HOME or HIVE_CONF_DIR,/home/hiveptest/35.238.102.117-hiveptest-1/apache-github-source-source/conf/ivysettings.xml will be used Hive Session ID = f45d9ddb-3993-4887-867a-053d213d4063 ivysettings.xml file not found in HIVE_HOME or HIVE_CONF_DIR,/home/hiveptest/35.238.102.117-hiveptest-1/apache-github-source-source/conf/ivysettings.xml will be used Begin query: temp_table_multi_insert_partitioned.q 2020-04-20 03:44:05 Running Dag: dag_1587379439418_0001_1 2020-04-20 03:44:06 Completed running task attempt: attempt_1587379439418_0001_1_00_000000_0 2020-04-20 03:44:06 Completed Dag: dag_1587379439418_0001_1 2020-04-20 03:44:07 Running Dag: dag_1587379439418_0001_2 2020-04-20 03:44:07 Completed running task attempt: attempt_1587379439418_0001_2_00_000000_0 2020-04-20 03:44:08 Completed running task attempt: attempt_1587379439418_0001_2_01_000000_0 2020-04-20 03:44:08 Completed Dag: dag_1587379439418_0001_2 2020-04-20 03:44:11 Running Dag: dag_1587379439418_0001_3 2020-04-20 03:44:11 Completed running task attempt: attempt_1587379439418_0001_3_00_000000_0 2020-04-20 03:44:11 Completed running task attempt: attempt_1587379439418_0001_3_01_000001_0 2020-04-20 03:44:11 Completed running task attempt: attempt_1587379439418_0001_3_01_000000_0 2020-04-20 03:44:12 Completed running task attempt: attempt_1587379439418_0001_3_02_000000_0 2020-04-20 03:44:12 Completed Dag: dag_1587379439418_0001_3 2020-04-20 03:44:12 Running Dag: dag_1587379439418_0001_4 2020-04-20 03:44:12 Completed running task attempt: attempt_1587379439418_0001_4_00_000000_0 2020-04-20 03:44:12 Completed running task attempt: attempt_1587379439418_0001_4_01_000001_0 2020-04-20 03:44:12 Completed running task attempt: attempt_1587379439418_0001_4_01_000000_0 ERROR StatusLogger Recursive call to appender DRFA ERROR StatusLogger Recursive call to appender DRFA 2020-04-20 03:44:12 Completed running task attempt: attempt_1587379439418_0001_4_02_000000_0 2020-04-20 03:44:12 Completed Dag: dag_1587379439418_0001_4 2020-04-20 03:44:13 Running Dag: dag_1587379439418_0001_5 2020-04-20 03:44:13 Completed running task attempt: attempt_1587379439418_0001_5_00_000000_0 2020-04-20 03:44:13 Completed running task attempt: attempt_1587379439418_0001_5_01_000001_0 ERROR StatusLogger Recursive call to appender DRFA ERROR StatusLogger Recursive call to appender DRFA 2020-04-20 03:44:13 Completed running task attempt: attempt_1587379439418_0001_5_01_000000_0 2020-04-20 03:44:13 Completed running task attempt: attempt_1587379439418_0001_5_02_000000_0 2020-04-20 03:44:13 Completed Dag: dag_1587379439418_0001_5 2020-04-20 03:44:13 Running Dag: dag_1587379439418_0001_6 2020-04-20 03:44:14 Completed running task attempt: attempt_1587379439418_0001_6_00_000000_0 2020-04-20 03:44:14 Completed Dag: dag_1587379439418_0001_6 2020-04-20 03:44:14 Running Dag: dag_1587379439418_0001_7 2020-04-20 03:44:14 Completed running task attempt: attempt_1587379439418_0001_7_00_000000_0 2020-04-20 03:44:14 Completed running task attempt: attempt_1587379439418_0001_7_01_000000_0 2020-04-20 03:44:14 Completed Dag: dag_1587379439418_0001_7 2020-04-20 03:44:14 Running Dag: dag_1587379439418_0001_8 2020-04-20 03:44:14 Completed running task attempt: attempt_1587379439418_0001_8_00_000000_0 2020-04-20 03:44:14 Completed Dag: dag_1587379439418_0001_8 2020-04-20 03:44:15 Running Dag: dag_1587379439418_0001_9 2020-04-20 03:44:15 Completed running task attempt: attempt_1587379439418_0001_9_00_000000_0 2020-04-20 03:44:15 Completed running task attempt: attempt_1587379439418_0001_9_01_000000_0 2020-04-20 03:44:15 Completed Dag: dag_1587379439418_0001_9 2020-04-20 03:44:15 Running Dag: dag_1587379439418_0001_10 2020-04-20 03:44:15 Completed running task attempt: attempt_1587379439418_0001_10_00_000000_0 2020-04-20 03:44:15 Completed Dag: dag_1587379439418_0001_10 2020-04-20 03:44:15 Running Dag: dag_1587379439418_0001_11 2020-04-20 03:44:16 Completed running task attempt: attempt_1587379439418_0001_11_00_000000_0 2020-04-20 03:44:16 Completed running task attempt: attempt_1587379439418_0001_11_01_000000_0 2020-04-20 03:44:16 Completed Dag: dag_1587379439418_0001_11 2020-04-20 03:44:16 Running Dag: dag_1587379439418_0001_12 2020-04-20 03:44:16 Completed running task attempt: attempt_1587379439418_0001_12_00_000000_0 2020-04-20 03:44:16 Completed Dag: dag_1587379439418_0001_12 2020-04-20 03:44:16 Running Dag: dag_1587379439418_0001_13 2020-04-20 03:44:16 Completed running task attempt: attempt_1587379439418_0001_13_00_000000_0 2020-04-20 03:44:16 Completed running task attempt: attempt_1587379439418_0001_13_01_000000_0 2020-04-20 03:44:16 Completed Dag: dag_1587379439418_0001_13 2020-04-20 03:44:16 Running Dag: dag_1587379439418_0001_14 2020-04-20 03:44:17 Completed running task attempt: attempt_1587379439418_0001_14_00_000000_0 2020-04-20 03:44:17 Completed Dag: dag_1587379439418_0001_14 2020-04-20 03:44:17 Running Dag: dag_1587379439418_0001_15 2020-04-20 03:44:17 Completed running task attempt: attempt_1587379439418_0001_15_00_000000_0 2020-04-20 03:44:17 Completed running task attempt: attempt_1587379439418_0001_15_01_000000_0 2020-04-20 03:44:17 Completed Dag: dag_1587379439418_0001_15 Done query temp_table_multi_insert_partitioned.q. succeeded=false, skipped=false. ElapsedTime(ms)=16664