Links
Github and Issue Tracker
crates.io
API Docs
Code of conduct
User Guide
Introduction
Example Usage
Command line SQL console
DataFrame API
Expression API
SQL Reference
Data Types
SELECT syntax
Subqueries
DDL
DML
EXPLAIN
Information Schema
Operators
Aggregate Functions
Window Functions
Scalar Functions
Status
Write Options
Configuration Settings
Frequently Asked Questions
Library User Guide
Introduction
Using the SQL API
Working with Exprs
Using the DataFrame API
Building Logical Plans
Catalogs, Schemas, and Tables
Adding User Defined Functions: Scalar/Window/Aggregate
Custom Table Provider
Extending DataFusion’s operators: custom LogicalPlan and Execution Plans
Contributor Guide
Introduction
Communication
Architecture
Roadmap
Quarterly Roadmap
Specifications
Invariants
Output field name semantics
Edit this page
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
EXISTS
NOT EXISTS
IN
NOT IN
Scalar Subquery
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
Statistical
Approximate
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
Hashing Functions
Other Functions
Status
General
SQL Support
Runtime
Data Sources
Write Options
Specifying Options and Order of Precedence
Available Options
previous
Expression API
next
Data Types