use std::{any::Any, sync::Arc};
use arrow::datatypes::{Field, Schema, SchemaRef};
use async_trait::async_trait;
use datafusion::{
catalog::Session,
datasource::{file_format::file_compression_type::FileCompressionType, TableProvider},
error::Result,
logical_expr::{TableProviderFilterPushDown, TableType},
physical_plan::{empty::EmptyExec, ExecutionPlan},
prelude::Expr,
};
use exon_common::TableSchema;
use exon_fastq::new_fastq_schema_builder;
use futures::TryStreamExt;
use crate::{
datasources::{
exon_file_type::get_file_extension_with_compression,
exon_listing_table_options::{ExonListingConfig, ExonListingOptions},
hive_partition::filter_matches_partition_cols,
ExonFileType,
},
physical_plan::{
file_scan_config_builder::FileScanConfigBuilder, object_store::pruned_partition_list,
},
};
use super::FASTQScan;
#[derive(Debug, Clone)]
pub struct ListingFASTQTableOptions {
file_extension: String,
file_compression_type: FileCompressionType,
table_partition_cols: Vec<Field>,
}
impl Default for ListingFASTQTableOptions {
fn default() -> Self {
Self {
file_extension: String::from("fastq"),
file_compression_type: FileCompressionType::UNCOMPRESSED,
table_partition_cols: Vec::new(),
}
}
}
#[async_trait]
impl ExonListingOptions for ListingFASTQTableOptions {
fn table_partition_cols(&self) -> &[Field] {
&self.table_partition_cols
}
fn file_compression_type(&self) -> FileCompressionType {
self.file_compression_type
}
fn file_extension(&self) -> &str {
&self.file_extension
}
async fn create_physical_plan(
&self,
conf: datafusion::datasource::physical_plan::FileScanConfig,
) -> datafusion::error::Result<Arc<dyn ExecutionPlan>> {
let scan = FASTQScan::new(conf, self.file_compression_type());
Ok(Arc::new(scan))
}
}
impl ListingFASTQTableOptions {
pub fn new(file_compression_type: FileCompressionType) -> Self {
let file_extension = ExonFileType::FASTQ.get_file_extension(file_compression_type);
Self {
file_extension,
file_compression_type,
table_partition_cols: Vec::new(),
}
}
pub fn with_some_file_extension(self, file_extension: Option<&str>) -> Self {
let file_extension = if let Some(file_extension) = file_extension {
file_extension.to_string()
} else {
String::from("fastq")
};
let file_extension: String =
get_file_extension_with_compression(&file_extension, self.file_compression_type());
Self {
file_extension,
..self
}
}
pub fn with_table_partition_cols(self, table_partition_cols: Vec<Field>) -> Self {
Self {
table_partition_cols,
..self
}
}
pub fn infer_schema(&self) -> TableSchema {
let builder =
new_fastq_schema_builder().add_partition_fields(self.table_partition_cols.clone());
builder.build()
}
}
#[derive(Debug, Clone)]
pub struct ListingFASTQTable<T> {
table_schema: TableSchema,
config: ExonListingConfig<T>,
}
impl<T: ExonListingOptions> ListingFASTQTable<T> {
pub fn try_new(config: ExonListingConfig<T>, table_schema: TableSchema) -> Result<Self> {
Ok(Self {
table_schema,
config,
})
}
}
#[async_trait]
impl<T: ExonListingOptions + 'static> TableProvider for ListingFASTQTable<T> {
fn as_any(&self) -> &dyn Any {
self
}
fn schema(&self) -> SchemaRef {
Arc::clone(&self.table_schema.table_schema())
}
fn table_type(&self) -> TableType {
TableType::Base
}
fn supports_filters_pushdown(
&self,
filters: &[&Expr],
) -> Result<Vec<TableProviderFilterPushDown>> {
Ok(filters
.iter()
.map(|f| filter_matches_partition_cols(f, self.config.options.table_partition_cols()))
.collect())
}
async fn scan(
&self,
state: &dyn Session,
projection: Option<&Vec<usize>>,
filters: &[Expr],
limit: Option<usize>,
) -> Result<Arc<dyn ExecutionPlan>> {
let object_store_url = if let Some(url) = self.config.inner.table_paths.first() {
url.object_store()
} else {
return Ok(Arc::new(EmptyExec::new(Arc::new(Schema::empty()))));
};
let object_store = state.runtime_env().object_store(object_store_url.clone())?;
let file_list = pruned_partition_list(
&object_store,
&self.config.inner.table_paths[0],
filters,
self.config.options.file_extension(),
self.config.options.table_partition_cols(),
)
.await?
.try_collect::<Vec<_>>()
.await?;
let file_scan_config = FileScanConfigBuilder::new(
object_store_url.clone(),
self.table_schema.file_schema()?,
vec![file_list],
)
.projection_option(projection.cloned())
.table_partition_cols(self.config.options.table_partition_cols().to_vec())
.limit_option(limit)
.build();
let plan = self
.config
.options
.create_physical_plan(file_scan_config)
.await?;
Ok(plan)
}
}
#[cfg(test)]
mod tests {
use std::collections::HashMap;
use datafusion::datasource::file_format::file_compression_type::FileCompressionType;
use exon_test::test_listing_table_url;
use crate::{
datasources::{ExonFileType, ExonListingTableFactory},
ExonSession,
};
#[tokio::test]
async fn test_table_scan() -> Result<(), Box<dyn std::error::Error>> {
let ctx = ExonSession::new_exon()?;
let session_state = ctx.session.state();
let table_path = test_listing_table_url("fastq");
let table = ExonListingTableFactory::new()
.create_from_file_type(
&session_state,
ExonFileType::FASTQ,
FileCompressionType::UNCOMPRESSED,
table_path.to_string(),
Vec::new(),
&HashMap::new(),
)
.await?;
let df = ctx.session.read_table(table)?;
let mut row_cnt = 0;
let bs = df.collect().await?;
for batch in bs {
row_cnt += batch.num_rows();
}
assert_eq!(row_cnt, 2);
Ok(())
}
}