执行load脚本后,控制台打印信息ok之后,报错No Stats for app@ods_sku_info_full, Columns:
你这是什么情况
我尝试一层一层找问题,
SELECT * FROM( SELECT id, industry_name, superior_industry_id FROM financial_lease.ods_industry_full WHERE dt = '2023-06-09' AND industry_level = '3' )i3 LEFT JOIN( SELECT id, industry_name, superior_industry_id FROM financial_lease.ods_industry_full WHERE dt = '2023-06-09' AND industry_level = '2' )i2 ON i3.superior_industry_id = i2.id LEFT JOIN( SELECT id, industry_name FROM financial_lease.ods_industry_full WHERE dt = '2023-06-09' AND industry_level = '1' )i1 ON i2.superior_industry_id = i1.id;
SELECT * FROM( SELECT id, industry_name, superior_industry_id FROM financial_lease.ods_industry_full WHERE dt = '2023-06-09' AND industry_level = '2' )i2 LEFT JOIN( SELECT id, industry_name FROM financial_lease.ods_industry_full WHERE dt = '2023-06-09' AND industry_level = '1' )i1 ON i2.superior_industry_id = i1.id;
SELECT * FROM( SELECT id, industry_name, superior_industry_id FROM financial_lease.ods_industry_full WHERE dt = '2023-06-09' AND industry_level = '3' )i3 LEFT JOIN( SELECT id, industry_name, superior_industry_id FROM financial_lease.ods_industry_full WHERE dt = '2023-06-09' AND industry_level = '2' )i2 ON i3.superior_industry_id = i2.id;
3 left join 2,没问题
2 left join 1,没问题
但是把他们连着left join 会报这个
No Stats for financial_lease@ods_industry_full, Columns: industry_name, superior_industry_id, industry_level, id
还是不明白为什么