[jira] [Assigned] (IGNITE-7537) SQL COPY command: implement CSV format options

["Vladimir Ozerov (JIRA)" <ji...@apache.org>]

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

Vladimir Ozerov reassigned IGNITE-7537:
---------------------------------------

    Assignee:     (was: Vladimir Ozerov)

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