[jira] [Created] (IGNITE-7548) SQL COPY: handle CSV lines with less values than required correctly

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (IGNITE-7548) SQL COPY: handle CSV lines with less values than required correctly

Anton Vinogradov (Jira)
Kirill Shirokov created IGNITE-7548:
---------------------------------------

             Summary: SQL COPY: handle CSV lines with less values than required correctly
                 Key: IGNITE-7548
                 URL: https://issues.apache.org/jira/browse/IGNITE-7548
             Project: Ignite
          Issue Type: Improvement
          Components: sql
    Affects Versions: 2.4
            Reporter: Kirill Shirokov


Currently some of lines in CSV files can have less values than declared in the command or CSV header.

We need to think how do we handle such rows:
* append empty values ("") for the missing trailing columns
* append null values
* reject such lines and report an error

We might need a COPY command parameter to configure the desired behaviour.



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