Package org.apache.calcite.sql.advise

Class SqlAdvisorValidator

java.lang.Object

org.apache.calcite.sql.validate.SqlValidatorImpl

org.apache.calcite.sql.advise.SqlAdvisorValidator

All Implemented Interfaces:

SqlValidator, SqlValidatorWithHints

public class SqlAdvisorValidator
extends SqlValidatorImpl

SqlAdvisorValidator is used by SqlAdvisor to traverse the parse tree of a SQL statement, not for validation purpose but for setting up the scopes and namespaces to facilitate retrieval of SQL statement completion hints.

Nested Class Summary

Nested classes/interfaces inherited from class org.apache.calcite.sql.validate.SqlValidatorImpl

SqlValidatorImpl.DmlNamespace, SqlValidatorImpl.FunctionParamInfo, SqlValidatorImpl.IdInfo, SqlValidatorImpl.Status

Nested classes/interfaces inherited from interface org.apache.calcite.sql.validate.SqlValidator

SqlValidator.Config

Field Summary

Fields inherited from class org.apache.calcite.sql.validate.SqlValidatorImpl

callToOperandTypesMap, functionCallStack, idPositions, namespaces, scopes, timeFrameSet, TRACER, typeFactory, unknownType, UPDATE_ANON_PREFIX, UPDATE_SRC_ALIAS, UPDATE_TGT_ALIAS

Constructor Summary

Constructors

Constructor	Description
SqlAdvisorValidator(SqlOperatorTable opTab, SqlValidatorCatalogReader catalogReader, RelDataTypeFactory typeFactory, SqlValidator.Config config)	Creates a SqlAdvisor validator.

Method Summary

Modifier and Type	Method	Description
RelDataType	deriveType(SqlValidatorScope scope, SqlNode operand)	Calls the parent class method and mask Farrago exception thrown.
SqlNode	expand(SqlNode expr, SqlValidatorScope scope)	Expands an expression.
SqlNode	expandOrderExpr(SqlSelect select, SqlNode orderExpr)	Expands an expression in the ORDER BY clause into an expression with the same semantics as expressions in the SELECT clause.
SqlNode	expandSelectExpr(SqlNode expr, SelectScope scope, SqlSelect select, Map<String,SqlNode> expansions)
protected boolean	shouldAllowOverRelation()
protected void	validateFrom(SqlNode node, RelDataType targetRowType, SqlValidatorScope scope)	Validates the FROM clause of a query, or (recursively) a child node of the FROM clause: AS, OVER, JOIN, VALUES, or sub-query.
protected void	validateHavingClause(SqlSelect select)	Calls the parent class method and masks Farrago exception thrown.
void	validateIdentifier(SqlIdentifier id, SqlValidatorScope scope)	Registers the identifier and its scope into a map keyed by ParserPosition.
boolean	validateModality(SqlSelect select, SqlModality modality, boolean fail)	Validates that a query is capable of producing a return of given modality (relational or streaming).
protected void	validateNamespace(SqlValidatorNamespace namespace, RelDataType targetRowType)	Validates a namespace.
protected void	validateOver(SqlCall call, SqlValidatorScope scope)
protected void	validateWhereClause(SqlSelect select)	Calls the parent class method and masks Farrago exception thrown.

Methods inherited from class org.apache.calcite.sql.validate.SqlValidatorImpl

addToSelectList, checkTypeAssignment, config, createMatchRecognizeNameSpace, createPivotNameSpace, createSelectNamespace, createSetopNamespace, createSourceSelectForDelete, createSourceSelectForUpdate, createTargetRowType, createUnpivotNameSpace, declareCursor, deriveAlias, deriveConstructorType, expandStar, extendedExpandGroupBy, getAggregate, getCatalogReader, getConformance, getCursorScope, getEmptyScope, getFieldOrigins, getFromScope, getGroupScope, getHavingScope, getJoinScope, getLambdaScope, getLogicalSourceRowType, getLogicalTargetRowType, getMatchRecognizeScope, getMeasureScope, getNamespace, getOperatorTable, getOrderScope, getOriginal, getOverScope, getParameterRowType, getParentCursor, getRawSelectScope, getSelectScope, getSelfJoinExprForUpdate, getTimeFrameSet, getTypeCoercion, getTypeFactory, getUnknownType, getValidatedNodeType, getValidatedNodeTypeIfKnown, getValidatedOperandTypes, getValidationErrorFunction, getWhereScope, getWindowByName, getWithScope, handleUnresolvedFunction, inferUnknownTypes, isAggregate, isAggregate, isNestedAggregateWindow, isOverAggregateWindow, isSystemField, lookupHints, lookupNameCompletionHints, lookupQualifiedName, makeNullaryCall, newValidationError, performUnconditionalRewrites, popFunctionCall, pushFunctionCall, registerNamespace, registerQuery, removeValidatedNodeType, resolveLiteral, resolveWindow, setOriginal, setValidatedNodeType, shouldAllowIntermediateOrderBy, transform, usingNames, validate, validateAggregateParams, validateCall, validateDataType, validateDelete, validateDynamicParam, validateFeature, validateGroupClause, validateInsert, validateIntervalQualifier, validateJoin, validateLambda, validateLiteral, validateMatchRecognize, validateMerge, validateMustFilterRequirements, validateOrderList, validateParameterizedExpression, validatePivot, validateQualifyClause, validateQuery, validateSelect, validateSelectList, validateSequenceValue, validateTableFunction, validateTimeFrame, validateUnnest, validateUnpivot, validateUpdate, validateValues, validateWhereOrOn, validateWindow, validateWindowClause, validateWith, validateWithItem

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.apache.calcite.sql.validate.SqlValidator

