select_stmt
2018-08-30 14:37:40 2 举报AI智能生成
hive select
作者其他创作
大纲/内容
select_stmt
cte_select_stmt
WITH
cte_select_stmt_item *
ident
cte_select_cols?
（
ident *
）
AS
(
fullselect_stmt
fullselect_stmt_item
subselect_stmt
SELECT | SEL
select_list
select_list_set?
ALL | DISTINCT
select_list limit?
TOP
expr
select_list_item *
into_clause?
INTO
ident ?
from_clause?
FROM
from_table_clause
from_table_name_clause
table_name
from_alias_clause?
AS?
ID，*
）？
| from_subselect_clause
)
||
from_table_valuse_clause
TABLE
VALUES
from_table_values_row *
expr *
from_join_clause ?
，from_table_clause
from_join_type_clause
INNER? JOIN
(LEFT | RIGHT | FULL) OUTER? JOIN
+ from_table_clause ON bool_expr
where_clause?
where
bool_expr
group_by_clause?
GROUP
BY
expr ASC | DESC ? *
having_clause | qualify_clause ?
HAVING bool_expr
QUALIFY bool_expr
order_by_clause?
ORDER
expr ASC | DESC ? *
select_options?
select_options_item +
LIMIT expr | WITH (RR | RS | CS | UR) (USE AND KEEP (EXCLUSIVE | UPDATE | SHARE) LOCKS)?
( fullselect_stmt )
fullselect_set_clause
UNION ALL？
EXCEPT ALL ?
INTERSECT ALL ?
收藏
0 条评论
下一页
