use std::any::Any;
use std::sync::Arc;
use arrow::array::ArrayRef;
use arrow::compute;
use arrow::datatypes::{DataType, Date32Type, Field, FieldRef};
use datafusion_common::cast::{
as_date32_array, as_int8_array, as_int16_array, as_int32_array,
};
use datafusion_common::{Result, internal_err};
use datafusion_expr::{
ColumnarValue, ReturnFieldArgs, ScalarFunctionArgs, ScalarUDFImpl, Signature,
TypeSignature, Volatility,
};
use datafusion_functions::utils::make_scalar_function;
#[derive(Debug, PartialEq, Eq, Hash)]
pub struct SparkDateSub {
signature: Signature,
}
impl Default for SparkDateSub {
fn default() -> Self {
Self::new()
}
}
impl SparkDateSub {
pub fn new() -> Self {
Self {
signature: Signature::one_of(
vec![
TypeSignature::Exact(vec![DataType::Date32, DataType::Int8]),
TypeSignature::Exact(vec![DataType::Date32, DataType::Int16]),
TypeSignature::Exact(vec![DataType::Date32, DataType::Int32]),
],
Volatility::Immutable,
),
}
}
}
impl ScalarUDFImpl for SparkDateSub {
fn as_any(&self) -> &dyn Any {
self
}
fn name(&self) -> &str {
"date_sub"
}
fn signature(&self) -> &Signature {
&self.signature
}
fn return_type(&self, _arg_types: &[DataType]) -> Result<DataType> {
internal_err!("return_field_from_args should be used instead")
}
fn return_field_from_args(&self, args: ReturnFieldArgs) -> Result<FieldRef> {
let nullable = args.arg_fields.iter().any(|f| f.is_nullable());
Ok(Arc::new(Field::new(
self.name(),
DataType::Date32,
nullable,
)))
}
fn invoke_with_args(&self, args: ScalarFunctionArgs) -> Result<ColumnarValue> {
make_scalar_function(spark_date_sub, vec![])(&args.args)
}
}
fn spark_date_sub(args: &[ArrayRef]) -> Result<ArrayRef> {
let [date_arg, days_arg] = args else {
return internal_err!(
"Spark `date_sub` function requires 2 arguments, got {}",
args.len()
);
};
let date_array = as_date32_array(date_arg)?;
let result = match days_arg.data_type() {
DataType::Int8 => {
let days_array = as_int8_array(days_arg)?;
compute::binary::<_, _, _, Date32Type>(
date_array,
days_array,
|date, days| date.wrapping_sub(days as i32),
)?
}
DataType::Int16 => {
let days_array = as_int16_array(days_arg)?;
compute::binary::<_, _, _, Date32Type>(
date_array,
days_array,
|date, days| date.wrapping_sub(days as i32),
)?
}
DataType::Int32 => {
let days_array = as_int32_array(days_arg)?;
compute::binary::<_, _, _, Date32Type>(
date_array,
days_array,
|date, days| date.wrapping_sub(days),
)?
}
_ => {
return internal_err!(
"Spark `date_sub` function: argument must be int8, int16, int32, got {:?}",
days_arg.data_type()
);
}
};
Ok(Arc::new(result))
}
#[cfg(test)]
mod tests {
use super::*;
#[test]
fn test_date_sub_nullability_non_nullable_args() {
let udf = SparkDateSub::new();
let date_field = Arc::new(Field::new("d", DataType::Date32, false));
let days_field = Arc::new(Field::new("n", DataType::Int32, false));
let result = udf
.return_field_from_args(ReturnFieldArgs {
arg_fields: &[date_field, days_field],
scalar_arguments: &[None, None],
})
.unwrap();
assert!(!result.is_nullable());
assert_eq!(result.data_type(), &DataType::Date32);
}
#[test]
fn test_date_sub_nullability_nullable_arg() {
let udf = SparkDateSub::new();
let date_field = Arc::new(Field::new("d", DataType::Date32, false));
let nullable_days_field = Arc::new(Field::new("n", DataType::Int32, true));
let result = udf
.return_field_from_args(ReturnFieldArgs {
arg_fields: &[date_field, nullable_days_field],
scalar_arguments: &[None, None],
})
.unwrap();
assert!(result.is_nullable());
assert_eq!(result.data_type(), &DataType::Date32);
}
}