com.facebook.presto.sql.analyzer

Class MaterializedViewColumnMappingExtractor

java.lang.Object

com.facebook.presto.sql.tree.AstVisitor<R,C>

com.facebook.presto.sql.tree.DefaultTraversalVisitor<Void,MaterializedViewPlanValidator.MaterializedViewPlanValidatorContext>

com.facebook.presto.sql.analyzer.MaterializedViewPlanValidator

com.facebook.presto.sql.analyzer.MaterializedViewColumnMappingExtractor

public class MaterializedViewColumnMappingExtractor
extends MaterializedViewPlanValidator

Nested Class Summary

Nested classes/interfaces inherited from class com.facebook.presto.sql.analyzer.MaterializedViewPlanValidator

MaterializedViewPlanValidator.MaterializedViewPlanValidatorContext

Constructor Summary

Constructors

Constructor and Description
MaterializedViewColumnMappingExtractor(Analysis analysis, Session session)

Method Summary

Modifier and Type	Method and Description
List<SchemaTableName>	getBaseTablesOnOuterJoinSide()
Map<String,Map<SchemaTableName,String>>	getMaterializedViewColumnMappings() Compute the 1-to-N column mapping from a materialized view to its base tables.
Map<String,Map<SchemaTableName,String>>	getMaterializedViewDirectColumnMappings() Similar to getMaterializedViewColumnMappings, but only includes direct column mappings.
protected Void	visitComparisonExpression(ComparisonExpression node, MaterializedViewPlanValidator.MaterializedViewPlanValidatorContext context)
protected Void	visitSetOperation(SetOperation node, MaterializedViewPlanValidator.MaterializedViewPlanValidatorContext context)
protected Void	visitTable(Table node, MaterializedViewPlanValidator.MaterializedViewPlanValidatorContext context)

Methods inherited from class com.facebook.presto.sql.analyzer.MaterializedViewPlanValidator

validate, visitJoin, visitLogicalBinaryExpression, visitOrderBy, visitQuery, visitQuerySpecification, visitSubqueryExpression

Methods inherited from class com.facebook.presto.sql.tree.DefaultTraversalVisitor

visitAddColumn, visitAliasedRelation, visitAnalyze, visitArithmeticBinary, visitArithmeticUnary, visitArrayConstructor, visitAtTimeZone, visitBetweenPredicate, visitBindExpression, visitCast, visitCoalesceExpression, visitCreateMaterializedView, visitCreateTable, visitCreateTableAsSelect, visitCreateView, visitCube, visitDelete, visitDereferenceExpression, visitExists, visitExplain, visitExtract, visitFrameBound, visitFunctionCall, visitGroupBy, visitGroupingOperation, visitGroupingSets, visitIfExpression, visitInListExpression, visitInPredicate, visitInsert, visitIsNotNullPredicate, visitIsNullPredicate, visitLateral, visitLikePredicate, visitNotExpression, visitNullIfExpression, visitProperty, visitQuantifiedComparisonExpression, visitRefreshMaterializedView, visitRollup, visitRow, visitSampledRelation, visitSearchedCaseExpression, visitSelect, visitSetSession, visitSimpleCaseExpression, visitSimpleGroupBy, visitSingleColumn, visitSortItem, visitStartTransaction, visitSubscriptExpression, visitTableSubquery, visitTryExpression, visitUnnest, visitValues, visitWhenClause, visitWindow, visitWindowFrame, visitWith, visitWithQuery

Methods inherited from class com.facebook.presto.sql.tree.AstVisitor

