You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Chinmay Kulkarni (Jira)" <ji...@apache.org> on 2019/12/21 00:55:06 UTC
[jira] [Closed] (PHOENIX-5319) Document: A note on lower case
table/schema name for Bulkload
[ https://issues.apache.org/jira/browse/PHOENIX-5319?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chinmay Kulkarni closed PHOENIX-5319.
-------------------------------------
Bulk closing Jiras for the 4.15.0 release.
> 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
> Priority: Minor
> Fix For: 4.15.0, 5.1.0
>
> Attachments: PHOENIX-5319.svn.master.v1.patch
>
>
> 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
(v8.3.4#803005)