[ https://issues.apache.org/jira/browse/PHOENIX-4634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas D'Silva updated PHOENIX-4634: ------------------------------------ Description: If we are looking up a parent table index of a child view , we need to resolve the view which will load the parent table indexes (instead of trying to resolve the parent table index directly). {code:java} org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table undefined. tableName=Schema.Schema.Index#Schma.View org.apache.phoenix.compile.FromCompiler$BaseColumnResolver.createTableRef(FromCompiler.java:577) at org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.<init>(FromCompiler.java:391) at org.apache.phoenix.compile.FromCompiler.getResolverForQuery(FromCompiler.java:228) at org.apache.phoenix.compile.FromCompiler.getResolverForQuery(FromCompiler.java:206) at org.apache.phoenix.optimize.QueryOptimizer.addPlan(QueryOptimizer.java:226) at org.apache.phoenix.optimize.QueryOptimizer.getApplicablePlans(QueryOptimizer.java:146) at org.apache.phoenix.optimize.QueryOptimizer.getApplicablePlans(QueryOptimizer.java:103) at org.apache.phoenix.compile.DeleteCompiler.compile(DeleteCompiler.java:501) at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableDeleteStatement.compilePlan(PhoenixStatement.java:770) at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableDeleteStatement.compilePlan(PhoenixStatement.java:758) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:386) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:376) {code} was:If we are looking up a parent table index of a child view , we need to resolve the view which will load the parent table indexes (instead of trying to resolve the parent table index directly). > Looking up a parent index table of a tenant child view fails in > BaseColumnResolver createTableRef() > --------------------------------------------------------------------------------------------------- > > Key: PHOENIX-4634 > URL: https://issues.apache.org/jira/browse/PHOENIX-4634 > Project: Phoenix > Issue Type: Bug > Reporter: Thomas D'Silva > Priority: Major > > If we are looking up a parent table index of a child view , we need to > resolve the view which will load the parent table indexes (instead of trying > to resolve the parent table index directly). > > {code:java} > org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table > undefined. tableName=Schema.Schema.Index#Schma.View > org.apache.phoenix.compile.FromCompiler$BaseColumnResolver.createTableRef(FromCompiler.java:577) > at > org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.<init>(FromCompiler.java:391) > at > org.apache.phoenix.compile.FromCompiler.getResolverForQuery(FromCompiler.java:228) > at > org.apache.phoenix.compile.FromCompiler.getResolverForQuery(FromCompiler.java:206) > at org.apache.phoenix.optimize.QueryOptimizer.addPlan(QueryOptimizer.java:226) > at > org.apache.phoenix.optimize.QueryOptimizer.getApplicablePlans(QueryOptimizer.java:146) > at > org.apache.phoenix.optimize.QueryOptimizer.getApplicablePlans(QueryOptimizer.java:103) > at org.apache.phoenix.compile.DeleteCompiler.compile(DeleteCompiler.java:501) > at > org.apache.phoenix.jdbc.PhoenixStatement$ExecutableDeleteStatement.compilePlan(PhoenixStatement.java:770) > at > org.apache.phoenix.jdbc.PhoenixStatement$ExecutableDeleteStatement.compilePlan(PhoenixStatement.java:758) > at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:386) > at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:376) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)