User Guide
Introduction
Example Usage
Using DataFusion as a library
DataFusion Command-line SQL Utility
DataFrame API
Expressions
SQL Reference
Data Types
SELECT syntax
Subqueries
DDL
EXPLAIN
Information Schema
Aggregate Functions
Scalar Functions
Status
Configuration Settings
Frequently Asked Questions
Rust Crate Documentation
Contributor Guide
Introduction
Communication
Roadmap
Quarterly Roadmap
Specifications
Invariants
Output field name semantics
Issue tracker
Code of conduct
Edit this page
SQL Reference
ΒΆ
Data Types
Character Types
Numeric Types
Date/Time Types
Boolean Types
Binary Types
Unsupported 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 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
Temporal Functions
Other Functions
Status
General
SQL Support
Data Sources
previous
Expressions
next
Data Types