[jira] [Updated] (AMBARI-17421) Hive view : Upload Table feature should support various column and row delimiters

["Nitiraj Singh Rathore (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/AMBARI-17421?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Nitiraj Singh Rathore updated AMBARI-17421:
-------------------------------------------
    Attachment: AMBARI-17421_branch-2.4.patch

patch file AMBARI-17421_branch-2.4.patch uploaded with following changes

1. when "File type" is selected there will be a settings button which can be clicked to open following CSV specific configurations
Column delimiter: select from dropdown : printable and non printable ascii characters supported.
Escape Character: select from dropdown : printable and non printable ascii characters supported.
Quote Character: select from dropdown : printable and non printable ascii characters supported.
Is first row header ?: checkbox to specify if the first row of CSV is header
2. when "Stored As" is TEXTFILE the setting button next to it will be enabled for further settings
Fields Terminated By: the field terminator for hive table
Escape By: the escape character for hive table.
3. When "Stored As" is not TEXTFILE a field called "Contains endlines?" will be visible.
User has to check this field if the they field values contains endline (\n) characters. If this is checked the temporary table is created with Hex encoding of fields with datatype STRING, VARCHAR and CHAR to preserve endline characters properly. If user does not select this and fields contain endline characters then behaviour of upload is unexpected. Endline characters are not supported in TEXTFILE hive storage type.


> Hive view : Upload Table feature should support various column and row delimiters
> ---------------------------------------------------------------------------------
>
>                 Key: AMBARI-17421
>                 URL: https://issues.apache.org/jira/browse/AMBARI-17421
>             Project: Ambari
>          Issue Type: Bug
>          Components: ambari-views
>    Affects Versions: 2.2.2
>            Reporter: Nitiraj Singh Rathore
>            Assignee: Nitiraj Singh Rathore
>             Fix For: 2.4.0
>
>         Attachments: AMBARI-17421_branch-2.4.patch
>
>
> Currently Uploaded table can have only one CSV format which supports field delimiter as comma and row delimiter as endline.
> The view should take this as input from User and/or support other standards.
> Also column values should support endline character etc as input.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)