You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Kirill Shirokov (JIRA)" <ji...@apache.org> on 2018/01/26 10:01:00 UTC
[jira] [Updated] (IGNITE-7546) SQL COPY command: implement CSV
header row parsing
[ https://issues.apache.org/jira/browse/IGNITE-7546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kirill Shirokov updated IGNITE-7546:
------------------------------------
Affects Version/s: 2.4
Description:
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.
Component/s: sql
Summary: SQL COPY command: implement CSV header row parsing (was: SQL COPY co)
> 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)