Skip to main content 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 Measure A single MEASURES item: <expr> AS <alias>. 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. SubsetDefinition A single SUBSET item: <name> = (<pattern variable>, ...) — a union variable. SymbolDefinition A single DEFINE item: <symbol> AS <condition>. TableAlias TableWithJoins Top Values With AfterMatchSkip The AFTER MATCH SKIP strategy of a MATCH_RECOGNIZE clause. CteInner Distinct An ALL, DISTINCT or DISTINCT ON (expr, ...) after SELECT. JoinConstraint JoinOperator MatchRecognizePattern A row-pattern expression inside PATTERN ( ... ). MatchRecognizeSymbol A row-pattern variable, or one of the row-pattern anchors. RepetitionQuantifier A quantifier applied to a row-pattern, e.g. *, +, ?, {n,m}. RowsPerMatch The output mode of a MATCH_RECOGNIZE clause. 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