phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thamarai Selvi (JIRA)" <>
Subject [jira] [Created] (PHOENIX-1761) rg.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table undefined
Date Fri, 20 Mar 2015 09:49:40 GMT
Thamarai Selvi created PHOENIX-1761:

             Summary: rg.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03):
Table undefined
                 Key: PHOENIX-1761
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.2
            Reporter: Thamarai Selvi
            Priority: Critical

Hi James Taylor,

I am facing this issue repetately. Its not the case always getting this issue. Sometimes only
it is occuring. Not able to identify the root cause of this issue. We are using hbase 0.98
and phoenix-4.2.0. Following are the two scenarios where i have faced this issue,

1. Ran a simple aggregation query without any join in phoenix client directly.
2. Client throws table not found exception.
3. Ran command !tables in client.
4. None of the tables were shown in the client apart from SYSTEM tables.
5. Quit the client and reconnected again.
6. Ran the same command !tables in client.
7. Now i can able to see all the tables along with SYSTEM tables.
8. Ran the same query. The query executed successfully and gave the result.

1. Ran a simple aggregation query without any join from our application server through phoenix
jdbc server.
2. Application throws Phoenix table not found exception.
3. Re triggered the same process
4. The same query executed sucessfully by the same process and returned the result.

Exception Trace:
org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table undefined. 
        at org.apache.phoenix.compile.FromCompiler$BaseColumnResolver.createTableRef(
        at org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.<init>(
        at org.apache.phoenix.compile.FromCompiler.getResolverForQuery(
        at org.apache.phoenix.compile.QueryCompiler.compileSingleQuery(
        at org.apache.phoenix.compile.QueryCompiler.compile(
        at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(
        at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(
        at org.apache.phoenix.jdbc.PhoenixStatement$
        at org.apache.phoenix.jdbc.PhoenixStatement$
        at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(
        at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(

This message was sent by Atlassian JIRA

View raw message