phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Karthik Palanisamy (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-5319) Document: A note on lower case table/schema name for Bulkload
Date Thu, 06 Jun 2019 22:15:00 GMT
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)

Mime
View raw message