hive return code 2的问题

 

 

在执行脚本:

 

create table liuchengtmp1_%CHINDAASDATE% as
	select a.markcode, a.xiangmu, 
	case when instrfun(xiangmu,'已注册（') >0 THEN '已注册'
		 when instrfun(xiangmu,'初步审定（') >0 THEN '初步审定'
		 ELSE XIANGMU
	END XIANGMU_new
	from f_tm_process_hdfs_ext_%CHINDAASDATE%  a 
	join (

	select max(fliuc_id) fliucid1 from f_tm_process_hdfs_ext_%CHINDAASDATE% a join
  (select a.markcode,max(a.liuchengdate) maxliuchendate,max(a.fliuc_idt) maxfliucidt 
  from f_tm_process_hdfs_ext_%CHINDAASDATE% a join 
  (select
  markcode,
  max(liuchengdate) maxliuchendate
  from f_tm_process_hdfs_ext_%CHINDAASDATE% group by markcode) b
  on a.markcode = b.markcode and a.liuchengdate = b.maxliuchendate
  group by a.markcode) c
  on a.markcode = c.markcode and a.liuchengdate = c.maxliuchendate and a.fliuc_idt =