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
• Subqueries
  • EXISTS
  • NOT EXISTS
  • IN
  • NOT IN
  • Scalar Subquery
• DDL
  • CREATE DATABASE
  • CREATE SCHEMA
  • CREATE EXTERNAL TABLE
  • CREATE TABLE
  • DROP TABLE
  • CREATE VIEW
  • DROP VIEW
• EXPLAIN
  • EXPLAIN
  • EXPLAIN ANALYZE
• Information Schema
• Aggregate Functions
  • General
  • Statistical
  • Approximate
• Scalar Functions
  • Math Functions
  • Conditional Functions
  • String Functions
  • Regular Expression Functions
  • Time and Date Functions
  • Hashing Functions
  • Other Functions
• Status
  • General
  • SQL Support
  • Data Sources

previous

Expression API

next

Data Types