SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/data0/jenkins/workspace/impala-asf-master-core-tsan/Impala-Toolchain/cdp_components-4493826/apache-hive-3.1.3000.7.2.1.0-287-bin/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/data0/jenkins/workspace/impala-asf-master-core-tsan/Impala-Toolchain/cdp_components-4493826/hadoop-3.1.1.7.2.1.0-287/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-asf-master-core-tsan/Impala-Toolchain/cdp_components-4493826/apache-hive-3.1.3000.7.2.1.0-287-bin/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/data0/jenkins/workspace/impala-asf-master-core-tsan/Impala-Toolchain/cdp_components-4493826/hadoop-3.1.1.7.2.1.0-287/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.1.0-287) Driver: Hive JDBC (version 3.1.3000.7.2.1.0-287) Transaction isolation: TRANSACTION_REPEATABLE_READ 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.061 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.003 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.006 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.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 tpcds_orc_def.ca ll_center . . . . . . . . . . . . . . . . . . . .> SELECT * FROM tpcds.call_center; going to print operations logs printed operations logs going to print operations logs INFO : Compiling command(queryId=jenkins_20200716162816_0567e548-9c51-4b30-abc4-6fbed67dfa54): INSERT OVERWRITE TABLE tpcds_orc_def.call_center SELECT * FROM tpcds.call_center INFO : No Stats for tpcds@call_center, Columns: cc_class, cc_market_manager, cc_division_name, cc_city, cc_mkt_class, cc_company, cc_zip, cc_street_name, cc_rec_end_date, cc_closed_date_sk, cc_division, cc_hours, cc_open_date_sk, cc_mkt_desc, cc_street_number, cc_name, cc_call_center_sk, cc_tax_percentage, cc_call_center_id, cc_sq_ft, cc_country, cc_company_name, cc_mkt_id, cc_state, cc_county, cc_rec_start_date, cc_employees, cc_manager, cc_suite_number, cc_street_type, cc_gmt_offset INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:call_center.cc_call_center_sk, type:int, comment:null), FieldSchema(name:call_center.cc_call_center_id, type:string, comment:null), FieldSchema(name:call_center.cc_rec_start_date, type:string, comment:null), FieldSchema(name:call_center.cc_rec_end_date, type:string, comment:null), FieldSchema(name:call_center.cc_closed_date_sk, type:int, comment:null), FieldSchema(name:call_center.cc_open_date_sk, type:int, comment:null), FieldSchema(name:call_center.cc_name, type:string, comment:null), FieldSchema(name:call_center.cc_class, type:string, comment:null), FieldSchema(name:call_center.cc_employees, type:int, comment:null), FieldSchema(name:call_center.cc_sq_ft, type:int, comment:null), FieldSchema(name:call_center.cc_hours, type:string, comment:null), FieldSchema(name:call_center.cc_manager, type:string, comment:null), FieldSchema(name:call_center.cc_mkt_id, type:int, comment:null), FieldSchema(name:call_center.cc_mkt_class, type:string, comment:null), FieldSchema(name:call_center.cc_mkt_desc, type:string, comment:null), FieldSchema(name:call_center.cc_market_manager, type:string, comment:null), FieldSchema(name:call_center.cc_division, type:int, comment:null), FieldSchema(name:call_center.cc_division_name, type:string, comment:null), FieldSchema(name:call_center.cc_company, type:int, comment:null), FieldSchema(name:call_center.cc_company_name, type:string, comment:null), FieldSchema(name:call_center.cc_street_number, type:string, comment:null), FieldSchema(name:call_center.cc_street_name, type:string, comment:null), FieldSchema(name:call_center.cc_street_type, type:string, comment:null), FieldSchema(name:call_center.cc_suite_number, type:string, comment:null), FieldSchema(name:call_center.cc_city, type:string, comment:null), FieldSchema(name:call_center.cc_county, type:string, comment:null), FieldSchema(name:call_center.cc_state, type:string, comment:null), FieldSchema(name:call_center.cc_zip, type:string, comment:null), FieldSchema(name:call_center.cc_country, type:string, comment:null), FieldSchema(name:call_center.cc_gmt_offset, type:decimal(5,2), comment:null), FieldSchema(name:call_center.cc_tax_percentage, type:decimal(5,2), comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20200716162816_0567e548-9c51-4b30-abc4-6fbed67dfa54); Time taken: 0.034 seconds INFO : Executing command(queryId=jenkins_20200716162816_0567e548-9c51-4b30-abc4-6fbed67dfa54): INSERT OVERWRITE TABLE tpcds_orc_def.call_center SELECT * FROM tpcds.call_center INFO : Query ID = jenkins_20200716162816_0567e548-9c51-4b30-abc4-6fbed67dfa54 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_20200716162816_0567e548-9c51-4b30-abc4-6fbed67dfa54 INFO : Tez session hasn't been created yet. Opening session printed operations logs going to print operations logs printed operations logs going to print operations logs INFO : Dag name: INSERT OVERWRITE TABLE t...tpcds.call_center (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1594941333185_0012) printed operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container INITIALIZING -1 0 0 -1 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 0.06 s ---------------------------------------------------------------------------------------------- going to print operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container INITED 1 0 0 1 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 3.56 s ---------------------------------------------------------------------------------------------- printed operations logs going to print operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 7.07 s ---------------------------------------------------------------------------------------------- printed operations logs going to print operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 10.29 s ---------------------------------------------------------------------------------------------- INFO : Starting task [Stage-2:DEPENDENCY_COLLECTION] in serial mode INFO : Starting task [Stage-0:MOVE] in serial mode INFO : Loading data to table tpcds_orc_def.call_center from hdfs://localhost:20500/test-warehouse/managed/tpcds.call_center_orc_def INFO : Completed executing command(queryId=jenkins_20200716162816_0567e548-9c51-4b30-abc4-6fbed67dfa54); Time taken: 76.235 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 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 10.30 s ---------------------------------------------------------------------------------------------- 6 rows affected (76.291 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.013 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.type=BLOC K; No rows affected (0.032 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; No rows affected (0.004 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.017 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; No rows affected (0.007 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions.pe rnode=10000; No rows affected (0.015 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; No rows affected (0.003 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.009 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; No rows affected (0.039 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE tpcds_orc_def.ca talog_page . . . . . . . . . . . . . . . . . . . .> SELECT * FROM tpcds.catalog_page; going to print operations logs printed operations logs going to print operations logs INFO : Compiling command(queryId=jenkins_20200716162933_78dbea68-bed3-4d83-994b-577c595ee472): INSERT OVERWRITE TABLE tpcds_orc_def.catalog_page SELECT * FROM tpcds.catalog_page INFO : No Stats for tpcds@catalog_page, Columns: cp_catalog_page_number, cp_description, cp_department, cp_type, cp_catalog_page_sk, cp_catalog_page_id, cp_catalog_number, cp_end_date_sk, cp_start_date_sk INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:catalog_page.cp_catalog_page_sk, type:int, comment:null), FieldSchema(name:catalog_page.cp_catalog_page_id, type:string, comment:null), FieldSchema(name:catalog_page.cp_start_date_sk, type:int, comment:null), FieldSchema(name:catalog_page.cp_end_date_sk, type:int, comment:null), FieldSchema(name:catalog_page.cp_department, type:string, comment:null), FieldSchema(name:catalog_page.cp_catalog_number, type:int, comment:null), FieldSchema(name:catalog_page.cp_catalog_page_number, type:int, comment:null), FieldSchema(name:catalog_page.cp_description, type:string, comment:null), FieldSchema(name:catalog_page.cp_type, type:string, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20200716162933_78dbea68-bed3-4d83-994b-577c595ee472); Time taken: 0.091 seconds INFO : Executing command(queryId=jenkins_20200716162933_78dbea68-bed3-4d83-994b-577c595ee472): INSERT OVERWRITE TABLE tpcds_orc_def.catalog_page SELECT * FROM tpcds.catalog_page INFO : Query ID = jenkins_20200716162933_78dbea68-bed3-4d83-994b-577c595ee472 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_20200716162933_78dbea68-bed3-4d83-994b-577c595ee472 INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABLE ...tpcds.catalog_page (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1594941333185_0012) printed operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 1.05 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 1.55 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 2.06 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 2.57 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 2.69 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 tpcds_orc_def.catalog_page from hdfs://localhost:20500/test-warehouse/managed/tpcds.catalog_page_orc_def INFO : Completed executing command(queryId=jenkins_20200716162933_78dbea68-bed3-4d83-994b-577c595ee472); Time taken: 3.122 seconds INFO : OK ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 2.69 s ---------------------------------------------------------------------------------------------- 11,718 rows affected (3.276 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.093 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.type=BLOC K; No rows affected (0.07 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; No rows affected (0.003 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition.mode=no nstrict; No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions.pe rnode=10000; No rows affected (0.044 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; No rows affected (0.048 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.max.split.size=256000000; No rows affected (0.043 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; No rows affected (0.078 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE tpcds_orc_def.ca talog_returns . . . . . . . . . . . . . . . . . . . .> SELECT * FROM tpcds.catalog_returns; going to print operations logs printed operations logs going to print operations logs INFO : Compiling command(queryId=jenkins_20200716162937_7f44fdea-e2c9-4270-83c5-40833d5b89fc): INSERT OVERWRITE TABLE tpcds_orc_def.catalog_returns SELECT * FROM tpcds.catalog_returns INFO : No Stats for tpcds@catalog_returns, Columns: cr_refunded_cash, cr_warehouse_sk, cr_return_quantity, cr_returning_addr_sk, cr_reason_sk, cr_return_amount, cr_store_credit, cr_fee, cr_net_loss, cr_return_amt_inc_tax, cr_catalog_page_sk, cr_returned_date_sk, cr_returning_hdemo_sk, cr_item_sk, cr_refunded_customer_sk, cr_return_ship_cost, cr_refunded_cdemo_sk, cr_returning_cdemo_sk, cr_call_center_sk, cr_refunded_hdemo_sk, cr_order_number, cr_return_tax, cr_reversed_charge, cr_returned_time_sk, cr_ship_mode_sk, cr_returning_customer_sk, cr_refunded_addr_sk INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:catalog_returns.cr_returned_date_sk, type:int, comment:null), FieldSchema(name:catalog_returns.cr_returned_time_sk, type:int, comment:null), FieldSchema(name:catalog_returns.cr_item_sk, type:bigint, comment:null), FieldSchema(name:catalog_returns.cr_refunded_customer_sk, type:int, comment:null), FieldSchema(name:catalog_returns.cr_refunded_cdemo_sk, type:int, comment:null), FieldSchema(name:catalog_returns.cr_refunded_hdemo_sk, type:int, comment:null), FieldSchema(name:catalog_returns.cr_refunded_addr_sk, type:int, comment:null), FieldSchema(name:catalog_returns.cr_returning_customer_sk, type:int, comment:null), FieldSchema(name:catalog_returns.cr_returning_cdemo_sk, type:int, comment:null), FieldSchema(name:catalog_returns.cr_returning_hdemo_sk, type:int, comment:null), FieldSchema(name:catalog_returns.cr_returning_addr_sk, type:int, comment:null), FieldSchema(name:catalog_returns.cr_call_center_sk, type:int, comment:null), FieldSchema(name:catalog_returns.cr_catalog_page_sk, type:int, comment:null), FieldSchema(name:catalog_returns.cr_ship_mode_sk, type:int, comment:null), FieldSchema(name:catalog_returns.cr_warehouse_sk, type:int, comment:null), FieldSchema(name:catalog_returns.cr_reason_sk, type:int, comment:null), FieldSchema(name:catalog_returns.cr_order_number, type:bigint, comment:null), FieldSchema(name:catalog_returns.cr_return_quantity, type:int, comment:null), FieldSchema(name:catalog_returns.cr_return_amount, type:decimal(7,2), comment:null), FieldSchema(name:catalog_returns.cr_return_tax, type:decimal(7,2), comment:null), FieldSchema(name:catalog_returns.cr_return_amt_inc_tax, type:decimal(7,2), comment:null), FieldSchema(name:catalog_returns.cr_fee, type:decimal(7,2), comment:null), FieldSchema(name:catalog_returns.cr_return_ship_cost, type:decimal(7,2), comment:null), FieldSchema(name:catalog_returns.cr_refunded_cash, type:decimal(7,2), comment:null), FieldSchema(name:catalog_returns.cr_reversed_charge, type:decimal(7,2), comment:null), FieldSchema(name:catalog_returns.cr_store_credit, type:decimal(7,2), comment:null), FieldSchema(name:catalog_returns.cr_net_loss, type:decimal(7,2), comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20200716162937_7f44fdea-e2c9-4270-83c5-40833d5b89fc); Time taken: 0.137 seconds INFO : Executing command(queryId=jenkins_20200716162937_7f44fdea-e2c9-4270-83c5-40833d5b89fc): INSERT OVERWRITE TABLE tpcds_orc_def.catalog_returns SELECT * FROM tpcds.catalog_returns INFO : Query ID = jenkins_20200716162937_7f44fdea-e2c9-4270-83c5-40833d5b89fc 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_20200716162937_7f44fdea-e2c9-4270-83c5-40833d5b89fc INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABL...pcds.catalog_returns (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1594941333185_0012) printed operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 1.21 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 1.72 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 2.24 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 2.75 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 3.26 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 3.76 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 4.27 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 4.77 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 5.27 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 5.77 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 6.28 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 6.78 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 7.29 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 7.38 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 tpcds_orc_def.catalog_returns from hdfs://localhost:20500/test-warehouse/managed/tpcds.catalog_returns_orc_def INFO : Completed executing command(queryId=jenkins_20200716162937_7f44fdea-e2c9-4270-83c5-40833d5b89fc); Time taken: 7.63 seconds INFO : OK ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 7.38 s ---------------------------------------------------------------------------------------------- 144,067 rows affected (7.836 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.028 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.type=BLOC K; No rows affected (0.043 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; No rows affected (0.014 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition.mode=no nstrict; No rows affected (0.054 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; No rows affected (0.003 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; No rows affected (0.04 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.086 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; No rows affected (0.018 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.max.split.size=256000000; No rows affected (0.011 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; No rows affected (0.051 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE tpcds_orc_def.ca talog_sales . . . . . . . . . . . . . . . . . . . .> SELECT * FROM tpcds.catalog_sales; going to print operations logs printed operations logs going to print operations logs INFO : Compiling command(queryId=jenkins_20200716162945_3799a31d-7f79-4c16-b0ab-f5a06c534140): INSERT OVERWRITE TABLE tpcds_orc_def.catalog_sales SELECT * FROM tpcds.catalog_sales INFO : No Stats for tpcds@catalog_sales, Columns: cs_warehouse_sk, cs_ship_date_sk, cs_ext_list_price, cs_quantity, cs_net_paid_inc_tax, cs_sold_time_sk, cs_promo_sk, cs_list_price, cs_ext_ship_cost, cs_net_paid, cs_sold_date_sk, cs_ext_discount_amt, cs_ship_addr_sk, cs_catalog_page_sk, cs_ext_tax, cs_net_profit, cs_bill_cdemo_sk, cs_item_sk, cs_bill_hdemo_sk, cs_net_paid_inc_ship, cs_coupon_amt, cs_net_paid_inc_ship_tax, cs_order_number, cs_ext_wholesale_cost, cs_ship_customer_sk, cs_ship_mode_sk, cs_ext_sales_price, cs_bill_addr_sk, cs_ship_cdemo_sk, cs_ship_hdemo_sk, cs_wholesale_cost, cs_sales_price, cs_call_center_sk, cs_bill_customer_sk INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:catalog_sales.cs_sold_date_sk, type:int, comment:null), FieldSchema(name:catalog_sales.cs_sold_time_sk, type:int, comment:null), FieldSchema(name:catalog_sales.cs_ship_date_sk, type:int, comment:null), FieldSchema(name:catalog_sales.cs_bill_customer_sk, type:int, comment:null), FieldSchema(name:catalog_sales.cs_bill_cdemo_sk, type:int, comment:null), FieldSchema(name:catalog_sales.cs_bill_hdemo_sk, type:int, comment:null), FieldSchema(name:catalog_sales.cs_bill_addr_sk, type:int, comment:null), FieldSchema(name:catalog_sales.cs_ship_customer_sk, type:int, comment:null), FieldSchema(name:catalog_sales.cs_ship_cdemo_sk, type:int, comment:null), FieldSchema(name:catalog_sales.cs_ship_hdemo_sk, type:int, comment:null), FieldSchema(name:catalog_sales.cs_ship_addr_sk, type:int, comment:null), FieldSchema(name:catalog_sales.cs_call_center_sk, type:int, comment:null), FieldSchema(name:catalog_sales.cs_catalog_page_sk, type:int, comment:null), FieldSchema(name:catalog_sales.cs_ship_mode_sk, type:int, comment:null), FieldSchema(name:catalog_sales.cs_warehouse_sk, type:int, comment:null), FieldSchema(name:catalog_sales.cs_item_sk, type:bigint, comment:null), FieldSchema(name:catalog_sales.cs_promo_sk, type:int, comment:null), FieldSchema(name:catalog_sales.cs_order_number, type:bigint, comment:null), FieldSchema(name:catalog_sales.cs_quantity, type:int, comment:null), FieldSchema(name:catalog_sales.cs_wholesale_cost, type:decimal(7,2), comment:null), FieldSchema(name:catalog_sales.cs_list_price, type:decimal(7,2), comment:null), FieldSchema(name:catalog_sales.cs_sales_price, type:decimal(7,2), comment:null), FieldSchema(name:catalog_sales.cs_ext_discount_amt, type:decimal(7,2), comment:null), FieldSchema(name:catalog_sales.cs_ext_sales_price, type:decimal(7,2), comment:null), FieldSchema(name:catalog_sales.cs_ext_wholesale_cost, type:decimal(7,2), comment:null), FieldSchema(name:catalog_sales.cs_ext_list_price, type:decimal(7,2), comment:null), FieldSchema(name:catalog_sales.cs_ext_tax, type:decimal(7,2), comment:null), FieldSchema(name:catalog_sales.cs_coupon_amt, type:decimal(7,2), comment:null), FieldSchema(name:catalog_sales.cs_ext_ship_cost, type:decimal(7,2), comment:null), FieldSchema(name:catalog_sales.cs_net_paid, type:decimal(7,2), comment:null), FieldSchema(name:catalog_sales.cs_net_paid_inc_tax, type:decimal(7,2), comment:null), FieldSchema(name:catalog_sales.cs_net_paid_inc_ship, type:decimal(7,2), comment:null), FieldSchema(name:catalog_sales.cs_net_paid_inc_ship_tax, type:decimal(7,2), comment:null), FieldSchema(name:catalog_sales.cs_net_profit, type:decimal(7,2), comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20200716162945_3799a31d-7f79-4c16-b0ab-f5a06c534140); Time taken: 0.197 seconds INFO : Executing command(queryId=jenkins_20200716162945_3799a31d-7f79-4c16-b0ab-f5a06c534140): INSERT OVERWRITE TABLE tpcds_orc_def.catalog_sales SELECT * FROM tpcds.catalog_sales INFO : Query ID = jenkins_20200716162945_3799a31d-7f79-4c16-b0ab-f5a06c534140 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_20200716162945_3799a31d-7f79-4c16-b0ab-f5a06c534140 INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABLE...tpcds.catalog_sales (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1594941333185_0012) printed operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 5 0 1 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 1.10 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 5 0 1 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 1.60 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 5 0 1 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 2.10 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 5 0 1 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 2.61 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 5 0 1 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 3.11 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 5 0 1 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 3.61 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 5 0 1 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 4.11 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 5 0 1 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 4.62 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 5 0 2 3 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 5.12 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 5 0 2 3 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 5.63 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 5 0 3 2 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 6.14 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 5 0 3 2 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 6.64 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 5 0 3 2 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 7.14 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 5 0 5 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 7.65 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .. container RUNNING 5 1 4 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [=====>>---------------------] 20% ELAPSED TIME: 8.15 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .. container RUNNING 5 1 4 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [=====>>---------------------] 20% ELAPSED TIME: 8.65 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .. container RUNNING 5 1 4 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [=====>>---------------------] 20% ELAPSED TIME: 9.16 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .. container RUNNING 5 1 4 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [=====>>---------------------] 20% ELAPSED TIME: 9.66 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .. container RUNNING 5 1 4 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [=====>>---------------------] 20% ELAPSED TIME: 10.66 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .. container RUNNING 5 1 4 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [=====>>---------------------] 20% ELAPSED TIME: 11.67 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .... container RUNNING 5 2 3 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [==========>>----------------] 40% ELAPSED TIME: 12.67 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 5 5 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 13.44 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 tpcds_orc_def.catalog_sales from hdfs://localhost:20500/test-warehouse/managed/tpcds.catalog_sales_orc_def INFO : Completed executing command(queryId=jenkins_20200716162945_3799a31d-7f79-4c16-b0ab-f5a06c534140); Time taken: 13.84 seconds INFO : OK ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 5 5 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 13.44 s ---------------------------------------------------------------------------------------------- 1,441,548 rows affected (14.193 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.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.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.002 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE tpcds_orc_def.cu stomer . . . . . . . . . . . . . . . . . . . .> SELECT * FROM tpcds.customer; going to print operations logs printed operations logs going to print operations logs INFO : Compiling command(queryId=jenkins_20200716162959_166ae152-267a-4b28-8467-8be576665e5f): INSERT OVERWRITE TABLE tpcds_orc_def.customer SELECT * FROM tpcds.customer INFO : No Stats for tpcds@customer, Columns: c_salutation, c_preferred_cust_flag, c_first_sales_date_sk, c_customer_sk, c_login, c_current_cdemo_sk, c_first_name, c_current_hdemo_sk, c_current_addr_sk, c_last_name, c_customer_id, c_birth_month, c_birth_country, c_birth_year, c_last_review_date, c_birth_day, c_first_shipto_date_sk, c_email_address INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:customer.c_customer_sk, type:int, comment:null), FieldSchema(name:customer.c_customer_id, type:string, comment:null), FieldSchema(name:customer.c_current_cdemo_sk, type:int, comment:null), FieldSchema(name:customer.c_current_hdemo_sk, type:int, comment:null), FieldSchema(name:customer.c_current_addr_sk, type:int, comment:null), FieldSchema(name:customer.c_first_shipto_date_sk, type:int, comment:null), FieldSchema(name:customer.c_first_sales_date_sk, type:int, comment:null), FieldSchema(name:customer.c_salutation, type:string, comment:null), FieldSchema(name:customer.c_first_name, type:string, comment:null), FieldSchema(name:customer.c_last_name, type:string, comment:null), FieldSchema(name:customer.c_preferred_cust_flag, type:string, comment:null), FieldSchema(name:customer.c_birth_day, type:int, comment:null), FieldSchema(name:customer.c_birth_month, type:int, comment:null), FieldSchema(name:customer.c_birth_year, type:int, comment:null), FieldSchema(name:customer.c_birth_country, type:string, comment:null), FieldSchema(name:customer.c_login, type:string, comment:null), FieldSchema(name:customer.c_email_address, type:string, comment:null), FieldSchema(name:customer.c_last_review_date, type:string, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20200716162959_166ae152-267a-4b28-8467-8be576665e5f); Time taken: 0.032 seconds INFO : Executing command(queryId=jenkins_20200716162959_166ae152-267a-4b28-8467-8be576665e5f): INSERT OVERWRITE TABLE tpcds_orc_def.customer SELECT * FROM tpcds.customer INFO : Query ID = jenkins_20200716162959_166ae152-267a-4b28-8467-8be576665e5f 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_20200716162959_166ae152-267a-4b28-8467-8be576665e5f INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABLE tpcd...tpcds.customer (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1594941333185_0012) printed operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 1.32 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 tpcds_orc_def.customer from hdfs://localhost:20500/test-warehouse/managed/tpcds.customer_orc_def INFO : Completed executing command(queryId=jenkins_20200716162959_166ae152-267a-4b28-8467-8be576665e5f); Time taken: 1.347 seconds INFO : OK ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 1.32 s ---------------------------------------------------------------------------------------------- 100,000 rows affected (1.391 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 tpcds_orc_def.cu stomer_address . . . . . . . . . . . . . . . . . . . .> SELECT * FROM tpcds.customer_address; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20200716163001_0ca767bd-e83f-4961-8bdd-07a35ab7f9a3): INSERT OVERWRITE TABLE tpcds_orc_def.customer_address SELECT * FROM tpcds.customer_address INFO : No Stats for tpcds@customer_address, Columns: ca_street_name, ca_suite_number, ca_state, ca_location_type, ca_address_sk, ca_country, ca_address_id, ca_county, ca_street_number, ca_zip, ca_city, ca_street_type, ca_gmt_offset INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:customer_address.ca_address_sk, type:int, comment:null), FieldSchema(name:customer_address.ca_address_id, type:string, comment:null), FieldSchema(name:customer_address.ca_street_number, type:string, comment:null), FieldSchema(name:customer_address.ca_street_name, type:string, comment:null), FieldSchema(name:customer_address.ca_street_type, type:string, comment:null), FieldSchema(name:customer_address.ca_suite_number, type:string, comment:null), FieldSchema(name:customer_address.ca_city, type:string, comment:null), FieldSchema(name:customer_address.ca_county, type:string, comment:null), FieldSchema(name:customer_address.ca_state, type:string, comment:null), FieldSchema(name:customer_address.ca_zip, type:string, comment:null), FieldSchema(name:customer_address.ca_country, type:string, comment:null), FieldSchema(name:customer_address.ca_gmt_offset, type:decimal(5,2), comment:null), FieldSchema(name:customer_address.ca_location_type, type:string, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20200716163001_0ca767bd-e83f-4961-8bdd-07a35ab7f9a3); Time taken: 0.03 seconds INFO : Executing command(queryId=jenkins_20200716163001_0ca767bd-e83f-4961-8bdd-07a35ab7f9a3): INSERT OVERWRITE TABLE tpcds_orc_def.customer_address SELECT * FROM tpcds.customer_address INFO : Query ID = jenkins_20200716163001_0ca767bd-e83f-4961-8bdd-07a35ab7f9a3 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_20200716163001_0ca767bd-e83f-4961-8bdd-07a35ab7f9a3 INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABL...cds.customer_address (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1594941333185_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 tpcds_orc_def.customer_address from hdfs://localhost:20500/test-warehouse/managed/tpcds.customer_address_orc_def INFO : Completed executing command(queryId=jenkins_20200716163001_0ca767bd-e83f-4961-8bdd-07a35ab7f9a3); Time taken: 0.849 seconds INFO : OK 50,000 rows affected (0.89 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.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.001 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE tpcds_orc_def.cu stomer_demographics . . . . . . . . . . . . . . . . . . . .> SELECT * FROM tpcds.customer_demographi cs; going to print operations logs printed operations logs going to print operations logs INFO : Compiling command(queryId=jenkins_20200716163001_8eda5b7b-a42f-42b5-8dbe-dd7c4d3812dc): INSERT OVERWRITE TABLE tpcds_orc_def.customer_demographics SELECT * FROM tpcds.customer_demographics INFO : No Stats for tpcds@customer_demographics, Columns: cd_dep_employed_count, cd_demo_sk, cd_education_status, cd_credit_rating, cd_dep_count, cd_purchase_estimate, cd_marital_status, cd_dep_college_count, cd_gender INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:customer_demographics.cd_demo_sk, type:int, comment:null), FieldSchema(name:customer_demographics.cd_gender, type:string, comment:null), FieldSchema(name:customer_demographics.cd_marital_status, type:string, comment:null), FieldSchema(name:customer_demographics.cd_education_status, type:string, comment:null), FieldSchema(name:customer_demographics.cd_purchase_estimate, type:int, comment:null), FieldSchema(name:customer_demographics.cd_credit_rating, type:string, comment:null), FieldSchema(name:customer_demographics.cd_dep_count, type:int, comment:null), FieldSchema(name:customer_demographics.cd_dep_employed_count, type:int, comment:null), FieldSchema(name:customer_demographics.cd_dep_college_count, type:int, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20200716163001_8eda5b7b-a42f-42b5-8dbe-dd7c4d3812dc); Time taken: 0.031 seconds INFO : Executing command(queryId=jenkins_20200716163001_8eda5b7b-a42f-42b5-8dbe-dd7c4d3812dc): INSERT OVERWRITE TABLE tpcds_orc_def.customer_demographics SELECT * FROM tpcds.customer_demographics INFO : Query ID = jenkins_20200716163001_8eda5b7b-a42f-42b5-8dbe-dd7c4d3812dc 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_20200716163001_8eda5b7b-a42f-42b5-8dbe-dd7c4d3812dc INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABL...ustomer_demographics (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1594941333185_0012) printed operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ..... container RUNNING 2 1 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [=============>>-------------] 50% ELAPSED TIME: 1.47 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ..... container RUNNING 2 1 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [=============>>-------------] 50% ELAPSED TIME: 1.97 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ..... container RUNNING 2 1 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [=============>>-------------] 50% ELAPSED TIME: 2.47 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ..... container RUNNING 2 1 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [=============>>-------------] 50% ELAPSED TIME: 2.97 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ..... container RUNNING 2 1 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [=============>>-------------] 50% ELAPSED TIME: 3.47 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ..... container RUNNING 2 1 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [=============>>-------------] 50% ELAPSED TIME: 3.98 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ..... container RUNNING 2 1 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [=============>>-------------] 50% ELAPSED TIME: 4.48 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ..... container RUNNING 2 1 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [=============>>-------------] 50% ELAPSED TIME: 4.99 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ..... container RUNNING 2 1 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [=============>>-------------] 50% ELAPSED TIME: 5.49 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ..... container RUNNING 2 1 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [=============>>-------------] 50% ELAPSED TIME: 6.00 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 2 2 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 6.29 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 tpcds_orc_def.customer_demographics from hdfs://localhost:20500/test-warehouse/managed/tpcds.customer_demographics_orc_def INFO : Completed executing command(queryId=jenkins_20200716163001_8eda5b7b-a42f-42b5-8dbe-dd7c4d3812dc); Time taken: 6.313 seconds INFO : OK ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 2 2 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 6.29 s ---------------------------------------------------------------------------------------------- 1,920,800 rows affected (6.358 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.021 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.006 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; No rows affected (0.022 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition.mode=no nstrict; No rows affected (0.003 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.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.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.002 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE tpcds_orc_def.da te_dim . . . . . . . . . . . . . . . . . . . .> SELECT * FROM tpcds.date_dim; going to print operations logs printed operations logs going to print operations logs INFO : Compiling command(queryId=jenkins_20200716163008_bf7d9117-a3bf-4a37-9260-eeb95c0c216e): INSERT OVERWRITE TABLE tpcds_orc_def.date_dim SELECT * FROM tpcds.date_dim INFO : No Stats for tpcds@date_dim, Columns: d_quarter_seq, d_last_dom, d_dom, d_current_day, d_week_seq, d_current_month, d_first_dom, d_moy, d_dow, d_holiday, d_current_quarter, d_following_holiday, d_date_id, d_fy_week_seq, d_current_week, d_day_name, d_same_day_ly, d_date, d_month_seq, d_weekend, d_quarter_name, d_fy_quarter_seq, d_current_year, d_qoy, d_same_day_lq, d_year, d_fy_year, d_date_sk INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:date_dim.d_date_sk, type:int, comment:null), FieldSchema(name:date_dim.d_date_id, type:string, comment:null), FieldSchema(name:date_dim.d_date, type:string, comment:null), FieldSchema(name:date_dim.d_month_seq, type:int, comment:null), FieldSchema(name:date_dim.d_week_seq, type:int, comment:null), FieldSchema(name:date_dim.d_quarter_seq, type:int, comment:null), FieldSchema(name:date_dim.d_year, type:int, comment:null), FieldSchema(name:date_dim.d_dow, type:int, comment:null), FieldSchema(name:date_dim.d_moy, type:int, comment:null), FieldSchema(name:date_dim.d_dom, type:int, comment:null), FieldSchema(name:date_dim.d_qoy, type:int, comment:null), FieldSchema(name:date_dim.d_fy_year, type:int, comment:null), FieldSchema(name:date_dim.d_fy_quarter_seq, type:int, comment:null), FieldSchema(name:date_dim.d_fy_week_seq, type:int, comment:null), FieldSchema(name:date_dim.d_day_name, type:string, comment:null), FieldSchema(name:date_dim.d_quarter_name, type:string, comment:null), FieldSchema(name:date_dim.d_holiday, type:string, comment:null), FieldSchema(name:date_dim.d_weekend, type:string, comment:null), FieldSchema(name:date_dim.d_following_holiday, type:string, comment:null), FieldSchema(name:date_dim.d_first_dom, type:int, comment:null), FieldSchema(name:date_dim.d_last_dom, type:int, comment:null), FieldSchema(name:date_dim.d_same_day_ly, type:int, comment:null), FieldSchema(name:date_dim.d_same_day_lq, type:int, comment:null), FieldSchema(name:date_dim.d_current_day, type:string, comment:null), FieldSchema(name:date_dim.d_current_week, type:string, comment:null), FieldSchema(name:date_dim.d_current_month, type:string, comment:null), FieldSchema(name:date_dim.d_current_quarter, type:string, comment:null), FieldSchema(name:date_dim.d_current_year, type:string, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20200716163008_bf7d9117-a3bf-4a37-9260-eeb95c0c216e); Time taken: 0.056 seconds INFO : Executing command(queryId=jenkins_20200716163008_bf7d9117-a3bf-4a37-9260-eeb95c0c216e): INSERT OVERWRITE TABLE tpcds_orc_def.date_dim SELECT * FROM tpcds.date_dim INFO : Query ID = jenkins_20200716163008_bf7d9117-a3bf-4a37-9260-eeb95c0c216e 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_20200716163008_bf7d9117-a3bf-4a37-9260-eeb95c0c216e INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABLE tpcd...tpcds.date_dim (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1594941333185_0012) printed operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 1.34 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 1.85 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 2.35 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 2.55 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 tpcds_orc_def.date_dim from hdfs://localhost:20500/test-warehouse/managed/tpcds.date_dim_orc_def INFO : Completed executing command(queryId=jenkins_20200716163008_bf7d9117-a3bf-4a37-9260-eeb95c0c216e); Time taken: 2.689 seconds INFO : OK ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 2.56 s ---------------------------------------------------------------------------------------------- 73,049 rows affected (2.781 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.017 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; No rows affected (0.009 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.041 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.dynamic.partition=true; No rows affected (0.023 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions=10 000; No rows affected (0.005 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.exec.max.dynamic.partitions.pe rnode=10000; No rows affected (0.02 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.016 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.max.split.size=256000000; No rows affected (0.002 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; No rows affected (0.028 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE tpcds_orc_def.ho usehold_demographics . . . . . . . . . . . . . . . . . . . .> SELECT * FROM tpcds.household_demograph ics; going to print operations logs printed operations logs going to print operations logs INFO : Compiling command(queryId=jenkins_20200716163011_87716090-52f3-40dc-9b75-e84323f65665): INSERT OVERWRITE TABLE tpcds_orc_def.household_demographics SELECT * FROM tpcds.household_demographics INFO : No Stats for tpcds@household_demographics, Columns: hd_buy_potential, hd_income_band_sk, hd_demo_sk, hd_dep_count, hd_vehicle_count INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:household_demographics.hd_demo_sk, type:int, comment:null), FieldSchema(name:household_demographics.hd_income_band_sk, type:int, comment:null), FieldSchema(name:household_demographics.hd_buy_potential, type:string, comment:null), FieldSchema(name:household_demographics.hd_dep_count, type:int, comment:null), FieldSchema(name:household_demographics.hd_vehicle_count, type:int, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20200716163011_87716090-52f3-40dc-9b75-e84323f65665); Time taken: 0.07 seconds INFO : Executing command(queryId=jenkins_20200716163011_87716090-52f3-40dc-9b75-e84323f65665): INSERT OVERWRITE TABLE tpcds_orc_def.household_demographics SELECT * FROM tpcds.household_demographics INFO : Query ID = jenkins_20200716163011_87716090-52f3-40dc-9b75-e84323f65665 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_20200716163011_87716090-52f3-40dc-9b75-e84323f65665 INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABL...usehold_demographics (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1594941333185_0012) printed operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 1.28 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 1.79 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 1.81 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 tpcds_orc_def.household_demographics from hdfs://localhost:20500/test-warehouse/managed/tpcds.household_demographics_orc_def INFO : Completed executing command(queryId=jenkins_20200716163011_87716090-52f3-40dc-9b75-e84323f65665); Time taken: 1.98 seconds INFO : OK ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 1.82 s ---------------------------------------------------------------------------------------------- 7,200 rows affected (2.123 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.005 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.01 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; No rows affected (0.007 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; No rows affected (0.007 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.015 seconds) 0: jdbc:hive2://localhost:11050/default> set hive.auto.convert.join=true; No rows affected (0.004 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.009 seconds) 0: jdbc:hive2://localhost:11050/default> SET hive.input.format=org.apache.hadoop .hive.ql.io.HiveInputFormat; No rows affected (0.037 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE tpcds_orc_def.in come_band . . . . . . . . . . . . . . . . . . . .> SELECT * FROM tpcds.income_band; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20200716163013_25b5a496-e86b-43a9-8138-04c9e999f92f): INSERT OVERWRITE TABLE tpcds_orc_def.income_band SELECT * FROM tpcds.income_band INFO : No Stats for tpcds@income_band, Columns: ib_income_band_sk, ib_lower_bound, ib_upper_bound INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:income_band.ib_income_band_sk, type:int, comment:null), FieldSchema(name:income_band.ib_lower_bound, type:int, comment:null), FieldSchema(name:income_band.ib_upper_bound, type:int, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20200716163013_25b5a496-e86b-43a9-8138-04c9e999f92f); Time taken: 0.077 seconds INFO : Executing command(queryId=jenkins_20200716163013_25b5a496-e86b-43a9-8138-04c9e999f92f): INSERT OVERWRITE TABLE tpcds_orc_def.income_band SELECT * FROM tpcds.income_band INFO : Query ID = jenkins_20200716163013_25b5a496-e86b-43a9-8138-04c9e999f92f 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_20200716163013_25b5a496-e86b-43a9-8138-04c9e999f92f INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABLE t...tpcds.income_band (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1594941333185_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 tpcds_orc_def.income_band from hdfs://localhost:20500/test-warehouse/managed/tpcds.income_band_orc_def INFO : Completed executing command(queryId=jenkins_20200716163013_25b5a496-e86b-43a9-8138-04c9e999f92f); Time taken: 0.833 seconds INFO : OK 20 rows affected (0.942 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.004 seconds) 0: jdbc:hive2://localhost:11050/default> SET mapred.output.compression.codec=org .apache.hadoop.io.compress.DefaultCodec; No rows affected (0.015 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; 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.003 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.006 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; 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 tpcds_orc_def.in ventory . . . . . . . . . . . . . . . . . . . .> SELECT * FROM tpcds.inventory; going to print operations logs printed operations logs going to print operations logs INFO : Compiling command(queryId=jenkins_20200716163014_470bc1be-cd1e-454d-88e6-4f1995c7abe6): INSERT OVERWRITE TABLE tpcds_orc_def.inventory SELECT * FROM tpcds.inventory INFO : No Stats for tpcds@inventory, Columns: inv_date_sk, inv_quantity_on_hand, inv_warehouse_sk, inv_item_sk INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:inventory.inv_date_sk, type:int, comment:null), FieldSchema(name:inventory.inv_item_sk, type:bigint, comment:null), FieldSchema(name:inventory.inv_warehouse_sk, type:int, comment:null), FieldSchema(name:inventory.inv_quantity_on_hand, type:int, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20200716163014_470bc1be-cd1e-454d-88e6-4f1995c7abe6); Time taken: 0.068 seconds INFO : Executing command(queryId=jenkins_20200716163014_470bc1be-cd1e-454d-88e6-4f1995c7abe6): INSERT OVERWRITE TABLE tpcds_orc_def.inventory SELECT * FROM tpcds.inventory INFO : Query ID = jenkins_20200716163014_470bc1be-cd1e-454d-88e6-4f1995c7abe6 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_20200716163014_470bc1be-cd1e-454d-88e6-4f1995c7abe6 INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABLE tpc...tpcds.inventory (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1594941333185_0012) printed operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 4 0 2 2 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 1.33 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 4 0 2 2 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 1.83 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 4 0 2 2 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 2.33 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 4 0 2 2 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 2.84 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 4 0 2 2 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 3.35 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 4 0 3 1 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 3.85 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 4 0 3 1 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 4.35 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 4 0 4 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 4.85 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 4 0 4 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 5.36 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 4 0 4 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 5.86 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 4 0 4 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 6.36 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 4 0 4 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 6.87 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 4 0 4 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 7.37 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .. container RUNNING 4 1 3 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [======>>--------------------] 25% ELAPSED TIME: 7.87 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ..... container RUNNING 4 2 2 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [=============>>-------------] 50% ELAPSED TIME: 8.37 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ..... container RUNNING 4 2 2 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [=============>>-------------] 50% ELAPSED TIME: 8.88 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ..... container RUNNING 4 2 2 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [=============>>-------------] 50% ELAPSED TIME: 9.38 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ....... container RUNNING 4 3 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [===================>>-------] 75% ELAPSED TIME: 9.88 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ....... container RUNNING 4 3 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [===================>>-------] 75% ELAPSED TIME: 10.88 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 4 4 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 11.19 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 tpcds_orc_def.inventory from hdfs://localhost:20500/test-warehouse/managed/tpcds.inventory_orc_def INFO : Completed executing command(queryId=jenkins_20200716163014_470bc1be-cd1e-454d-88e6-4f1995c7abe6); Time taken: 11.352 seconds INFO : OK ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 4 4 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 11.19 s ---------------------------------------------------------------------------------------------- 11,745,000 rows affected (11.445 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.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 tpcds_orc_def.it em . . . . . . . . . . . . . . . . . . . .> SELECT * FROM tpcds.item; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20200716163026_3b6d8540-8b8b-4bd0-b020-3c5eccffa349): INSERT OVERWRITE TABLE tpcds_orc_def.item SELECT * FROM tpcds.item INFO : No Stats for tpcds@item, Columns: i_item_desc, i_container, i_wholesale_cost, i_manufact_id, i_brand_id, i_formulation, i_current_price, i_size, i_rec_start_date, i_manufact, i_item_sk, i_manager_id, i_item_id, i_class_id, i_class, i_category, i_category_id, i_brand, i_units, i_rec_end_date, i_color, i_product_name INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:item.i_item_sk, type:bigint, comment:null), FieldSchema(name:item.i_item_id, type:string, comment:null), FieldSchema(name:item.i_rec_start_date, type:string, comment:null), FieldSchema(name:item.i_rec_end_date, type:string, comment:null), FieldSchema(name:item.i_item_desc, type:string, comment:null), FieldSchema(name:item.i_current_price, type:decimal(7,2), comment:null), FieldSchema(name:item.i_wholesale_cost, type:decimal(7,2), comment:null), FieldSchema(name:item.i_brand_id, type:int, comment:null), FieldSchema(name:item.i_brand, type:string, comment:null), FieldSchema(name:item.i_class_id, type:int, comment:null), FieldSchema(name:item.i_class, type:string, comment:null), FieldSchema(name:item.i_category_id, type:int, comment:null), FieldSchema(name:item.i_category, type:string, comment:null), FieldSchema(name:item.i_manufact_id, type:int, comment:null), FieldSchema(name:item.i_manufact, type:string, comment:null), FieldSchema(name:item.i_size, type:string, comment:null), FieldSchema(name:item.i_formulation, type:string, comment:null), FieldSchema(name:item.i_color, type:string, comment:null), FieldSchema(name:item.i_units, type:string, comment:null), FieldSchema(name:item.i_container, type:string, comment:null), FieldSchema(name:item.i_manager_id, type:int, comment:null), FieldSchema(name:item.i_product_name, type:string, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20200716163026_3b6d8540-8b8b-4bd0-b020-3c5eccffa349); Time taken: 0.026 seconds INFO : Executing command(queryId=jenkins_20200716163026_3b6d8540-8b8b-4bd0-b020-3c5eccffa349): INSERT OVERWRITE TABLE tpcds_orc_def.item SELECT * FROM tpcds.item INFO : Query ID = jenkins_20200716163026_3b6d8540-8b8b-4bd0-b020-3c5eccffa349 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_20200716163026_3b6d8540-8b8b-4bd0-b020-3c5eccffa349 INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABLE tpcds_or...tpcds.item (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1594941333185_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 tpcds_orc_def.item from hdfs://localhost:20500/test-warehouse/managed/tpcds.item_orc_def INFO : Completed executing command(queryId=jenkins_20200716163026_3b6d8540-8b8b-4bd0-b020-3c5eccffa349); Time taken: 0.688 seconds INFO : OK 18,000 rows affected (0.726 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.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.002 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE tpcds_orc_def.pr omotion . . . . . . . . . . . . . . . . . . . .> SELECT * FROM tpcds.promotion; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20200716163026_40bf4254-e96b-4e01-82b4-8beef333d0e8): INSERT OVERWRITE TABLE tpcds_orc_def.promotion SELECT * FROM tpcds.promotion INFO : No Stats for tpcds@promotion, Columns: p_start_date_sk, p_channel_catalog, p_channel_demo, p_channel_email, p_end_date_sk, p_channel_press, p_channel_tv, p_discount_active, p_channel_details, p_purpose, p_promo_id, p_cost, p_channel_event, p_item_sk, p_response_target, p_promo_sk, p_promo_name, p_channel_dmail, p_channel_radio INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:promotion.p_promo_sk, type:int, comment:null), FieldSchema(name:promotion.p_promo_id, type:string, comment:null), FieldSchema(name:promotion.p_start_date_sk, type:int, comment:null), FieldSchema(name:promotion.p_end_date_sk, type:int, comment:null), FieldSchema(name:promotion.p_item_sk, type:bigint, comment:null), FieldSchema(name:promotion.p_cost, type:decimal(15,2), comment:null), FieldSchema(name:promotion.p_response_target, type:int, comment:null), FieldSchema(name:promotion.p_promo_name, type:string, comment:null), FieldSchema(name:promotion.p_channel_dmail, type:string, comment:null), FieldSchema(name:promotion.p_channel_email, type:string, comment:null), FieldSchema(name:promotion.p_channel_catalog, type:string, comment:null), FieldSchema(name:promotion.p_channel_tv, type:string, comment:null), FieldSchema(name:promotion.p_channel_radio, type:string, comment:null), FieldSchema(name:promotion.p_channel_press, type:string, comment:null), FieldSchema(name:promotion.p_channel_event, type:string, comment:null), FieldSchema(name:promotion.p_channel_demo, type:string, comment:null), FieldSchema(name:promotion.p_channel_details, type:string, comment:null), FieldSchema(name:promotion.p_purpose, type:string, comment:null), FieldSchema(name:promotion.p_discount_active, type:string, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20200716163026_40bf4254-e96b-4e01-82b4-8beef333d0e8); Time taken: 0.032 seconds INFO : Executing command(queryId=jenkins_20200716163026_40bf4254-e96b-4e01-82b4-8beef333d0e8): INSERT OVERWRITE TABLE tpcds_orc_def.promotion SELECT * FROM tpcds.promotion INFO : Query ID = jenkins_20200716163026_40bf4254-e96b-4e01-82b4-8beef333d0e8 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_20200716163026_40bf4254-e96b-4e01-82b4-8beef333d0e8 INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABLE tpc...tpcds.promotion (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1594941333185_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 tpcds_orc_def.promotion from hdfs://localhost:20500/test-warehouse/managed/tpcds.promotion_orc_def INFO : Completed executing command(queryId=jenkins_20200716163026_40bf4254-e96b-4e01-82b4-8beef333d0e8); Time taken: 0.209 seconds INFO : OK 300 rows affected (0.254 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.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.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 tpcds_orc_def.sh ip_mode . . . . . . . . . . . . . . . . . . . .> SELECT * FROM tpcds.ship_mode; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20200716163027_2693510a-eff9-4bc7-b270-87c6f40f50f5): INSERT OVERWRITE TABLE tpcds_orc_def.ship_mode SELECT * FROM tpcds.ship_mode INFO : No Stats for tpcds@ship_mode, Columns: sm_ship_mode_sk, sm_type, sm_code, sm_carrier, sm_contract, sm_ship_mode_id INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:ship_mode.sm_ship_mode_sk, type:int, comment:null), FieldSchema(name:ship_mode.sm_ship_mode_id, type:string, comment:null), FieldSchema(name:ship_mode.sm_type, type:string, comment:null), FieldSchema(name:ship_mode.sm_code, type:string, comment:null), FieldSchema(name:ship_mode.sm_carrier, type:string, comment:null), FieldSchema(name:ship_mode.sm_contract, type:string, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20200716163027_2693510a-eff9-4bc7-b270-87c6f40f50f5); Time taken: 0.023 seconds INFO : Executing command(queryId=jenkins_20200716163027_2693510a-eff9-4bc7-b270-87c6f40f50f5): INSERT OVERWRITE TABLE tpcds_orc_def.ship_mode SELECT * FROM tpcds.ship_mode INFO : Query ID = jenkins_20200716163027_2693510a-eff9-4bc7-b270-87c6f40f50f5 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_20200716163027_2693510a-eff9-4bc7-b270-87c6f40f50f5 INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABLE tpc...tpcds.ship_mode (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1594941333185_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 tpcds_orc_def.ship_mode from hdfs://localhost:20500/test-warehouse/managed/tpcds.ship_mode_orc_def INFO : Completed executing command(queryId=jenkins_20200716163027_2693510a-eff9-4bc7-b270-87c6f40f50f5); Time taken: 0.333 seconds INFO : OK 20 rows affected (0.369 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.001 seconds) 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE tpcds_orc_def.st ore . . . . . . . . . . . . . . . . . . . .> SELECT * FROM tpcds.store; going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! INFO : Compiling command(queryId=jenkins_20200716163027_129cb886-0613-4c28-93e6-2cd58ee36621): INSERT OVERWRITE TABLE tpcds_orc_def.store SELECT * FROM tpcds.store INFO : No Stats for tpcds@store, Columns: s_geography_class, s_company_id, s_closed_date_sk, s_county, s_city, s_division_name, s_zip, s_state, s_rec_end_date, s_floor_space, s_number_employees, s_tax_precentage, s_company_name, s_street_number, s_market_id, s_rec_start_date, s_store_name, s_suite_number, s_street_name, s_market_desc, s_division_id, s_country, s_hours, s_manager, s_market_manager, s_store_id, s_gmt_offset, s_store_sk, s_street_type INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:store.s_store_sk, type:int, comment:null), FieldSchema(name:store.s_store_id, type:string, comment:null), FieldSchema(name:store.s_rec_start_date, type:string, comment:null), FieldSchema(name:store.s_rec_end_date, type:string, comment:null), FieldSchema(name:store.s_closed_date_sk, type:int, comment:null), FieldSchema(name:store.s_store_name, type:string, comment:null), FieldSchema(name:store.s_number_employees, type:int, comment:null), FieldSchema(name:store.s_floor_space, type:int, comment:null), FieldSchema(name:store.s_hours, type:string, comment:null), FieldSchema(name:store.s_manager, type:string, comment:null), FieldSchema(name:store.s_market_id, type:int, comment:null), FieldSchema(name:store.s_geography_class, type:string, comment:null), FieldSchema(name:store.s_market_desc, type:string, comment:null), FieldSchema(name:store.s_market_manager, type:string, comment:null), FieldSchema(name:store.s_division_id, type:int, comment:null), FieldSchema(name:store.s_division_name, type:string, comment:null), FieldSchema(name:store.s_company_id, type:int, comment:null), FieldSchema(name:store.s_company_name, type:string, comment:null), FieldSchema(name:store.s_street_number, type:string, comment:null), FieldSchema(name:store.s_street_name, type:string, comment:null), FieldSchema(name:store.s_street_type, type:string, comment:null), FieldSchema(name:store.s_suite_number, type:string, comment:null), FieldSchema(name:store.s_city, type:string, comment:null), FieldSchema(name:store.s_county, type:string, comment:null), FieldSchema(name:store.s_state, type:string, comment:null), FieldSchema(name:store.s_zip, type:string, comment:null), FieldSchema(name:store.s_country, type:string, comment:null), FieldSchema(name:store.s_gmt_offset, type:decimal(5,2), comment:null), FieldSchema(name:store.s_tax_precentage, type:decimal(5,2), comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20200716163027_129cb886-0613-4c28-93e6-2cd58ee36621); Time taken: 0.027 seconds INFO : Executing command(queryId=jenkins_20200716163027_129cb886-0613-4c28-93e6-2cd58ee36621): INSERT OVERWRITE TABLE tpcds_orc_def.store SELECT * FROM tpcds.store INFO : Query ID = jenkins_20200716163027_129cb886-0613-4c28-93e6-2cd58ee36621 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_20200716163027_129cb886-0613-4c28-93e6-2cd58ee36621 INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABLE tpcds_o...tpcds.store (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1594941333185_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 tpcds_orc_def.store from hdfs://localhost:20500/test-warehouse/managed/tpcds.store_orc_def INFO : Completed executing command(queryId=jenkins_20200716163027_129cb886-0613-4c28-93e6-2cd58ee36621); Time taken: 0.19 seconds INFO : OK 12 rows affected (0.258 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 tpcds_orc_def.st ore_returns . . . . . . . . . . . . . . . . . . . .> SELECT * FROM tpcds.store_returns; going to print operations logs printed operations logs going to print operations logs INFO : Compiling command(queryId=jenkins_20200716163027_f4643686-9e61-4afe-a032-2880353e3097): INSERT OVERWRITE TABLE tpcds_orc_def.store_returns SELECT * FROM tpcds.store_returns INFO : No Stats for tpcds@store_returns, Columns: sr_hdemo_sk, sr_return_ship_cost, sr_reversed_charge, sr_returned_date_sk, sr_ticket_number, sr_net_loss, sr_reason_sk, sr_item_sk, sr_return_tax, sr_refunded_cash, sr_fee, sr_cdemo_sk, sr_return_amt, sr_store_credit, sr_addr_sk, sr_return_amt_inc_tax, sr_store_sk, sr_return_quantity, sr_customer_sk, sr_return_time_sk INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:store_returns.sr_returned_date_sk, type:int, comment:null), FieldSchema(name:store_returns.sr_return_time_sk, type:int, comment:null), FieldSchema(name:store_returns.sr_item_sk, type:bigint, comment:null), FieldSchema(name:store_returns.sr_customer_sk, type:int, comment:null), FieldSchema(name:store_returns.sr_cdemo_sk, type:int, comment:null), FieldSchema(name:store_returns.sr_hdemo_sk, type:int, comment:null), FieldSchema(name:store_returns.sr_addr_sk, type:int, comment:null), FieldSchema(name:store_returns.sr_store_sk, type:int, comment:null), FieldSchema(name:store_returns.sr_reason_sk, type:int, comment:null), FieldSchema(name:store_returns.sr_ticket_number, type:bigint, comment:null), FieldSchema(name:store_returns.sr_return_quantity, type:int, comment:null), FieldSchema(name:store_returns.sr_return_amt, type:decimal(7,2), comment:null), FieldSchema(name:store_returns.sr_return_tax, type:decimal(7,2), comment:null), FieldSchema(name:store_returns.sr_return_amt_inc_tax, type:decimal(7,2), comment:null), FieldSchema(name:store_returns.sr_fee, type:decimal(7,2), comment:null), FieldSchema(name:store_returns.sr_return_ship_cost, type:decimal(7,2), comment:null), FieldSchema(name:store_returns.sr_refunded_cash, type:decimal(7,2), comment:null), FieldSchema(name:store_returns.sr_reversed_charge, type:decimal(7,2), comment:null), FieldSchema(name:store_returns.sr_store_credit, type:decimal(7,2), comment:null), FieldSchema(name:store_returns.sr_net_loss, type:decimal(7,2), comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20200716163027_f4643686-9e61-4afe-a032-2880353e3097); Time taken: 0.024 seconds INFO : Executing command(queryId=jenkins_20200716163027_f4643686-9e61-4afe-a032-2880353e3097): INSERT OVERWRITE TABLE tpcds_orc_def.store_returns SELECT * FROM tpcds.store_returns INFO : Query ID = jenkins_20200716163027_f4643686-9e61-4afe-a032-2880353e3097 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_20200716163027_f4643686-9e61-4afe-a032-2880353e3097 INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABLE...tpcds.store_returns (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1594941333185_0012) printed operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 1.47 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 1.97 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 2.47 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 2.98 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 3.06 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 tpcds_orc_def.store_returns from hdfs://localhost:20500/test-warehouse/managed/tpcds.store_returns_orc_def INFO : Completed executing command(queryId=jenkins_20200716163027_f4643686-9e61-4afe-a032-2880353e3097); Time taken: 3.08 seconds INFO : OK ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 3.06 s ---------------------------------------------------------------------------------------------- 287,514 rows affected (3.117 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.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.022 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.003 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; 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> -- Split the load into multiple steps t o reduce total memory usage for larger 0: jdbc:hive2://localhost:11050/default> -- scale factors. TODO: Dynamically sca le this based on the scale factor? 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE tpcds_orc_def.st ore_sales PARTITION (ss_sold_date_sk) . . . . . . . . . . . . . . . . . . . .> SELECT ss_sold_time_sk, . . . . . . . . . . . . . . . . . . . .> ss_item_sk, . . . . . . . . . . . . . . . . . . . .> ss_customer_sk, . . . . . . . . . . . . . . . . . . . .> ss_cdemo_sk, . . . . . . . . . . . . . . . . . . . .> ss_hdemo_sk, . . . . . . . . . . . . . . . . . . . .> ss_addr_sk, . . . . . . . . . . . . . . . . . . . .> ss_store_sk, . . . . . . . . . . . . . . . . . . . .> ss_promo_sk, . . . . . . . . . . . . . . . . . . . .> ss_ticket_number, . . . . . . . . . . . . . . . . . . . .> ss_quantity, . . . . . . . . . . . . . . . . . . . .> ss_wholesale_cost, . . . . . . . . . . . . . . . . . . . .> ss_list_price, . . . . . . . . . . . . . . . . . . . .> ss_sales_price, . . . . . . . . . . . . . . . . . . . .> ss_ext_discount_amt, . . . . . . . . . . . . . . . . . . . .> ss_ext_sales_price, . . . . . . . . . . . . . . . . . . . .> ss_ext_wholesale_cost, . . . . . . . . . . . . . . . . . . . .> ss_ext_list_price, . . . . . . . . . . . . . . . . . . . .> ss_ext_tax, . . . . . . . . . . . . . . . . . . . .> ss_coupon_amt, . . . . . . . . . . . . . . . . . . . .> ss_net_paid, . . . . . . . . . . . . . . . . . . . .> ss_net_paid_inc_tax, . . . . . . . . . . . . . . . . . . . .> ss_net_profit, . . . . . . . . . . . . . . . . . . . .> ss_sold_date_sk . . . . . . . . . . . . . . . . . . . .> FROM tpcds.store_sales . . . . . . . . . . . . . . . . . . . .> WHERE ss_sold_date_sk IS NULL; going to print operations logs printed operations logs going to print operations logs INFO : Compiling command(queryId=jenkins_20200716163031_316614bc-c4f4-48fd-a0f5-7143912fcc31): INSERT OVERWRITE TABLE tpcds_orc_def.store_sales PARTITION (ss_sold_date_sk) SELECT ss_sold_time_sk, ss_item_sk, ss_customer_sk, ss_cdemo_sk, ss_hdemo_sk, ss_addr_sk, ss_store_sk, ss_promo_sk, ss_ticket_number, ss_quantity, ss_wholesale_cost, ss_list_price, ss_sales_price, ss_ext_discount_amt, ss_ext_sales_price, ss_ext_wholesale_cost, ss_ext_list_price, ss_ext_tax, ss_coupon_amt, ss_net_paid, ss_net_paid_inc_tax, ss_net_profit, ss_sold_date_sk FROM tpcds.store_sales WHERE ss_sold_date_sk IS NULL INFO : No Stats for tpcds@store_sales, Columns: ss_sold_time_sk, ss_cdemo_sk, ss_promo_sk, ss_ext_discount_amt, ss_ext_sales_price, ss_net_profit, ss_addr_sk, ss_ticket_number, ss_wholesale_cost, ss_item_sk, ss_ext_list_price, ss_store_sk, ss_coupon_amt, ss_quantity, ss_list_price, ss_sales_price, ss_customer_sk, ss_ext_wholesale_cost, ss_net_paid, ss_ext_tax, ss_hdemo_sk, ss_net_paid_inc_tax INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:ss_sold_time_sk, type:int, comment:null), FieldSchema(name:ss_item_sk, type:bigint, comment:null), FieldSchema(name:ss_customer_sk, type:int, comment:null), FieldSchema(name:ss_cdemo_sk, type:int, comment:null), FieldSchema(name:ss_hdemo_sk, type:int, comment:null), FieldSchema(name:ss_addr_sk, type:int, comment:null), FieldSchema(name:ss_store_sk, type:int, comment:null), FieldSchema(name:ss_promo_sk, type:int, comment:null), FieldSchema(name:ss_ticket_number, type:bigint, comment:null), FieldSchema(name:ss_quantity, type:int, comment:null), FieldSchema(name:ss_wholesale_cost, type:decimal(7,2), comment:null), FieldSchema(name:ss_list_price, type:decimal(7,2), comment:null), FieldSchema(name:ss_sales_price, type:decimal(7,2), comment:null), FieldSchema(name:ss_ext_discount_amt, type:decimal(7,2), comment:null), FieldSchema(name:ss_ext_sales_price, type:decimal(7,2), comment:null), FieldSchema(name:ss_ext_wholesale_cost, type:decimal(7,2), comment:null), FieldSchema(name:ss_ext_list_price, type:decimal(7,2), comment:null), FieldSchema(name:ss_ext_tax, type:decimal(7,2), comment:null), FieldSchema(name:ss_coupon_amt, type:decimal(7,2), comment:null), FieldSchema(name:ss_net_paid, type:decimal(7,2), comment:null), FieldSchema(name:ss_net_paid_inc_tax, type:decimal(7,2), comment:null), FieldSchema(name:ss_net_profit, type:decimal(7,2), comment:null), FieldSchema(name:ss_sold_date_sk, type:int, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20200716163031_316614bc-c4f4-48fd-a0f5-7143912fcc31); Time taken: 0.056 seconds INFO : Executing command(queryId=jenkins_20200716163031_316614bc-c4f4-48fd-a0f5-7143912fcc31): INSERT OVERWRITE TABLE tpcds_orc_def.store_sales PARTITION (ss_sold_date_sk) SELECT ss_sold_time_sk, ss_item_sk, ss_customer_sk, ss_cdemo_sk, ss_hdemo_sk, ss_addr_sk, ss_store_sk, ss_promo_sk, ss_ticket_number, ss_quantity, ss_wholesale_cost, ss_list_price, ss_sales_price, ss_ext_discount_amt, ss_ext_sales_price, ss_ext_wholesale_cost, ss_ext_list_price, ss_ext_tax, ss_coupon_amt, ss_net_paid, ss_net_paid_inc_tax, ss_net_profit, ss_sold_date_sk FROM tpcds.store_sales WHERE ss_sold_date_sk IS NULL INFO : Query ID = jenkins_20200716163031_316614bc-c4f4-48fd-a0f5-7143912fcc31 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_20200716163031_316614bc-c4f4-48fd-a0f5-7143912fcc31 INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABLE tpcds_orc_def....NULL (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1594941333185_0012) printed operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 1.37 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 1.88 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 1 0 1 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 2.38 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 2.61 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 tpcds_orc_def.store_sales partition (ss_sold_date_sk=null) from hdfs://localhost:20500/test-warehouse/managed/tpcds.store_sales_orc_def INFO : INFO : Time taken to load dynamic partitions: 0.11 seconds INFO : Time taken for adding to write entity : 0.001 seconds INFO : Completed executing command(queryId=jenkins_20200716163031_316614bc-c4f4-48fd-a0f5-7143912fcc31); Time taken: 2.684 seconds INFO : OK ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 1 1 0 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 2.62 s ---------------------------------------------------------------------------------------------- 130,093 rows affected (2.814 seconds) 0: jdbc:hive2://localhost:11050/default> 0: jdbc:hive2://localhost:11050/default> INSERT OVERWRITE TABLE tpcds_orc_def.st ore_sales PARTITION (ss_sold_date_sk) . . . . . . . . . . . . . . . . . . . .> SELECT ss_sold_time_sk, . . . . . . . . . . . . . . . . . . . .> ss_item_sk, . . . . . . . . . . . . . . . . . . . .> ss_customer_sk, . . . . . . . . . . . . . . . . . . . .> ss_cdemo_sk, . . . . . . . . . . . . . . . . . . . .> ss_hdemo_sk, . . . . . . . . . . . . . . . . . . . .> ss_addr_sk, . . . . . . . . . . . . . . . . . . . .> ss_store_sk, . . . . . . . . . . . . . . . . . . . .> ss_promo_sk, . . . . . . . . . . . . . . . . . . . .> ss_ticket_number, . . . . . . . . . . . . . . . . . . . .> ss_quantity, . . . . . . . . . . . . . . . . . . . .> ss_wholesale_cost, . . . . . . . . . . . . . . . . . . . .> ss_list_price, . . . . . . . . . . . . . . . . . . . .> ss_sales_price, . . . . . . . . . . . . . . . . . . . .> ss_ext_discount_amt, . . . . . . . . . . . . . . . . . . . .> ss_ext_sales_price, . . . . . . . . . . . . . . . . . . . .> ss_ext_wholesale_cost, . . . . . . . . . . . . . . . . . . . .> ss_ext_list_price, . . . . . . . . . . . . . . . . . . . .> ss_ext_tax, . . . . . . . . . . . . . . . . . . . .> ss_coupon_amt, . . . . . . . . . . . . . . . . . . . .> ss_net_paid, . . . . . . . . . . . . . . . . . . . .> ss_net_paid_inc_tax, . . . . . . . . . . . . . . . . . . . .> ss_net_profit, . . . . . . . . . . . . . . . . . . . .> ss_sold_date_sk . . . . . . . . . . . . . . . . . . . .> FROM tpcds.store_sales . . . . . . . . . . . . . . . . . . . .> WHERE ss_sold_date_sk < 2451272; going to print operations logs printed operations logs going to print operations logs INFO : Compiling command(queryId=jenkins_20200716163033_4fd19a3b-47b2-4ceb-a7ec-f4781b5c68b2): INSERT OVERWRITE TABLE tpcds_orc_def.store_sales PARTITION (ss_sold_date_sk) SELECT ss_sold_time_sk, ss_item_sk, ss_customer_sk, ss_cdemo_sk, ss_hdemo_sk, ss_addr_sk, ss_store_sk, ss_promo_sk, ss_ticket_number, ss_quantity, ss_wholesale_cost, ss_list_price, ss_sales_price, ss_ext_discount_amt, ss_ext_sales_price, ss_ext_wholesale_cost, ss_ext_list_price, ss_ext_tax, ss_coupon_amt, ss_net_paid, ss_net_paid_inc_tax, ss_net_profit, ss_sold_date_sk FROM tpcds.store_sales WHERE ss_sold_date_sk < 2451272 INFO : No Stats for tpcds@store_sales, Columns: ss_sold_time_sk, ss_cdemo_sk, ss_promo_sk, ss_ext_discount_amt, ss_ext_sales_price, ss_net_profit, ss_addr_sk, ss_ticket_number, ss_wholesale_cost, ss_item_sk, ss_ext_list_price, ss_store_sk, ss_coupon_amt, ss_quantity, ss_list_price, ss_sales_price, ss_customer_sk, ss_ext_wholesale_cost, ss_net_paid, ss_ext_tax, ss_hdemo_sk, ss_net_paid_inc_tax INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:ss_sold_time_sk, type:int, comment:null), FieldSchema(name:ss_item_sk, type:bigint, comment:null), FieldSchema(name:ss_customer_sk, type:int, comment:null), FieldSchema(name:ss_cdemo_sk, type:int, comment:null), FieldSchema(name:ss_hdemo_sk, type:int, comment:null), FieldSchema(name:ss_addr_sk, type:int, comment:null), FieldSchema(name:ss_store_sk, type:int, comment:null), FieldSchema(name:ss_promo_sk, type:int, comment:null), FieldSchema(name:ss_ticket_number, type:bigint, comment:null), FieldSchema(name:ss_quantity, type:int, comment:null), FieldSchema(name:ss_wholesale_cost, type:decimal(7,2), comment:null), FieldSchema(name:ss_list_price, type:decimal(7,2), comment:null), FieldSchema(name:ss_sales_price, type:decimal(7,2), comment:null), FieldSchema(name:ss_ext_discount_amt, type:decimal(7,2), comment:null), FieldSchema(name:ss_ext_sales_price, type:decimal(7,2), comment:null), FieldSchema(name:ss_ext_wholesale_cost, type:decimal(7,2), comment:null), FieldSchema(name:ss_ext_list_price, type:decimal(7,2), comment:null), FieldSchema(name:ss_ext_tax, type:decimal(7,2), comment:null), FieldSchema(name:ss_coupon_amt, type:decimal(7,2), comment:null), FieldSchema(name:ss_net_paid, type:decimal(7,2), comment:null), FieldSchema(name:ss_net_paid_inc_tax, type:decimal(7,2), comment:null), FieldSchema(name:ss_net_profit, type:decimal(7,2), comment:null), FieldSchema(name:ss_sold_date_sk, type:int, comment:null)], properties:null) INFO : Completed compiling command(queryId=jenkins_20200716163033_4fd19a3b-47b2-4ceb-a7ec-f4781b5c68b2); Time taken: 0.233 seconds INFO : Executing command(queryId=jenkins_20200716163033_4fd19a3b-47b2-4ceb-a7ec-f4781b5c68b2): INSERT OVERWRITE TABLE tpcds_orc_def.store_sales PARTITION (ss_sold_date_sk) SELECT ss_sold_time_sk, ss_item_sk, ss_customer_sk, ss_cdemo_sk, ss_hdemo_sk, ss_addr_sk, ss_store_sk, ss_promo_sk, ss_ticket_number, ss_quantity, ss_wholesale_cost, ss_list_price, ss_sales_price, ss_ext_discount_amt, ss_ext_sales_price, ss_ext_wholesale_cost, ss_ext_list_price, ss_ext_tax, ss_coupon_amt, ss_net_paid, ss_net_paid_inc_tax, ss_net_profit, ss_sold_date_sk FROM tpcds.store_sales WHERE ss_sold_date_sk < 2451272 INFO : Query ID = jenkins_20200716163033_4fd19a3b-47b2-4ceb-a7ec-f4781b5c68b2 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_20200716163033_4fd19a3b-47b2-4ceb-a7ec-f4781b5c68b2 INFO : Session is already open INFO : Dag name: INSERT OVERWRITE TABLE tpcds_orc_d...2451272 (Stage-1) INFO : Status: Running (Executing on YARN cluster with App id application_1594941333185_0012) printed operations logs ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container INITIALIZING -1 0 0 -1 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [>>--------------------------] 0% ELAPSED TIME: 1.17 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container INITIALIZING -1 0 0 -1 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [>>--------------------------] 0% ELAPSED TIME: 1.67 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container INITIALIZING -1 0 0 -1 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [>>--------------------------] 0% ELAPSED TIME: 2.18 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container INITIALIZING -1 0 0 -1 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [>>--------------------------] 0% ELAPSED TIME: 2.68 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 131 0 1 130 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [>>--------------------------] 0% ELAPSED TIME: 3.19 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 131 0 1 130 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [>>--------------------------] 0% ELAPSED TIME: 3.70 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 131 1 0 130 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [>>--------------------------] 0% ELAPSED TIME: 4.20 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 131 1 0 130 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [>>--------------------------] 0% ELAPSED TIME: 4.70 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 131 2 1 128 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [>>--------------------------] 1% ELAPSED TIME: 5.21 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 131 3 1 127 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [>>--------------------------] 2% ELAPSED TIME: 5.72 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 131 5 1 125 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [>>--------------------------] 3% ELAPSED TIME: 6.22 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 131 7 1 123 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [=>>-------------------------] 5% ELAPSED TIME: 6.72 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 131 9 1 121 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [=>>-------------------------] 6% ELAPSED TIME: 7.23 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 131 11 1 119 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [==>>------------------------] 8% ELAPSED TIME: 7.74 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 131 11 2 118 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [==>>------------------------] 8% ELAPSED TIME: 8.24 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container RUNNING 131 12 2 117 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [==>>------------------------] 8% ELAPSED TIME: 8.75 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 . container RUNNING 131 14 3 114 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [==>>------------------------] 10% ELAPSED TIME: 9.26 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 . container RUNNING 131 14 3 114 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [==>>------------------------] 10% ELAPSED TIME: 9.76 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 . container RUNNING 131 17 4 110 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [===>>-----------------------] 12% ELAPSED TIME: 10.76 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 . container RUNNING 131 20 6 105 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [===>>-----------------------] 14% ELAPSED TIME: 11.77 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 . container RUNNING 131 22 7 102 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [====>>----------------------] 16% ELAPSED TIME: 12.78 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 . container RUNNING 131 24 8 99 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [====>>----------------------] 17% ELAPSED TIME: 13.78 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .. container RUNNING 131 28 8 95 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [=====>>---------------------] 20% ELAPSED TIME: 14.79 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .. container RUNNING 131 32 9 90 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [======>>--------------------] 23% ELAPSED TIME: 15.80 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .. container RUNNING 131 38 10 83 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [=======>>-------------------] 28% ELAPSED TIME: 16.81 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ... container RUNNING 131 44 10 77 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [========>>------------------] 32% ELAPSED TIME: 17.81 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ... container RUNNING 131 50 11 70 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [=========>>-----------------] 37% ELAPSED TIME: 18.81 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .... container RUNNING 131 56 12 63 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [==========>>----------------] 41% ELAPSED TIME: 19.83 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ..... container RUNNING 131 69 15 47 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [=============>>-------------] 51% ELAPSED TIME: 21.33 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ..... container RUNNING 131 78 15 38 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [===============>>-----------] 57% ELAPSED TIME: 22.84 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ....... container RUNNING 131 92 16 23 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [=================>>---------] 68% ELAPSED TIME: 24.34 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ....... container RUNNING 131 103 16 12 0 0 Reducer 2 container INITED 4 0 0 4 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [===================>>-------] 76% ELAPSED TIME: 25.85 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ........ container RUNNING 131 112 12 7 0 0 Reducer 2 container RUNNING 4 0 4 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [=====================>>-----] 82% ELAPSED TIME: 27.35 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ........ container RUNNING 131 113 13 5 0 0 Reducer 2 container RUNNING 4 0 4 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [=====================>>-----] 83% ELAPSED TIME: 28.86 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ........ container RUNNING 131 113 16 2 0 0 Reducer 2 container RUNNING 4 0 4 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [=====================>>-----] 83% ELAPSED TIME: 30.37 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ........ container RUNNING 131 116 15 0 0 0 Reducer 2 container RUNNING 4 0 4 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [======================>>----] 85% ELAPSED TIME: 32.38 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ......... container RUNNING 131 118 13 0 0 0 Reducer 2 container RUNNING 4 0 4 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [======================>>----] 87% ELAPSED TIME: 34.39 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ......... container RUNNING 131 121 10 0 0 0 Reducer 2 container RUNNING 4 0 4 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [=======================>>---] 89% ELAPSED TIME: 36.40 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ......... container RUNNING 131 123 8 0 0 0 Reducer 2 container RUNNING 4 0 4 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [=======================>>---] 91% ELAPSED TIME: 38.40 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 ......... container RUNNING 131 127 4 0 0 0 Reducer 2 container RUNNING 4 0 4 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [========================>>--] 94% ELAPSED TIME: 40.41 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 131 131 0 0 0 0 Reducer 2 container RUNNING 4 0 4 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [=========================>>-] 97% ELAPSED TIME: 42.91 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 131 131 0 0 0 0 Reducer 2 container RUNNING 4 0 4 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [=========================>>-] 97% ELAPSED TIME: 45.42 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 131 131 0 0 0 0 Reducer 2 container RUNNING 4 0 4 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [=========================>>-] 97% ELAPSED TIME: 47.92 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 131 131 0 0 0 0 Reducer 2 container RUNNING 4 0 4 0 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [=========================>>-] 97% ELAPSED TIME: 50.42 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 131 131 0 0 0 0 Reducer 2 container RUNNING 4 0 4 0 1 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [=========================>>-] 97% ELAPSED TIME: 53.42 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 131 131 0 0 0 0 Reducer 2 . container RUNNING 4 1 3 0 1 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [=========================>>-] 97% ELAPSED TIME: 56.42 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 131 131 0 0 0 0 Reducer 2 . container RUNNING 4 1 3 0 1 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [=========================>>-] 97% ELAPSED TIME: 59.42 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 131 131 0 0 0 0 Reducer 2 . container RUNNING 4 1 3 0 1 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [=========================>>-] 97% ELAPSED TIME: 62.92 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 131 131 0 0 0 0 Reducer 2 . container RUNNING 4 1 3 0 1 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [=========================>>-] 97% ELAPSED TIME: 66.43 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 131 131 0 0 0 0 Reducer 2 ... container RUNNING 4 2 2 0 1 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [=========================>>-] 98% ELAPSED TIME: 69.93 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 131 131 0 0 0 0 Reducer 2 ... container RUNNING 4 2 2 0 1 0 ---------------------------------------------------------------------------------------------- VERTICES: 01/02 [=========================>>-] 98% ELAPSED TIME: 73.93 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 131 131 0 0 0 0 Reducer 2 ...... container SUCCEEDED 4 4 0 0 1 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 77.93 s ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 .......... container SUCCEEDED 131 131 0 0 0 0 Reducer 2 ...... container SUCCEEDED 4 4 0 0 1 0 ---------------------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 79.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 tpcds_orc_def.store_sales partition (ss_sold_date_sk=null) from hdfs://localhost:20500/test-warehouse/managed/tpcds.store_sales_orc_def INFO : ERROR : FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask. java.io.IOException: Fail to get checksum, since file /test-warehouse/managed/tpcds.store_sales_orc_def/ss_sold_date_sk=2451141/base_0000002/_orc_acid_version is under construction. INFO : Completed executing command(queryId=jenkins_20200716163033_4fd19a3b-47b2-4ceb-a7ec-f4781b5c68b2); Time taken: 80.229 seconds INFO : OK Error: Error while compiling statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask. java.io.IOException: Fail to get checksum, since file /test-warehouse/managed/tpcds.store_sales_orc_def/ss_sold_date_sk=2451141/base_0000002/_orc_acid_version is under construction. (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. java.io.IOException: Fail to get checksum, since file /test-warehouse/managed/tpcds.store_sales_orc_def/ss_sold_date_sk=2451141/base_0000002/_orc_acid_version is under construction. 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