phoenix-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hadoop QA (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-5319) Document: A note on lower case table/schema name for Bulkload
Date Thu, 06 Jun 2019 22:36:00 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-5319?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16858130#comment-16858130
] 

Hadoop QA commented on PHOENIX-5319:
------------------------------------

{color:red}-1 overall{color}.  Here are the results of testing the latest attachment 
  http://issues.apache.org/jira/secure/attachment/12971118/PHOENIX-5319.svn.master.v1.patch
  against master branch at commit 5303d292a4c875f8ee8f484094c897f8e7595e63.
  ATTACHMENT ID: 12971118

    {color:green}+1 @author{color}.  The patch does not contain any @author tags.

    {color:green}+0 tests included{color}.  The patch appears to be a documentation, build,
                        or dev patch that doesn't require tests.

    {color:red}-1 patch{color}.  The patch command could not apply the patch.

Console output: https://builds.apache.org/job/PreCommit-PHOENIX-Build/2634//console

This message is automatically generated.

> 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
>         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
(v7.6.3#76005)

Mime
View raw message