[
https://issues.apache.org/jira/browse/PHOENIX-3064?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15372690#comment-15372690
]
Lars Hofhansl commented on PHOENIX-3064:
----------------------------------------
This is the exception for a missing column. (just putting it here for my own
reference)
{code}
Error: ERROR 504 (42703): Undefined column. columnName=Y (state=42703,code=504)
org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703): Undefined
column. columnName=Y
at org.apache.phoenix.schema.PTableImpl.getColumn(PTableImpl.java:694)
at
org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.resolveColumn(FromCompiler.java:451)
at
org.apache.phoenix.compile.TupleProjectionCompiler$ColumnRefVisitor.visit(TupleProjectionCompiler.java:203)
at
org.apache.phoenix.compile.TupleProjectionCompiler$ColumnRefVisitor.visit(TupleProjectionCompiler.java:189)
at
org.apache.phoenix.parse.ColumnParseNode.accept(ColumnParseNode.java:56)
at
org.apache.phoenix.compile.TupleProjectionCompiler.createProjectedTable(TupleProjectionCompiler.java:107)
at
org.apache.phoenix.compile.QueryCompiler.compileSingleFlatQuery(QueryCompiler.java:528)
at
org.apache.phoenix.compile.QueryCompiler.compileSingleQuery(QueryCompiler.java:507)
at
org.apache.phoenix.compile.QueryCompiler.compileSelect(QueryCompiler.java:202)
at
org.apache.phoenix.compile.QueryCompiler.compile(QueryCompiler.java:157)
at
org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:401)
at
org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:375)
at
org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:268)
at
org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:263)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:262)
at
org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1392)
at sqlline.Commands.execute(Commands.java:822)
at sqlline.Commands.sql(Commands.java:732)
at sqlline.SqlLine.dispatch(SqlLine.java:807)
at sqlline.SqlLine.begin(SqlLine.java:681)
at sqlline.SqlLine.start(SqlLine.java:398)
{code}
> Reduce client time spent in createTableRef and ARRQ for point queries
> ----------------------------------------------------------------------
>
> Key: PHOENIX-3064
> URL: https://issues.apache.org/jira/browse/PHOENIX-3064
> Project: Phoenix
> Issue Type: Bug
> Reporter: Lars Hofhansl
> Attachments: PhoenixGetTableAndARRQ.png
>
>
> Did some profiling for point queries (I actually wanted to test the HBase
> server side).
> I found that a _lot_ of client time is spent in
> FromCompiler.getResolverForQuery (in createTableRef) and also in
> AbstractRoundRobinQueue.offer.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
