Skip to content

Apache DataFusion SQL Query Engine

4.3 KB
Raw Blame
// SPDX-License-Identifier: Apache-2.0
// SPDX-FileCopyrightText: See the NOTICE file distributed with this work for additional information regarding copyright ownership
// SPDX-FileContributor: Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements

//! # These examples are all related to extending or defining how DataFusion reads data
//!
//! These examples demonstrate how DataFusion reads data.
//!
//! ## Usage
//! ```bash
//! cargo run --example custom_data_source -- [all|adapter_serialization|csv_json_opener|csv_sql_streaming|custom_datasource|custom_file_casts|custom_file_format|default_column_values|file_stream_provider]
//! ```
//!
//! Each subcommand runs a corresponding example:
//! - `all` — run all examples included in this module
//!
//! - `adapter_serialization`
//!   (file: adapter_serialization.rs, desc: Preserve custom PhysicalExprAdapter information during plan serialization using PhysicalExtensionCodec interception)
//!
//! - `csv_json_opener`
//!   (file: csv_json_opener.rs, desc: Use low-level FileOpener APIs for CSV/JSON)
//!
//! - `csv_sql_streaming`
//!   (file: csv_sql_streaming.rs, desc: Run a streaming SQL query against CSV data)
//!
//! - `custom_datasource`
//!   (file: custom_datasource.rs, desc: Query a custom TableProvider)
//!
//! - `custom_file_casts`
//!   (file: custom_file_casts.rs, desc: Implement custom casting rules)
//!
//! - `custom_file_format`
//!   (file: custom_file_format.rs, desc: Write to a custom file format)
//!
//! - `default_column_values`
//!   (file: default_column_values.rs, desc: Custom default values using metadata)
//!
//! - `file_stream_provider`
//!   (file: file_stream_provider.rs, desc: Read/write via FileStreamProvider for streams)

mod adapter_serialization;
mod csv_json_opener;
mod csv_sql_streaming;
mod custom_datasource;
mod custom_file_casts;
mod custom_file_format;
mod default_column_values;
mod file_stream_provider;

use datafusion::error::{DataFusionError, Result};
use strum::{IntoEnumIterator, VariantNames};
use strum_macros::{Display, EnumIter, EnumString, VariantNames};

#[derive(EnumIter, EnumString, Display, VariantNames)]
#[strum(serialize_all = "snake_case")]
enum ExampleKind {
    All,
    AdapterSerialization,
    CsvJsonOpener,
    CsvSqlStreaming,
    CustomDatasource,
    CustomFileCasts,
    CustomFileFormat,
    DefaultColumnValues,
    FileStreamProvider,
}

impl ExampleKind {
    const EXAMPLE_NAME: &str = "custom_data_source";

    fn runnable() -> impl Iterator<Item = ExampleKind> {
        ExampleKind::iter().filter(|v| !matches!(v, ExampleKind::All))
    }

    async fn run(&self) -> Result<()> {
        match self {
            ExampleKind::All => {
                for example in ExampleKind::runnable() {
                    println!("Running example: {example}");
                    Box::pin(example.run()).await?;
                }
            }
            ExampleKind::AdapterSerialization => {
                adapter_serialization::adapter_serialization().await?
            }
            ExampleKind::CsvJsonOpener => csv_json_opener::csv_json_opener().await?,
            ExampleKind::CsvSqlStreaming => {
                csv_sql_streaming::csv_sql_streaming().await?
            }
            ExampleKind::CustomDatasource => {
                custom_datasource::custom_datasource().await?
            }
            ExampleKind::CustomFileCasts => {
                custom_file_casts::custom_file_casts().await?
            }
            ExampleKind::CustomFileFormat => {
                custom_file_format::custom_file_format().await?
            }
            ExampleKind::DefaultColumnValues => {
                default_column_values::default_column_values().await?
            }
            ExampleKind::FileStreamProvider => {
                file_stream_provider::file_stream_provider().await?
            }
        }
        Ok(())
    }
}

#[tokio::main]
async fn main() -> Result<()> {
    let usage = format!(
        "Usage: cargo run --example {} -- [{}]",
        ExampleKind::EXAMPLE_NAME,
        ExampleKind::VARIANTS.join("|")
    );

    let example: ExampleKind = std::env::args()
        .nth(1)
        .unwrap_or_else(|| ExampleKind::All.to_string())
        .parse()
        .map_err(|_| DataFusionError::Execution(format!("Unknown example. {usage}")))?;

    example.run().await
}