[
https://issues.apache.org/jira/browse/IGNITE-7537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kirill Shirokov updated IGNITE-7537:
------------------------------------
Description:
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
was:
The following options can be implemented for the CSV format:
* Line separator pattern
* Field separator pattern
* Set of quote characters
* Escape sequence start 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']
{noformat}
We may also want:
* Line comments handling
* Spaces trimming
* Empty lines skipping
> 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)
