Package org.apache.calcite.sql

Class SqlMatchRecognize

java.lang.Object

org.apache.calcite.sql.SqlNode

org.apache.calcite.sql.SqlCall

org.apache.calcite.sql.SqlMatchRecognize

All Implemented Interfaces:

Cloneable

public class SqlMatchRecognize
extends SqlCall

SqlNode for MATCH_RECOGNIZE clause.

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static enum	SqlMatchRecognize.AfterOption	Options for AFTER MATCH clause.
static enum	SqlMatchRecognize.RowsPerMatchOption	Options for ROWS PER MATCH.
static class	SqlMatchRecognize.SqlMatchRecognizeOperator	An operator describing a MATCH_RECOGNIZE specification.

Field Summary

Fields

Modifier and Type	Field	Description
static final int	OPERAND_AFTER
static final int	OPERAND_INTERVAL
static final int	OPERAND_MEASURES
static final int	OPERAND_ORDER_BY
static final int	OPERAND_PARTITION_BY
static final int	OPERAND_PATTERN
static final int	OPERAND_PATTERN_DEFINES
static final int	OPERAND_ROWS_PER_MATCH
static final int	OPERAND_STRICT_END
static final int	OPERAND_STRICT_START
static final int	OPERAND_SUBSET
static final int	OPERAND_TABLE_REF
static final SqlPrefixOperator	SKIP_TO_FIRST
static final SqlPrefixOperator	SKIP_TO_LAST

Fields inherited from class org.apache.calcite.sql.SqlNode

EMPTY_ARRAY, pos

Constructor Summary

Constructors

Constructor	Description
SqlMatchRecognize(SqlParserPos pos, SqlNode tableRef, SqlNode pattern, SqlLiteral strictStart, SqlLiteral strictEnd, SqlNodeList patternDefList, SqlNodeList measureList, @Nullable SqlNode after, SqlNodeList subsetList, @Nullable SqlLiteral rowsPerMatch, SqlNodeList partitionList, SqlNodeList orderList, @Nullable SqlLiteral interval)	Creates a SqlMatchRecognize.

Method Summary

Modifier and Type	Method	Description
@Nullable SqlNode	getAfter()
@Nullable SqlLiteral	getInterval()
SqlKind	getKind()	Returns the type of node this is, or SqlKind.OTHER if it's nothing special.
SqlNodeList	getMeasureList()
List<SqlNode>	getOperandList()	Returns the list of operands.
SqlOperator	getOperator()
SqlNodeList	getOrderList()
SqlNodeList	getPartitionList()
SqlNode	getPattern()
SqlNodeList	getPatternDefList()
@Nullable SqlLiteral	getRowsPerMatch()
SqlLiteral	getStrictEnd()
SqlLiteral	getStrictStart()
SqlNodeList	getSubsetList()
SqlNode	getTableRef()
void	setOperand(int i, @Nullable SqlNode operand)	Changes the value of an operand.
void	unparse(SqlWriter writer, int leftPrec, int rightPrec)	Writes a SQL representation of this node to a writer.
void	validate(SqlValidator validator, SqlValidatorScope scope)	Validates this call.

Methods inherited from class org.apache.calcite.sql.SqlCall

accept, clone, equalsDeep, findValidOptions, getCallSignature, getFunctionQuantifier, getMonotonicity, isCountStar, isExpanded, operand, operandCount

Methods inherited from class org.apache.calcite.sql.SqlNode

clone, clone, cloneArray, equalDeep, equalDeep, equalsDeep, getParserPosition, isA, toList, toList, toSqlString, toSqlString, toSqlString, toString, unparseWithParentheses, validateExpr

Methods inherited from class java.lang.Object

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

Field Details

OPERAND_TABLE_REF

public static final int OPERAND_TABLE_REF

See Also:

• Constant Field Values

OPERAND_PATTERN

public static final int OPERAND_PATTERN

See Also:

• Constant Field Values

OPERAND_STRICT_START

public static final int OPERAND_STRICT_START

See Also:

• Constant Field Values

OPERAND_STRICT_END

public static final int OPERAND_STRICT_END

See Also:

• Constant Field Values

OPERAND_PATTERN_DEFINES

public static final int OPERAND_PATTERN_DEFINES

See Also:

• Constant Field Values

OPERAND_MEASURES

public static final int OPERAND_MEASURES

See Also:

• Constant Field Values

OPERAND_AFTER

public static final int OPERAND_AFTER

See Also:

• Constant Field Values

OPERAND_SUBSET

public static final int OPERAND_SUBSET

See Also:

• Constant Field Values

