Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9196

Set record separator and ignore lines in CSV CONNECT engine

    XMLWordPrintable

Details

    Description

      LOAD DATA INFILE allows the user to change field and record separators and to ignore header lines. This allows reading files that CONNECT cannot read.

      For example, this variation on CSV can be read with

      load data infile ...
      fields terminated by 0x01 
      lines terminated by 0x020A 
      ignore 34 lines

      Please add this flexibility also to CONNECT CSV to expand its applicability.

      (Note: the record separator in this example is 2 bytes long.)

      Attachments

        Activity

          People

            Unassigned Unassigned
            thefsb Tom
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.