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

Psql load fails with lower table name

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.15.0, 5.1.0
    • Component/s: None
    • Labels:
      None

      Description

      sqlline> CREATE TABLE "table_zyx" (EMPID INTEGER PRIMARY KEY, ENAME VARCHAR(30));

      psql.py -t table_zyx localhost:/hbase-unsecure Temp.csv

      19/10/03 20:13:18 INFO util.UpsertExecutor: Upserting SQL data with UPSERT  INTO table_zyx ("EMPID", "0"."ENAME") VALUES (?, ?)
      19/10/03 20:13:18 DEBUG jdbc.PhoenixStatement: Reloading table TABLE_ZYX data from server
      19/10/03 20:13:18 DEBUG csv.CsvUpsertExecutor: Error on CSVRecord [1, a]
      org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table undefined. tableName=TABLE_ZYX
      	at org.apache.phoenix.compile.FromCompiler$BaseColumnResolver.createTableRef(FromCompiler.java:599)
      	at org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.<init>(FromCompiler.java:391)
      	at org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.<init>(FromCompiler.java:383)
      	at org.apache.phoenix.compile.FromCompiler.getResolverForMutation(FromCompiler.java:300)
      	at org.apache.phoenix.compile.UpsertCompiler.compile(UpsertCompiler.java:352)
      	at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:784)
      	at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:770)
      	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:401)
      	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:391)
      	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
      	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:390)
      	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:378)
      	at org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:173)
      	at org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:183)
      	at org.apache.phoenix.util.csv.CsvUpsertExecutor.execute(CsvUpsertExecutor.java:95)
      	at org.apache.phoenix.util.csv.CsvUpsertExecutor.execute(CsvUpsertExecutor.java:55)
      	at org.apache.phoenix.util.UpsertExecutor.execute(UpsertExecutor.java:133)
      	at org.apache.phoenix.util.CSVCommonsLoader.upsert(CSVCommonsLoader.java:217)
      	at org.apache.phoenix.util.CSVCommonsLoader.upsert(CSVCommonsLoader.java:182)
      	at org.apache.phoenix.util.PhoenixRuntime.main(PhoenixRuntime.java:307)
      

        Attachments

        1. PHOENIX-5506.patch
          4 kB
          Ankit Singhal
        2. PHOENIX-5506_v1.patch
          4 kB
          Ankit Singhal

          Activity

            People

            • Assignee:
              ankit@apache.org Ankit Singhal
              Reporter:
              Das Smarak
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: