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

xtyly

试卷: 阿里云大数据专业ACP认证模拟考试练习题
[单选题]

ODPS表t1、t2都是分区表，分区键是pt，对于sql语句select t1.id from t1 left outer join t2 on t1.id=t2.id where t1.pt=’20140101’ and t2.pt=’20140101’,哪一个说法是正确的。

你没有权限查看更多信息! 登陆

leonknight

但以下官方文件, 答案好像是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

沒有進行分區裁剪.....