华为云首页用户手册

MAPREDUCE服务 MRS-SELECT:语法

MAPREDUCE服务 MRS-SELECT:语法

时间：2024-11-28 20:08:11

MAPREDUCE服务 MRS

语法

[/*+ query_rewrite_hint*/]

[ WITH [ RECURSIVE ] with_query [, ...] ]

SELECT [ ALL | DISTINCT ] select_expression [, ...]

[ FROM from_item [, ...] ]

[ WHERE condition ]

[ GROUP BY [ ALL | DISTINCT ] grouping_element [, ...] ]

[ HAVING condition]

[ { UNION | INTERSECT | EXCEPT } [ ALL | DISTINCT ] select ]

[ ORDER BY expression [ ASC | DESC ] [, ...] ]

[ OFFSET count [ ROW | ROWS ] ]

[ LIMIT { count | ALL } ]

[ FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } { ONLY | WITH TIES } ]

from_item可以是以下形式：
- table_name [ [ AS ] alias [ ( column_alias [, ...] ) ] ]
- from_item join_type from_item [ ON join_condition | USING ( join_column [, ...] ) ]
- table_name [ [ AS ] alias [ ( column_alias [, ...] ) ] ]
  MATCH_RECOGNIZE pattern_recognition_specification
  
  [ [ AS ] alias [ ( column_alias [, ...] ) ] ]
join_type可以是以下形式：
- [ INNER ] JOIN
- LEFT [ OUTER ] JOIN
- RIGHT [ OUTER ] JOIN
- FULL [ OUTER ] JOIN
- LEFT [SEMI] JOIN
- RIGHT [SEMI] JOIN
- LEFT [ANTI] JOIN
- RIGHT [ANTI] JOIN
- CROSS JOIN
grouping_element可以是以下形式：
- ()
- expression
- GROUPING SETS ( ( column [, ...] ) [, ...] )
- CUBE ( column [, ...] )
- ROLLUP ( column [, ...] )

上一篇：MAPREDUCE服务 MRS-SHOW CREATE TABLE:示例

下一篇：MAPREDUCE服务 MRS-日志聚合下，如何查看Spark已完成应用日志:回答

新客秒杀 2核2G 3M L实例

68元/年

普惠上云领千元上云礼券

立即前往

企业专享 X实例 4核8G 5M

888元/年

热门域名 1元随心购

1元/年起

MAPREDUCE服务 MRS-SELECT:语法

意见反馈

0/200

提交成功！非常感谢您的反馈，我们会继续努力做到更好反馈提交失败！请稍后重试！

推荐文章

解决方案
相关专题