#数仓#执行load脚本后,控制台打印信息ok之后,报错No Stats for app@ods_sku_info_full, Columns,如何解决?

执行load脚本后,控制台打印信息ok之后,报错No Stats for app@ods_sku_info_full, Columns:

img


网上有人说元数据服务未启动,查看元数据服务进程和日志后无异常

img

img

你这是什么情况

我尝试一层一层找问题,
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

还是不明白为什么