org.apache.beam.sdk.extensions.sql.impl.interpreter.operator

Class DateOperators

java.lang.Object

org.apache.beam.sdk.extensions.sql.impl.interpreter.operator.DateOperators

public class DateOperators
extends java.lang.Object

Date operator implementations.

Field Summary

Fields

Modifier and Type	Field and Description
static BeamSqlOperator	DATETIME_CEIL Implementation of CEIL(date or time TO unit).
static BeamSqlOperator	DATETIME_FLOOR Implementation of FLOOR(date or time TO unit).
static BeamSqlOperator	EXTRACT BeamSqlOperator for EXTRACT.

Constructor Summary

Constructors

Constructor and Description
DateOperators()

Method Summary

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

DATETIME_CEIL

public static final BeamSqlOperator DATETIME_CEIL

Implementation of CEIL(date or time TO unit).

Only supports months and years.

DATETIME_FLOOR

public static final BeamSqlOperator DATETIME_FLOOR

Implementation of FLOOR(date or time TO unit).

Only supports months and years.

EXTRACT

public static final BeamSqlOperator EXTRACT

BeamSqlOperator for EXTRACT.

The following date functions also implicitly converted to EXTRACT:

• YEAR(date) => EXTRACT(YEAR FROM date)
• MONTH(date) => EXTRACT(MONTH FROM date)
• DAY(date) => EXTRACT(DAY FROM date)
• QUARTER(date) => EXTRACT(QUARTER FROM date)
• WEEK(date) => EXTRACT(WEEK FROM date)
• DAYOFYEAR(date) => EXTRACT(DOY FROM date)
• DAYOFMONTH(date) => EXTRACT(DAY FROM date)
• DAYOFWEEK(date) => EXTRACT(DOW FROM date)
• HOUR(date) => EXTRACT(HOUR FROM date)
• MINUTE(date) => EXTRACT(MINUTE FROM date)
• SECOND(date) => EXTRACT(SECOND FROM date)

Constructor Detail

DateOperators

public DateOperators()