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 NamedWindow A named window definition in the WINDOW clause 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