[
https://issues.apache.org/jira/browse/IGNITE-7537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vladimir Ozerov reassigned IGNITE-7537:
---------------------------------------
Assignee: Vladimir Ozerov (was: Kirill Shirokov)
> 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: Vladimir Ozerov
> 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)
