[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 ] YuJue Li reassigned IGNITE-7537: Assignee: Anton Kurbanov > 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: Anton Kurbanov >Priority: Major > Time Spent: 20m > Remaining Estimate: 0h > > 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 (v8.3.4#803005)
[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)
[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 ] 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)
[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 ] 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)
[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 ] Kirill Shirokov reassigned IGNITE-7537: --- Assignee: 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: 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)