ODPS-0130071:[0,0] Semantic analysis exception - physical plan generation failed

ゝ一纸荒年。 2022-02-01 11:07 745阅读 0赞

使用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:

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTc3MDE2OQ_size_16_color_FFFFFF_t_70][]

代码：

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;

附加：如下官方常见错误中没找到

[https://github.com/AlibabaCloudDocs/odps/blob/master/cn.zh-CN/%E9%94%99%E8%AF%AF%E7%A0%81%E9%99%84%E5%BD%95/SQL%E5%B8%B8%E8%A7%81%E9%94%99%E8%AF%AF.md][https_github.com_AlibabaCloudDocs_odps_blob_master_cn.zh-CN_E9_94_99_E8_AF_AF_E7_A0_81_E9_99_84_E5_BD_95_SQL_E5_B8_B8_E8_A7_81_E9_94_99_E8_AF_AF.md]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTc3MDE2OQ_size_16_color_FFFFFF_t_70]: /images/20220201/3dc79b5b80ca418796297184a0fda913.png
[https_github.com_AlibabaCloudDocs_odps_blob_master_cn.zh-CN_E9_94_99_E8_AF_AF_E7_A0_81_E9_99_84_E5_BD_95_SQL_E5_B8_B8_E8_A7_81_E9_94_99_E8_AF_AF.md]: https://github.com/AlibabaCloudDocs/odps/blob/master/cn.zh-CN/%E9%94%99%E8%AF%AF%E7%A0%81%E9%99%84%E5%BD%95/SQL%E5%B8%B8%E8%A7%81%E9%94%99%E8%AF%AF.md