java.sql.SQLException: SQLJob: 28ed8f13-d1ad-41a8-977b-baa49f413c04 failed when executing SQL: /********************************************************************/ insert overwrite table ksh_xjr_ssbk -- 一维度 select count(*) as ssbkqy,industry_name,null as area_name,null as qylx,null as ssbk from tmp_xjr_2 group by industry_name union all select count(*) as ssbkqy,null as industry_name,area_name,null as qylx,null as ssbk from tmp_xjr_2 group by area_name union all select count(*) as ssbkqy,null as industry_name,null as area_name,qylx,null as ssbk from tmp_xjr_2 group by qylx union all select count(*) as ssbkqy,null as industry_name,null as area_name,null as qylx,ssbk from tmp_xjr_2 group by ssbk -- 二维度 union all select count(*) as ssbkqy,industry_name,area_name,null as qylx,null as ssbk from tmp_xjr_2 group by industry_name,area_name union all select count(*) as ssbkqy,industry_name,null as area_name,qylx,null as ssbk from tmp_xjr_2 group by industry_name,qylx union all select count(*) as ssbkqy,industry_name,null as area_name,null as qylx,ssbk from tmp_xjr_2 group by industry_name,ssbk union all select count(*) as ssbkqy,null as industry_name,area_name,qylx,null as ssbk from tmp_xjr_2 group by area_name,qylx union all select count(*) as ssbkqy,null as industry_name,area_name,null as qylx,null as ssbk from tmp_xjr_2 group by area_name,ssbk union all select count(*) as ssbkqy,null as industry_name,null as area_name,qylx,ssbk from tmp_xjr_2 group by qylx,ssbk -- 三维度 union all select count(*) as ssbkqy,industry_name,null as area_name,qylx,ssbk from tmp_xjr_2 group by industry_name,qylx,ssbk union all select count(*) as ssbkqy,industry_name,area_name,null as qylx,ssbk from tmp_xjr_2 group by industry_name,area_name,ssbk union all select count(*) as ssbkqy,industry_name,area_name,qylx,null as ssbk from tmp_xjr_2 group by industry_name,area_name,qylx union all select count(*) as ssbkqy,null as industry_name,area_name,qylx,ssbk from tmp_xjr_2 group by area_name,qylx,ssbk -- 四维度 union all select count(*) as ssbkqy,null as industry_name,area_name,qylx,ssbk from tmp_xjr_2 group by industry_name,area_name,qylx,ssbk;
3583
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
