Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-7548

SQL COPY: handle CSV lines with less values than required correctly

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 2.4
    • Fix Version/s: None
    • Component/s: sql
    • Labels:
      None

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                kirill.shirokov Kirill Shirokov
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: