hive> insert overwrite table fp3 select farm_id , group_id ,time,regexp_replace(power_forecast,'NA','') from fp1;
Query ID = root_20160717160918_0fa00313-ec8e-4079-a642-b420fca15cba
Total jobs = 3
Launching Job 1 out of 3
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_1463811115991_0016, Tracking URL = http://node-master2-845ae.com:80 ... 1463811115991_0016/
Kill Command = /data0/app/cloud/client/hadoop/bin/hadoop job -kill job_1463811115991_0016
Hadoop job information for Stage-1: number of mappers: 0; number of reducers: 0
2016-07-17 16:09:23,368 Stage-1 map = 0%, reduce = 0%
Ended Job = job_1463811115991_0016 with errors
Error during job, obtaining debugging information...
FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
MapReduce Jobs Launched:
Stage-Stage-1: HDFS Read: 0 HDFS Write: 0 FAIL
Total MapReduce CPU Time Spent: 0 msec |