使用maxcompute sql时报错:
FAILED: ODPS-0130071:[0,0] Semantic analysis exception - physical plan generation failed: org.apache.calcite.plan.RelOptPlanner$CannotPlanException: Node [rel#416195775:Subset#5.ODPS.[].any] could not be implemented; plannerstate:
代码:
SELECT u.uid AS uid, u.plan_id AS plan_id
, u.item_list AS item_list, v.itemdata AS itemData
FROM table1 u
LEFT OUTER JOIN table2
WHERE u.uid = v.uid;
查看发现,table1的uid类型时STRING,table2的uid类型时BIGINT,将table2类型改的跟table1一致后,解决。
INSERT OVERWRITE TABLE data_combine
SELECT u.uid AS uid, u.plan_id AS plan_id
, u.item_list AS item_list, v.itemdata AS itemData
FROM table1 u
LEFT OUTER JOIN(
SELECT CAST(v1.uid AS STRING) AS uid, v1.itemdata AS itemdata
FROM table2 v1
)v
WHERE u.uid = v.uid;
附加:如下官方常见错误中没找到