[jira] [Closed] (IGNITE-7546) SQL COPY command: implement CSV header row parsing

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

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

Vladimir Ozerov closed IGNITE-7546.
-----------------------------------

> SQL COPY command: implement CSV header row parsing
> --------------------------------------------------
>
>                 Key: IGNITE-7546
>                 URL: https://issues.apache.org/jira/browse/IGNITE-7546
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql
>    Affects Versions: 2.4
>            Reporter: Kirill Shirokov
>            Priority: Major
>
> Implement optional reading of CSV format header row and matching it to column numbers.
> So, there are the following options:
> * just skip the header row (or arbitrary number of rows)
> * match the fields in the header row to the query entity columns and map them to the column list
> A possible syntax for this option might look like this:
> {noformat}
> COPY
>     ...
>     [(MATCH | SKIP) HEADER]
> {noformat}
> When implementing this feature please keep in mind that we might have an option for skipping user-specified number of header lines / left columns and importing only user-specified number of lines and columns.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)