1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192
// Licensed to the Apache Software Foundation (ASF) under one
// or more contributor license agreements. See the NOTICE file
// distributed with this work for additional information
// regarding copyright ownership. The ASF licenses this file
// to you under the Apache License, Version 2.0 (the
// "License"); you may not use this file except in compliance
// with the License. You may obtain a copy of the License at
//
//http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing,
// software distributed under the License is distributed on an
// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
// KIND, either express or implied. See the License for the
// specific language governing permissions and limitations
// under the License.
//! Utility functions for the interval arithmetic library
use std::sync::Arc;
use super::{Interval, IntervalBound};
use crate::{
expressions::{BinaryExpr, CastExpr, Column, Literal},
PhysicalExpr,
};
use arrow_schema::DataType;
use datafusion_common::{DataFusionError, Result, ScalarValue};
use datafusion_expr::Operator;
const MDN_DAY_MASK: i128 = 0xFFFF_FFFF_0000_0000_0000_0000;
const MDN_NS_MASK: i128 = 0xFFFF_FFFF_FFFF_FFFF;
const DT_MS_MASK: i64 = 0xFFFF_FFFF;
/// Indicates whether interval arithmetic is supported for the given expression.
/// Currently, we do not support all [`PhysicalExpr`]s for interval calculations.
/// We do not support every type of [`Operator`]s either. Over time, this check
/// will relax as more types of `PhysicalExpr`s and `Operator`s are supported.
/// Currently, [`CastExpr`], [`BinaryExpr`], [`Column`] and [`Literal`] are supported.
pub fn check_support(expr: &Arc<dyn PhysicalExpr>) -> bool {
let expr_any = expr.as_any();
let expr_supported = if let Some(binary_expr) = expr_any.downcast_ref::<BinaryExpr>()
{
is_operator_supported(binary_expr.op())
} else {
expr_any.is::<Column>() || expr_any.is::<Literal>() || expr_any.is::<CastExpr>()
};
expr_supported && expr.children().iter().all(check_support)
}
// This function returns the inverse operator of the given operator.
pub fn get_inverse_op(op: Operator) -> Operator {
match op {
Operator::Plus => Operator::Minus,
Operator::Minus => Operator::Plus,
_ => unreachable!(),
}
}
/// Indicates whether interval arithmetic is supported for the given operator.
pub fn is_operator_supported(op: &Operator) -> bool {
matches!(
op,
&Operator::Plus
| &Operator::Minus
| &Operator::And
| &Operator::Gt
| &Operator::GtEq
| &Operator::Lt
| &Operator::LtEq
| &Operator::Eq
)
}
/// Indicates whether interval arithmetic is supported for the given data type.
pub fn is_datatype_supported(data_type: &DataType) -> bool {
matches!(
data_type,
&DataType::Int64
| &DataType::Int32
| &DataType::Int16
| &DataType::Int8
| &DataType::UInt64
| &DataType::UInt32
| &DataType::UInt16
| &DataType::UInt8
| &DataType::Float64
| &DataType::Float32
)
}
/// Converts an [`Interval`] of time intervals to one of `Duration`s, if applicable. Otherwise, returns [`None`].
pub fn convert_interval_type_to_duration(interval: &Interval) -> Option<Interval> {
if let (Some(lower), Some(upper)) = (
convert_interval_bound_to_duration(&interval.lower),
convert_interval_bound_to_duration(&interval.upper),
) {
Some(Interval::new(lower, upper))
} else {
None
}
}
/// Converts an [`IntervalBound`] containing a time interval to one containing a `Duration`, if applicable. Otherwise, returns [`None`].
fn convert_interval_bound_to_duration(
interval_bound: &IntervalBound,
) -> Option<IntervalBound> {
match interval_bound.value {
ScalarValue::IntervalMonthDayNano(Some(mdn)) => {
interval_mdn_to_duration_ns(&mdn).ok().map(|duration| {
IntervalBound::new(
ScalarValue::DurationNanosecond(Some(duration)),
interval_bound.open,
)
})
}
ScalarValue::IntervalDayTime(Some(dt)) => {
interval_dt_to_duration_ms(&dt).ok().map(|duration| {
IntervalBound::new(
ScalarValue::DurationMillisecond(Some(duration)),
interval_bound.open,
)
})
}
_ => None,
}
}
/// Converts an [`Interval`] of `Duration`s to one of time intervals, if applicable. Otherwise, returns [`None`].
pub fn convert_duration_type_to_interval(interval: &Interval) -> Option<Interval> {
if let (Some(lower), Some(upper)) = (
convert_duration_bound_to_interval(&interval.lower),
convert_duration_bound_to_interval(&interval.upper),
) {
Some(Interval::new(lower, upper))
} else {
None
}
}
/// Converts an [`IntervalBound`] containing a `Duration` to one containing a time interval, if applicable. Otherwise, returns [`None`].
fn convert_duration_bound_to_interval(
interval_bound: &IntervalBound,
) -> Option<IntervalBound> {
match interval_bound.value {
ScalarValue::DurationNanosecond(Some(duration)) => Some(IntervalBound::new(
ScalarValue::new_interval_mdn(0, 0, duration),
interval_bound.open,
)),
ScalarValue::DurationMillisecond(Some(duration)) => Some(IntervalBound::new(
ScalarValue::new_interval_dt(0, duration as i32),
interval_bound.open,
)),
_ => None,
}
}
/// If both the month and day fields of [`ScalarValue::IntervalMonthDayNano`] are zero, this function returns the nanoseconds part.
/// Otherwise, it returns an error.
fn interval_mdn_to_duration_ns(mdn: &i128) -> Result<i64> {
let months = mdn >> 96;
let days = (mdn & MDN_DAY_MASK) >> 64;
let nanoseconds = mdn & MDN_NS_MASK;
if months == 0 && days == 0 {
nanoseconds.try_into().map_err(|_| {
DataFusionError::Internal("Resulting duration exceeds i64::MAX".to_string())
})
} else {
Err(DataFusionError::Internal(
"The interval cannot have a non-zero month or day value for duration convertibility"
.to_string(),
))
}
}
/// If the day field of the [`ScalarValue::IntervalDayTime`] is zero, this function returns the milliseconds part.
/// Otherwise, it returns an error.
fn interval_dt_to_duration_ms(dt: &i64) -> Result<i64> {
let days = dt >> 32;
let milliseconds = dt & DT_MS_MASK;
if days == 0 {
Ok(milliseconds)
} else {
Err(DataFusionError::Internal(
"The interval cannot have a non-zero day value for duration convertibility"
.to_string(),
))
}
}