phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ankit Singhal (Jira)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-5506) Psql load fails with lower table name
Date Thu, 03 Oct 2019 20:15:46 GMT
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)

Mime
View raw message