Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-2065

Throw TableNotFoundException when select all columns of one column family from the table with schema

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.4.0
    • Fix Version/s: 4.5.0, 4.4.1
    • Labels:
      None

      Description

      1、create table with schema, like "create table s.t (k integer not null primary key, f1.v1 varchar, f2.v2 varchar);"
      2、select table like "select f1.* from s.t;"

      It goes wrong, throws TableNotFoundException:

      0: jdbc:phoenix:160.149.0.117> select a.* from dept.saler;
      Error: ERROR 1012 (42M03): Table undefined. tableName=SALER (state=42M03,code=1012)
      org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table undefined. tableName=SALER
      at org.apache.phoenix.compile.FromCompiler$MultiTableColumnResolver.resolveTable(FromCompiler.java:690)
      at org.apache.phoenix.compile.FromCompiler$MultiTableColumnResolver.resolveColumnFamily(FromCompiler.java:713)
      at org.apache.phoenix.compile.FromCompiler$MultiTableColumnResolver.resolveColumn(FromCompiler.java:745)
      at org.apache.phoenix.compile.FromCompiler$ProjectedTableColumnResolver.resolveColumn(FromCompiler.java:796)
      at org.apache.phoenix.compile.ProjectionCompiler.projectTableColumnFamily(ProjectionCompiler.java:266)
      at org.apache.phoenix.compile.ProjectionCompiler.compile(ProjectionCompiler.java:393)
      at org.apache.phoenix.compile.QueryCompiler.compileSingleFlatQuery(QueryCompiler.java:537)
      at org.apache.phoenix.compile.QueryCompiler.compileSingleQuery(QueryCompiler.java:488)
      at org.apache.phoenix.compile.QueryCompiler.compileSelect(QueryCompiler.java:200)
      at org.apache.phoenix.compile.QueryCompiler.compile(QueryCompiler.java:157)
      at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:364)
      at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:338)
      at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:246)
      at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:241)
      at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
      at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:240)
      at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1250)
      at sqlline.Commands.execute(Commands.java:822)
      at sqlline.Commands.sql(Commands.java:732)
      at sqlline.SqlLine.dispatch(SqlLine.java:808)

        Attachments

        1. PHOENIX-2065-for-master.patch
          3 kB
          Jun Ng
        2. PHOENIX-2065-for-4.4-HBase-1.0.patch
          3 kB
          Jun Ng
        3. PHOENIX-2065-2.patch
          3 kB
          Jun Ng
        4. PHOENIX-2065-1.patch
          3 kB
          Jun Ng
        5. PHOENIX-2065.patch
          0.8 kB
          Jun Ng

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              Jun Ng Jun Ng
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: