DQL SQL (SELECT)
- SELECT syntax
- SELECT statement order
- Subqueries
- INTERSECT, UNION, EXCEPT, and MINUS
- JOIN
- SEMI JOIN
- MAPJOIN HINT
- SUBQUERY_MAPJOIN 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