数据湖探索 DLI-基本语句:语法格式

时间:2024-11-11 14:10:59

语法格式

1
2
3
4
5
6
7
SELECT [ALL | DISTINCT] attr_expr_list FROM table_reference
  [WHERE where_condition]
  [GROUP BY col_name_list]
  [ORDER BY col_name_list][ASC | DESC]
  [CLUSTER BY col_name_list | DISTRIBUTE BY col_name_list]
  [SORT BY col_name_list]]
  [LIMIT number];
support.huaweicloud.com/sqlref-spark-dli/dli_08_0150.html