use crate::conversions::{AddressArrayRecycler, PrimitiveArrayRecycler, StringViewArrayRecycler};
use crate::DEFAULT_BATCH_SIZE;
use arrow::array::RecordBatch;
use arrow::datatypes::{DataType, Date32Type, Decimal128Type, Field, Int32Type, Schema, SchemaRef};
use arrow::error::ArrowError;
use arrow::record_batch::RecordBatchReader;
use std::sync::{Arc, LazyLock};
use tpcdsgen::config::{Session, Table};
use tpcdsgen::row::{StoreRow, StoreRowGenerator};
pub struct StoreArrow {
inner: StoreRowGenerator,
batch_size: usize,
scratch: Vec<StoreRow>,
s_store_sk: PrimitiveArrayRecycler<Int32Type>,
s_store_id: StringViewArrayRecycler,
s_rec_start_date: PrimitiveArrayRecycler<Date32Type>,
s_rec_end_date: PrimitiveArrayRecycler<Date32Type>,
s_closed_date_sk: PrimitiveArrayRecycler<Int32Type>,
s_store_name: StringViewArrayRecycler,
s_number_employees: PrimitiveArrayRecycler<Int32Type>,
s_floor_space: PrimitiveArrayRecycler<Int32Type>,
s_hours: StringViewArrayRecycler,
s_manager: StringViewArrayRecycler,
s_market_id: PrimitiveArrayRecycler<Int32Type>,
s_geography_class: StringViewArrayRecycler,
s_market_desc: StringViewArrayRecycler,
s_market_manager: StringViewArrayRecycler,
s_division_id: PrimitiveArrayRecycler<Int32Type>,
s_division_name: StringViewArrayRecycler,
s_company_id: PrimitiveArrayRecycler<Int32Type>,
s_company_name: StringViewArrayRecycler,
address: AddressArrayRecycler,
s_tax_precentage: PrimitiveArrayRecycler<Decimal128Type>,
}
impl StoreArrow {
pub fn schema_ref() -> SchemaRef {
Arc::clone(&SCHEMA)
}
pub fn new(session: Session) -> Self {
let row_count = session.get_scaling().get_row_count(Table::Store);
Self {
inner: StoreRowGenerator::new(session, row_count),
batch_size: DEFAULT_BATCH_SIZE,
scratch: Vec::with_capacity(DEFAULT_BATCH_SIZE),
s_store_sk: PrimitiveArrayRecycler::new(),
s_store_id: StringViewArrayRecycler::new(),
s_rec_start_date: PrimitiveArrayRecycler::new(),
s_rec_end_date: PrimitiveArrayRecycler::new(),
s_closed_date_sk: PrimitiveArrayRecycler::new(),
s_store_name: StringViewArrayRecycler::new(),
s_number_employees: PrimitiveArrayRecycler::new(),
s_floor_space: PrimitiveArrayRecycler::new(),
s_hours: StringViewArrayRecycler::new(),
s_manager: StringViewArrayRecycler::new(),
s_market_id: PrimitiveArrayRecycler::new(),
s_geography_class: StringViewArrayRecycler::new(),
s_market_desc: StringViewArrayRecycler::new(),
s_market_manager: StringViewArrayRecycler::new(),
s_division_id: PrimitiveArrayRecycler::new(),
s_division_name: StringViewArrayRecycler::new(),
s_company_id: PrimitiveArrayRecycler::new(),
s_company_name: StringViewArrayRecycler::new(),
address: AddressArrayRecycler::new(),
s_tax_precentage: PrimitiveArrayRecycler::new(),
}
}
pub fn skip_rows_until_starting_row_number(&mut self, starting_row_number: u64) {
self.inner
.skip_rows_until_starting_row_number(starting_row_number);
}
pub fn with_source_row_range(
mut self,
starting_row_number: u64,
ending_row_number: u64,
) -> Self {
self.inner
.set_source_row_range(starting_row_number, ending_row_number);
self
}
pub fn with_batch_size(mut self, batch_size: usize) -> Self {
self.batch_size = batch_size;
self
}
}
impl RecordBatchReader for StoreArrow {
fn schema(&self) -> SchemaRef {
Self::schema_ref()
}
}
impl Iterator for StoreArrow {
type Item = Result<RecordBatch, ArrowError>;
fn next(&mut self) -> Option<Self::Item> {
self.scratch.clear();
self.scratch
.extend(self.inner.by_ref().take(self.batch_size));
let rows = &self.scratch;
if rows.is_empty() {
return None;
}
let schema = self.schema();
let Self {
s_store_sk,
s_store_id,
s_rec_start_date,
s_rec_end_date,
s_closed_date_sk,
s_store_name,
s_number_employees,
s_floor_space,
s_hours,
s_manager,
s_market_id,
s_geography_class,
s_market_desc,
s_market_manager,
s_division_id,
s_division_name,
s_company_id,
s_company_name,
address,
s_tax_precentage,
..
} = self;
let nbm = StoreRow::null_bit_map;
let sk32 = |rec: &mut PrimitiveArrayRecycler<Int32Type>, pos, f: fn(&StoreRow) -> i64| {
rec.int32_sk(rows, pos, nbm, f)
};
let int = |rec: &mut PrimitiveArrayRecycler<Int32Type>, pos, f: fn(&StoreRow) -> i32| {
rec.int32(rows, pos, nbm, f)
};
let int64 = |rec: &mut PrimitiveArrayRecycler<Int32Type>, pos, f: fn(&StoreRow) -> i64| {
rec.int32(rows, pos, nbm, |r| {
i32::try_from(f(r)).expect("TPC-DS INTEGER value exceeds i32 range")
})
};
let str = |rec: &mut StringViewArrayRecycler, pos, f: fn(&StoreRow) -> &str| {
rec.str(rows, pos, nbm, f)
};
let date = |rec: &mut PrimitiveArrayRecycler<Date32Type>, pos, f: fn(&StoreRow) -> i64| {
rec.date32_julian(rows, pos, nbm, f)
};
let s_store_sk = sk32(s_store_sk, 0, StoreRow::get_store_sk);
let s_store_id = str(s_store_id, 1, StoreRow::get_store_id);
let s_rec_start_date = date(s_rec_start_date, 2, StoreRow::get_rec_start_date_id);
let s_rec_end_date =
s_rec_end_date.date32_julian(rows, 3, |_| 0, StoreRow::get_rec_end_date_id);
let s_closed_date_sk = sk32(s_closed_date_sk, 4, StoreRow::get_closed_date_id);
let s_store_name = str(s_store_name, 5, StoreRow::get_store_name);
let s_number_employees = int(s_number_employees, 6, StoreRow::get_employees);
let s_floor_space = int(s_floor_space, 7, StoreRow::get_floor_space);
let s_hours = str(s_hours, 8, StoreRow::get_hours);
let s_manager = str(s_manager, 9, StoreRow::get_store_manager);
let s_market_id = int(s_market_id, 10, StoreRow::get_market_id);
let s_geography_class = str(s_geography_class, 12, StoreRow::get_geography_class);
let s_market_desc = str(s_market_desc, 13, StoreRow::get_market_desc);
let s_market_manager = str(s_market_manager, 14, StoreRow::get_market_manager);
let s_division_id = int64(s_division_id, 15, StoreRow::get_division_id);
let s_division_name = str(s_division_name, 16, StoreRow::get_division_name);
let s_company_id = int64(s_company_id, 17, StoreRow::get_company_id);
let s_company_name = str(s_company_name, 18, StoreRow::get_company_name);
let address = address.build(rows, 19, nbm, StoreRow::get_address);
let s_tax_precentage =
s_tax_precentage.decimal_5_2(rows, 11, nbm, StoreRow::get_d_tax_percentage);
let batch = RecordBatch::try_new(
schema,
vec![
Arc::new(s_store_sk),
Arc::new(s_store_id),
Arc::new(s_rec_start_date),
Arc::new(s_rec_end_date),
Arc::new(s_closed_date_sk),
Arc::new(s_store_name),
Arc::new(s_number_employees),
Arc::new(s_floor_space),
Arc::new(s_hours),
Arc::new(s_manager),
Arc::new(s_market_id),
Arc::new(s_geography_class),
Arc::new(s_market_desc),
Arc::new(s_market_manager),
Arc::new(s_division_id),
Arc::new(s_division_name),
Arc::new(s_company_id),
Arc::new(s_company_name),
Arc::new(address.street_number),
Arc::new(address.street_name),
Arc::new(address.street_type),
Arc::new(address.suite_number),
Arc::new(address.city),
Arc::new(address.county),
Arc::new(address.state),
Arc::new(address.zip),
Arc::new(address.country),
Arc::new(address.gmt_offset),
Arc::new(s_tax_precentage),
],
);
Some(batch)
}
}
static SCHEMA: LazyLock<SchemaRef> = LazyLock::new(make_schema);
fn make_schema() -> SchemaRef {
Arc::new(Schema::new(vec![
Field::new("s_store_sk", DataType::Int32, false),
Field::new("s_store_id", DataType::Utf8View, false),
Field::new("s_rec_start_date", DataType::Date32, true),
Field::new("s_rec_end_date", DataType::Date32, true),
Field::new("s_closed_date_sk", DataType::Int32, true),
Field::new("s_store_name", DataType::Utf8View, true),
Field::new("s_number_employees", DataType::Int32, true),
Field::new("s_floor_space", DataType::Int32, true),
Field::new("s_hours", DataType::Utf8View, true),
Field::new("s_manager", DataType::Utf8View, true),
Field::new("s_market_id", DataType::Int32, true),
Field::new("s_geography_class", DataType::Utf8View, true),
Field::new("s_market_desc", DataType::Utf8View, true),
Field::new("s_market_manager", DataType::Utf8View, true),
Field::new("s_division_id", DataType::Int32, true),
Field::new("s_division_name", DataType::Utf8View, true),
Field::new("s_company_id", DataType::Int32, true),
Field::new("s_company_name", DataType::Utf8View, true),
Field::new("s_street_number", DataType::Utf8View, true),
Field::new("s_street_name", DataType::Utf8View, true),
Field::new("s_street_type", DataType::Utf8View, true),
Field::new("s_suite_number", DataType::Utf8View, true),
Field::new("s_city", DataType::Utf8View, true),
Field::new("s_county", DataType::Utf8View, true),
Field::new("s_state", DataType::Utf8View, true),
Field::new("s_zip", DataType::Utf8View, true),
Field::new("s_country", DataType::Utf8View, true),
Field::new("s_gmt_offset", DataType::Decimal128(5, 2), true),
Field::new("s_tax_precentage", DataType::Decimal128(5, 2), true),
]))
}