Mich Talebzadeh created PHOENIX-5900:
----------------------------------------
Summary: Bulk load a csv file into a phoenix table created in
lowercase fails
Key: PHOENIX-5900
URL: https://issues.apache.org/jira/browse/PHOENIX-5900
Project: Phoenix
Issue Type: Bug
Reporter: Mich Talebzadeh
I have a phoenix table *created in lowercase* as follows:
CREATE TABLE "MICHTEST"."StagingNotificationPreferencesRT"
(
ROWKEY VARCHAR NOT NULL PRIMARY KEY
, "cf"."partyId" VARCHAR
, "cf"."childNotificationId" VARCHAR
, "cf"."brand" VARCHAR
, "cf"."accountReference" VARCHAR
, "cf"."expiredDate" VARCHAR
, "cf"."parentNotificationId" VARCHAR
...
This table creates OK. When I try to bulk load from a csv file at Linux bash
command line as follows
*psql -t MICHTEST."StagingNotificationPreferencesRT"
./StagingNotificationPreferences.csv -s*
20/05/11 21:35:07 ERROR util.CSVCommonsLoader: Error upserting record
[3c7953b3-0c69-42ee-9abf-fe7a77d29c87, 876543914, 1, LTB, , , 50, 76543210, ,
2017-13-18 18:29:23:345, 19, 1, , , , , , , 9876543210123456]
java.lang.RuntimeException: org.apache.phoenix.schema.TableNotFoundException:
ERROR 1012 (42M03): Table undefined.
tableName=MICHTEST.STAGINGNOTIFICATIONPREFERENCESRT
Note that the table name shown in error is uppercase! Now this works if I go
back and create table all in UPPERCASE!
This seems to be a Phoenix bug similar to below as I have been advised
https://issues.apache.org/jira/browse/PHOENIX-3541
https://issues.apache.org/jira/browse/PHOENIX-5319
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
