ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vladimir Ozerov (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (IGNITE-7537) SQL COPY command: implement CSV format options
Date Thu, 14 Feb 2019 15:17:00 GMT

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

Vladimir Ozerov resolved IGNITE-7537.
-------------------------------------
    Resolution: Won't Fix

Not relevant at the moment.

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

Mime
View raw message