Ankit Singhal created PHOENIX-5506: -------------------------------------- Summary: Psql load fails with lower table name Key: PHOENIX-5506 URL: https://issues.apache.org/jira/browse/PHOENIX-5506 Project: Phoenix Issue Type: Bug Reporter: Ankit Singhal Assignee: Ankit Singhal
sqlline> CREATE TABLE "table_zyx" (EMPID INTEGER PRIMARY KEY, ENAME VARCHAR(30)); psql.py -t table_zyx localhost:/hbase-unsecure Temp.csv {code} 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) {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)