SQL Reference

• Data Types
  • Character Types
  • Numeric Types
  • Date/Time Types
  • Boolean Types
  • Binary Types
  • Unsupported SQL Types
  • Supported Arrow Types
• SELECT syntax
  • WITH clause
  • SELECT clause
  • FROM clause
  • WHERE clause
  • JOIN clause
  • GROUP BY clause
  • HAVING clause
  • UNION clause
  • ORDER BY clause
  • LIMIT clause
  • EXCLUDE and EXCEPT clause
• Subqueries
  • Subquery operators
  • SELECT clause subqueries
  • FROM clause subqueries
  • WHERE clause subqueries
  • HAVING clause subqueries
  • Subquery categories
• DDL
  • CREATE DATABASE
  • CREATE SCHEMA
  • CREATE EXTERNAL TABLE
  • CREATE TABLE
  • DROP TABLE
  • CREATE VIEW
  • DROP VIEW
• DML
  • COPY
  • INSERT
• EXPLAIN
  • EXPLAIN
  • EXPLAIN ANALYZE
• Information Schema
• Operators
  • Numerical Operators
  • Comparison Operators
  • Logical Operators
  • Bitwise Operators
  • Other Operators
• Aggregate Functions
  • General Functions
  • Statistical Functions
  • Approximate Functions
• Window Functions
  • Syntax
  • Aggregate functions
  • Ranking Functions
  • Analytical Functions
• Scalar Functions
  • Math Functions
  • Conditional Functions
  • String Functions
  • Binary String Functions
  • Regular Expression Functions
  • Time and Date Functions
  • Array Functions
  • Struct Functions
  • Map Functions
  • Hashing Functions
  • Other Functions
• Special Functions
  • Expansion Functions
• Status
  • General
  • SQL Support
  • Runtime
  • Data Sources
• Write Options
  • Specifying Options and Order of Precedence
  • Available Options

previous

Expression API

next

Data Types