You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Taras Ledkov (JIRA)" <ji...@apache.org> on 2018/04/02 15:24:00 UTC
[jira] [Assigned] (IGNITE-7537) SQL COPY command: implement CSV
format options
[ https://issues.apache.org/jira/browse/IGNITE-7537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Taras Ledkov reassigned IGNITE-7537:
------------------------------------
Assignee: Taras Ledkov
> SQL COPY command: implement CSV format options
> ----------------------------------------------
>
> Key: IGNITE-7537
> URL: https://issues.apache.org/jira/browse/IGNITE-7537
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Kirill Shirokov
> Assignee: Taras Ledkov
> Priority: Major
>
> The following options can be implemented for the CSV format:
> * Line separator pattern
> * Field separator pattern
> * Set of quote characters
> * Escape sequence start character
> * Line comment character
> Escape sequences support is important for this feature. There is a draft code for handling escape sequences in a branch called ignite-7372 (see IGNITE-7372 for details).
> Syntax example:
> {noformat}
> COPY
> ...
> FORMAT CSV
> [FIELDSEP='column-separators-regexp']
> [LINESEP='row-separators-regexp']
> [QUOTE='quote-chars']
> [ESCAPE='escape-char']
> [COMMENT='line-comment-char']
> {noformat}
> We may also want:
> * Line comments handling
> * Spaces trimming
> * Empty lines skipping
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)