xtyly 发表于 2019-11-28 23:50:36

ODPS表t1、t2都是分区表，分区键是pt，对于sql语句select t1.id from t1 left&nb

leonknight 发表于 2020-9-12 17:56:04

但以下官方文件, 答案好像是D
https://www.alibabacloud.com/help/doc-detail/89993.html

If Left join In the third case, the where condition filter after JOIN

SELECT A.*, B.*
FROM A JOIN B
ON a.key = b.key
WHERE A.ds='20180101' and B.ds='20180101';

For example, there are nine results of Descartes that meet the ON a.key = b.key there are 3 results for key, respectively:

a.key        a.ds        b.key        b.ds
1        20180101        1        20180101
2        20180101        2        20180102
2        20180102        2        20180102

沒有進行分區裁剪.....
页: [1]
查看完整版本: ODPS表t1、t2都是分区表，分区键是pt，对于sql语句select t1.id from t1 left&nb