Skip to main content
Ctrl+K
  • Apache Software Foundation
  • License
  • Donate
  • Thanks
  • Security
  • GitHub and Issue Tracker
  • crates.io
  • API Docs
  • Blog
  • Code of conduct
  • Download
  • Introduction
  • Example Usage
  • Features
  • Concepts, Readings, Events
  • Crate Configuration
  • DataFusion CLI
  • DataFrame API
  • Gentle Arrow Introduction
  • Expression API
  • SQL Reference
  • Configuration Settings
  • Reading Explain Plans
  • Metrics
  • Frequently Asked Questions
  • Introduction
  • Upgrade Guides
  • Extensions List
  • Using the SQL API
  • Working with Exprs
  • Using the DataFrame API
  • Building Logical Plans
  • Catalogs, Schemas, and Tables
  • Functions
  • Custom Table Provider
  • Table Constraint Enforcement
  • Extending DataFusion’s operators: custom LogicalPlan and Execution Plans
  • Profiling Cookbook
  • DataFusion Query Optimizer
  • Introduction
  • Communication
  • Development Environment
  • Architecture
  • Testing
  • API health policy
  • HOWTOs
  • Roadmap and Improvement Proposals
  • Governance
  • Inviting New Committers and PMC Members
  • Specifications
  • Google Summer of Code (GSOC)
  • DataFusion Ballista
  • DataFusion Comet
  • DataFusion Python

logo logo

ASF Links

  • Apache Software Foundation
  • License
  • Donate
  • Thanks
  • Security

Links

  • GitHub and Issue Tracker
  • crates.io
  • API Docs
  • Blog
  • Code of conduct
  • Download

User Guide

  • Introduction
  • Example Usage
  • Features
  • Concepts, Readings, Events
  • Crate Configuration
  • DataFusion CLI
    • Overview
    • Installation
    • Usage
    • Local Files / Directories
    • CLI Specific Functions
  • DataFrame API
  • Gentle Arrow Introduction
  • Expression API
  • SQL Reference
    • Data Types
    • SELECT syntax
    • Subqueries
    • DDL
    • DML
    • EXPLAIN
    • Information Schema
    • Operators and Literals
    • Aggregate Functions
    • Window Functions
    • Scalar Functions
    • Special Functions
    • Format Options
    • Prepared Statements
  • Configuration Settings
  • Reading Explain Plans
  • Metrics
  • Frequently Asked Questions

Library User Guide

  • Introduction
  • Upgrade Guides
  • Extensions List
  • Using the SQL API
  • Working with Exprs
  • Using the DataFrame API
  • Building Logical Plans
  • Catalogs, Schemas, and Tables
  • Functions
    • Adding User Defined Functions: Scalar/Window/Aggregate/Table Functions
    • Spark Compatible Functions
  • Custom Table Provider
  • Table Constraint Enforcement
  • Extending DataFusion’s operators: custom LogicalPlan and Execution Plans
  • Profiling Cookbook
  • DataFusion Query Optimizer

Contributor Guide

  • Introduction
  • Communication
  • Development Environment
  • Architecture
  • Testing
  • API health policy
  • HOWTOs
  • Roadmap and Improvement Proposals
  • Governance
  • Inviting New Committers and PMC Members
  • Specifications
    • Invariants
    • Output field name semantics
  • Google Summer of Code (GSOC)
    • GSoC Application Guidelines (2025)
    • GSoC Project Ideas (2025)

DataFusion Subprojects

  • DataFusion Ballista
  • DataFusion Comet
  • DataFusion Python
  • DataFusion CLI

DataFusion CLI#

  • Overview
  • Installation
    • Install and run using Cargo
    • Install and run using Homebrew (on MacOS)
    • Run using Docker
  • Usage
    • Commands
    • Supported SQL
      • SHOW ALL [VERBOSE]
      • SHOW <OPTION>>
      • SET <OPTION> TO <VALUE>
    • Configuration Options
    • Functions
  • Local Files / Directories
  • Remote Files / Directories
  • CREATE EXTERNAL TABLE
  • Formats
    • Parquet
      • Parquet Specific Options
    • CSV
  • Locations
    • HTTP(s)
    • S3
    • OSS
    • COS
    • GCS
  • CLI Specific Functions
    • parquet_metadata
    • metadata_cache

previous

Crate Configuration

next

Overview
Edit on GitHub

This Page

  • Show Source

Apache DataFusion, Apache, the Apache feather logo, and the Apache DataFusion project logo

are either registered trademarks or trademarks of The Apache Software Foundation in the United States and other countries.