THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
Table of Contents |
---|
GROUP BY; SORT BY, /ORDER BY, /CLUSTER BY, /DISTRIBUTE BY; JOIN (Hive Joins, Join Optimization, Outer Join Behavior); UNION; TABLESAMPLE; Subqueries; Virtual Columns; Operators and UDFs; LATERAL VIEW; Windowing, OVER, and Analytics; Common Table Expressions
...
See the following documents for additional syntax and features of SELECT statements:
- GROUP BY
- SORT BY, /ORDER BY, /CLUSTER BY, /DISTRIBUTE BY
- JOIN
- UNION
- TABLESAMPLE
- Subqueries
- Virtual Columns
- Operators and UDFs
- LATERAL VIEW
- Windowing, OVER, and Analytics
- Common Table Expressions
...