[
https://issues.apache.org/jira/browse/PHOENIX-6365?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17279716#comment-17279716
]
Istvan Toth commented on PHOENIX-6365:
--------------------------------------
{noformat}
Error: ERROR 501 (42000): Table name exists in more than one table schema and
is used without being qualified. (state=42000,code=501)
org.apache.phoenix.schema.AmbiguousTableException: ERROR 501 (42000): Table
name exists in more than one table schema and is used without being qualified.
at
org.apache.phoenix.compile.FromCompiler$MultiTableColumnResolver.resolveTable(FromCompiler.java:1013)
at
org.apache.phoenix.compile.FromCompiler$ProjectedTableColumnResolver.resolveColumn(FromCompiler.java:1174)
at
org.apache.phoenix.compile.ExpressionCompiler.resolveColumn(ExpressionCompiler.java:368)
at
org.apache.phoenix.compile.ProjectionCompiler$SelectClauseVisitor.resolveColumn(ProjectionCompiler.java:650)
at
org.apache.phoenix.compile.ExpressionCompiler.visit(ExpressionCompiler.java:404)
at
org.apache.phoenix.compile.ProjectionCompiler$SelectClauseVisitor.visit(ProjectionCompiler.java:657)
at
org.apache.phoenix.compile.ProjectionCompiler$SelectClauseVisitor.visit(ProjectionCompiler.java:614)
at
org.apache.phoenix.parse.ColumnParseNode.accept(ColumnParseNode.java:56)
at
org.apache.phoenix.compile.ProjectionCompiler.compile(ProjectionCompiler.java:431)
at
org.apache.phoenix.compile.QueryCompiler.compileSingleFlatQuery(QueryCompiler.java:757)
at
org.apache.phoenix.compile.QueryCompiler.compileJoinQuery(QueryCompiler.java:473)
at
org.apache.phoenix.compile.QueryCompiler.compileJoinQuery(QueryCompiler.java:304)
at
org.apache.phoenix.compile.QueryCompiler.compileJoinQuery(QueryCompiler.java:439)
at
org.apache.phoenix.compile.QueryCompiler.compileJoinQuery(QueryCompiler.java:304)
at
org.apache.phoenix.compile.QueryCompiler.compileSelect(QueryCompiler.java:251)
at
org.apache.phoenix.compile.QueryCompiler.compile(QueryCompiler.java:178)
at
org.apache.phoenix.optimize.QueryOptimizer.getApplicablePlans(QueryOptimizer.java:199)
at
org.apache.phoenix.optimize.QueryOptimizer.optimize(QueryOptimizer.java:116)
at
org.apache.phoenix.optimize.QueryOptimizer.optimize(QueryOptimizer.java:102)
at
org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:313)
at
org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:295)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:294)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:287)
at
org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1930)
at sqlline.Commands.executeSingleQuery(Commands.java:1054)
at sqlline.Commands.execute(Commands.java:1003)
at sqlline.Commands.sql(Commands.java:967)
at sqlline.SqlLine.dispatch(SqlLine.java:734)
at sqlline.SqlLine.begin(SqlLine.java:541)
at sqlline.SqlLine.start(SqlLine.java:267)
at sqlline.SqlLine.main(SqlLine.java:206)
{noformat}
> Bogus AmbiguousTableException in query with aliases on local indexed tables
> ---------------------------------------------------------------------------
>
> Key: PHOENIX-6365
> URL: https://issues.apache.org/jira/browse/PHOENIX-6365
> Project: Phoenix
> Issue Type: Task
> Components: core
> Affects Versions: 5.1.0
> Reporter: Istvan Toth
> Priority: Major
>
> Certain queries with aliases on tbales with local indexes throw
> AmbiguousTableException
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
