[2016-04-21 11:20:57] -- Job:============================================== [2016-04-21 11:20:57] -- Cube [Cube1] BUILD job [aa07dd4a-6c67-4724-814c-60bb61cbcc7a] progress:100.0% [2016-04-21 11:20:57] -- Job name:Cube1 - 20160115000000_20160131000000 - BUILD - PDT 2016-04-20 02:05:37 [2016-04-21 11:20:57] -- Duration:833s [2016-04-21 11:20:57] -- MapReduce Waiting:555s [2016-04-21 11:20:57] -- Job status:FINISHED [2016-04-21 11:20:57] -- Steps:============================================== [2016-04-21 11:20:57] -- 1-Create Intermediate Flat Hive Table [2016-04-21 11:20:57] -- ID: aa07dd4a-6c67-4724-814c-60bb61cbcc7a-00 [2016-04-21 11:20:57] -- Exec command: beeline -u "jdbc:hive2://[ip]:10000/hdw;principal=hive/cdh-datanode-001.xxx.storage@xxx.STORAGE" -n "" -p "" -i "$KYLIN_HOME/conf/hiverc" -f /wls/programs/apache-kylin-1.5.0-bin/bin/../tomcat/temp/beeline_4040353160274065482.hql;rm -f /wls/programs/apache-kylin-1.5.0-bin/bin/../tomcat/temp/beeline_4040353160274065482.hql [2016-04-21 11:20:57] -- Exec command type: SHELL_CMD_HADOOP [2016-04-21 11:20:57] -- Step status: FINISHED [2016-04-21 11:20:57] -- Start time: 2016-04-20T17:06:36 [2016-04-21 11:20:57] -- End time: 2016-04-20T17:08:42 [2016-04-21 11:20:57] -- Duration: 125s [2016-04-21 11:20:57] -- Try to get step log - aa07dd4a-6c67-4724-814c-60bb61cbcc7a - aa07dd4a-6c67-4724-814c-60bb61cbcc7a-00... [2016-04-21 11:20:57] -- HTTP STATUS:200 [2016-04-21 11:20:57] -- HTTP RESULT:OK [2016-04-21 11:20:57] -- Step Log : scan complete in 2ms Connecting to jdbc:hive2://[ip]:10000/hdw;principal=hive/cdh-datanode-001.xxx.storage@xxx.STORAGE Connected to: Apache Hive (version 1.1.0-cdh5.4.2) Driver: Hive JDBC (version 1.1.0-cdh5.4.2) Transaction isolation: TRANSACTION_REPEATABLE_READ Running init script /wls/programs/apache-kylin-1.5.0-bin/bin/..//conf/hiverc 0: jdbc:hive2://[ip]:10000/hdw> set mapreduce.job.queuename=root.mis.mi s_kyl; No rows affected (0.067 seconds) 0: jdbc:hive2://[ip]:10000/hdw> 0: jdbc:hive2://[ip]:10000/hdw> 0: jdbc:hive2://[ip]:10000/hdw> USE kyl; No rows affected (0.481 seconds) 0: jdbc:hive2://[ip]:10000/hdw> DROP TABLE IF EXISTS kylin_intermediate _Cube1_20160115000000_20160131000000; No rows affected (0.139 seconds) 0: jdbc:hive2://[ip]:10000/hdw> 0: jdbc:hive2://[ip]:10000/hdw> CREATE EXTERNAL TABLE IF NOT EXISTS kyl in_intermediate_Cube1_20160115000000_20160131000000 0: jdbc:hive2://[ip]:10000/hdw> ( 0: jdbc:hive2://[ip]:10000/hdw> MSCRPT_T1_STAT_DATE string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_PRODUCT_TYPE_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_ITEM_NAME string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_PRODUCT_CATEGORY_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_BANNER_CATEGORY_NAME string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_MOB_NAME string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_CURRENT_AUM_RANGE_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_PREVIOUS_AUM_RANGE_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_PREVIOUS_CHANGE_AUM_RATE_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_NEW_FLAG_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_SX_FLAG_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_SX_D_FLAG string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_T_NEXT_30_FLAG_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_VIP_FLAG_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_SCD_VIP_FLAG_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_COMMON_FLAG_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_CLASS_GROUP_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_IS_COMPANY_FLAG_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_STAT_YEAR int 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_STAT_MONTH int 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_STAT_DAY int 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_AUM decimal(38,10) 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_CHANGED_AUM decimal(38,10) 0: jdbc:hive2://[ip]:10000/hdw> ) 0: jdbc:hive2://[ip]:10000/hdw> ROW FORMAT DELIMITED FIELDS TERMINATED BY '\177' 0: jdbc:hive2://[ip]:10000/hdw> STORED AS SEQUENCEFILE 0: jdbc:hive2://[ip]:10000/hdw> LOCATION '/user/dba/kylin_v15/kyl-kylin _metadata_dba_v15/kylin-aa07dd4a-6c67-4724-814c-60bb61cbcc7a/kylin_intermediate_ Cube1_20160115000000_20160131000000'; No rows affected (0.372 seconds) 0: jdbc:hive2://[ip]:10000/hdw> 0: jdbc:hive2://[ip]:10000/hdw> SET dfs.replication=2; No rows affected (0.003 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET dfs.block.size=32000000; No rows affected (0.003 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET hive.exec.compress.output=true; No rows affected (0.003 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET hive.auto.convert.join.noconditiona ltask=true; No rows affected (0.004 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET hive.auto.convert.join.noconditiona ltask.size=300000000; No rows affected (0.005 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET mapreduce.map.output.compress.codec =org.apache.hadoop.io.compress.SnappyCodec; No rows affected (0.003 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET mapreduce.output.fileoutputformat.c ompress.codec=org.apache.hadoop.io.compress.SnappyCodec; No rows affected (0.004 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET hive.merge.mapfiles=true; No rows affected (0.004 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET hive.merge.mapredfiles=true; No rows affected (0.003 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET mapred.output.compression.type=BLOC K; No rows affected (0.003 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET hive.merge.size.per.task=256000000; No rows affected (0.003 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET hive.support.concurrency=false; No rows affected (0.003 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET mapreduce.job.split.metainfo.maxsiz e=-1; No rows affected (0.002 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET mapreduce.job.queuename=root.mis.mi s_kyl; No rows affected (0.003 seconds) 0: jdbc:hive2://[ip]:10000/hdw> INSERT OVERWRITE TABLE kylin_intermedia te_Cube1_20160115000000_20160131000000 SELECT 0: jdbc:hive2://[ip]:10000/hdw> T1.STAT_DATE 0: jdbc:hive2://[ip]:10000/hdw> ,T1.PRODUCT_TYPE_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.ITEM_NAME 0: jdbc:hive2://[ip]:10000/hdw> ,T1.PRODUCT_CATEGORY_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.BANNER_CATEGORY_NAME 0: jdbc:hive2://[ip]:10000/hdw> ,T1.MOB_NAME 0: jdbc:hive2://[ip]:10000/hdw> ,T1.CURRENT_AUM_RANGE_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.PREVIOUS_AUM_RANGE_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.PREVIOUS_CHANGE_AUM_RATE_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.NEW_FLAG_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.SX_FLAG_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.SX_D_FLAG 0: jdbc:hive2://[ip]:10000/hdw> ,T1.T_NEXT_30_FLAG_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.VIP_FLAG_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.SCD_VIP_FLAG_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.COMMON_FLAG_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.CLASS_GROUP_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.IS_COMPANY_FLAG_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.STAT_YEAR 0: jdbc:hive2://[ip]:10000/hdw> ,T1.STAT_MONTH 0: jdbc:hive2://[ip]:10000/hdw> ,T1.STAT_DAY 0: jdbc:hive2://[ip]:10000/hdw> ,T1.AUM 0: jdbc:hive2://[ip]:10000/hdw> ,T1.CHANGED_AUM 0: jdbc:hive2://[ip]:10000/hdw> FROM MSCRPT.T1 as T1 0: jdbc:hive2://[ip]:10000/hdw> WHERE (T1.FULL_STAT_DATE >= '2016-01-15' AND T1.FULL_STAT_DATE < '2016-01-31') 0: jdbc:hive2://[ip]:10000/hdw> ; INFO : Number of reduce tasks is set to 0 since there's no reduce operator WARN : Hadoop command-line option parsing not performed. Implement the Tool interface and execute your application with ToolRunner to remedy this. INFO : number of splits:1030 INFO : Submitting tokens for job: job_1460656710051_194273 INFO : Kind: HDFS_DELEGATION_TOKEN, Service: ha-hdfs:xxxhd, Ident: (HDFS_DELEGATION_TOKEN token 5148853 for hive) INFO : The url to track the job: http://cdh-namenode-012.xxx.storage:8088/proxy/application_1460656710051_194273/ INFO : Starting Job = job_1460656710051_194273, Tracking URL = http://cdh-namenode-012.xxx.storage:8088/proxy/application_1460656710051_194273/ INFO : Kill Command = /opt/cloudera/parcels/CDH-5.4.2-1.cdh5.4.2.p0.2/lib/hadoop/bin/hadoop job -kill job_1460656710051_194273 INFO : Hadoop job information for Stage-1: number of mappers: 1030; number of reducers: 0 INFO : 2016-04-20 17:07:05,294 Stage-1 map = 0%, reduce = 0% INFO : 2016-04-20 17:07:52,253 Stage-1 map = 1%, reduce = 0%, Cumulative CPU 2469.6 sec INFO : 2016-04-20 17:07:58,517 Stage-1 map = 2%, reduce = 0%, Cumulative CPU 2829.73 sec INFO : 2016-04-20 17:08:14,138 Stage-1 map = 3%, reduce = 0%, Cumulative CPU 3678.06 sec INFO : 2016-04-20 17:08:24,628 Stage-1 map = 4%, reduce = 0%, Cumulative CPU 4230.44 sec INFO : 2016-04-20 17:08:39,328 Stage-1 map = 99%, reduce = 0%, Cumulative CPU 3297.79 sec INFO : 2016-04-20 17:08:40,357 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 3297.79 sec INFO : MapReduce Total cumulative CPU time: 54 minutes 57 seconds 790 msec ERROR : Ended Job = job_1460656710051_194273 with errors Error: Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask (state=08S01,code=2) Closing: 0: jdbc:hive2://[ip]:10000/hdw;principal=hive/cdh-datanode-001.xxx.storage@xxx.STORAGE [2016-04-21 11:20:57] -- scan complete in 2ms Connecting to jdbc:hive2://[ip]:10000/hdw;principal=hive/cdh-datanode-001.xxx.storage@xxx.STORAGE Connected to: Apache Hive (version 1.1.0-cdh5.4.2) Driver: Hive JDBC (version 1.1.0-cdh5.4.2) Transaction isolation: TRANSACTION_REPEATABLE_READ Running init script /wls/programs/apache-kylin-1.5.0-bin/bin/..//conf/hiverc 0: jdbc:hive2://[ip]:10000/hdw> set mapreduce.job.queuename=root.mis.mi s_kyl; No rows affected (0.067 seconds) 0: jdbc:hive2://[ip]:10000/hdw> 0: jdbc:hive2://[ip]:10000/hdw> 0: jdbc:hive2://[ip]:10000/hdw> USE kyl; No rows affected (0.481 seconds) 0: jdbc:hive2://[ip]:10000/hdw> DROP TABLE IF EXISTS kylin_intermediate _Cube1_20160115000000_20160131000000; No rows affected (0.139 seconds) 0: jdbc:hive2://[ip]:10000/hdw> 0: jdbc:hive2://[ip]:10000/hdw> CREATE EXTERNAL TABLE IF NOT EXISTS kyl in_intermediate_Cube1_20160115000000_20160131000000 0: jdbc:hive2://[ip]:10000/hdw> ( 0: jdbc:hive2://[ip]:10000/hdw> MSCRPT_T1_STAT_DATE string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_PRODUCT_TYPE_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_ITEM_NAME string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_PRODUCT_CATEGORY_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_BANNER_CATEGORY_NAME string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_MOB_NAME string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_CURRENT_AUM_RANGE_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_PREVIOUS_AUM_RANGE_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_PREVIOUS_CHANGE_AUM_RATE_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_NEW_FLAG_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_SX_FLAG_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_SX_D_FLAG string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_T_NEXT_30_FLAG_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_VIP_FLAG_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_SCD_VIP_FLAG_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_COMMON_FLAG_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_CLASS_GROUP_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_IS_COMPANY_FLAG_CN string 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_STAT_YEAR int 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_STAT_MONTH int 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_STAT_DAY int 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_AUM decimal(38,10) 0: jdbc:hive2://[ip]:10000/hdw> ,MSCRPT_T1_CHANGED_AUM decimal(38,10) 0: jdbc:hive2://[ip]:10000/hdw> ) 0: jdbc:hive2://[ip]:10000/hdw> ROW FORMAT DELIMITED FIELDS TERMINATED BY '\177' 0: jdbc:hive2://[ip]:10000/hdw> STORED AS SEQUENCEFILE 0: jdbc:hive2://[ip]:10000/hdw> LOCATION '/user/dba/kylin_v15/kyl-kylin _metadata_dba_v15/kylin-aa07dd4a-6c67-4724-814c-60bb61cbcc7a/kylin_intermediate_ Cube1_20160115000000_20160131000000'; No rows affected (0.372 seconds) 0: jdbc:hive2://[ip]:10000/hdw> 0: jdbc:hive2://[ip]:10000/hdw> SET dfs.replication=2; No rows affected (0.003 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET dfs.block.size=32000000; No rows affected (0.003 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET hive.exec.compress.output=true; No rows affected (0.003 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET hive.auto.convert.join.noconditiona ltask=true; No rows affected (0.004 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET hive.auto.convert.join.noconditiona ltask.size=300000000; No rows affected (0.005 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET mapreduce.map.output.compress.codec =org.apache.hadoop.io.compress.SnappyCodec; No rows affected (0.003 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET mapreduce.output.fileoutputformat.c ompress.codec=org.apache.hadoop.io.compress.SnappyCodec; No rows affected (0.004 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET hive.merge.mapfiles=true; No rows affected (0.004 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET hive.merge.mapredfiles=true; No rows affected (0.003 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET mapred.output.compression.type=BLOC K; No rows affected (0.003 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET hive.merge.size.per.task=256000000; No rows affected (0.003 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET hive.support.concurrency=false; No rows affected (0.003 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET mapreduce.job.split.metainfo.maxsiz e=-1; No rows affected (0.002 seconds) 0: jdbc:hive2://[ip]:10000/hdw> SET mapreduce.job.queuename=root.mis.mi s_kyl; No rows affected (0.003 seconds) 0: jdbc:hive2://[ip]:10000/hdw> INSERT OVERWRITE TABLE kylin_intermedia te_Cube1_20160115000000_20160131000000 SELECT 0: jdbc:hive2://[ip]:10000/hdw> T1.STAT_DATE 0: jdbc:hive2://[ip]:10000/hdw> ,T1.PRODUCT_TYPE_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.ITEM_NAME 0: jdbc:hive2://[ip]:10000/hdw> ,T1.PRODUCT_CATEGORY_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.BANNER_CATEGORY_NAME 0: jdbc:hive2://[ip]:10000/hdw> ,T1.MOB_NAME 0: jdbc:hive2://[ip]:10000/hdw> ,T1.CURRENT_AUM_RANGE_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.PREVIOUS_AUM_RANGE_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.PREVIOUS_CHANGE_AUM_RATE_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.NEW_FLAG_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.SX_FLAG_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.SX_D_FLAG 0: jdbc:hive2://[ip]:10000/hdw> ,T1.T_NEXT_30_FLAG_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.VIP_FLAG_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.SCD_VIP_FLAG_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.COMMON_FLAG_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.CLASS_GROUP_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.IS_COMPANY_FLAG_CN 0: jdbc:hive2://[ip]:10000/hdw> ,T1.STAT_YEAR 0: jdbc:hive2://[ip]:10000/hdw> ,T1.STAT_MONTH 0: jdbc:hive2://[ip]:10000/hdw> ,T1.STAT_DAY 0: jdbc:hive2://[ip]:10000/hdw> ,T1.AUM 0: jdbc:hive2://[ip]:10000/hdw> ,T1.CHANGED_AUM 0: jdbc:hive2://[ip]:10000/hdw> FROM MSCRPT.T1 as T1 0: jdbc:hive2://[ip]:10000/hdw> WHERE (T1.FULL_STAT_DATE >= '2016-01-15' AND T1.FULL_STAT_DATE < '2016-01-31') 0: jdbc:hive2://[ip]:10000/hdw> ; INFO : Number of reduce tasks is set to 0 since there's no reduce operator WARN : Hadoop command-line option parsing not performed. Implement the Tool interface and execute your application with ToolRunner to remedy this. INFO : number of splits:1030 INFO : Submitting tokens for job: job_1460656710051_194273 INFO : Kind: HDFS_DELEGATION_TOKEN, Service: ha-hdfs:xxxhd, Ident: (HDFS_DELEGATION_TOKEN token 5148853 for hive) INFO : The url to track the job: http://cdh-namenode-012.xxx.storage:8088/proxy/application_1460656710051_194273/ INFO : Starting Job = job_1460656710051_194273, Tracking URL = http://cdh-namenode-012.xxx.storage:8088/proxy/application_1460656710051_194273/ INFO : Kill Command = /opt/cloudera/parcels/CDH-5.4.2-1.cdh5.4.2.p0.2/lib/hadoop/bin/hadoop job -kill job_1460656710051_194273 INFO : Hadoop job information for Stage-1: number of mappers: 1030; number of reducers: 0 INFO : 2016-04-20 17:07:05,294 Stage-1 map = 0%, reduce = 0% INFO : 2016-04-20 17:07:52,253 Stage-1 map = 1%, reduce = 0%, Cumulative CPU 2469.6 sec INFO : 2016-04-20 17:07:58,517 Stage-1 map = 2%, reduce = 0%, Cumulative CPU 2829.73 sec INFO : 2016-04-20 17:08:14,138 Stage-1 map = 3%, reduce = 0%, Cumulative CPU 3678.06 sec INFO : 2016-04-20 17:08:24,628 Stage-1 map = 4%, reduce = 0%, Cumulative CPU 4230.44 sec INFO : 2016-04-20 17:08:39,328 Stage-1 map = 99%, reduce = 0%, Cumulative CPU 3297.79 sec INFO : 2016-04-20 17:08:40,357 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 3297.79 sec INFO : MapReduce Total cumulative CPU time: 54 minutes 57 seconds 790 msec ERROR : Ended Job = job_1460656710051_194273 with errors Error: Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask (state=08S01,code=2) Closing: 0: jdbc:hive2://[ip]:10000/hdw;principal=hive/cdh-datanode-001.xxx.storage@xxx.STORAGE