You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by Pariksheet Barapatre <pb...@gmail.com> on 2015/02/12 12:10:25 UTC

Phoenix 4.2 - TableNotFound error

Hi,

Getting weird error -

We are trying to run below query, through JDBC

SELECT * FROM ABC.TABLE_2 ;
ERROR -
org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table
undefined. tableName=ABC.TABLE_2
    at
org.apache.phoenix.compile.FromCompiler$BaseColumnResolver.createTableRef(FromCompiler.java:303)
    at
org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.<init>(FromCompiler.java:215)
    at
org.apache.phoenix.compile.FromCompiler.getResolverForQuery(FromCompiler.java:159)
    at
org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:304)
    at
org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:294)
    at
org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:215)
    at
org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:211)
    at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
    at
org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:210)
    at
org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:1013)


Table is there and I can query it through sqlline .

Same program was running fine with phoenix 4.1.

Any pointers please.

-- 
Cheers,
Pari