[
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)
