Erro
===============================================================================================
Loading data to table
vau.vau_multi_issr_mnthly_mrch_participation partition (cpd_dt=20180630)
FAILED: Execution Error,
return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask. Unable to move
source hdfs://nameservice1/hive/vau.db/vau_multi_issr_mnthly_mrch_participation/cpd_dt=20180630/.hive-staging_hive_2018-07-26_11-06-28_809_8487593963319586229-1/-ext-10000
to destination
hdfs://nameservice1/hive/vau.db/vau_multi_issr_mnthly_mrch_participation/cpd_dt=20180630
===============================================================================================
Command
===============================================================================================
insert overwrite table
vau_multi_issr_mnthly_mrch_participation partition (cpd_dt=20180630)
select
concat_ws(':',cast
(temp2.ua_mult_issr_id as string),temp2.ua_mult_issr_nm,
concat_ws('~',collect_list(concat_ws('|',cast(temp1.ua_issr_seg_id
as string),
temp1.ua_issr_seg_nm,
cast(temp1.ua_issr_id as
string),
temp1.ua_issr_nm,
cast(temp1.ua_bin as
string),
cast(temp2.regn_cd as
string),
cast(temp2.regn_nm as
string),
cast(temp2.ctry_cd as
string),
cast(temp2.ctry_nm as
string),
cast(temp1.enrl_dt as
string),
cast(rpt_fmt_ind as
string),
lpad(cast(coalesce(vol_bus_id,
'') as string), 8, '0'))))) as arr1
from
vau_multi_issr_mnthly_mrch_participation_temp1
temp1
inner join
vau_multi_issr_mnthly_mrch_participation_temp2
temp2
on
temp1.ua_issr_seg_id =
temp2.ua_issr_seg_id
group by
temp2.ua_mult_issr_id,temp2.ua_mult_issr_nm;
