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;
时间: 2024-01-17 11:39:54 浏览: 93
SQL 错误提示
This is a SQL statement that is attempting to insert data into a table called "ksh_xjr_ssbk" using aggregation functions to group the data by different dimensions. There are four different dimensions being used, and the data is being grouped by each dimension separately using "union all" to combine the results.
The first dimension has only one grouping column, "industry_name", while the other columns are null. The second dimension has two grouping columns, "industry_name" and "area_name", and the other columns are null. The third dimension has three grouping columns, "industry_name", "area_name", and "qylx", and the other columns are null. The fourth dimension has all four grouping columns, "industry_name", "area_name", "qylx", and "ssbk".
The error message suggests that the SQL job with the ID "28ed8f13-d1ad-41a8-977b-baa49f413c04" has failed when trying to execute this statement. Without more context about the environment where this error occurred, it's hard to say what exactly went wrong. Some possible reasons could be: invalid SQL syntax, insufficient permissions to access the database or tables, missing data or columns in the temporary or target tables, or a network or hardware issue. It's recommended to check the logs and error messages in more detail to diagnose the root cause of the failure.
阅读全文