Module query Copy item path Source Corresponding CORRESPONDING [ BY <left paren> <corresponding column list> <right paren> ]
Cte A single CTE (used after WITH
): alias [(col1, col2, ...)] AS ( query )
Fetch Join LateralView A hive LATERAL VIEW with potential column aliases OrderByExpr An ORDER BY
expression Query The most complete variant of a SELECT
query expression, optionally
including WITH
, UNION
/ other set operations, and ORDER BY
. Select 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
. TableAlias TableWithJoins Top Values With CteInner Distinct An ALL
, DISTINCT
or DISTINCT ON (expr, ...)
after SELECT
. JoinConstraint JoinOperator SelectItem One item of the comma-separated list following SELECT
SetExpr A node in a tree, representing a “query body” expression, roughly:
SELECT ... [ {UNION|EXCEPT|INTERSECT} SELECT ...]
SetOperator TableFactor A table name or a parenthesized subquery with an optional alias