数据湖探索 DLI-WITH...AS:示例

时间:2023-11-03 17:00:59

示例

将“SELECT courseId FROM course_info WHERE courseName = 'Biology'”定义为公共表达式nv,然后在后续的查询中直接利用nv代替该SELECT语句。

1
WITH nv AS (SELECT courseId FROM course_info WHERE courseName = 'Biology') SELECT DISTINCT courseId FROM nv;
support.huaweicloud.com/sqlref-spark-dli/dli_08_0186.html