Links
Github and Issue Tracker
crates.io
API Docs
Code of conduct
User Guide
Introduction
Example Usage
datafusion-cli
DataFrame API
Expression API
SQL Reference
Data Types
SELECT syntax
Subqueries
DDL
EXPLAIN
Information Schema
Aggregate Functions
Scalar Functions
Status
Configuration Settings
Frequently Asked Questions
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
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