OPERAND_ROWS_PER_MATCH

public static final int OPERAND_ROWS_PER_MATCH

See Also:

• Constant Field Values

OPERAND_PARTITION_BY

public static final int OPERAND_PARTITION_BY

See Also:

• Constant Field Values

OPERAND_ORDER_BY

public static final int OPERAND_ORDER_BY

See Also:

• Constant Field Values

OPERAND_INTERVAL

public static final int OPERAND_INTERVAL

See Also:

• Constant Field Values

SKIP_TO_FIRST

public static final SqlPrefixOperator SKIP_TO_FIRST

SKIP_TO_LAST

public static final SqlPrefixOperator SKIP_TO_LAST

Constructor Details

SqlMatchRecognize

public SqlMatchRecognize(SqlParserPos pos,
 SqlNode tableRef,
 SqlNode pattern,
 SqlLiteral strictStart,
 SqlLiteral strictEnd,
 SqlNodeList patternDefList,
 SqlNodeList measureList,
 @Nullable SqlNode after,
 SqlNodeList subsetList,
 @Nullable SqlLiteral rowsPerMatch,
 SqlNodeList partitionList,
 SqlNodeList orderList,
 @Nullable SqlLiteral interval)

Creates a SqlMatchRecognize.

Method Details

getOperator

public SqlOperator getOperator()

Specified by:

getOperator in class SqlCall

getKind

public SqlKind getKind()

Description copied from class: SqlNode

Returns the type of node this is, or SqlKind.OTHER if it's nothing special.

Overrides:

getKind in class SqlCall

Returns:

a SqlKind value, never null

See Also:

• SqlNode.isA(java.util.Set<org.apache.calcite.sql.SqlKind>)

getOperandList

public List<SqlNode> getOperandList()

Description copied from class: SqlCall

Returns the list of operands. The set and order of operands is call-specific.

Note: the proper type would be List<@Nullable SqlNode>, however, it would trigger too many changes to the current codebase.

Specified by:

getOperandList in class SqlCall

Returns:

the list of call operands, never null, the operands can be null

unparse

public void unparse(SqlWriter writer,
 int leftPrec,
 int rightPrec)

Description copied from class: SqlNode

Writes a SQL representation of this node to a writer.

The leftPrec and rightPrec parameters give us enough context to decide whether we need to enclose the expression in parentheses. For example, we need parentheses around "2 + 3" if preceded by "5 *". This is because the precedence of the "*" operator is greater than the precedence of the "+" operator.

The algorithm handles left- and right-associative operators by giving them slightly different left- and right-precedence.

If SqlWriter.isAlwaysUseParentheses() is true, we use parentheses even when they are not required by the precedence rules.

For the details of this algorithm, see SqlCall.unparse(org.apache.calcite.sql.SqlWriter, int, int).

Overrides:

unparse in class SqlCall

Parameters:

writer - Target writer

leftPrec - The precedence of the SqlNode immediately preceding this node in a depth-first scan of the parse tree

rightPrec - The precedence of the SqlNode immediately

validate

public void validate(SqlValidator validator,
 SqlValidatorScope scope)

Description copied from class: SqlCall

Validates this call.

The default implementation delegates the validation to the operator's SqlOperator.validateCall(org.apache.calcite.sql.SqlCall, org.apache.calcite.sql.validate.SqlValidator, org.apache.calcite.sql.validate.SqlValidatorScope, org.apache.calcite.sql.validate.SqlValidatorScope). Derived classes may override (as do, for example SqlSelect and SqlUpdate).

Overrides:

validate in class SqlCall

Parameters:

scope - Validator

setOperand

public void setOperand(int i,
 @Nullable SqlNode operand)

Description copied from class: SqlCall

Changes the value of an operand. Allows some rewrite by SqlValidator; use sparingly.

Overrides:

setOperand in class SqlCall

Parameters:

i - Operand index

operand - Operand value

getTableRef

public SqlNode getTableRef()

getPattern

public SqlNode getPattern()

getStrictStart

public SqlLiteral getStrictStart()

getStrictEnd

public SqlLiteral getStrictEnd()

getPatternDefList

public SqlNodeList getPatternDefList()

getMeasureList

public SqlNodeList getMeasureList()

getAfter

public @Nullable SqlNode getAfter()

getSubsetList

public SqlNodeList getSubsetList()

getRowsPerMatch

public @Nullable SqlLiteral getRowsPerMatch()

getPartitionList

public SqlNodeList getPartitionList()

getOrderList

public SqlNodeList getOrderList()

getInterval

public @Nullable SqlLiteral getInterval()