Karthik Palanisamy created PHOENIX-5319:
-------------------------------------------
Summary: Document: A note on lower case table/schema name for
Bulkload
Key: PHOENIX-5319
URL: https://issues.apache.org/jira/browse/PHOENIX-5319
Project: Phoenix
Issue Type: Bug
Affects Versions: 5.0.0
Reporter: Karthik Palanisamy
Assignee: Karthik Palanisamy
The problem with bulk loading CSV/JSON data with lower case table name. This
will be fixed as part of
[PHOENIX-3541|https://issues.apache.org/jira/browse/PHOENIX-3541].
Created this separate doc Jira because Phoenix Website is maintained in svn.
NOTE:
{code}
Table names in Phoenix are case insensitive( generally uppercase). but
sometimes user may require to do mapping of existing HBase table with lowercase
name into Phoenix table, In this case, Double quotes around table name i.e
"tablename" can be used to preserve case sensitivity. The same was extended to
the bulkload options, but due to the way Apache Commons CLI library parse
command line options(Ref CLI-275), we need to pass the argument as
\"\"tablename\"\" instead of just "tablename" for CsvBulkLoadTool.
Example:
hadoop jar phoenix-<version>-client.jar
org.apache.phoenix.mapreduce.CsvBulkLoadTool --table \"\"t\"\" --input
/data/example.csv
{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
