[PHOENIX-4634] Looking up a parent index table of a tenant child view fails in BaseColumnResolver createTableRef()

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.14.0
• Assignee: Thomas D'Silva
• Reporter: Thomas D'Silva
• Created: 01/Mar/18 00:10
• Updated: 26/Jul/18 01:15
• Resolved: 13/Mar/18 18:21

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). 

 

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)

Issue Links

• is related to: PHOENIX-4468 Looking up a parent index table of a child view from a different client fails.