SqlOperators (Apache Beam 2.29.0)

java.lang.Object
- org.apache.beam.sdk.extensions.sql.zetasql.translation.SqlOperators

```
@Internal
public class SqlOperators
extends java.lang.Object
```
A separate SqlOperators table for those functions that do not exist or not compatible with Calcite. Most of functions within this class is copied from Calcite.

Field Summary

Fields
Modifier and Type	Field and Description
`static org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator`	`ARRAY_AGG_FN`
`static org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator`	`BIT_XOR`
`static org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.validate.SqlUserDefinedFunction`	`CAST_OP`
`static org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator`	`CHAR_LENGTH`
`static org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator`	`CONCAT`
`static org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator`	`COUNTIF`
`static org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator`	`DATE_OP`
`static org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator`	`ENDS_WITH`
`static org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator`	`LIKE`
`static org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator`	`LTRIM`
`static org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator`	`REPLACE`
`static org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator`	`REVERSE`
`static org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator`	`RTRIM`
`static org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator`	`START_WITHS`
`static org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator`	`STRING_AGG_STRING_FN`
`static org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator`	`SUBSTR`
`static org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator`	`TIMESTAMP_OP`
`static org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator`	`TRIM`
`static org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator`	`VALIDATE_TIME_INTERVAL`
`static org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator`	`VALIDATE_TIMESTAMP`
`static org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator`	`ZETASQL_TIMESTAMP_ADD`

Constructor Summary

Constructors
Constructor and Description

SqlOperators()

Constructors
Constructor and Description
`SqlOperators()`

Method Summary

All Methods Static Methods Concrete Methods
Modifier and Type	Method and Description
`static org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlFunction`	`createZetaSqlFunction(java.lang.String name, org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.type.SqlTypeName returnType)` Create a dummy SqlFunction of type OTHER_FUNCTION from given function name and return type.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

ZETASQL_TIMESTAMP_ADD

public static final org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator ZETASQL_TIMESTAMP_ADD

STRING_AGG_STRING_FN

public static final org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator STRING_AGG_STRING_FN

ARRAY_AGG_FN

public static final org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator ARRAY_AGG_FN

START_WITHS

public static final org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator START_WITHS

CONCAT

public static final org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator CONCAT

REPLACE

public static final org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator REPLACE

TRIM

public static final org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator TRIM

LTRIM

public static final org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator LTRIM

RTRIM

public static final org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator RTRIM

SUBSTR

public static final org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator SUBSTR

REVERSE

public static final org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator REVERSE

CHAR_LENGTH

public static final org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator CHAR_LENGTH

ENDS_WITH

public static final org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator ENDS_WITH

LIKE

public static final org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator LIKE

VALIDATE_TIMESTAMP

public static final org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator VALIDATE_TIMESTAMP

VALIDATE_TIME_INTERVAL

public static final org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator VALIDATE_TIME_INTERVAL

TIMESTAMP_OP

public static final org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator TIMESTAMP_OP

DATE_OP

public static final org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator DATE_OP

BIT_XOR

public static final org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator BIT_XOR

COUNTIF

public static final org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlOperator COUNTIF

CAST_OP

public static final org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.validate.SqlUserDefinedFunction CAST_OP

Constructor Detail
- SqlOperators
```
public SqlOperators()
```

Method Detail

createZetaSqlFunction

public static org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.SqlFunction createZetaSqlFunction(java.lang.String name,
                                                                                                              org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.type.SqlTypeName returnType)

Create a dummy SqlFunction of type OTHER_FUNCTION from given function name and return type. These functions will be unparsed in either BeamZetaSqlCalcRel (for built-in functions) or BeamCalcRel (for user-defined functions).

Class SqlOperators