getTypeMappingRule, resolveWindow

Constructor Details

SqlAdvisorValidator

public SqlAdvisorValidator(SqlOperatorTable opTab,
 SqlValidatorCatalogReader catalogReader,
 RelDataTypeFactory typeFactory,
 SqlValidator.Config config)

Creates a SqlAdvisor validator.

Parameters:

opTab - Operator table

catalogReader - Catalog reader

typeFactory - Type factory

config - Config

Method Details

validateIdentifier

public void validateIdentifier(SqlIdentifier id,
 SqlValidatorScope scope)

Registers the identifier and its scope into a map keyed by ParserPosition.

Specified by:

validateIdentifier in interface SqlValidator

Overrides:

validateIdentifier in class SqlValidatorImpl

Parameters:

id - Identifier

scope - Naming scope

expand

public SqlNode expand(SqlNode expr,
 SqlValidatorScope scope)

Description copied from interface: SqlValidator

Expands an expression.

Specified by:

expand in interface SqlValidator

Overrides:

expand in class SqlValidatorImpl

Parameters:

expr - Expression

scope - Scope

Returns:

Expanded expression

expandSelectExpr

public SqlNode expandSelectExpr(SqlNode expr,
 SelectScope scope,
 SqlSelect select,
 Map<String,SqlNode> expansions)

Overrides:

expandSelectExpr in class SqlValidatorImpl

expandOrderExpr

public SqlNode expandOrderExpr(SqlSelect select,
 SqlNode orderExpr)

Description copied from interface: SqlValidator

Expands an expression in the ORDER BY clause into an expression with the same semantics as expressions in the SELECT clause.

This is made necessary by a couple of dialect 'features':

• ordinal expressions: In "SELECT x, y FROM t ORDER BY 2", the expression "2" is shorthand for the 2nd item in the select clause, namely "y".
• alias references: In "SELECT x AS a, y FROM t ORDER BY a", the expression "a" is shorthand for the item in the select clause whose alias is "a"

Specified by:

expandOrderExpr in interface SqlValidator

Overrides:

expandOrderExpr in class SqlValidatorImpl

Parameters:

select - Select statement which contains ORDER BY

orderExpr - Expression in the ORDER BY clause.

Returns:

Expression translated into SELECT clause semantics

deriveType

public RelDataType deriveType(SqlValidatorScope scope,
 SqlNode operand)

Calls the parent class method and mask Farrago exception thrown.

Specified by:

deriveType in interface SqlValidator

Overrides:

deriveType in class SqlValidatorImpl

Parameters:

scope - Syntactic scope

operand - Parse tree node

Returns:

Type of the SqlNode. Should never return NULL

validateFrom

protected void validateFrom(SqlNode node,
 RelDataType targetRowType,
 SqlValidatorScope scope)

Description copied from class: SqlValidatorImpl

Validates the FROM clause of a query, or (recursively) a child node of the FROM clause: AS, OVER, JOIN, VALUES, or sub-query.

Overrides:

validateFrom in class SqlValidatorImpl

Parameters:

node - Node in FROM clause, typically a table or derived table

targetRowType - Desired row type of this expression, or SqlValidatorImpl.unknownType if not fussy. Must not be null.

scope - Scope

validateWhereClause

protected void validateWhereClause(SqlSelect select)

Calls the parent class method and masks Farrago exception thrown.

Overrides:

validateWhereClause in class SqlValidatorImpl

validateHavingClause

protected void validateHavingClause(SqlSelect select)

Calls the parent class method and masks Farrago exception thrown.

Overrides:

validateHavingClause in class SqlValidatorImpl

validateOver

protected void validateOver(SqlCall call,
 SqlValidatorScope scope)

Overrides:

validateOver in class SqlValidatorImpl

validateNamespace

protected void validateNamespace(SqlValidatorNamespace namespace,
 RelDataType targetRowType)

Description copied from class: SqlValidatorImpl

Validates a namespace.

Overrides:

validateNamespace in class SqlValidatorImpl

Parameters:

namespace - Namespace

targetRowType - Desired row type, must not be null, may be the data type 'unknown'.

validateModality

public boolean validateModality(SqlSelect select,
 SqlModality modality,
 boolean fail)

Description copied from interface: SqlValidator

Validates that a query is capable of producing a return of given modality (relational or streaming).

Specified by:

validateModality in interface SqlValidator

Overrides:

validateModality in class SqlValidatorImpl

Parameters:

select - Query

modality - Modality (streaming or relational)

fail - Whether to throw a user error if does not support required modality

Returns:

whether query supports the given modality

shouldAllowOverRelation

protected boolean shouldAllowOverRelation()

Overrides:

shouldAllowOverRelation in class SqlValidatorImpl