DQL SQL (SELECT)
- SELECT syntax
- SELECT statement order
- Subqueries
- INTERSECT, UNION, EXCEPT, and MINUS
- JOIN
- SEMI JOIN
- Spatial JOIN
- MAPJOIN HINT
- SUBQUERY_MAPJOIN HINT
- SCALAR SUBQUERY MATERIALIZE HINT
- DISTRIBUTED MAPJOIN
- SKEWJOIN HINT
- Split Size Hint
- Dynamic filter
- LATERAL VIEW
- GROUPING SETS
- SELECT TRANSFORM
- WINDOW keyword
- TABLESAMPLE
- QUALIFY
- PIVOT and UNPIVOT
- Time travel queries and incremental queries
- Common table expression (CTE)
- UNNEST
- Enhanced nested column pruning