0001 - text: Getting Started
0002 url: sql-getting-started.html
0003 subitems:
0004 - text: "Starting Point: SparkSession"
0005 url: sql-getting-started.html#starting-point-sparksession
0006 - text: Creating DataFrames
0007 url: sql-getting-started.html#creating-dataframes
0008 - text: Untyped Dataset Operations (DataFrame operations)
0009 url: sql-getting-started.html#untyped-dataset-operations-aka-dataframe-operations
0010 - text: Running SQL Queries Programmatically
0011 url: sql-getting-started.html#running-sql-queries-programmatically
0012 - text: Global Temporary View
0013 url: sql-getting-started.html#global-temporary-view
0014 - text: Creating Datasets
0015 url: sql-getting-started.html#creating-datasets
0016 - text: Interoperating with RDDs
0017 url: sql-getting-started.html#interoperating-with-rdds
0018 - text: Scalar Functions
0019 url: sql-getting-started.html#scalar-functions
0020 - text: Aggregations
0021 url: sql-getting-started.html#aggregations
0022 - text: Data Sources
0023 url: sql-data-sources.html
0024 subitems:
0025 - text: "Generic Load/Save Functions"
0026 url: sql-data-sources-load-save-functions.html
0027 - text: "Generic File Source Options"
0028 url: sql-data-sources-generic-options.html
0029 - text: Parquet Files
0030 url: sql-data-sources-parquet.html
0031 - text: ORC Files
0032 url: sql-data-sources-orc.html
0033 - text: JSON Files
0034 url: sql-data-sources-json.html
0035 - text: Hive Tables
0036 url: sql-data-sources-hive-tables.html
0037 - text: JDBC To Other Databases
0038 url: sql-data-sources-jdbc.html
0039 - text: Avro Files
0040 url: sql-data-sources-avro.html
0041 - text: Whole Binary Files
0042 url: sql-data-sources-binaryFile.html
0043 - text: Troubleshooting
0044 url: sql-data-sources-troubleshooting.html
0045 - text: Performance Tuning
0046 url: sql-performance-tuning.html
0047 subitems:
0048 - text: Caching Data In Memory
0049 url: sql-performance-tuning.html#caching-data-in-memory
0050 - text: Other Configuration Options
0051 url: sql-performance-tuning.html#other-configuration-options
0052 - text: Join Strategy Hints for SQL Queries
0053 url: sql-performance-tuning.html#join-strategy-hints-for-sql-queries
0054 - text: Distributed SQL Engine
0055 url: sql-distributed-sql-engine.html
0056 subitems:
0057 - text: "Running the Thrift JDBC/ODBC server"
0058 url: sql-distributed-sql-engine.html#running-the-thrift-jdbcodbc-server
0059 - text: Running the Spark SQL CLI
0060 url: sql-distributed-sql-engine.html#running-the-spark-sql-cli
0061 - text: PySpark Usage Guide for Pandas with Apache Arrow
0062 url: sql-pyspark-pandas-with-arrow.html
0063 subitems:
0064 - text: Apache Arrow in Spark
0065 url: sql-pyspark-pandas-with-arrow.html#apache-arrow-in-spark
0066 - text: "Enabling for Conversion to/from Pandas"
0067 url: sql-pyspark-pandas-with-arrow.html#enabling-for-conversion-tofrom-pandas
0068 - text: "Pandas UDFs (a.k.a. Vectorized UDFs)"
0069 url: sql-pyspark-pandas-with-arrow.html#pandas-udfs-aka-vectorized-udfs
0070 - text: "Pandas Function APIs"
0071 url: sql-pyspark-pandas-with-arrow.html#pandas-function-apis
0072 - text: Usage Notes
0073 url: sql-pyspark-pandas-with-arrow.html#usage-notes
0074 - text: Migration Guide
0075 url: sql-migration-old.html
0076 - text: SQL Reference
0077 url: sql-ref.html
0078 subitems:
0079 - text: ANSI Compliance
0080 url: sql-ref-ansi-compliance.html
0081 subitems:
0082 - text: Arithmetic Operations
0083 url: sql-ref-ansi-compliance.html#arithmetic-operations
0084 - text: Type Conversion
0085 url: sql-ref-ansi-compliance.html#type-conversion
0086 - text: SQL Keywords
0087 url: sql-ref-ansi-compliance.html#sql-keywords
0088 - text: Data Types
0089 url: sql-ref-datatypes.html
0090 - text: Datetime Pattern
0091 url: sql-ref-datetime-pattern.html
0092 - text: Functions
0093 url: sql-ref-functions.html
0094 subitems:
0095 - text: Built-in Functions
0096 url: sql-ref-functions-builtin.html
0097 - text: Scalar UDFs (User-Defined Functions)
0098 url: sql-ref-functions-udf-scalar.html
0099 - text: UDAFs (User-Defined Aggregate Functions)
0100 url: sql-ref-functions-udf-aggregate.html
0101 - text: Integration with Hive UDFs/UDAFs/UDTFs
0102 url: sql-ref-functions-udf-hive.html
0103 - text: Identifiers
0104 url: sql-ref-identifier.html
0105 - text: Literals
0106 url: sql-ref-literals.html
0107 - text: Null Semantics
0108 url: sql-ref-null-semantics.html
0109 - text: SQL Syntax
0110 url: sql-ref-syntax.html
0111 subitems:
0112 - text: Data Definition Statements
0113 url: sql-ref-syntax-ddl.html
0114 subitems:
0115 - text: ALTER DATABASE
0116 url: sql-ref-syntax-ddl-alter-database.html
0117 - text: ALTER TABLE
0118 url: sql-ref-syntax-ddl-alter-table.html
0119 - text: ALTER VIEW
0120 url: sql-ref-syntax-ddl-alter-view.html
0121 - text: CREATE DATABASE
0122 url: sql-ref-syntax-ddl-create-database.html
0123 - text: CREATE FUNCTION
0124 url: sql-ref-syntax-ddl-create-function.html
0125 - text: CREATE TABLE
0126 url: sql-ref-syntax-ddl-create-table.html
0127 - text: CREATE VIEW
0128 url: sql-ref-syntax-ddl-create-view.html
0129 - text: DROP DATABASE
0130 url: sql-ref-syntax-ddl-drop-database.html
0131 - text: DROP FUNCTION
0132 url: sql-ref-syntax-ddl-drop-function.html
0133 - text: DROP TABLE
0134 url: sql-ref-syntax-ddl-drop-table.html
0135 - text: DROP VIEW
0136 url: sql-ref-syntax-ddl-drop-view.html
0137 - text: TRUNCATE TABLE
0138 url: sql-ref-syntax-ddl-truncate-table.html
0139 - text: REPAIR TABLE
0140 url: sql-ref-syntax-ddl-repair-table.html
0141 - text: USE DATABASE
0142 url: sql-ref-syntax-qry-select-usedb.html
0143 - text: Data Manipulation Statements
0144 url: sql-ref-syntax-dml.html
0145 subitems:
0146 - text: INSERT
0147 url: sql-ref-syntax-dml-insert.html
0148 - text: LOAD
0149 url: sql-ref-syntax-dml-load.html
0150 - text: Data Retrieval(Queries)
0151 url: sql-ref-syntax-qry.html
0152 subitems:
0153 - text: SELECT
0154 url: sql-ref-syntax-qry-select.html
0155 subitems:
0156 - text: WHERE Clause
0157 url: sql-ref-syntax-qry-select-where.html
0158 - text: GROUP BY Clause
0159 url: sql-ref-syntax-qry-select-groupby.html
0160 - text: HAVING Clause
0161 url: sql-ref-syntax-qry-select-having.html
0162 - text: ORDER BY Clause
0163 url: sql-ref-syntax-qry-select-orderby.html
0164 - text: SORT BY Clause
0165 url: sql-ref-syntax-qry-select-sortby.html
0166 - text: CLUSTER BY Clause
0167 url: sql-ref-syntax-qry-select-clusterby.html
0168 - text: DISTRIBUTE BY Clause
0169 url: sql-ref-syntax-qry-select-distribute-by.html
0170 - text: LIMIT Clause
0171 url: sql-ref-syntax-qry-select-limit.html
0172 - text: Common Table Expression
0173 url: sql-ref-syntax-qry-select-cte.html
0174 - text: Hints
0175 url: sql-ref-syntax-qry-select-hints.html
0176 - text: Inline Table
0177 url: sql-ref-syntax-qry-select-inline-table.html
0178 - text: JOIN
0179 url: sql-ref-syntax-qry-select-join.html
0180 - text: LIKE Predicate
0181 url: sql-ref-syntax-qry-select-like.html
0182 - text: Set Operators
0183 url: sql-ref-syntax-qry-select-setops.html
0184 - text: TABLESAMPLE
0185 url: sql-ref-syntax-qry-select-sampling.html
0186 - text: Table-valued Function
0187 url: sql-ref-syntax-qry-select-tvf.html
0188 - text: Window Function
0189 url: sql-ref-syntax-qry-select-window.html
0190 - text: EXPLAIN
0191 url: sql-ref-syntax-qry-explain.html
0192 - text: Auxiliary Statements
0193 url: sql-ref-syntax-aux.html
0194 subitems:
0195 - text: ANALYZE
0196 url: sql-ref-syntax-aux-analyze.html
0197 subitems:
0198 - text: ANALYZE TABLE
0199 url: sql-ref-syntax-aux-analyze-table.html
0200 - text: CACHE
0201 url: sql-ref-syntax-aux-cache.html
0202 subitems:
0203 - text: CACHE TABLE
0204 url: sql-ref-syntax-aux-cache-cache-table.html
0205 - text: UNCACHE TABLE
0206 url: sql-ref-syntax-aux-cache-uncache-table.html
0207 - text: CLEAR CACHE
0208 url: sql-ref-syntax-aux-cache-clear-cache.html
0209 - text: REFRESH TABLE
0210 url: sql-ref-syntax-aux-refresh-table.html
0211 - text: REFRESH
0212 url: sql-ref-syntax-aux-cache-refresh.html
0213 - text: DESCRIBE
0214 url: sql-ref-syntax-aux-describe.html
0215 subitems:
0216 - text: DESCRIBE DATABASE
0217 url: sql-ref-syntax-aux-describe-database.html
0218 - text: DESCRIBE TABLE
0219 url: sql-ref-syntax-aux-describe-table.html
0220 - text: DESCRIBE FUNCTION
0221 url: sql-ref-syntax-aux-describe-function.html
0222 - text: DESCRIBE QUERY
0223 url: sql-ref-syntax-aux-describe-query.html
0224 - text: SHOW
0225 url: sql-ref-syntax-aux-show.html
0226 subitems:
0227 - text: SHOW COLUMNS
0228 url: sql-ref-syntax-aux-show-columns.html
0229 - text: SHOW CREATE TABLE
0230 url: sql-ref-syntax-aux-show-create-table.html
0231 - text: SHOW DATABASES
0232 url: sql-ref-syntax-aux-show-databases.html
0233 - text: SHOW FUNCTIONS
0234 url: sql-ref-syntax-aux-show-functions.html
0235 - text: SHOW PARTITIONS
0236 url: sql-ref-syntax-aux-show-partitions.html
0237 - text: SHOW TABLE
0238 url: sql-ref-syntax-aux-show-table.html
0239 - text: SHOW TABLES
0240 url: sql-ref-syntax-aux-show-tables.html
0241 - text: SHOW TBLPROPERTIES
0242 url: sql-ref-syntax-aux-show-tblproperties.html
0243 - text: SHOW VIEWS
0244 url: sql-ref-syntax-aux-show-views.html
0245 - text: CONFIGURATION MANAGEMENT
0246 url: sql-ref-syntax-aux-conf-mgmt.html
0247 subitems:
0248 - text: SET
0249 url: sql-ref-syntax-aux-conf-mgmt-set.html
0250 - text: RESET
0251 url: sql-ref-syntax-aux-conf-mgmt-reset.html
0252 - text: RESOURCE MANAGEMENT
0253 url: sql-ref-syntax-aux-resource-mgmt.html
0254 subitems:
0255 - text: ADD FILE
0256 url: sql-ref-syntax-aux-resource-mgmt-add-file.html
0257 - text: ADD JAR
0258 url: sql-ref-syntax-aux-resource-mgmt-add-jar.html
0259 - text: LIST FILE
0260 url: sql-ref-syntax-aux-resource-mgmt-list-file.html
0261 - text: LIST JAR
0262 url: sql-ref-syntax-aux-resource-mgmt-list-jar.html