title: phoenix error: hbase table undefined, even though it is present
body: <p>I am trying to access my hbase running on my local machine with zookeeper at localhost:2181. I installed phoenix-3.3.1-bin and trying to access an already existing hbase tabe, but could not. So, simply to test, i created a table using phoenix commandline and see it when i run !tables command. but when i run selet command, it shows error.</p>
  
  <p>This is what I am doing and i am using mac, hbase-0.94.26. Same thing is happening with squirrel-sql client also.</p>
  
  <pre><code>0: jdbc:phoenix:localhost&gt; CREATE TABLE stats.prod_metrics ( host char(50) not null, created_date date not null,
  . . . . . . . . . . . . .&gt;     txn_count bigint CONSTRAINT pk PRIMARY KEY (host, created_date) );
  No rows affected (1.82 seconds)
  
  0: jdbc:phoenix:localhost&gt; !tables
  +------------------------------------------+------------------------------------------+------------------------------------------+---------------------------+
  |                TABLE_CAT                 |               TABLE_SCHEM                |                TABLE_NAME                |                TABLE_TYPE |
  +------------------------------------------+------------------------------------------+------------------------------------------+---------------------------+
  |                                          | SYSTEM                                   | CATALOG                                  | SYSTEM TABLE              |
  |                                          | SYSTEM                                   | SEQUENCE                                 | SYSTEM TABLE              |
  |                                          | SYSTEM                                   | STATS                                    | SYSTEM TABLE              |
  |                                          | STATS                                    | PROD_METRICS                             | TABLE                     |
  +------------------------------------------+------------------------------------------+------------------------------------------+---------------------------+
  
  0: jdbc:phoenix:localhost&gt; select * from PROD_METRICS;
      Error: ERROR 1012 (42M03): Table undefined. tableName=PROD_METRICS (state=42M03,code=1012)
      org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table undefined. tableName=PROD_METRICS
          at org.apache.phoenix.compile.FromCompiler$BaseColumnResolver.createTableRef(FromCompiler.java:336)
          at org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.&lt;init&gt;(FromCompiler.java:236)
          at org.apache.phoenix.compile.FromCompiler.getResolverForQuery(FromCompiler.java:159)
          at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:318)
          at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:308)
          at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:225)
          at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:221)
          at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:54)
          at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:221)
          at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1059)
          at sqlline.Commands.execute(Commands.java:822)
          at sqlline.Commands.sql(Commands.java:732)
          at sqlline.SqlLine.dispatch(SqlLine.java:808)
          at sqlline.SqlLine.begin(SqlLine.java:681)
          at sqlline.SqlLine.start(SqlLine.java:398)
          at sqlline.SqlLine.main(SqlLine.java:292)
  </code></pre>