[
https://issues.apache.org/jira/browse/PHOENIX-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16944478#comment-16944478
]
Josh Elser commented on PHOENIX-5506:
-------------------------------------
Do you need to clean up {{tempFile}} or does the Rule do that automatically?
Please change the {{e.printStackTrace()}} to a logger error call.
Otherwise, change looks good. I looked quickly into QA not running here. Seems
like since 3 days ago, we stopped having good runs. The reason the build didn't
even happen wasn't obvious (we tried to run mvn, but it just reported an exit
code of 1 and had no stdout). Making sure we don't introduce a regression would
be good if you can double check locally, if not get a QA run manually.
> 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: Smarak
> Assignee: Ankit Singhal
> Priority: Major
> Attachments: PHOENIX-5506.patch
>
>
> 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)
