Spark SQL Guide

• Getting Started
• Data Sources
• Performance Tuning
• Distributed SQL Engine
• PySpark Usage Guide for Pandas with Apache Arrow
• Migration Guide
• SQL Reference
• Data Types
• Null Semantics
• NaN Semantics
• SQL Syntax
• Data Definition Statements
• Data Manipulation Statements
• Data Retrieval(Queries)
• SELECT
• DISTINCT Clause
• Joins
• ORDER BY Clause
• GROUP BY Clause
• HAVING Clause
• LIMIT Clause
• Set operations
• USE database
• Common Table Expression(CTE)
• Subqueries
• Query hints
• SAMPLING
• WINDOWING ANALYTIC FUNCTIONS
• AGGREGATION (CUBE/ROLLUP/GROUPING)
• EXPLAIN
• Auxilarry Statements
• Functions
• Arthmetic operations