Re: How to bulk load a csv file into a phoenix table created in lowercase

2020-05-14 Thread Ankit Singhal
Can you please try using CSVBulkLoad (as a workaround, we have it recently fixed) and raise a bug for the Psql not handling table-name case sensitivity. https://issues.apache.org/jira/browse/PHOENIX-3541 https://issues.apache.org/jira/browse/PHOENIX-5319 Regards, Ankit Singhal On Thu, May 14,

Re: How to bulk load a csv file into a phoenix table created in lowercase

2020-05-14 Thread Mich Talebzadeh
Well. This was happening at work I think the question is not the shell but the way Phoenix interpret the mix case. This works through once you are inside phoenix sql shell. However, the way psql interprets it is not working. You can easily replicate it by creating the csv file and the mixed

Re: How to bulk load a csv file into a phoenix table created in lowercase

2020-05-14 Thread Josh Elser
Quoting can be really annoying. Remember that when you are executing commands, you have to deal with what your shell will do to quoting. You say that escaping the slashes doesn't work? e.g. `pqsl -t MICHTEST.\"StagingNotificationPreferencesRT\" ...` What else did you try? Have you checked