process, process, visitAllColumns, visitAlterFunction, visitBinaryLiteral, visitBooleanLiteral, visitCall, visitCallArgument, visitCharLiteral, visitColumnDefinition, visitCommit, visitCreateFunction, visitCreateRole, visitCreateSchema, visitCreateType, visitCurrentTime, visitCurrentUser, visitDeallocate, visitDecimalLiteral, visitDescribeInput, visitDescribeOutput, visitDoubleLiteral, visitDropColumn, visitDropFunction, visitDropFunction, visitDropMaterializedView, visitDropRole, visitDropSchema, visitDropTable, visitDropView, visitEnumLiteral, visitExcept, visitExecute, visitExplainOption, visitExpression, visitExternalBodyReference, visitFieldReference, visitGenericLiteral, visitGrant, visitGrantRoles, visitGroupingElement, visitIdentifier, visitIntersect, visitIntervalLiteral, visitIsolationLevel, visitLambdaArgumentDeclaration, visitLambdaExpression, visitLikeClause, visitLiteral, visitLongLiteral, visitNode, visitNullLiteral, visitOffset, visitParameter, visitPrepare, visitQueryBody, visitRelation, visitRenameColumn, visitRenameSchema, visitRenameTable, visitResetSession, visitReturn, visitRevoke, visitRevokeRoles, visitRollback, visitRoutineBody, visitSelectItem, visitSetRole, visitShowCatalogs, visitShowColumns, visitShowCreate, visitShowCreateFunction, visitShowFunctions, visitShowGrants, visitShowRoleGrants, visitShowRoles, visitShowSchemas, visitShowSession, visitShowStats, visitShowTables, visitStatement, visitStringLiteral, visitSymbolReference, visitTableElement, visitTimeLiteral, visitTimestampLiteral, visitTransactionAccessMode, visitTransactionMode, visitTruncateTable, visitUnion, visitUse

Methods inherited from class java.lang.Object

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

Constructor Detail

MaterializedViewColumnMappingExtractor

public MaterializedViewColumnMappingExtractor(Analysis analysis,
                                              Session session)

Method Detail

getMaterializedViewColumnMappings

public Map<String,Map<SchemaTableName,String>> getMaterializedViewColumnMappings()

Compute the 1-to-N column mapping from a materialized view to its base tables.

From analysis, we could derive only one base table column that one materialized view column maps to. In case of 1 materialized view defined on N base tables via join, union, etc, this method helps compute all the N base table columns that one materialized view column maps to.

For example, given SELECT column_a AS column_x FROM table_a JOIN table_b ON (table_a.column_a = table_b.column_b), the 1-to-1 column mapping from analysis is column_x -> table_a.column_a. Mapped base table columns are [table_a.column_a, table_b.column_b]. Then it will return a 1-to-N column mapping column_x -> {table_a -> column_a, table_b -> column_b}.

getMaterializedViewDirectColumnMappings

public Map<String,Map<SchemaTableName,String>> getMaterializedViewDirectColumnMappings()

Similar to getMaterializedViewColumnMappings, but only includes direct column mappings. It excludes columns mappings derived from outer join EQ clauses.

For example, given SELECT t1_a as t1.a, t2_a as t2.a FROM t1 LEFT JOIN t2 ON t1.a = t2.a Column mappings are: t1_a -> {t1 -> t1.a} t2_a -> {t2 -> t2.a}

getBaseTablesOnOuterJoinSide

public List<SchemaTableName> getBaseTablesOnOuterJoinSide()

visitSetOperation

protected Void visitSetOperation(SetOperation node,
                                 MaterializedViewPlanValidator.MaterializedViewPlanValidatorContext context)

Overrides:

visitSetOperation in class DefaultTraversalVisitor<Void,MaterializedViewPlanValidator.MaterializedViewPlanValidatorContext>

visitTable

protected Void visitTable(Table node,
                          MaterializedViewPlanValidator.MaterializedViewPlanValidatorContext context)

Overrides:

visitTable in class MaterializedViewPlanValidator

visitComparisonExpression

protected Void visitComparisonExpression(ComparisonExpression node,
                                         MaterializedViewPlanValidator.MaterializedViewPlanValidatorContext context)

Overrides:

visitComparisonExpression in class MaterializedViewPlanValidator