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

SQL COPY command: implement CSV header row parsing

    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

      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:

      COPY
          ...
          [(MATCH | SKIP) HEADER]
      

      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.

        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: