SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/data0/jenkins/workspace/impala-cdpd-master-staging-exhaustive/Impala-Toolchain/cdp_components-6753238/apache-hive-3.1.3000.7.2.3.0-228-bin/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/data0/jenkins/workspace/impala-cdpd-master-staging-exhaustive/Impala-Toolchain/cdp_components-6753238/hadoop-3.1.1.7.2.3.0-228/share/hadoop/common/lib/slf4j-log4j12-1.7.30.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] ERROR StatusLogger No log4j2 configuration file found. Using default configuration: logging only errors to the console. Set system property 'log4j2.debug' to show Log4j2 internal initialization logging. SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/data0/jenkins/workspace/impala-cdpd-master-staging-exhaustive/Impala-Toolchain/cdp_components-6753238/apache-hive-3.1.3000.7.2.3.0-228-bin/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/data0/jenkins/workspace/impala-cdpd-master-staging-exhaustive/Impala-Toolchain/cdp_components-6753238/hadoop-3.1.1.7.2.3.0-228/share/hadoop/common/lib/slf4j-log4j12-1.7.30.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] !connect jdbc:hive2://localhost:11050/default;auth=none jenkins [passwd stripped] Connecting to jdbc:hive2://localhost:11050/default;auth=none Connected to: Apache Hive (version 3.1.3000.7.2.3.0-228) Driver: Hive JDBC (version 3.1.3000.7.2.3.0-228) Transaction isolation: TRANSACTION_REPEATABLE_READ 0: jdbc:hive2://localhost:11050/default> -- Used for positive/negative testing o f complex types on various file formats. 0: jdbc:hive2://localhost:11050/default> -- In particular, queries on file forma ts for which we do not support complex types 0: jdbc:hive2://localhost:11050/default> -- should fail gracefully. 0: jdbc:hive2://localhost:11050/default> CREATE TABLE IF NOT EXISTS functional_o rc_def.complextypes_fileformat ( . . . . . . . . . . . . . . . . . . . .> id int, . . . . . . . . . . . . . . . . . . . .> s struct, . . . . . . . . . . . . . . . . . . . .> a array, . . . . . . . . . . . . . . . . . . . .> m map) . . . . . . . . . . . . . . . . . . . .> STORED AS ORC; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135813_a7de73f9-fa2f-4e62-9dde-34b05d08593b): CREATE TABLE IF NOT EXISTS functional_orc_def.complextypes_fileformat ( id int, s struct, a array, m map) STORED AS ORC INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:null, properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135813_a7de73f9-fa2f-4e62-9dde-34b05d08593b); Time taken: 0.014 seconds INFO : Executing command(queryId=jenkins_20201113135813_a7de73f9-fa2f-4e62-9dde-34b05d08593b): CREATE TABLE IF NOT EXISTS functional_orc_def.complextypes_fileformat ( id int, s struct, a array, m map) STORED AS ORC INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=jenkins_20201113135813_a7de73f9-fa2f-4e62-9dde-34b05d08593b); Time taken: 0.023 seconds INFO : OK No rows affected (0.1 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> CREATE EXTERNAL TABLE IF NOT EXISTS fun ctional_orc_def.nullformat_custom ( . . . . . . . . . . . . . . . . . . . .> id int, . . . . . . . . . . . . . . . . . . . .> a boolean, . . . . . . . . . . . . . . . . . . . .> b string, . . . . . . . . . . . . . . . . . . . .> c int, . . . . . . . . . . . . . . . . . . . .> d double) . . . . . . . . . . . . . . . . . . . .> STORED AS TEXTFILE . . . . . . . . . . . . . . . . . . . .> TBLPROPERTIES("serialization.null.forma t" = "xyz"); going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135813_1f8f0323-20d5-4bd4-9509-6108c815a064): CREATE EXTERNAL TABLE IF NOT EXISTS functional_orc_def.nullformat_custom ( id int, a boolean, b string, c int, d double) STORED AS TEXTFILE TBLPROPERTIES("serialization.null.format" = "xyz") INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:null, properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135813_1f8f0323-20d5-4bd4-9509-6108c815a064); Time taken: 0.016 seconds INFO : Executing command(queryId=jenkins_20201113135813_1f8f0323-20d5-4bd4-9509-6108c815a064): CREATE EXTERNAL TABLE IF NOT EXISTS functional_orc_def.nullformat_custom ( id int, a boolean, b string, c int, d double) STORED AS TEXTFILE TBLPROPERTIES("serialization.null.format" = "xyz") INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=jenkins_20201113135813_1f8f0323-20d5-4bd4-9509-6108c815a064); Time taken: 0.014 seconds INFO : OK No rows affected (0.063 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> -- Create a table that mixes supported and unsupported scalar types. 0: jdbc:hive2://localhost:11050/default> -- We should be able to read the column values of supported types and 0: jdbc:hive2://localhost:11050/default> -- fail queries that reference columns of unsupported types. 0: jdbc:hive2://localhost:11050/default> CREATE EXTERNAL TABLE IF NOT EXISTS fun ctional_orc_def.unsupported_types ( . . . . . . . . . . . . . . . . . . . .> int_col INT, . . . . . . . . . . . . . . . . . . . .> dec_col DECIMAL, . . . . . . . . . . . . . . . . . . . .> date_col DATE, . . . . . . . . . . . . . . . . . . . .> str_col STRING, . . . . . . . . . . . . . . . . . . . .> bin_col BINARY, . . . . . . . . . . . . . . . . . . . .> bigint_col BIGINT) . . . . . . . . . . . . . . . . . . . .> ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' . . . . . . . . . . . . . . . . . . . .> STORED AS ORC . . . . . . . . . . . . . . . . . . . .> LOCATION '/test-warehouse/unsupported_t ypes_orc_def'; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135813_082dcff1-7e6b-4c7e-8201-4a529319ee3e): CREATE EXTERNAL TABLE IF NOT EXISTS functional_orc_def.unsupported_types ( int_col INT, dec_col DECIMAL, date_col DATE, str_col STRING, bin_col BINARY, bigint_col BIGINT) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS ORC LOCATION '/test-warehouse/unsupported_types_orc_def' INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:null, properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135813_082dcff1-7e6b-4c7e-8201-4a529319ee3e); Time taken: 0.025 seconds INFO : Executing command(queryId=jenkins_20201113135813_082dcff1-7e6b-4c7e-8201-4a529319ee3e): CREATE EXTERNAL TABLE IF NOT EXISTS functional_orc_def.unsupported_types ( int_col INT, dec_col DECIMAL, date_col DATE, str_col STRING, bin_col BINARY, bigint_col BIGINT) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS ORC LOCATION '/test-warehouse/unsupported_types_orc_def' INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=jenkins_20201113135813_082dcff1-7e6b-4c7e-8201-4a529319ee3e); Time taken: 0.035 seconds INFO : OK No rows affected (0.087 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> CREATE TABLE IF NOT EXISTS functional_o rc_def.full_transactional_table ( . . . . . . . . . . . . . . . . . . . .> col1 int) . . . . . . . . . . . . . . . . . . . .> STORED AS ORC . . . . . . . . . . . . . . . . . . . .> TBLPROPERTIES('transactional'='true'); going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135813_07fc99e7-2fb2-4a2c-9cc2-d88c84dbece2): CREATE TABLE IF NOT EXISTS functional_orc_def.full_transactional_table ( col1 int) STORED AS ORC TBLPROPERTIES('transactional'='true') INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:null, properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135813_07fc99e7-2fb2-4a2c-9cc2-d88c84dbece2); Time taken: 0.007 seconds INFO : Executing command(queryId=jenkins_20201113135813_07fc99e7-2fb2-4a2c-9cc2-d88c84dbece2): CREATE TABLE IF NOT EXISTS functional_orc_def.full_transactional_table ( col1 int) STORED AS ORC TBLPROPERTIES('transactional'='true') INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=jenkins_20201113135813_07fc99e7-2fb2-4a2c-9cc2-d88c84dbece2); Time taken: 0.02 seconds INFO : OK No rows affected (0.053 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> CREATE TABLE IF NOT EXISTS functional_o rc_def.insert_only_transactional_bucketed_table ( . . . . . . . . . . . . . . . . . . . .> col1 int, col2 int) . . . . . . . . . . . . . . . . . . . .> CLUSTERED BY (col1) INTO 5 BUCKETS . . . . . . . . . . . . . . . . . . . .> STORED AS ORC . . . . . . . . . . . . . . . . . . . .> TBLPROPERTIES('transactional'='true', ' transactional_properties'='insert_only'); going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135813_905d7c57-5ef6-4a08-8247-e04fd69da379): CREATE TABLE IF NOT EXISTS functional_orc_def.insert_only_transactional_bucketed_table ( col1 int, col2 int) CLUSTERED BY (col1) INTO 5 BUCKETS STORED AS ORC TBLPROPERTIES('transactional'='true', 'transactional_properties'='insert_only') INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:null, properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135813_905d7c57-5ef6-4a08-8247-e04fd69da379); Time taken: 0.007 seconds INFO : Executing command(queryId=jenkins_20201113135813_905d7c57-5ef6-4a08-8247-e04fd69da379): CREATE TABLE IF NOT EXISTS functional_orc_def.insert_only_transactional_bucketed_table ( col1 int, col2 int) CLUSTERED BY (col1) INTO 5 BUCKETS STORED AS ORC TBLPROPERTIES('transactional'='true', 'transactional_properties'='insert_only') INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=jenkins_20201113135813_905d7c57-5ef6-4a08-8247-e04fd69da379); Time taken: 0.028 seconds INFO : OK No rows affected (0.051 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> CREATE EXTERNAL TABLE IF NOT EXISTS fun ctional_orc_def.bucketed_ext_table ( . . . . . . . . . . . . . . . . . . . .> col1 int, col2 int) . . . . . . . . . . . . . . . . . . . .> CLUSTERED BY (col1) INTO 5 BUCKETS . . . . . . . . . . . . . . . . . . . .> STORED AS TEXTFILE . . . . . . . . . . . . . . . . . . . .> LOCATION '/test-warehouse/functional_or c_defbucketed_ext_table'; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135814_7227f92f-ccd1-4243-8a6a-c93ce9b8c016): CREATE EXTERNAL TABLE IF NOT EXISTS functional_orc_def.bucketed_ext_table ( col1 int, col2 int) CLUSTERED BY (col1) INTO 5 BUCKETS STORED AS TEXTFILE LOCATION '/test-warehouse/functional_orc_defbucketed_ext_table' INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:null, properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135814_7227f92f-ccd1-4243-8a6a-c93ce9b8c016); Time taken: 0.01 seconds INFO : Executing command(queryId=jenkins_20201113135814_7227f92f-ccd1-4243-8a6a-c93ce9b8c016): CREATE EXTERNAL TABLE IF NOT EXISTS functional_orc_def.bucketed_ext_table ( col1 int, col2 int) CLUSTERED BY (col1) INTO 5 BUCKETS STORED AS TEXTFILE LOCATION '/test-warehouse/functional_orc_defbucketed_ext_table' INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=jenkins_20201113135814_7227f92f-ccd1-4243-8a6a-c93ce9b8c016); Time taken: 0.017 seconds INFO : OK No rows affected (0.048 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> CREATE TABLE IF NOT EXISTS functional_o rc_def.bucketed_table ( . . . . . . . . . . . . . . . . . . . .> col1 int, col2 int) . . . . . . . . . . . . . . . . . . . .> CLUSTERED BY (col1) INTO 5 BUCKETS . . . . . . . . . . . . . . . . . . . .> STORED AS ORC; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135814_5d6a9c93-36ac-4461-9d39-2ddd9e558917): CREATE TABLE IF NOT EXISTS functional_orc_def.bucketed_table ( col1 int, col2 int) CLUSTERED BY (col1) INTO 5 BUCKETS STORED AS ORC INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:null, properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135814_5d6a9c93-36ac-4461-9d39-2ddd9e558917); Time taken: 0.007 seconds INFO : Executing command(queryId=jenkins_20201113135814_5d6a9c93-36ac-4461-9d39-2ddd9e558917): CREATE TABLE IF NOT EXISTS functional_orc_def.bucketed_table ( col1 int, col2 int) CLUSTERED BY (col1) INTO 5 BUCKETS STORED AS ORC INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=jenkins_20201113135814_5d6a9c93-36ac-4461-9d39-2ddd9e558917); Time taken: 0.02 seconds INFO : OK No rows affected (0.041 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> -- The create materialized view command is moved down so that the database's 0: jdbc:hive2://localhost:11050/default> -- managed directory has been created. Otherwise the command would fail. This 0: jdbc:hive2://localhost:11050/default> -- is a bug in Hive. 0: jdbc:hive2://localhost:11050/default> CREATE MATERIALIZED VIEW IF NOT EXISTS functional_orc_def.materialized_view . . . . . . . . . . . . . . . . . . . .> AS SELECT * FROM functional_orc_def.i nsert_only_transactional_table; going to print operations logs printed operations logs going to print operations logs INFO : Compiling command(queryId=jenkins_20201113135814_99823091-29ff-4ae1-8ef5-abc68ae2c45e): CREATE MATERIALIZED VIEW IF NOT EXISTS functional_orc_def.materialized_view AS SELECT * FROM functional_orc_def.insert_only_transactional_table INFO : No Stats for functional_orc_def@insert_only_transactional_table, Columns: col1 INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:col1, type:int, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135814_99823091-29ff-4ae1-8ef5-abc68ae2c45e); Time taken: 0.073 seconds INFO : Executing command(queryId=jenkins_20201113135814_99823091-29ff-4ae1-8ef5-abc68ae2c45e): CREATE MATERIALIZED VIEW IF NOT EXISTS functional_orc_def.materialized_view AS SELECT * FROM functional_orc_def.insert_only_transactional_table INFO : Query ID = jenkins_20201113135814_99823091-29ff-4ae1-8ef5-abc68ae2c45e INFO : Total jobs = 3 INFO : Launching Job 1 out of 3 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135814_99823091-29ff-4ae1-8ef5-abc68ae2c45e INFO : Tez session hasn't been created yet. Opening session INFO : Dag name: CREATE MATERIALIZED V..._transactional_table (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) INFO : Starting task [Stage-7:CONDITIONAL] in serial mode INFO : Stage-4 is selected by condition resolver. INFO : Stage-3 is filtered out by condition resolver. INFO : Stage-5 is filtered out by condition resolver. INFO : Starting task [Stage-4:MOVE] in serial mode INFO : Moving data to directory hdfs://localhost:20500/test-warehouse/.hive-staging_hive_2020-11-13_13-58-14_131_5458288376322668794-1/-ext-10002 from hdfs://localhost:20500/test-warehouse/.hive-staging_hive_2020-11-13_13-58-14_131_5458288376322668794-1/-ext-10004 INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Moving data to directory hdfs://localhost:20500/test-warehouse/managed/functional_orc_def.db/materialized_view from hdfs://localhost:20500/test-warehouse/.hive-staging_hive_2020-11-13_13-58-14_131_5458288376322668794-1/-ext-10002 INFO : Starting task [Stage-8:DDL] in serial mode INFO : Starting task [Stage-9:DDL] in serial mode INFO : No Stats for functional_orc_def@insert_only_transactional_table, Columns: col1 INFO : Completed executing command(queryId=jenkins_20201113135814_99823091-29ff-4ae1-8ef5-abc68ae2c45e); Time taken: 6.55 seconds INFO : OK printed operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container SUCCEEDED 0 0 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 0.19 s ---------------------------------------------------------------------------------------------- Getting log thread is interrupted, since query is done! ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container SUCCEEDED 0 0 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 0.19 s ---------------------------------------------------------------------------------------------- No rows affected (6.647 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> CREATE TABLE functional_orc_def.uncomp_ src_alltypes LIKE functional.alltypes STORED AS ORC; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135820_03af5b42-eb97-44e6-aca4-a7ca833a4852): CREATE TABLE functional_orc_def.uncomp_src_alltypes LIKE functional.alltypes STORED AS ORC INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:null, properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135820_03af5b42-eb97-44e6-aca4-a7ca833a4852); Time taken: 0.011 seconds INFO : Executing command(queryId=jenkins_20201113135820_03af5b42-eb97-44e6-aca4-a7ca833a4852): CREATE TABLE functional_orc_def.uncomp_src_alltypes LIKE functional.alltypes STORED AS ORC INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=jenkins_20201113135820_03af5b42-eb97-44e6-aca4-a7ca833a4852); Time taken: 0.023 seconds INFO : OK No rows affected (0.047 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> CREATE TABLE functional_orc_def.uncomp_ src_decimal_tbl LIKE functional.decimal_tbl STORED AS ORC; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135820_8bd11d74-7574-4be0-899d-5012c8ab131d): CREATE TABLE functional_orc_def.uncomp_src_decimal_tbl LIKE functional.decimal_tbl STORED AS ORC INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:null, properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135820_8bd11d74-7574-4be0-899d-5012c8ab131d); Time taken: 0.011 seconds INFO : Executing command(queryId=jenkins_20201113135820_8bd11d74-7574-4be0-899d-5012c8ab131d): CREATE TABLE functional_orc_def.uncomp_src_decimal_tbl LIKE functional.decimal_tbl STORED AS ORC INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=jenkins_20201113135820_8bd11d74-7574-4be0-899d-5012c8ab131d); Time taken: 0.018 seconds INFO : OK No rows affected (0.046 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> SET hive.exec.compress.output=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.003 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.type=BLOC K; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition.mode=no nstrict; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions.pe rnode=10000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.max.split.size=256000000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.004 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE functional_orc_d ef.alltypes partition (year, month) . . . . . . . . . . . . . . . . . . . .> SELECT id, bool_col, tinyint_col, small int_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col , timestamp_col, year, month . . . . . . . . . . . . . . . . . . . .> FROM functional.alltypes; going to print operations logs printed operations logs going to print operations logs INFO : Compiling command(queryId=jenkins_20201113135820_98753ae7-cfae-4d86-a36d-13febfc26b3c): INSERT OVERWRITE TABLE functional_orc_def.alltypes partition (year, month) SELECT id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col, timestamp_col, year, month FROM functional.alltypes INFO : No Stats for functional@alltypes, Columns: float_col, int_col, string_col, bool_col, date_string_col, smallint_col, timestamp_col, tinyint_col, bigint_col, id, double_col INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:id, type:int, comment:null), FieldSchema(name:bool_col, type:boolean, comment:null), FieldSchema(name:tinyint_col, type:tinyint, comment:null), FieldSchema(name:smallint_col, type:smallint, comment:null), FieldSchema(name:int_col, type:int, comment:null), FieldSchema(name:bigint_col, type:bigint, comment:null), FieldSchema(name:float_col, type:float, comment:null), FieldSchema(name:double_col, type:double, comment:null), FieldSchema(name:date_string_col, type:string, comment:null), FieldSchema(name:string_col, type:string, comment:null), FieldSchema(name:timestamp_col, type:timestamp, comment:null), FieldSchema(name:year, type:int, comment:null), FieldSchema(name:month, type:int, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135820_98753ae7-cfae-4d86-a36d-13febfc26b3c); Time taken: 0.066 seconds INFO : Executing command(queryId=jenkins_20201113135820_98753ae7-cfae-4d86-a36d-13febfc26b3c): INSERT OVERWRITE TABLE functional_orc_def.alltypes partition (year, month) SELECT id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col, timestamp_col, year, month FROM functional.alltypes INFO : Query ID = jenkins_20201113135820_98753ae7-cfae-4d86-a36d-13febfc26b3c INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135820_98753ae7-cfae-4d86-a36d-13febfc26b3c INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABLE...functional.alltypes (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) printed operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container INITED 24 0 0 24 0 0 Reducer 2 container INITED 1 0 0 1 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [>>--------------------------] 0% ELAPSED TIME: 1.32 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container INITED 24 0 0 24 0 0 Reducer 2 container INITED 1 0 0 1 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [>>--------------------------] 0% ELAPSED TIME: 1.82 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container INITED 24 0 0 24 0 0 Reducer 2 container INITED 1 0 0 1 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [>>--------------------------] 0% ELAPSED TIME: 2.32 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container INITED 24 0 0 24 0 0 Reducer 2 container INITED 1 0 0 1 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [>>--------------------------] 0% ELAPSED TIME: 2.82 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container INITED 24 0 0 24 0 0 Reducer 2 container INITED 1 0 0 1 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [>>--------------------------] 0% ELAPSED TIME: 3.33 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 24 0 1 23 0 0 Reducer 2 container INITED 1 0 0 1 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [>>--------------------------] 0% ELAPSED TIME: 3.83 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 24 0 1 23 0 0 Reducer 2 container INITED 1 0 0 1 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [>>--------------------------] 0% ELAPSED TIME: 4.33 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 24 0 3 21 0 0 Reducer 2 container INITED 1 0 0 1 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [>>--------------------------] 0% ELAPSED TIME: 4.83 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 24 0 3 21 0 0 Reducer 2 container INITED 1 0 0 1 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [>>--------------------------] 0% ELAPSED TIME: 5.33 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 24 0 4 20 0 0 Reducer 2 container INITED 1 0 0 1 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [>>--------------------------] 0% ELAPSED TIME: 5.84 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 24 1 3 20 0 0 Reducer 2 container INITED 1 0 0 1 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [=>>-------------------------] 3% ELAPSED TIME: 6.34 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .. container RUNNING 24 6 4 14 0 0 Reducer 2 container INITED 1 0 0 1 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [======>>--------------------] 23% ELAPSED TIME: 6.85 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ..... container RUNNING 24 12 5 7 0 0 Reducer 2 container INITED 1 0 0 1 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [============>>--------------] 47% ELAPSED TIME: 7.35 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ........ container RUNNING 24 20 2 2 0 0 Reducer 2 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [====================>>------] 80% ELAPSED TIME: 7.86 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ........ container RUNNING 24 21 2 1 0 0 Reducer 2 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [=====================>>-----] 83% ELAPSED TIME: 8.36 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ........ container RUNNING 24 21 3 0 0 0 Reducer 2 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [=====================>>-----] 83% ELAPSED TIME: 8.86 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ........ container RUNNING 24 21 3 0 0 0 Reducer 2 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [=====================>>-----] 83% ELAPSED TIME: 9.36 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ......... container RUNNING 24 22 2 0 0 0 Reducer 2 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [======================>>----] 87% ELAPSED TIME: 9.87 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 24 24 0 0 0 0 Reducer 2 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [========================>>--] 95% ELAPSED TIME: 10.87 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 24 24 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 11.88 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 24 24 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 12.00 s ---------------------------------------------------------------------------------------------- Getting log thread is interrupted, since query is done! INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.alltypes partition (year=null, month=null) from hdfs://localhost:20500/test-warehouse/managed/alltypes_orc_def INFO : INFO : Time taken to load dynamic partitions: 0.403 seconds INFO : Time taken for adding to write entity : 0.001 seconds INFO : Completed executing command(queryId=jenkins_20201113135820_98753ae7-cfae-4d86-a36d-13febfc26b3c); Time taken: 12.179 seconds INFO : OK ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 24 24 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 12.01 s ---------------------------------------------------------------------------------------------- 7,300 rows affected (12.262 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> SET hive.exec.compress.output=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.type=BLOC K; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition.mode=no nstrict; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions.pe rnode=10000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.max.split.size=256000000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.009 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE functional_orc_d ef.alltypessmall partition (year, month) . . . . . . . . . . . . . . . . . . . .> SELECT id, bool_col, tinyint_col, small int_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col , timestamp_col, year, month . . . . . . . . . . . . . . . . . . . .> FROM functional.alltypessmall; going to print operations logs printed operations logs going to print operations logs INFO : Compiling command(queryId=jenkins_20201113135833_6dc794d6-7f9c-4fbc-9653-2daa02a483b1): INSERT OVERWRITE TABLE functional_orc_def.alltypessmall partition (year, month) SELECT id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col, timestamp_col, year, month FROM functional.alltypessmall INFO : No Stats for functional@alltypessmall, Columns: float_col, int_col, string_col, bool_col, date_string_col, smallint_col, timestamp_col, tinyint_col, bigint_col, id, double_col INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:id, type:int, comment:null), FieldSchema(name:bool_col, type:boolean, comment:null), FieldSchema(name:tinyint_col, type:tinyint, comment:null), FieldSchema(name:smallint_col, type:smallint, comment:null), FieldSchema(name:int_col, type:int, comment:null), FieldSchema(name:bigint_col, type:bigint, comment:null), FieldSchema(name:float_col, type:float, comment:null), FieldSchema(name:double_col, type:double, comment:null), FieldSchema(name:date_string_col, type:string, comment:null), FieldSchema(name:string_col, type:string, comment:null), FieldSchema(name:timestamp_col, type:timestamp, comment:null), FieldSchema(name:year, type:int, comment:null), FieldSchema(name:month, type:int, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135833_6dc794d6-7f9c-4fbc-9653-2daa02a483b1); Time taken: 0.031 seconds INFO : Executing command(queryId=jenkins_20201113135833_6dc794d6-7f9c-4fbc-9653-2daa02a483b1): INSERT OVERWRITE TABLE functional_orc_def.alltypessmall partition (year, month) SELECT id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col, timestamp_col, year, month FROM functional.alltypessmall INFO : Query ID = jenkins_20201113135833_6dc794d6-7f9c-4fbc-9653-2daa02a483b1 INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135833_6dc794d6-7f9c-4fbc-9653-2daa02a483b1 INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABL...tional.alltypessmall (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.alltypessmall partition (year=null, month=null) from hdfs://localhost:20500/test-warehouse/managed/alltypessmall_orc_def INFO : INFO : Time taken to load dynamic partitions: 0.103 seconds INFO : Time taken for adding to write entity : 0.0 seconds INFO : Completed executing command(queryId=jenkins_20201113135833_6dc794d6-7f9c-4fbc-9653-2daa02a483b1); Time taken: 0.984 seconds INFO : OK printed operations logs Getting log thread is interrupted, since query is done! ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 4 4 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 0.94 s ---------------------------------------------------------------------------------------------- 100 rows affected (1.029 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> SET hive.exec.compress.output=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.type=BLOC K; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition.mode=no nstrict; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions.pe rnode=10000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.max.split.size=256000000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE functional_orc_d ef.alltypestiny partition (year, month) . . . . . . . . . . . . . . . . . . . .> SELECT id, bool_col, tinyint_col, small int_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col , timestamp_col, year, month . . . . . . . . . . . . . . . . . . . .> FROM functional.alltypestiny; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135834_864d4b18-adc5-4701-86ee-4eae3088ec86): INSERT OVERWRITE TABLE functional_orc_def.alltypestiny partition (year, month) SELECT id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col, timestamp_col, year, month FROM functional.alltypestiny INFO : No Stats for functional@alltypestiny, Columns: float_col, int_col, string_col, bool_col, date_string_col, smallint_col, timestamp_col, tinyint_col, bigint_col, id, double_col INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:id, type:int, comment:null), FieldSchema(name:bool_col, type:boolean, comment:null), FieldSchema(name:tinyint_col, type:tinyint, comment:null), FieldSchema(name:smallint_col, type:smallint, comment:null), FieldSchema(name:int_col, type:int, comment:null), FieldSchema(name:bigint_col, type:bigint, comment:null), FieldSchema(name:float_col, type:float, comment:null), FieldSchema(name:double_col, type:double, comment:null), FieldSchema(name:date_string_col, type:string, comment:null), FieldSchema(name:string_col, type:string, comment:null), FieldSchema(name:timestamp_col, type:timestamp, comment:null), FieldSchema(name:year, type:int, comment:null), FieldSchema(name:month, type:int, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135834_864d4b18-adc5-4701-86ee-4eae3088ec86); Time taken: 0.04 seconds INFO : Executing command(queryId=jenkins_20201113135834_864d4b18-adc5-4701-86ee-4eae3088ec86): INSERT OVERWRITE TABLE functional_orc_def.alltypestiny partition (year, month) SELECT id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col, timestamp_col, year, month FROM functional.alltypestiny INFO : Query ID = jenkins_20201113135834_864d4b18-adc5-4701-86ee-4eae3088ec86 INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135834_864d4b18-adc5-4701-86ee-4eae3088ec86 INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABL...ctional.alltypestiny (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.alltypestiny partition (year=null, month=null) from hdfs://localhost:20500/test-warehouse/managed/alltypestiny_orc_def INFO : INFO : Time taken to load dynamic partitions: 0.08 seconds INFO : Time taken for adding to write entity : 0.0 seconds INFO : Completed executing command(queryId=jenkins_20201113135834_864d4b18-adc5-4701-86ee-4eae3088ec86); Time taken: 0.769 seconds INFO : OK 8 rows affected (0.832 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> SET hive.exec.compress.output=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.type=BLOC K; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition.mode=no nstrict; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions.pe rnode=10000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.max.split.size=256000000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> USE functional_orc_def; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135835_ed4acf44-d7f6-4087-9f19-2b3a12f83576): USE functional_orc_def INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:null, properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135835_ed4acf44-d7f6-4087-9f19-2b3a12f83576); Time taken: 0.001 seconds INFO : Executing command(queryId=jenkins_20201113135835_ed4acf44-d7f6-4087-9f19-2b3a12f83576): USE functional_orc_def INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=jenkins_20201113135835_ed4acf44-d7f6-4087-9f19-2b3a12f83576); Time taken: 0.001 seconds INFO : OK No rows affected (0.005 seconds) 0: jdbc:hive2://localhost:11050/default> -- Step 4: Stream the data from tmp tex t table to desired format tmp table 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE functional_orc_d ef.alltypeserror_tmp PARTITION (year, month) . . . . . . . . . . . . . . . . . . . .> SELECT * FROM functional.alltypeserror_ tmp; going to print operations logs printed operations logs going to print operations logs INFO : Compiling command(queryId=jenkins_20201113135835_da246f8a-0676-454c-b49b-311d53778c66): INSERT OVERWRITE TABLE functional_orc_def.alltypeserror_tmp PARTITION (year, month) SELECT * FROM functional.alltypeserror_tmp INFO : No Stats for functional@alltypeserror_tmp, Columns: float_col, int_col, string_col, bool_col, date_string_col, smallint_col, timestamp_col, tinyint_col, bigint_col, id, double_col INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:alltypeserror_tmp.id, type:string, comment:null), FieldSchema(name:alltypeserror_tmp.bool_col, type:string, comment:null), FieldSchema(name:alltypeserror_tmp.tinyint_col, type:string, comment:null), FieldSchema(name:alltypeserror_tmp.smallint_col, type:string, comment:null), FieldSchema(name:alltypeserror_tmp.int_col, type:string, comment:null), FieldSchema(name:alltypeserror_tmp.bigint_col, type:string, comment:null), FieldSchema(name:alltypeserror_tmp.float_col, type:string, comment:null), FieldSchema(name:alltypeserror_tmp.double_col, type:string, comment:null), FieldSchema(name:alltypeserror_tmp.date_string_col, type:string, comment:null), FieldSchema(name:alltypeserror_tmp.string_col, type:string, comment:null), FieldSchema(name:alltypeserror_tmp.timestamp_col, type:string, comment:null), FieldSchema(name:alltypeserror_tmp.year, type:int, comment:null), FieldSchema(name:alltypeserror_tmp.month, type:int, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135835_da246f8a-0676-454c-b49b-311d53778c66); Time taken: 0.238 seconds INFO : Executing command(queryId=jenkins_20201113135835_da246f8a-0676-454c-b49b-311d53778c66): INSERT OVERWRITE TABLE functional_orc_def.alltypeserror_tmp PARTITION (year, month) SELECT * FROM functional.alltypeserror_tmp INFO : Query ID = jenkins_20201113135835_da246f8a-0676-454c-b49b-311d53778c66 INFO : Total jobs = 3 INFO : Launching Job 1 out of 3 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135835_da246f8a-0676-454c-b49b-311d53778c66 INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABL...al.alltypeserror_tmp (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) printed operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 3 3 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 1.25 s ---------------------------------------------------------------------------------------------- Getting log thread is interrupted, since query is done! INFO : Starting task [Stage-7:CONDITIONAL] in serial mode INFO : Stage-4 is selected by condition resolver. INFO : Stage-3 is filtered out by condition resolver. INFO : Stage-5 is filtered out by condition resolver. INFO : Starting task [Stage-4:MOVE] in serial mode INFO : Moving data to directory hdfs://localhost:20500/test-warehouse/alltypeserror_orc_def/.hive-staging_hive_2020-11-13_13-58-35_168_4589136922011768158-1/-ext-10000 from hdfs://localhost:20500/test-warehouse/alltypeserror_orc_def/.hive-staging_hive_2020-11-13_13-58-35_168_4589136922011768158-1/-ext-10002 INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.alltypeserror_tmp partition (year=null, month=null) from hdfs://localhost:20500/test-warehouse/alltypeserror_orc_def/.hive-staging_hive_2020-11-13_13-58-35_168_4589136922011768158-1/-ext-10000 INFO : INFO : Time taken to load dynamic partitions: 0.189 seconds INFO : Time taken for adding to write entity : 0.0 seconds INFO : Completed executing command(queryId=jenkins_20201113135835_da246f8a-0676-454c-b49b-311d53778c66); Time taken: 1.286 seconds INFO : OK ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 3 3 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 1.25 s ---------------------------------------------------------------------------------------------- 31 rows affected (1.532 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> -- Cleanup the temp table 0: jdbc:hive2://localhost:11050/default> DROP TABLE IF EXISTS functional_orc_def .alltypeserror_tmp; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135836_50c45bd1-9c1a-4e8f-9284-bd1e31b5fbcc): DROP TABLE IF EXISTS functional_orc_def.alltypeserror_tmp INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:null, properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135836_50c45bd1-9c1a-4e8f-9284-bd1e31b5fbcc); Time taken: 0.008 seconds INFO : Executing command(queryId=jenkins_20201113135836_50c45bd1-9c1a-4e8f-9284-bd1e31b5fbcc): DROP TABLE IF EXISTS functional_orc_def.alltypeserror_tmp INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=jenkins_20201113135836_50c45bd1-9c1a-4e8f-9284-bd1e31b5fbcc); Time taken: 0.075 seconds INFO : OK No rows affected (0.091 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> SET hive.exec.compress.output=true; No rows affected (0.003 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.type=BLOC K; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.003 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition.mode=no nstrict; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions.pe rnode=10000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.max.split.size=256000000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT INTO TABLE functional_orc_def.al ltypes_promoted SELECT * FROM functional_orc_def.alltypes; going to print operations logs printed operations logs going to print operations logs INFO : Compiling command(queryId=jenkins_20201113135836_e7b7eb76-19d6-4f07-86f3-4863ed8e70c4): INSERT INTO TABLE functional_orc_def.alltypes_promoted SELECT * FROM functional_orc_def.alltypes INFO : No Stats for functional_orc_def@alltypes, Columns: float_col, int_col, string_col, bool_col, date_string_col, smallint_col, timestamp_col, tinyint_col, bigint_col, id, double_col INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:alltypes.id, type:int, comment:null), FieldSchema(name:alltypes.bool_col, type:boolean, comment:null), FieldSchema(name:alltypes.tinyint_col, type:tinyint, comment:null), FieldSchema(name:alltypes.smallint_col, type:smallint, comment:null), FieldSchema(name:alltypes.int_col, type:int, comment:null), FieldSchema(name:alltypes.bigint_col, type:bigint, comment:null), FieldSchema(name:alltypes.float_col, type:float, comment:null), FieldSchema(name:alltypes.double_col, type:double, comment:null), FieldSchema(name:alltypes.date_string_col, type:string, comment:null), FieldSchema(name:alltypes.string_col, type:string, comment:null), FieldSchema(name:alltypes.timestamp_col, type:timestamp, comment:null), FieldSchema(name:alltypes.year, type:int, comment:null), FieldSchema(name:alltypes.month, type:int, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135836_e7b7eb76-19d6-4f07-86f3-4863ed8e70c4); Time taken: 0.05 seconds INFO : Executing command(queryId=jenkins_20201113135836_e7b7eb76-19d6-4f07-86f3-4863ed8e70c4): INSERT INTO TABLE functional_orc_def.alltypes_promoted SELECT * FROM functional_orc_def.alltypes INFO : Query ID = jenkins_20201113135836_e7b7eb76-19d6-4f07-86f3-4863ed8e70c4 INFO : Total jobs = 3 INFO : Launching Job 1 out of 3 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135836_e7b7eb76-19d6-4f07-86f3-4863ed8e70c4 INFO : Session is already open INFO : Dag name: INSERT INTO TABLE fun...nal_orc_def.alltypes (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) printed operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 24 24 0 0 0 0 Reducer 2 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [========================>>--] 95% ELAPSED TIME: 1.45 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 24 24 0 0 0 0 Reducer 2 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [========================>>--] 95% ELAPSED TIME: 1.95 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 24 24 0 0 0 0 Reducer 2 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [========================>>--] 95% ELAPSED TIME: 2.45 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 24 24 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 2.95 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 24 24 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 2.98 s ---------------------------------------------------------------------------------------------- Getting log thread is interrupted, since query is done! INFO : Starting task [Stage-7:CONDITIONAL] in serial mode INFO : Stage-4 is selected by condition resolver. INFO : Stage-3 is filtered out by condition resolver. INFO : Stage-5 is filtered out by condition resolver. INFO : Starting task [Stage-4:MOVE] in serial mode INFO : Moving data to directory hdfs://localhost:20500/test-warehouse/alltypes_promoted_orc_def/.hive-staging_hive_2020-11-13_13-58-36_831_7989595434584774752-1/-ext-10000 from hdfs://localhost:20500/test-warehouse/alltypes_promoted_orc_def/.hive-staging_hive_2020-11-13_13-58-36_831_7989595434584774752-1/-ext-10002 INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.alltypes_promoted partition (year=null, month=null) from hdfs://localhost:20500/test-warehouse/alltypes_promoted_orc_def/.hive-staging_hive_2020-11-13_13-58-36_831_7989595434584774752-1/-ext-10000 INFO : INFO : Time taken to load dynamic partitions: 0.231 seconds INFO : Time taken for adding to write entity : 0.0 seconds INFO : Completed executing command(queryId=jenkins_20201113135836_e7b7eb76-19d6-4f07-86f3-4863ed8e70c4); Time taken: 3.022 seconds INFO : OK ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 24 24 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 2.98 s ---------------------------------------------------------------------------------------------- 7,300 rows affected (3.088 seconds) 0: jdbc:hive2://localhost:11050/default> ALTER TABLE functional_orc_def.alltypes _promoted SET tblproperties('EXTERNAL'='FALSE','transactional'='true'); going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135839_8f85df06-b225-49a9-93ab-585b3c167f23): ALTER TABLE functional_orc_def.alltypes_promoted SET tblproperties('EXTERNAL'='FALSE','transactional'='true') INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:null, properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135839_8f85df06-b225-49a9-93ab-585b3c167f23); Time taken: 0.033 seconds INFO : Executing command(queryId=jenkins_20201113135839_8f85df06-b225-49a9-93ab-585b3c167f23): ALTER TABLE functional_orc_def.alltypes_promoted SET tblproperties('EXTERNAL'='FALSE','transactional'='true') INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=jenkins_20201113135839_8f85df06-b225-49a9-93ab-585b3c167f23); Time taken: 0.151 seconds INFO : OK No rows affected (0.195 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> SET hive.exec.compress.output=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.type=BLOC K; No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition.mode=no nstrict; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions.pe rnode=10000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.max.split.size=256000000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> USE functional_orc_def; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135840_00e5799f-485c-4d95-96a6-0eeedb2b2794): USE functional_orc_def INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:null, properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135840_00e5799f-485c-4d95-96a6-0eeedb2b2794); Time taken: 0.002 seconds INFO : Executing command(queryId=jenkins_20201113135840_00e5799f-485c-4d95-96a6-0eeedb2b2794): USE functional_orc_def INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=jenkins_20201113135840_00e5799f-485c-4d95-96a6-0eeedb2b2794); Time taken: 0.002 seconds INFO : OK No rows affected (0.008 seconds) 0: jdbc:hive2://localhost:11050/default> -- Step 4: Stream the data from tmp tex t table to desired format tmp table 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE functional_orc_d ef.alltypeserrornonulls_tmp PARTITION (year, month) . . . . . . . . . . . . . . . . . . . .> SELECT * FROM functional.alltypeserrorn onulls_tmp; going to print operations logs printed operations logs going to print operations logs INFO : Compiling command(queryId=jenkins_20201113135840_af481a9f-0860-4da6-9180-fae585f16ad5): INSERT OVERWRITE TABLE functional_orc_def.alltypeserrornonulls_tmp PARTITION (year, month) SELECT * FROM functional.alltypeserrornonulls_tmp INFO : No Stats for functional@alltypeserrornonulls_tmp, Columns: float_col, int_col, string_col, bool_col, date_string_col, smallint_col, timestamp_col, tinyint_col, bigint_col, id, double_col INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:alltypeserrornonulls_tmp.id, type:string, comment:null), FieldSchema(name:alltypeserrornonulls_tmp.bool_col, type:string, comment:null), FieldSchema(name:alltypeserrornonulls_tmp.tinyint_col, type:string, comment:null), FieldSchema(name:alltypeserrornonulls_tmp.smallint_col, type:string, comment:null), FieldSchema(name:alltypeserrornonulls_tmp.int_col, type:string, comment:null), FieldSchema(name:alltypeserrornonulls_tmp.bigint_col, type:string, comment:null), FieldSchema(name:alltypeserrornonulls_tmp.float_col, type:string, comment:null), FieldSchema(name:alltypeserrornonulls_tmp.double_col, type:string, comment:null), FieldSchema(name:alltypeserrornonulls_tmp.date_string_col, type:string, comment:null), FieldSchema(name:alltypeserrornonulls_tmp.string_col, type:string, comment:null), FieldSchema(name:alltypeserrornonulls_tmp.timestamp_col, type:string, comment:null), FieldSchema(name:alltypeserrornonulls_tmp.year, type:int, comment:null), FieldSchema(name:alltypeserrornonulls_tmp.month, type:int, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135840_af481a9f-0860-4da6-9180-fae585f16ad5); Time taken: 0.046 seconds INFO : Executing command(queryId=jenkins_20201113135840_af481a9f-0860-4da6-9180-fae585f16ad5): INSERT OVERWRITE TABLE functional_orc_def.alltypeserrornonulls_tmp PARTITION (year, month) SELECT * FROM functional.alltypeserrornonulls_tmp INFO : Query ID = jenkins_20201113135840_af481a9f-0860-4da6-9180-fae585f16ad5 INFO : Total jobs = 3 INFO : Launching Job 1 out of 3 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135840_af481a9f-0860-4da6-9180-fae585f16ad5 INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABL...ypeserrornonulls_tmp (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) printed operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 3 3 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 1.45 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 3 3 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 1.66 s ---------------------------------------------------------------------------------------------- Getting log thread is interrupted, since query is done! INFO : Starting task [Stage-7:CONDITIONAL] in serial mode INFO : Stage-4 is selected by condition resolver. INFO : Stage-3 is filtered out by condition resolver. INFO : Stage-5 is filtered out by condition resolver. INFO : Starting task [Stage-4:MOVE] in serial mode INFO : Moving data to directory hdfs://localhost:20500/test-warehouse/alltypeserrornonulls_orc_def/.hive-staging_hive_2020-11-13_13-58-40_164_8135697502149742287-1/-ext-10000 from hdfs://localhost:20500/test-warehouse/alltypeserrornonulls_orc_def/.hive-staging_hive_2020-11-13_13-58-40_164_8135697502149742287-1/-ext-10002 INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.alltypeserrornonulls_tmp partition (year=null, month=null) from hdfs://localhost:20500/test-warehouse/alltypeserrornonulls_orc_def/.hive-staging_hive_2020-11-13_13-58-40_164_8135697502149742287-1/-ext-10000 INFO : INFO : Time taken to load dynamic partitions: 0.291 seconds INFO : Time taken for adding to write entity : 0.0 seconds INFO : Completed executing command(queryId=jenkins_20201113135840_af481a9f-0860-4da6-9180-fae585f16ad5); Time taken: 1.728 seconds INFO : OK ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 3 3 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 1.67 s ---------------------------------------------------------------------------------------------- 30 rows affected (1.783 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> -- Cleanup the temp table 0: jdbc:hive2://localhost:11050/default> DROP TABLE IF EXISTS functional_orc_def .alltypeserrornonulls_tmp; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135842_f15ce8cd-ca05-448d-be53-8febd6edcf2c): DROP TABLE IF EXISTS functional_orc_def.alltypeserrornonulls_tmp INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:null, properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135842_f15ce8cd-ca05-448d-be53-8febd6edcf2c); Time taken: 0.017 seconds INFO : Executing command(queryId=jenkins_20201113135842_f15ce8cd-ca05-448d-be53-8febd6edcf2c): DROP TABLE IF EXISTS functional_orc_def.alltypeserrornonulls_tmp INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=jenkins_20201113135842_f15ce8cd-ca05-448d-be53-8febd6edcf2c); Time taken: 0.05 seconds INFO : OK No rows affected (0.11 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> SET hive.exec.compress.output=true; No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.type=BLOC K; No rows affected (0.058 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; No rows affected (0.094 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition.mode=no nstrict; No rows affected (0.005 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; No rows affected (0.038 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; No rows affected (0.016 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions.pe rnode=10000; No rows affected (0.025 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; No rows affected (0.044 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.max.split.size=256000000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.036 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT INTO TABLE functional_orc_def.al ltypes_deleted_rows SELECT * FROM functional_orc_def.alltypes; going to print operations logs printed operations logs going to print operations logs INFO : Compiling command(queryId=jenkins_20201113135842_e92c7535-7432-463e-8143-5df817c272df): INSERT INTO TABLE functional_orc_def.alltypes_deleted_rows SELECT * FROM functional_orc_def.alltypes INFO : No Stats for functional_orc_def@alltypes, Columns: float_col, int_col, string_col, bool_col, date_string_col, smallint_col, timestamp_col, tinyint_col, bigint_col, id, double_col INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:alltypes.id, type:int, comment:null), FieldSchema(name:alltypes.bool_col, type:boolean, comment:null), FieldSchema(name:alltypes.tinyint_col, type:tinyint, comment:null), FieldSchema(name:alltypes.smallint_col, type:smallint, comment:null), FieldSchema(name:alltypes.int_col, type:int, comment:null), FieldSchema(name:alltypes.bigint_col, type:bigint, comment:null), FieldSchema(name:alltypes.float_col, type:float, comment:null), FieldSchema(name:alltypes.double_col, type:double, comment:null), FieldSchema(name:alltypes.date_string_col, type:string, comment:null), FieldSchema(name:alltypes.string_col, type:string, comment:null), FieldSchema(name:alltypes.timestamp_col, type:timestamp, comment:null), FieldSchema(name:alltypes.year, type:int, comment:null), FieldSchema(name:alltypes.month, type:int, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135842_e92c7535-7432-463e-8143-5df817c272df); Time taken: 0.091 seconds INFO : Executing command(queryId=jenkins_20201113135842_e92c7535-7432-463e-8143-5df817c272df): INSERT INTO TABLE functional_orc_def.alltypes_deleted_rows SELECT * FROM functional_orc_def.alltypes INFO : Query ID = jenkins_20201113135842_e92c7535-7432-463e-8143-5df817c272df INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135842_e92c7535-7432-463e-8143-5df817c272df INFO : Session is already open INFO : Dag name: INSERT INTO TABLE fun...nal_orc_def.alltypes (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) printed operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ....... container RUNNING 24 18 5 1 0 0 Reducer 2 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [==================>>--------] 72% ELAPSED TIME: 1.30 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 24 24 0 0 0 0 Reducer 2 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [========================>>--] 95% ELAPSED TIME: 1.80 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 24 24 0 0 0 0 Reducer 2 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [========================>>--] 95% ELAPSED TIME: 2.30 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 24 24 0 0 0 0 Reducer 2 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [========================>>--] 95% ELAPSED TIME: 2.81 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 24 24 0 0 0 0 Reducer 2 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [========================>>--] 95% ELAPSED TIME: 3.31 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 24 24 0 0 0 0 Reducer 2 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [========================>>--] 95% ELAPSED TIME: 3.82 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 24 24 0 0 0 0 Reducer 2 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [========================>>--] 95% ELAPSED TIME: 4.33 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 24 24 0 0 0 0 Reducer 2 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [========================>>--] 95% ELAPSED TIME: 4.83 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 24 24 0 0 0 0 Reducer 2 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [========================>>--] 95% ELAPSED TIME: 5.33 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 24 24 0 0 0 0 Reducer 2 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [========================>>--] 95% ELAPSED TIME: 5.83 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 24 24 0 0 0 0 Reducer 2 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [========================>>--] 95% ELAPSED TIME: 6.33 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 24 24 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 6.83 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 24 24 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 7.28 s ---------------------------------------------------------------------------------------------- Getting log thread is interrupted, since query is done! INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.alltypes_deleted_rows partition (year=null, month=null) from hdfs://localhost:20500/test-warehouse/managed/alltypes_deleted_rows_orc_def INFO : INFO : Time taken to load dynamic partitions: 0.494 seconds INFO : Time taken for adding to write entity : 0.0 seconds INFO : Completed executing command(queryId=jenkins_20201113135842_e92c7535-7432-463e-8143-5df817c272df); Time taken: 7.464 seconds INFO : OK ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 24 24 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 7.28 s ---------------------------------------------------------------------------------------------- 7,300 rows affected (7.589 seconds) 0: jdbc:hive2://localhost:11050/default> DELETE FROM functional_orc_def.alltypes _deleted_rows WHERE month % 2 = 0 and year % 2 = 0 and id % 10 = 0; going to print operations logs printed operations logs going to print operations logs INFO : Compiling command(queryId=jenkins_20201113135850_98047843-ab05-4ad0-9561-9160147bfdea): DELETE FROM functional_orc_def.alltypes_deleted_rows WHERE month % 2 = 0 and year % 2 = 0 and id % 10 = 0 INFO : No Stats for functional_orc_def@alltypes_deleted_rows, Columns: id INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:row__id, type:struct, comment:null), FieldSchema(name:year, type:int, comment:null), FieldSchema(name:month, type:int, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135850_98047843-ab05-4ad0-9561-9160147bfdea); Time taken: 0.116 seconds INFO : Executing command(queryId=jenkins_20201113135850_98047843-ab05-4ad0-9561-9160147bfdea): DELETE FROM functional_orc_def.alltypes_deleted_rows WHERE month % 2 = 0 and year % 2 = 0 and id % 10 = 0 INFO : Query ID = jenkins_20201113135850_98047843-ab05-4ad0-9561-9160147bfdea INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135850_98047843-ab05-4ad0-9561-9160147bfdea INFO : Session is already open INFO : Dag name: DELETE FROM functional_orc_def.alltypes_...0 (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) printed operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 6 6 0 0 0 0 Reducer 2 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [======================>>----] 85% ELAPSED TIME: 1.38 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 6 6 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 1.89 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 6 6 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 2.00 s ---------------------------------------------------------------------------------------------- Getting log thread is interrupted, since query is done! INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.alltypes_deleted_rows partition (year=null, month=null) from hdfs://localhost:20500/test-warehouse/managed/alltypes_deleted_rows_orc_def/.hive-staging_hive_2020-11-13_13-58-50_084_6106788970345074174-1/-ext-10000 INFO : INFO : Time taken to load dynamic partitions: 0.144 seconds INFO : Time taken for adding to write entity : 0.0 seconds INFO : Completed executing command(queryId=jenkins_20201113135850_98047843-ab05-4ad0-9561-9160147bfdea); Time taken: 2.102 seconds INFO : OK ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 6 6 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 2.00 s ---------------------------------------------------------------------------------------------- 181 rows affected (2.235 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> SET hive.exec.compress.output=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.003 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.type=BLOC K; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition.mode=no nstrict; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions.pe rnode=10000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.003 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.max.split.size=256000000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE functional_orc_d ef.alltypesagg partition (year, month, day) . . . . . . . . . . . . . . . . . . . .> SELECT id, bool_col, tinyint_col, small int_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col , timestamp_col, year, month, day . . . . . . . . . . . . . . . . . . . .> FROM functional.alltypesagg; going to print operations logs printed operations logs going to print operations logs INFO : Compiling command(queryId=jenkins_20201113135852_07b6c2bf-5977-4069-83ca-d75184e15cc0): INSERT OVERWRITE TABLE functional_orc_def.alltypesagg partition (year, month, day) SELECT id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col, timestamp_col, year, month, day FROM functional.alltypesagg INFO : No Stats for functional@alltypesagg, Columns: float_col, int_col, string_col, bool_col, date_string_col, smallint_col, timestamp_col, tinyint_col, bigint_col, id, double_col INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:id, type:int, comment:null), FieldSchema(name:bool_col, type:boolean, comment:null), FieldSchema(name:tinyint_col, type:tinyint, comment:null), FieldSchema(name:smallint_col, type:smallint, comment:null), FieldSchema(name:int_col, type:int, comment:null), FieldSchema(name:bigint_col, type:bigint, comment:null), FieldSchema(name:float_col, type:float, comment:null), FieldSchema(name:double_col, type:double, comment:null), FieldSchema(name:date_string_col, type:string, comment:null), FieldSchema(name:string_col, type:string, comment:null), FieldSchema(name:timestamp_col, type:timestamp, comment:null), FieldSchema(name:year, type:int, comment:null), FieldSchema(name:month, type:int, comment:null), FieldSchema(name:day, type:int, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135852_07b6c2bf-5977-4069-83ca-d75184e15cc0); Time taken: 0.044 seconds INFO : Executing command(queryId=jenkins_20201113135852_07b6c2bf-5977-4069-83ca-d75184e15cc0): INSERT OVERWRITE TABLE functional_orc_def.alltypesagg partition (year, month, day) SELECT id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col, timestamp_col, year, month, day FROM functional.alltypesagg INFO : Query ID = jenkins_20201113135852_07b6c2bf-5977-4069-83ca-d75184e15cc0 INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135852_07b6c2bf-5977-4069-83ca-d75184e15cc0 INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABL...nctional.alltypesagg (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) printed operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 11 11 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 1.43 s ---------------------------------------------------------------------------------------------- Getting log thread is interrupted, since query is done! INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.alltypesagg partition (year=null, month=null, day=null) from hdfs://localhost:20500/test-warehouse/managed/alltypesagg_orc_def INFO : INFO : Time taken to load dynamic partitions: 0.214 seconds INFO : Time taken for adding to write entity : 0.001 seconds INFO : Completed executing command(queryId=jenkins_20201113135852_07b6c2bf-5977-4069-83ca-d75184e15cc0); Time taken: 1.487 seconds INFO : OK ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 11 11 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 1.44 s ---------------------------------------------------------------------------------------------- 11,000 rows affected (1.545 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> SET hive.exec.compress.output=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.type=BLOC K; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition.mode=no nstrict; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions.pe rnode=10000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.max.split.size=256000000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE functional_orc_d ef.alltypesaggnonulls partition (year, month, day) . . . . . . . . . . . . . . . . . . . .> SELECT id, bool_col, tinyint_col, small int_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col , timestamp_col, year, month, day . . . . . . . . . . . . . . . . . . . .> FROM functional.alltypesaggnonulls; going to print operations logs printed operations logs going to print operations logs INFO : Compiling command(queryId=jenkins_20201113135853_2c7e6a3b-1779-474b-b325-35096f8d5ab4): INSERT OVERWRITE TABLE functional_orc_def.alltypesaggnonulls partition (year, month, day) SELECT id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col, timestamp_col, year, month, day FROM functional.alltypesaggnonulls INFO : No Stats for functional@alltypesaggnonulls, Columns: float_col, int_col, string_col, bool_col, date_string_col, smallint_col, timestamp_col, tinyint_col, bigint_col, id, double_col INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:id, type:int, comment:null), FieldSchema(name:bool_col, type:boolean, comment:null), FieldSchema(name:tinyint_col, type:tinyint, comment:null), FieldSchema(name:smallint_col, type:smallint, comment:null), FieldSchema(name:int_col, type:int, comment:null), FieldSchema(name:bigint_col, type:bigint, comment:null), FieldSchema(name:float_col, type:float, comment:null), FieldSchema(name:double_col, type:double, comment:null), FieldSchema(name:date_string_col, type:string, comment:null), FieldSchema(name:string_col, type:string, comment:null), FieldSchema(name:timestamp_col, type:timestamp, comment:null), FieldSchema(name:year, type:int, comment:null), FieldSchema(name:month, type:int, comment:null), FieldSchema(name:day, type:int, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135853_2c7e6a3b-1779-474b-b325-35096f8d5ab4); Time taken: 0.038 seconds INFO : Executing command(queryId=jenkins_20201113135853_2c7e6a3b-1779-474b-b325-35096f8d5ab4): INSERT OVERWRITE TABLE functional_orc_def.alltypesaggnonulls partition (year, month, day) SELECT id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col, timestamp_col, year, month, day FROM functional.alltypesaggnonulls INFO : Query ID = jenkins_20201113135853_2c7e6a3b-1779-474b-b325-35096f8d5ab4 INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135853_2c7e6a3b-1779-474b-b325-35096f8d5ab4 INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABL...l.alltypesaggnonulls (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) printed operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 10 10 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 1.36 s ---------------------------------------------------------------------------------------------- Getting log thread is interrupted, since query is done! INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.alltypesaggnonulls partition (year=null, month=null, day=null) from hdfs://localhost:20500/test-warehouse/managed/alltypesaggnonulls_orc_def INFO : INFO : Time taken to load dynamic partitions: 0.192 seconds INFO : Time taken for adding to write entity : 0.0 seconds INFO : Completed executing command(queryId=jenkins_20201113135853_2c7e6a3b-1779-474b-b325-35096f8d5ab4); Time taken: 1.41 seconds INFO : OK ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 10 10 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 1.36 s ---------------------------------------------------------------------------------------------- 10,000 rows affected (1.461 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> SET hive.exec.compress.output=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.type=BLOC K; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition.mode=no nstrict; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions.pe rnode=10000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.max.split.size=256000000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE functional_orc_d ef.complextypestbl SELECT * FROM functional_parquet.complextypestbl; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135855_75d3c695-fe7c-4391-8bd4-c8a9b5662cb2): INSERT OVERWRITE TABLE functional_orc_def.complextypestbl SELECT * FROM functional_parquet.complextypestbl INFO : No Stats for functional_parquet@complextypestbl, Columns: int_array, int_map_array, id, int_array_array, nested_struct, int_map INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:complextypestbl.id, type:bigint, comment:null), FieldSchema(name:complextypestbl.int_array, type:array, comment:null), FieldSchema(name:complextypestbl.int_array_array, type:array>, comment:null), FieldSchema(name:complextypestbl.int_map, type:map, comment:null), FieldSchema(name:complextypestbl.int_map_array, type:array>, comment:null), FieldSchema(name:complextypestbl.nested_struct, type:struct,c:struct>>>,g:map>>>>, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135855_75d3c695-fe7c-4391-8bd4-c8a9b5662cb2); Time taken: 0.038 seconds INFO : Executing command(queryId=jenkins_20201113135855_75d3c695-fe7c-4391-8bd4-c8a9b5662cb2): INSERT OVERWRITE TABLE functional_orc_def.complextypestbl SELECT * FROM functional_parquet.complextypestbl INFO : Query ID = jenkins_20201113135855_75d3c695-fe7c-4391-8bd4-c8a9b5662cb2 INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135855_75d3c695-fe7c-4391-8bd4-c8a9b5662cb2 INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABL...quet.complextypestbl (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.complextypestbl from hdfs://localhost:20500/test-warehouse/managed/complextypestbl_orc_def INFO : Completed executing command(queryId=jenkins_20201113135855_75d3c695-fe7c-4391-8bd4-c8a9b5662cb2); Time taken: 0.793 seconds INFO : OK 8 rows affected (0.85 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> SET hive.exec.compress.output=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.type=BLOC K; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition.mode=no nstrict; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions.pe rnode=10000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.max.split.size=256000000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.018 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT INTO TABLE functional_orc_def.co mplextypestbl_minor_compacted SELECT * FROM functional_orc_def.complextypestbl w here id = 1; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135856_7489a5dc-f8b0-43cf-bdc6-8de57b8a91d1): INSERT INTO TABLE functional_orc_def.complextypestbl_minor_compacted SELECT * FROM functional_orc_def.complextypestbl where id = 1 INFO : No Stats for functional_orc_def@complextypestbl, Columns: int_array, int_map_array, id, int_array_array, nested_struct, int_map INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:complextypestbl.id, type:bigint, comment:null), FieldSchema(name:complextypestbl.int_array, type:array, comment:null), FieldSchema(name:complextypestbl.int_array_array, type:array>, comment:null), FieldSchema(name:complextypestbl.int_map, type:map, comment:null), FieldSchema(name:complextypestbl.int_map_array, type:array>, comment:null), FieldSchema(name:complextypestbl.nested_struct, type:struct,c:struct>>>,g:map>>>>, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135856_7489a5dc-f8b0-43cf-bdc6-8de57b8a91d1); Time taken: 0.038 seconds INFO : Executing command(queryId=jenkins_20201113135856_7489a5dc-f8b0-43cf-bdc6-8de57b8a91d1): INSERT INTO TABLE functional_orc_def.complextypestbl_minor_compacted SELECT * FROM functional_orc_def.complextypestbl where id = 1 INFO : Query ID = jenkins_20201113135856_7489a5dc-f8b0-43cf-bdc6-8de57b8a91d1 INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135856_7489a5dc-f8b0-43cf-bdc6-8de57b8a91d1 INFO : Session is already open INFO : Dag name: INSERT INTO TABLE functional_orc_def.com...1 (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.complextypestbl_minor_compacted from hdfs://localhost:20500/test-warehouse/managed/complextypestbl_minor_compacted_orc_def INFO : Completed executing command(queryId=jenkins_20201113135856_7489a5dc-f8b0-43cf-bdc6-8de57b8a91d1); Time taken: 0.238 seconds INFO : OK 1 row affected (0.289 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT INTO TABLE functional_orc_def.co mplextypestbl_minor_compacted SELECT * FROM functional_orc_def.complextypestbl w here id = 2; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135856_6626d1df-4a06-4012-88d6-3703bcd99b74): INSERT INTO TABLE functional_orc_def.complextypestbl_minor_compacted SELECT * FROM functional_orc_def.complextypestbl where id = 2 INFO : No Stats for functional_orc_def@complextypestbl, Columns: int_array, int_map_array, id, int_array_array, nested_struct, int_map INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:complextypestbl.id, type:bigint, comment:null), FieldSchema(name:complextypestbl.int_array, type:array, comment:null), FieldSchema(name:complextypestbl.int_array_array, type:array>, comment:null), FieldSchema(name:complextypestbl.int_map, type:map, comment:null), FieldSchema(name:complextypestbl.int_map_array, type:array>, comment:null), FieldSchema(name:complextypestbl.nested_struct, type:struct,c:struct>>>,g:map>>>>, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135856_6626d1df-4a06-4012-88d6-3703bcd99b74); Time taken: 0.034 seconds INFO : Executing command(queryId=jenkins_20201113135856_6626d1df-4a06-4012-88d6-3703bcd99b74): INSERT INTO TABLE functional_orc_def.complextypestbl_minor_compacted SELECT * FROM functional_orc_def.complextypestbl where id = 2 INFO : Query ID = jenkins_20201113135856_6626d1df-4a06-4012-88d6-3703bcd99b74 INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135856_6626d1df-4a06-4012-88d6-3703bcd99b74 INFO : Session is already open INFO : Dag name: INSERT INTO TABLE functional_orc_def.com...2 (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.complextypestbl_minor_compacted from hdfs://localhost:20500/test-warehouse/managed/complextypestbl_minor_compacted_orc_def INFO : Completed executing command(queryId=jenkins_20201113135856_6626d1df-4a06-4012-88d6-3703bcd99b74); Time taken: 0.281 seconds INFO : OK 1 row affected (0.328 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT INTO TABLE functional_orc_def.co mplextypestbl_minor_compacted SELECT * FROM functional_orc_def.complextypestbl w here id = 3; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135856_0d1ef7a0-2941-4636-b593-951e14b66f83): INSERT INTO TABLE functional_orc_def.complextypestbl_minor_compacted SELECT * FROM functional_orc_def.complextypestbl where id = 3 INFO : No Stats for functional_orc_def@complextypestbl, Columns: int_array, int_map_array, id, int_array_array, nested_struct, int_map INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:complextypestbl.id, type:bigint, comment:null), FieldSchema(name:complextypestbl.int_array, type:array, comment:null), FieldSchema(name:complextypestbl.int_array_array, type:array>, comment:null), FieldSchema(name:complextypestbl.int_map, type:map, comment:null), FieldSchema(name:complextypestbl.int_map_array, type:array>, comment:null), FieldSchema(name:complextypestbl.nested_struct, type:struct,c:struct>>>,g:map>>>>, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135856_0d1ef7a0-2941-4636-b593-951e14b66f83); Time taken: 0.031 seconds INFO : Executing command(queryId=jenkins_20201113135856_0d1ef7a0-2941-4636-b593-951e14b66f83): INSERT INTO TABLE functional_orc_def.complextypestbl_minor_compacted SELECT * FROM functional_orc_def.complextypestbl where id = 3 INFO : Query ID = jenkins_20201113135856_0d1ef7a0-2941-4636-b593-951e14b66f83 INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135856_0d1ef7a0-2941-4636-b593-951e14b66f83 INFO : Session is already open INFO : Dag name: INSERT INTO TABLE functional_orc_def.com...3 (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.complextypestbl_minor_compacted from hdfs://localhost:20500/test-warehouse/managed/complextypestbl_minor_compacted_orc_def INFO : Completed executing command(queryId=jenkins_20201113135856_0d1ef7a0-2941-4636-b593-951e14b66f83); Time taken: 0.226 seconds INFO : OK 1 row affected (0.27 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT INTO TABLE functional_orc_def.co mplextypestbl_minor_compacted SELECT * FROM functional_orc_def.complextypestbl w here id = 4; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135857_429c66b8-1ec5-447b-9c83-b399c3dad778): INSERT INTO TABLE functional_orc_def.complextypestbl_minor_compacted SELECT * FROM functional_orc_def.complextypestbl where id = 4 INFO : No Stats for functional_orc_def@complextypestbl, Columns: int_array, int_map_array, id, int_array_array, nested_struct, int_map INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:complextypestbl.id, type:bigint, comment:null), FieldSchema(name:complextypestbl.int_array, type:array, comment:null), FieldSchema(name:complextypestbl.int_array_array, type:array>, comment:null), FieldSchema(name:complextypestbl.int_map, type:map, comment:null), FieldSchema(name:complextypestbl.int_map_array, type:array>, comment:null), FieldSchema(name:complextypestbl.nested_struct, type:struct,c:struct>>>,g:map>>>>, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135857_429c66b8-1ec5-447b-9c83-b399c3dad778); Time taken: 0.026 seconds INFO : Executing command(queryId=jenkins_20201113135857_429c66b8-1ec5-447b-9c83-b399c3dad778): INSERT INTO TABLE functional_orc_def.complextypestbl_minor_compacted SELECT * FROM functional_orc_def.complextypestbl where id = 4 INFO : Query ID = jenkins_20201113135857_429c66b8-1ec5-447b-9c83-b399c3dad778 INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135857_429c66b8-1ec5-447b-9c83-b399c3dad778 INFO : Session is already open INFO : Dag name: INSERT INTO TABLE functional_orc_def.com...4 (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.complextypestbl_minor_compacted from hdfs://localhost:20500/test-warehouse/managed/complextypestbl_minor_compacted_orc_def INFO : Completed executing command(queryId=jenkins_20201113135857_429c66b8-1ec5-447b-9c83-b399c3dad778); Time taken: 0.295 seconds INFO : OK 1 row affected (0.333 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT INTO TABLE functional_orc_def.co mplextypestbl_minor_compacted SELECT * FROM functional_orc_def.complextypestbl w here id = 5; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135857_e934468d-16a9-4901-a054-b94de8ccc3ae): INSERT INTO TABLE functional_orc_def.complextypestbl_minor_compacted SELECT * FROM functional_orc_def.complextypestbl where id = 5 INFO : No Stats for functional_orc_def@complextypestbl, Columns: int_array, int_map_array, id, int_array_array, nested_struct, int_map INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:complextypestbl.id, type:bigint, comment:null), FieldSchema(name:complextypestbl.int_array, type:array, comment:null), FieldSchema(name:complextypestbl.int_array_array, type:array>, comment:null), FieldSchema(name:complextypestbl.int_map, type:map, comment:null), FieldSchema(name:complextypestbl.int_map_array, type:array>, comment:null), FieldSchema(name:complextypestbl.nested_struct, type:struct,c:struct>>>,g:map>>>>, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135857_e934468d-16a9-4901-a054-b94de8ccc3ae); Time taken: 0.03 seconds INFO : Executing command(queryId=jenkins_20201113135857_e934468d-16a9-4901-a054-b94de8ccc3ae): INSERT INTO TABLE functional_orc_def.complextypestbl_minor_compacted SELECT * FROM functional_orc_def.complextypestbl where id = 5 INFO : Query ID = jenkins_20201113135857_e934468d-16a9-4901-a054-b94de8ccc3ae INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135857_e934468d-16a9-4901-a054-b94de8ccc3ae INFO : Session is already open INFO : Dag name: INSERT INTO TABLE functional_orc_def.com...5 (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.complextypestbl_minor_compacted from hdfs://localhost:20500/test-warehouse/managed/complextypestbl_minor_compacted_orc_def INFO : Completed executing command(queryId=jenkins_20201113135857_e934468d-16a9-4901-a054-b94de8ccc3ae); Time taken: 0.201 seconds INFO : OK 1 row affected (0.243 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT INTO TABLE functional_orc_def.co mplextypestbl_minor_compacted SELECT * FROM functional_orc_def.complextypestbl w here id = 6; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135857_8975cb5e-0114-4036-861c-1a38af95e58a): INSERT INTO TABLE functional_orc_def.complextypestbl_minor_compacted SELECT * FROM functional_orc_def.complextypestbl where id = 6 INFO : No Stats for functional_orc_def@complextypestbl, Columns: int_array, int_map_array, id, int_array_array, nested_struct, int_map INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:complextypestbl.id, type:bigint, comment:null), FieldSchema(name:complextypestbl.int_array, type:array, comment:null), FieldSchema(name:complextypestbl.int_array_array, type:array>, comment:null), FieldSchema(name:complextypestbl.int_map, type:map, comment:null), FieldSchema(name:complextypestbl.int_map_array, type:array>, comment:null), FieldSchema(name:complextypestbl.nested_struct, type:struct,c:struct>>>,g:map>>>>, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135857_8975cb5e-0114-4036-861c-1a38af95e58a); Time taken: 0.037 seconds INFO : Executing command(queryId=jenkins_20201113135857_8975cb5e-0114-4036-861c-1a38af95e58a): INSERT INTO TABLE functional_orc_def.complextypestbl_minor_compacted SELECT * FROM functional_orc_def.complextypestbl where id = 6 INFO : Query ID = jenkins_20201113135857_8975cb5e-0114-4036-861c-1a38af95e58a INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135857_8975cb5e-0114-4036-861c-1a38af95e58a INFO : Session is already open INFO : Dag name: INSERT INTO TABLE functional_orc_def.com...6 (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.complextypestbl_minor_compacted from hdfs://localhost:20500/test-warehouse/managed/complextypestbl_minor_compacted_orc_def INFO : Completed executing command(queryId=jenkins_20201113135857_8975cb5e-0114-4036-861c-1a38af95e58a); Time taken: 0.2 seconds INFO : OK 1 row affected (0.25 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT INTO TABLE functional_orc_def.co mplextypestbl_minor_compacted SELECT * FROM functional_orc_def.complextypestbl w here id = 7; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135858_d0db1280-9abc-460f-8c0f-897e341431d6): INSERT INTO TABLE functional_orc_def.complextypestbl_minor_compacted SELECT * FROM functional_orc_def.complextypestbl where id = 7 INFO : No Stats for functional_orc_def@complextypestbl, Columns: int_array, int_map_array, id, int_array_array, nested_struct, int_map INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:complextypestbl.id, type:bigint, comment:null), FieldSchema(name:complextypestbl.int_array, type:array, comment:null), FieldSchema(name:complextypestbl.int_array_array, type:array>, comment:null), FieldSchema(name:complextypestbl.int_map, type:map, comment:null), FieldSchema(name:complextypestbl.int_map_array, type:array>, comment:null), FieldSchema(name:complextypestbl.nested_struct, type:struct,c:struct>>>,g:map>>>>, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135858_d0db1280-9abc-460f-8c0f-897e341431d6); Time taken: 0.03 seconds INFO : Executing command(queryId=jenkins_20201113135858_d0db1280-9abc-460f-8c0f-897e341431d6): INSERT INTO TABLE functional_orc_def.complextypestbl_minor_compacted SELECT * FROM functional_orc_def.complextypestbl where id = 7 INFO : Query ID = jenkins_20201113135858_d0db1280-9abc-460f-8c0f-897e341431d6 INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135858_d0db1280-9abc-460f-8c0f-897e341431d6 INFO : Session is already open INFO : Dag name: INSERT INTO TABLE functional_orc_def.com...7 (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.complextypestbl_minor_compacted from hdfs://localhost:20500/test-warehouse/managed/complextypestbl_minor_compacted_orc_def INFO : Completed executing command(queryId=jenkins_20201113135858_d0db1280-9abc-460f-8c0f-897e341431d6); Time taken: 0.297 seconds INFO : OK 1 row affected (0.34 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT INTO TABLE functional_orc_def.co mplextypestbl_minor_compacted SELECT * FROM functional_orc_def.complextypestbl w here id = 8; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135858_f1ca244e-5a6f-4c66-8154-2c4ac85e6309): INSERT INTO TABLE functional_orc_def.complextypestbl_minor_compacted SELECT * FROM functional_orc_def.complextypestbl where id = 8 INFO : No Stats for functional_orc_def@complextypestbl, Columns: int_array, int_map_array, id, int_array_array, nested_struct, int_map INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:complextypestbl.id, type:bigint, comment:null), FieldSchema(name:complextypestbl.int_array, type:array, comment:null), FieldSchema(name:complextypestbl.int_array_array, type:array>, comment:null), FieldSchema(name:complextypestbl.int_map, type:map, comment:null), FieldSchema(name:complextypestbl.int_map_array, type:array>, comment:null), FieldSchema(name:complextypestbl.nested_struct, type:struct,c:struct>>>,g:map>>>>, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135858_f1ca244e-5a6f-4c66-8154-2c4ac85e6309); Time taken: 0.028 seconds INFO : Executing command(queryId=jenkins_20201113135858_f1ca244e-5a6f-4c66-8154-2c4ac85e6309): INSERT INTO TABLE functional_orc_def.complextypestbl_minor_compacted SELECT * FROM functional_orc_def.complextypestbl where id = 8 INFO : Query ID = jenkins_20201113135858_f1ca244e-5a6f-4c66-8154-2c4ac85e6309 INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135858_f1ca244e-5a6f-4c66-8154-2c4ac85e6309 INFO : Session is already open INFO : Dag name: INSERT INTO TABLE functional_orc_def.com...8 (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.complextypestbl_minor_compacted from hdfs://localhost:20500/test-warehouse/managed/complextypestbl_minor_compacted_orc_def INFO : Completed executing command(queryId=jenkins_20201113135858_f1ca244e-5a6f-4c66-8154-2c4ac85e6309); Time taken: 0.198 seconds INFO : OK 1 row affected (0.238 seconds) 0: jdbc:hive2://localhost:11050/default> ALTER TABLE functional_orc_def.complext ypestbl_minor_compacted compact 'minor'; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135858_0c292cff-b44e-451d-ae2e-257373f6f224): ALTER TABLE functional_orc_def.complextypestbl_minor_compacted compact 'minor' INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:null, properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135858_0c292cff-b44e-451d-ae2e-257373f6f224); Time taken: 0.005 seconds INFO : Executing command(queryId=jenkins_20201113135858_0c292cff-b44e-451d-ae2e-257373f6f224): ALTER TABLE functional_orc_def.complextypestbl_minor_compacted compact 'minor' INFO : Starting task [Stage-0:DDL] in serial mode INFO : Compaction enqueued with id 1 INFO : Completed executing command(queryId=jenkins_20201113135858_0c292cff-b44e-451d-ae2e-257373f6f224); Time taken: 0.026 seconds INFO : OK No rows affected (0.037 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> SET hive.exec.compress.output=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.type=BLOC K; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition.mode=no nstrict; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions.pe rnode=10000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.max.split.size=256000000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT INTO TABLE functional_orc_def.co mplextypestbl_deleted_rows SELECT * FROM functional_orc_def.complextypestbl; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135858_ca56f161-d048-46a0-94da-511dac487989): INSERT INTO TABLE functional_orc_def.complextypestbl_deleted_rows SELECT * FROM functional_orc_def.complextypestbl INFO : No Stats for functional_orc_def@complextypestbl, Columns: int_array, int_map_array, id, int_array_array, nested_struct, int_map INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:complextypestbl.id, type:bigint, comment:null), FieldSchema(name:complextypestbl.int_array, type:array, comment:null), FieldSchema(name:complextypestbl.int_array_array, type:array>, comment:null), FieldSchema(name:complextypestbl.int_map, type:map, comment:null), FieldSchema(name:complextypestbl.int_map_array, type:array>, comment:null), FieldSchema(name:complextypestbl.nested_struct, type:struct,c:struct>>>,g:map>>>>, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135858_ca56f161-d048-46a0-94da-511dac487989); Time taken: 0.025 seconds INFO : Executing command(queryId=jenkins_20201113135858_ca56f161-d048-46a0-94da-511dac487989): INSERT INTO TABLE functional_orc_def.complextypestbl_deleted_rows SELECT * FROM functional_orc_def.complextypestbl INFO : Query ID = jenkins_20201113135858_ca56f161-d048-46a0-94da-511dac487989 INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135858_ca56f161-d048-46a0-94da-511dac487989 INFO : Session is already open INFO : Dag name: INSERT INTO TABLE fun..._def.complextypestbl (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.complextypestbl_deleted_rows from hdfs://localhost:20500/test-warehouse/managed/complextypestbl_deleted_rows_orc_def INFO : Completed executing command(queryId=jenkins_20201113135858_ca56f161-d048-46a0-94da-511dac487989); Time taken: 0.247 seconds INFO : OK 8 rows affected (0.283 seconds) 0: jdbc:hive2://localhost:11050/default> DELETE FROM functional_orc_def.complext ypestbl_deleted_rows WHERE id % 2 = 0; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135858_0d3aaf2b-6685-48ed-9d31-6d021ece1f6b): DELETE FROM functional_orc_def.complextypestbl_deleted_rows WHERE id % 2 = 0 INFO : No Stats for functional_orc_def@complextypestbl_deleted_rows, Columns: id INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:row__id, type:struct, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135858_0d3aaf2b-6685-48ed-9d31-6d021ece1f6b); Time taken: 0.032 seconds INFO : Executing command(queryId=jenkins_20201113135858_0d3aaf2b-6685-48ed-9d31-6d021ece1f6b): DELETE FROM functional_orc_def.complextypestbl_deleted_rows WHERE id % 2 = 0 INFO : Query ID = jenkins_20201113135858_0d3aaf2b-6685-48ed-9d31-6d021ece1f6b INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135858_0d3aaf2b-6685-48ed-9d31-6d021ece1f6b INFO : Session is already open INFO : Dag name: DELETE FROM functional_orc_def.complexty...0 (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.complextypestbl_deleted_rows from hdfs://localhost:20500/test-warehouse/managed/complextypestbl_deleted_rows_orc_def/.hive-staging_hive_2020-11-13_13-58-58_998_139890911308732629-1/-ext-10000 INFO : Completed executing command(queryId=jenkins_20201113135858_0d3aaf2b-6685-48ed-9d31-6d021ece1f6b); Time taken: 0.372 seconds INFO : OK 4 rows affected (0.418 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> SET hive.exec.compress.output=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.type=BLOC K; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition.mode=no nstrict; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions.pe rnode=10000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.max.split.size=256000000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> -- This INSERT must run in Hive, becaus e Impala doesn't support inserting into tables 0: jdbc:hive2://localhost:11050/default> -- with complex types. 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE functional_orc_d ef.complextypestbl_medium SELECT c.* FROM functional_parquet.complextypestbl c j oin functional.alltypes sort by id; going to print operations logs printed operations logs going to print operations logs INFO : Compiling command(queryId=jenkins_20201113135859_cb901fe3-5dbf-4b72-87fb-f8d2e5ed2a6c): INSERT OVERWRITE TABLE functional_orc_def.complextypestbl_medium SELECT c.* FROM functional_parquet.complextypestbl c join functional.alltypes sort by id INFO : No Stats for functional_parquet@complextypestbl, Columns: int_array, int_map_array, id, int_array_array, nested_struct, int_map INFO : Warning: Map Join MAPJOIN[11][bigTable=?] in task 'Map 2' is a cross product INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:c.id, type:bigint, comment:null), FieldSchema(name:c.int_array, type:array, comment:null), FieldSchema(name:c.int_array_array, type:array>, comment:null), FieldSchema(name:c.int_map, type:map, comment:null), FieldSchema(name:c.int_map_array, type:array>, comment:null), FieldSchema(name:c.nested_struct, type:struct,c:struct>>>,g:map>>>>, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135859_cb901fe3-5dbf-4b72-87fb-f8d2e5ed2a6c); Time taken: 0.117 seconds INFO : Executing command(queryId=jenkins_20201113135859_cb901fe3-5dbf-4b72-87fb-f8d2e5ed2a6c): INSERT OVERWRITE TABLE functional_orc_def.complextypestbl_medium SELECT c.* FROM functional_parquet.complextypestbl c join functional.alltypes sort by id INFO : Query ID = jenkins_20201113135859_cb901fe3-5dbf-4b72-87fb-f8d2e5ed2a6c INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135859_cb901fe3-5dbf-4b72-87fb-f8d2e5ed2a6c INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABLE functional_orc_d...id (Stage-1) INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896 INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) printed operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 2 2 0 0 0 0 Map 2 .. container RUNNING 24 5 6 13 0 0 Reducer 3 container INITED 3 0 0 3 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/03 [======>>--------------------] 24% ELAPSED TIME: 1.29 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 2 2 0 0 0 0 Map 2 .. container RUNNING 24 7 5 12 0 0 Reducer 3 container INITED 3 0 0 3 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/03 [========>>------------------] 31% ELAPSED TIME: 1.81 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 2 2 0 0 0 0 Map 2 ..... container RUNNING 24 13 5 6 0 0 Reducer 3 container INITED 3 0 0 3 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/03 [=============>>-------------] 51% ELAPSED TIME: 2.34 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 2 2 0 0 0 0 Map 2 ....... container RUNNING 24 19 5 0 0 0 Reducer 3 container RUNNING 3 0 1 2 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/03 [==================>>--------] 72% ELAPSED TIME: 2.85 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 2 2 0 0 0 0 Map 2 ......... container RUNNING 24 23 1 0 1 0 Reducer 3 container RUNNING 3 0 3 0 1 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/03 [======================>>----] 86% ELAPSED TIME: 3.35 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 2 2 0 0 0 0 Map 2 ......... container RUNNING 24 23 1 0 1 0 Reducer 3 container RUNNING 3 0 3 0 1 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/03 [======================>>----] 86% ELAPSED TIME: 3.85 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 2 2 0 0 0 0 Map 2 ......... container RUNNING 24 23 1 0 1 0 Reducer 3 container RUNNING 3 0 3 0 1 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/03 [======================>>----] 86% ELAPSED TIME: 4.35 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 2 2 0 0 0 0 Map 2 ......... container RUNNING 24 23 1 0 1 0 Reducer 3 container RUNNING 3 0 3 0 1 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/03 [======================>>----] 86% ELAPSED TIME: 4.85 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 2 2 0 0 0 0 Map 2 ......... container RUNNING 24 23 1 0 1 0 Reducer 3 container RUNNING 3 0 3 0 1 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/03 [======================>>----] 86% ELAPSED TIME: 5.35 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 2 2 0 0 0 0 Map 2 ......... container RUNNING 24 23 1 0 1 0 Reducer 3 container RUNNING 3 0 3 0 1 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/03 [======================>>----] 86% ELAPSED TIME: 5.85 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 2 2 0 0 0 0 Map 2 ......... container RUNNING 24 23 1 0 1 0 Reducer 3 container RUNNING 3 0 3 0 1 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/03 [======================>>----] 86% ELAPSED TIME: 6.35 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 2 2 0 0 0 0 Map 2 ......... container RUNNING 24 23 1 0 1 0 Reducer 3 container RUNNING 3 0 3 0 1 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/03 [======================>>----] 86% ELAPSED TIME: 6.86 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 2 2 0 0 0 0 Map 2 ......... container RUNNING 24 23 1 0 1 0 Reducer 3 container RUNNING 3 0 3 0 1 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/03 [======================>>----] 86% ELAPSED TIME: 7.36 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 2 2 0 0 0 0 Map 2 ......... container RUNNING 24 23 1 0 1 0 Reducer 3 container RUNNING 3 0 3 0 1 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/03 [======================>>----] 86% ELAPSED TIME: 7.86 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 2 2 0 0 0 0 Map 2 .......... container SUCCEEDED 24 24 0 0 1 0 Reducer 3 container RUNNING 3 0 3 0 1 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/03 [=======================>>---] 89% ELAPSED TIME: 8.36 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 2 2 0 0 0 0 Map 2 .......... container SUCCEEDED 24 24 0 0 1 0 Reducer 3 .... container RUNNING 3 2 1 0 1 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/03 [=========================>>-] 96% ELAPSED TIME: 8.86 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 2 2 0 0 0 0 Map 2 .......... container SUCCEEDED 24 24 0 0 1 0 Reducer 3 ...... container SUCCEEDED 3 3 0 0 1 0 ---------------------------------------------------------------------------------------------- VERTICES: 03/03 [==========================>>] 100% ELAPSED TIME: 8.93 s ---------------------------------------------------------------------------------------------- Getting log thread is interrupted, since query is done! INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.complextypestbl_medium from hdfs://localhost:20500/test-warehouse/managed/complextypestbl_medium_orc_def INFO : Completed executing command(queryId=jenkins_20201113135859_cb901fe3-5dbf-4b72-87fb-f8d2e5ed2a6c); Time taken: 9.153 seconds INFO : OK ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 2 2 0 0 0 0 Map 2 .......... container SUCCEEDED 24 24 0 0 1 0 Reducer 3 ...... container SUCCEEDED 3 3 0 0 1 0 ---------------------------------------------------------------------------------------------- VERTICES: 03/03 [==========================>>] 100% ELAPSED TIME: 8.93 s ---------------------------------------------------------------------------------------------- 58,400 rows affected (9.286 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> SET hive.exec.compress.output=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.type=BLOC K; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition.mode=no nstrict; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions.pe rnode=10000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.max.split.size=256000000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> -- This INSERT must run in Hive, becaus e Impala doesn't support inserting into tables 0: jdbc:hive2://localhost:11050/default> -- with complex types. 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE functional_orc_d ef.complextypes_fileformat SELECT * FROM functional.complextypes_fileformat; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135908_25c9a54f-95e2-49b1-9cd0-2f10ca9786fe): INSERT OVERWRITE TABLE functional_orc_def.complextypes_fileformat SELECT * FROM functional.complextypes_fileformat INFO : No Stats for functional@complextypes_fileformat, Columns: a, s, id, m INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:complextypes_fileformat.id, type:int, comment:null), FieldSchema(name:complextypes_fileformat.s, type:struct, comment:null), FieldSchema(name:complextypes_fileformat.a, type:array, comment:null), FieldSchema(name:complextypes_fileformat.m, type:map, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135908_25c9a54f-95e2-49b1-9cd0-2f10ca9786fe); Time taken: 0.032 seconds INFO : Executing command(queryId=jenkins_20201113135908_25c9a54f-95e2-49b1-9cd0-2f10ca9786fe): INSERT OVERWRITE TABLE functional_orc_def.complextypes_fileformat SELECT * FROM functional.complextypes_fileformat INFO : Query ID = jenkins_20201113135908_25c9a54f-95e2-49b1-9cd0-2f10ca9786fe INFO : Total jobs = 3 INFO : Launching Job 1 out of 3 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135908_25c9a54f-95e2-49b1-9cd0-2f10ca9786fe INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABL...plextypes_fileformat (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) INFO : Starting task [Stage-7:CONDITIONAL] in serial mode INFO : Stage-4 is selected by condition resolver. INFO : Stage-3 is filtered out by condition resolver. INFO : Stage-5 is filtered out by condition resolver. INFO : Starting task [Stage-4:MOVE] in serial mode INFO : Moving data to directory hdfs://localhost:20500/test-warehouse/functional_orc_def.db/complextypes_fileformat/.hive-staging_hive_2020-11-13_13-59-08_754_9211718098909608264-1/-ext-10000 from hdfs://localhost:20500/test-warehouse/functional_orc_def.db/complextypes_fileformat/.hive-staging_hive_2020-11-13_13-59-08_754_9211718098909608264-1/-ext-10002 INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.complextypes_fileformat from hdfs://localhost:20500/test-warehouse/functional_orc_def.db/complextypes_fileformat/.hive-staging_hive_2020-11-13_13-59-08_754_9211718098909608264-1/-ext-10000 INFO : Completed executing command(queryId=jenkins_20201113135908_25c9a54f-95e2-49b1-9cd0-2f10ca9786fe); Time taken: 0.195 seconds INFO : OK 8 rows affected (0.234 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> SET hive.exec.compress.output=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.type=BLOC K; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition.mode=no nstrict; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions.pe rnode=10000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.max.split.size=256000000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE functional_orc_d ef.dimtbl SELECT * FROM functional.dimtbl; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135909_5168dab3-e844-4276-9083-5742581dda65): INSERT OVERWRITE TABLE functional_orc_def.dimtbl SELECT * FROM functional.dimtbl INFO : No Stats for functional@dimtbl, Columns: zip, name, id INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:dimtbl.id, type:bigint, comment:null), FieldSchema(name:dimtbl.name, type:string, comment:null), FieldSchema(name:dimtbl.zip, type:int, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135909_5168dab3-e844-4276-9083-5742581dda65); Time taken: 0.036 seconds INFO : Executing command(queryId=jenkins_20201113135909_5168dab3-e844-4276-9083-5742581dda65): INSERT OVERWRITE TABLE functional_orc_def.dimtbl SELECT * FROM functional.dimtbl INFO : Query ID = jenkins_20201113135909_5168dab3-e844-4276-9083-5742581dda65 INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135909_5168dab3-e844-4276-9083-5742581dda65 INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABLE f...functional.dimtbl (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.dimtbl from hdfs://localhost:20500/test-warehouse/managed/dimtbl_orc_def INFO : Completed executing command(queryId=jenkins_20201113135909_5168dab3-e844-4276-9083-5742581dda65); Time taken: 0.161 seconds INFO : OK 10 rows affected (0.212 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> SET hive.exec.compress.output=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.type=BLOC K; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition.mode=no nstrict; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions.pe rnode=10000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.max.split.size=256000000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE functional_orc_d ef.jointbl SELECT * FROM functional.jointbl; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135909_69af0f4e-ab48-416c-9d07-33ea919a809b): INSERT OVERWRITE TABLE functional_orc_def.jointbl SELECT * FROM functional.jointbl INFO : No Stats for functional@jointbl, Columns: alltypes_id, test_name, test_zip, test_id INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:jointbl.test_id, type:bigint, comment:null), FieldSchema(name:jointbl.test_name, type:string, comment:null), FieldSchema(name:jointbl.test_zip, type:int, comment:null), FieldSchema(name:jointbl.alltypes_id, type:int, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135909_69af0f4e-ab48-416c-9d07-33ea919a809b); Time taken: 0.03 seconds INFO : Executing command(queryId=jenkins_20201113135909_69af0f4e-ab48-416c-9d07-33ea919a809b): INSERT OVERWRITE TABLE functional_orc_def.jointbl SELECT * FROM functional.jointbl INFO : Query ID = jenkins_20201113135909_69af0f4e-ab48-416c-9d07-33ea919a809b INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135909_69af0f4e-ab48-416c-9d07-33ea919a809b INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABLE ...functional.jointbl (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.jointbl from hdfs://localhost:20500/test-warehouse/managed/jointbl_orc_def INFO : Completed executing command(queryId=jenkins_20201113135909_69af0f4e-ab48-416c-9d07-33ea919a809b); Time taken: 0.197 seconds INFO : OK 19 rows affected (0.239 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> SET hive.exec.compress.output=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.type=BLOC K; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition.mode=no nstrict; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.004 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions.pe rnode=10000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.max.split.size=256000000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE functional_orc_d ef.liketbl SELECT * FROM functional.liketbl; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135909_eb2051b2-3c34-4cfd-806c-cc521d323359): INSERT OVERWRITE TABLE functional_orc_def.liketbl SELECT * FROM functional.liketbl INFO : No Stats for functional@liketbl, Columns: str_col, no_match_like_col, match_regex_col, no_match_regex_col, match_like_col INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:liketbl.str_col, type:string, comment:null), FieldSchema(name:liketbl.match_like_col, type:string, comment:null), FieldSchema(name:liketbl.no_match_like_col, type:string, comment:null), FieldSchema(name:liketbl.match_regex_col, type:string, comment:null), FieldSchema(name:liketbl.no_match_regex_col, type:string, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135909_eb2051b2-3c34-4cfd-806c-cc521d323359); Time taken: 0.032 seconds INFO : Executing command(queryId=jenkins_20201113135909_eb2051b2-3c34-4cfd-806c-cc521d323359): INSERT OVERWRITE TABLE functional_orc_def.liketbl SELECT * FROM functional.liketbl INFO : Query ID = jenkins_20201113135909_eb2051b2-3c34-4cfd-806c-cc521d323359 INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135909_eb2051b2-3c34-4cfd-806c-cc521d323359 INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABLE ...functional.liketbl (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.liketbl from hdfs://localhost:20500/test-warehouse/managed/liketbl_orc_def INFO : Completed executing command(queryId=jenkins_20201113135909_eb2051b2-3c34-4cfd-806c-cc521d323359); Time taken: 0.137 seconds INFO : OK 15 rows affected (0.18 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> SET hive.exec.compress.output=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.type=BLOC K; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition.mode=no nstrict; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions.pe rnode=10000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.max.split.size=256000000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE functional_orc_d ef.widerow SELECT * FROM functional.widerow; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135909_9bce98a9-ff6b-40a6-8d04-cf5a1c93dd73): INSERT OVERWRITE TABLE functional_orc_def.widerow SELECT * FROM functional.widerow INFO : No Stats for functional@widerow, Columns: string_col INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:widerow.string_col, type:string, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135909_9bce98a9-ff6b-40a6-8d04-cf5a1c93dd73); Time taken: 0.025 seconds INFO : Executing command(queryId=jenkins_20201113135909_9bce98a9-ff6b-40a6-8d04-cf5a1c93dd73): INSERT OVERWRITE TABLE functional_orc_def.widerow SELECT * FROM functional.widerow INFO : Query ID = jenkins_20201113135909_9bce98a9-ff6b-40a6-8d04-cf5a1c93dd73 INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135909_9bce98a9-ff6b-40a6-8d04-cf5a1c93dd73 INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABLE ...functional.widerow (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.widerow from hdfs://localhost:20500/test-warehouse/managed/widerow_orc_def INFO : Completed executing command(queryId=jenkins_20201113135909_9bce98a9-ff6b-40a6-8d04-cf5a1c93dd73); Time taken: 0.889 seconds INFO : OK 1 row affected (0.929 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> SET hive.exec.compress.output=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.type=BLOC K; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition.mode=no nstrict; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions.pe rnode=10000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.max.split.size=256000000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE functional_orc_d ef.greptiny SELECT * FROM functional.greptiny; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135910_98d80d3f-4dba-428a-b57b-f683734fdfdf): INSERT OVERWRITE TABLE functional_orc_def.greptiny SELECT * FROM functional.greptiny INFO : No Stats for functional@greptiny, Columns: field INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:greptiny.field, type:string, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135910_98d80d3f-4dba-428a-b57b-f683734fdfdf); Time taken: 0.023 seconds INFO : Executing command(queryId=jenkins_20201113135910_98d80d3f-4dba-428a-b57b-f683734fdfdf): INSERT OVERWRITE TABLE functional_orc_def.greptiny SELECT * FROM functional.greptiny INFO : Query ID = jenkins_20201113135910_98d80d3f-4dba-428a-b57b-f683734fdfdf INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135910_98d80d3f-4dba-428a-b57b-f683734fdfdf INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABLE...functional.greptiny (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.greptiny from hdfs://localhost:20500/test-warehouse/managed/greptiny_orc_def INFO : Completed executing command(queryId=jenkins_20201113135910_98d80d3f-4dba-428a-b57b-f683734fdfdf); Time taken: 0.47 seconds INFO : OK 100 rows affected (0.503 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> SET hive.exec.compress.output=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.type=BLOC K; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition.mode=no nstrict; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions.pe rnode=10000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.max.split.size=256000000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE functional_orc_d ef.rankingssmall SELECT * FROM functional.rankingssmall; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135911_c304d16a-3f2b-425c-8b48-d71dacf17e5b): INSERT OVERWRITE TABLE functional_orc_def.rankingssmall SELECT * FROM functional.rankingssmall INFO : No Stats for functional@rankingssmall, Columns: avgduration, pageurl, pagerank INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:rankingssmall.pagerank, type:int, comment:null), FieldSchema(name:rankingssmall.pageurl, type:string, comment:null), FieldSchema(name:rankingssmall.avgduration, type:int, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135911_c304d16a-3f2b-425c-8b48-d71dacf17e5b); Time taken: 0.023 seconds INFO : Executing command(queryId=jenkins_20201113135911_c304d16a-3f2b-425c-8b48-d71dacf17e5b): INSERT OVERWRITE TABLE functional_orc_def.rankingssmall SELECT * FROM functional.rankingssmall INFO : Query ID = jenkins_20201113135911_c304d16a-3f2b-425c-8b48-d71dacf17e5b INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135911_c304d16a-3f2b-425c-8b48-d71dacf17e5b INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABL...tional.rankingssmall (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.rankingssmall from hdfs://localhost:20500/test-warehouse/managed/rankingssmall_orc_def INFO : Completed executing command(queryId=jenkins_20201113135911_c304d16a-3f2b-425c-8b48-d71dacf17e5b); Time taken: 0.304 seconds INFO : OK 5,703 rows affected (0.338 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> SET hive.exec.compress.output=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.type=BLOC K; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition.mode=no nstrict; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions.pe rnode=10000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.007 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.max.split.size=256000000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE functional_orc_d ef.uservisitssmall SELECT * FROM functional.uservisitssmall; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20201113135911_8626d8ad-2495-4e7c-b076-bffd8b23a164): INSERT OVERWRITE TABLE functional_orc_def.uservisitssmall SELECT * FROM functional.uservisitssmall INFO : No Stats for functional@uservisitssmall, Columns: ccode, avgtimeonsite, sourceip, visitdate, adrevenue, useragent, lcode, skeyword, desturl INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:uservisitssmall.sourceip, type:string, comment:null), FieldSchema(name:uservisitssmall.desturl, type:string, comment:null), FieldSchema(name:uservisitssmall.visitdate, type:string, comment:null), FieldSchema(name:uservisitssmall.adrevenue, type:float, comment:null), FieldSchema(name:uservisitssmall.useragent, type:string, comment:null), FieldSchema(name:uservisitssmall.ccode, type:string, comment:null), FieldSchema(name:uservisitssmall.lcode, type:string, comment:null), FieldSchema(name:uservisitssmall.skeyword, type:string, comment:null), FieldSchema(name:uservisitssmall.avgtimeonsite, type:int, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135911_8626d8ad-2495-4e7c-b076-bffd8b23a164); Time taken: 0.023 seconds INFO : Executing command(queryId=jenkins_20201113135911_8626d8ad-2495-4e7c-b076-bffd8b23a164): INSERT OVERWRITE TABLE functional_orc_def.uservisitssmall SELECT * FROM functional.uservisitssmall INFO : Query ID = jenkins_20201113135911_8626d8ad-2495-4e7c-b076-bffd8b23a164 INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135911_8626d8ad-2495-4e7c-b076-bffd8b23a164 INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABL...onal.uservisitssmall (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.uservisitssmall from hdfs://localhost:20500/test-warehouse/managed/uservisitssmall_orc_def INFO : Completed executing command(queryId=jenkins_20201113135911_8626d8ad-2495-4e7c-b076-bffd8b23a164); Time taken: 0.419 seconds INFO : OK 10,000 rows affected (0.452 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> SET hive.exec.compress.output=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.type=BLOC K; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition.mode=no nstrict; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions.pe rnode=10000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.max.split.size=256000000; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! No rows affected (0.001 seconds) 0: jdbc:hive2://localhost:11050/default> insert overwrite table functional_orc_d ef.alltypesaggmultifiles partition (year, month, day) SELECT id, bool_col, tinyi nt_col, smallint_col, int_col, bigint_col, float_col, double_col, date_string_co l, string_col, timestamp_col, year, month, day FROM functional.alltypesaggmultif iles where id % 4 = 0; going to print operations logs printed operations logs going to print operations logs INFO : Compiling command(queryId=jenkins_20201113135912_c70fe07f-0282-4439-95ae-6fa64f25f791): insert overwrite table functional_orc_def.alltypesaggmultifiles partition (year, month, day) SELECT id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col, timestamp_col, year, month, day FROM functional.alltypesaggmultifiles where id % 4 = 0 INFO : No Stats for functional@alltypesaggmultifiles, Columns: float_col, int_col, string_col, bool_col, date_string_col, smallint_col, timestamp_col, tinyint_col, bigint_col, id, double_col INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:id, type:int, comment:null), FieldSchema(name:bool_col, type:boolean, comment:null), FieldSchema(name:tinyint_col, type:tinyint, comment:null), FieldSchema(name:smallint_col, type:smallint, comment:null), FieldSchema(name:int_col, type:int, comment:null), FieldSchema(name:bigint_col, type:bigint, comment:null), FieldSchema(name:float_col, type:float, comment:null), FieldSchema(name:double_col, type:double, comment:null), FieldSchema(name:date_string_col, type:string, comment:null), FieldSchema(name:string_col, type:string, comment:null), FieldSchema(name:timestamp_col, type:timestamp, comment:null), FieldSchema(name:year, type:int, comment:null), FieldSchema(name:month, type:int, comment:null), FieldSchema(name:day, type:int, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135912_c70fe07f-0282-4439-95ae-6fa64f25f791); Time taken: 0.039 seconds INFO : Executing command(queryId=jenkins_20201113135912_c70fe07f-0282-4439-95ae-6fa64f25f791): insert overwrite table functional_orc_def.alltypesaggmultifiles partition (year, month, day) SELECT id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col, timestamp_col, year, month, day FROM functional.alltypesaggmultifiles where id % 4 = 0 INFO : Query ID = jenkins_20201113135912_c70fe07f-0282-4439-95ae-6fa64f25f791 INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135912_c70fe07f-0282-4439-95ae-6fa64f25f791 INFO : Session is already open INFO : Dag name: insert overwrite table functional_orc_de...0 (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) printed operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ........ container RUNNING 42 35 4 3 0 0 Reducer 2 container INITED 1 0 0 1 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [=====================>>-----] 81% ELAPSED TIME: 1.47 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 42 42 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 1.79 s ---------------------------------------------------------------------------------------------- Getting log thread is interrupted, since query is done! INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.alltypesaggmultifiles partition (year=null, month=null, day=null) from hdfs://localhost:20500/test-warehouse/managed/alltypesaggmultifiles_orc_def INFO : INFO : Time taken to load dynamic partitions: 0.201 seconds INFO : Time taken for adding to write entity : 0.0 seconds INFO : Completed executing command(queryId=jenkins_20201113135912_c70fe07f-0282-4439-95ae-6fa64f25f791); Time taken: 1.823 seconds INFO : OK ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 42 42 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 1.79 s ---------------------------------------------------------------------------------------------- 3,000 rows affected (1.877 seconds) 0: jdbc:hive2://localhost:11050/default> insert into table functional_orc_def.al ltypesaggmultifiles partition (year, month, day) SELECT id, bool_col, tinyint_co l, smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, st ring_col, timestamp_col, year, month, day FROM functional.alltypesaggmultifiles where id % 4 = 1; going to print operations logs printed operations logs going to print operations logs INFO : Compiling command(queryId=jenkins_20201113135913_d2ecc422-ec51-4fe2-9e92-e8d93b01aca9): insert into table functional_orc_def.alltypesaggmultifiles partition (year, month, day) SELECT id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col, timestamp_col, year, month, day FROM functional.alltypesaggmultifiles where id % 4 = 1 INFO : No Stats for functional@alltypesaggmultifiles, Columns: float_col, int_col, string_col, bool_col, date_string_col, smallint_col, timestamp_col, tinyint_col, bigint_col, id, double_col INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:id, type:int, comment:null), FieldSchema(name:bool_col, type:boolean, comment:null), FieldSchema(name:tinyint_col, type:tinyint, comment:null), FieldSchema(name:smallint_col, type:smallint, comment:null), FieldSchema(name:int_col, type:int, comment:null), FieldSchema(name:bigint_col, type:bigint, comment:null), FieldSchema(name:float_col, type:float, comment:null), FieldSchema(name:double_col, type:double, comment:null), FieldSchema(name:date_string_col, type:string, comment:null), FieldSchema(name:string_col, type:string, comment:null), FieldSchema(name:timestamp_col, type:timestamp, comment:null), FieldSchema(name:year, type:int, comment:null), FieldSchema(name:month, type:int, comment:null), FieldSchema(name:day, type:int, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20201113135913_d2ecc422-ec51-4fe2-9e92-e8d93b01aca9); Time taken: 0.036 seconds INFO : Executing command(queryId=jenkins_20201113135913_d2ecc422-ec51-4fe2-9e92-e8d93b01aca9): insert into table functional_orc_def.alltypesaggmultifiles partition (year, month, day) SELECT id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col, timestamp_col, year, month, day FROM functional.alltypesaggmultifiles where id % 4 = 1 INFO : Query ID = jenkins_20201113135913_d2ecc422-ec51-4fe2-9e92-e8d93b01aca9 INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: jenkins_20201113135913_d2ecc422-ec51-4fe2-9e92-e8d93b01aca9 INFO : Session is already open INFO : Dag name: insert into table functional_orc_def.all...1 (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1605304119768_0012) printed operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 42 42 0 0 0 0 Reducer 2 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [=========================>>-] 97% ELAPSED TIME: 1.46 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 42 42 0 0 0 0 Reducer 2 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [=========================>>-] 97% ELAPSED TIME: 1.96 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 42 42 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 1 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 2.46 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 42 42 0 0 0 0 Reducer 2 ...... container SUCCEEDED 1 1 0 0 1 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 2.49 s ---------------------------------------------------------------------------------------------- Getting log thread is interrupted, since query is done! INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table functional_orc_def.alltypesaggmultifiles partition (year=null, month=null, day=null) from hdfs://localhost:20500/test-warehouse/managed/alltypesaggmultifiles_orc_def INFO : ERROR : FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask. Exception when loading 11 partitions in table alltypesaggmultifiles with loadPath=hdfs://localhost:20500/test-warehouse/managed/alltypesaggmultifiles_orc_def INFO : Completed executing command(queryId=jenkins_20201113135913_d2ecc422-ec51-4fe2-9e92-e8d93b01aca9); Time taken: 2.511 seconds INFO : OK Error: Error while compiling statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask. Exception when loading 11 partitions in table alltypesaggmultifiles with loadPath=hdfs://localhost:20500/test-warehouse/managed/alltypesaggmultifiles_orc_def (state=08S01,code=1) java.sql.SQLException: Error while compiling statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask. Exception when loading 11 partitions in table alltypesaggmultifiles with loadPath=hdfs://localhost:20500/test-warehouse/managed/alltypesaggmultifiles_orc_def at org.apache.hive.jdbc.HiveStatement.waitForOperationToComplete(HiveStatement.java:401) at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:266) at org.apache.hive.beeline.Commands.executeInternal(Commands.java:1007) at org.apache.hive.beeline.Commands.execute(Commands.java:1217) at org.apache.hive.beeline.Commands.sql(Commands.java:1146) at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:1497) at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:1355) at org.apache.hive.beeline.BeeLine.executeFile(BeeLine.java:1329) at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:1127) at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:1082) at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:546) at org.apache.hive.beeline.BeeLine.main(BeeLine.java:528) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.RunJar.run(RunJar.java:318) at org.apache.hadoop.util.RunJar.main(RunJar.java:232) Closing: 0: jdbc:hive2://localhost:11050/default;auth=none