CORRESPONDING [ BY <left paren> <corresponding column list> <right paren> ]
A single CTE (used after WITH
): alias [(col1, col2, ...)] AS ( query )
A hive LATERAL VIEW with potential column aliases
An ORDER BY
expression
The most complete variant of a SELECT
query expression, optionally
including WITH
, UNION
/ other set operations, and ORDER BY
.
A restricted variant of SELECT
(without CTEs/ORDER BY
), which may
appear either as the only body item of an SQLQuery
, or as an operand
to a set operation like UNION
.