Skip to content

README.md

Latest commit

 

History

History
73 lines (59 loc) · 4.35 KB

README.md

File metadata and controls

73 lines (59 loc) · 4.35 KB
Raw

DataFusion Examples

This crate includes several examples of how to use various DataFusion APIs and help you on your way.

Prerequisites:

Run git submodule update --init to init test files.

Running Examples

To run the examples, use the cargo run command, such as:

git clone https://github.com/apache/arrow-datafusion
cd arrow-datafusion
# Download test data
git submodule update --init

# Run the `csv_sql` example:
# ... use the equivalent for other examples
cargo run --example csv_sql

Single Process

  • avro_sql.rs: Build and run a query plan from a SQL statement against a local AVRO file
  • csv_sql.rs: Build and run a query plan from a SQL statement against a local CSV file
  • catalog.rs: Register the table into a custom catalog
  • custom_datasource.rs: Run queries against a custom datasource (TableProvider)
  • dataframe.rs: Run a query using a DataFrame against a local parquet file
  • dataframe-to-s3.rs: Run a query using a DataFrame against a parquet file from s3 and writing back to s3
  • dataframe_output.rs: Examples of methods which write data out from a DataFrame
  • dataframe_in_memory.rs: Run a query using a DataFrame against data in memory
  • deserialize_to_struct.rs: Convert query results into rust structs using serde
  • expr_api.rs: Create, execute, simplify and anaylze Exprs
  • flight_sql_server.rs: Run DataFusion as a standalone process and execute SQL queries from JDBC clients
  • memtable.rs: Create an query data in memory using SQL and RecordBatches
  • parquet_sql.rs: Build and run a query plan from a SQL statement against a local Parquet file
  • parquet_sql_multiple_files.rs: Build and run a query plan from a SQL statement against multiple local Parquet files
  • query-aws-s3.rs: Configure object_store and run a query against files stored in AWS S3
  • query-http-csv.rs: Configure object_store and run a query against files vi HTTP
  • rewrite_expr.rs: Define and invoke a custom Query Optimizer pass
  • simple_udf.rs: Define and invoke a User Defined Scalar Function (UDF)
  • advanced_udf.rs: Define and invoke a more complicated User Defined Scalar Function (UDF)
  • simple_udaf.rs: Define and invoke a User Defined Aggregate Function (UDAF)
  • advanced_udaf.rs: Define and invoke a more complicated User Defined Aggregate Function (UDAF)
  • simple_udfw.rs: Define and invoke a User Defined Window Function (UDWF)
  • make_date.rs: Examples of using the make_date function
  • to_timestamp.rs: Examples of using the to_timestamp functions
  • advanced_udwf.rs: Define and invoke a more complicated User Defined Window Function (UDWF)

Distributed