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

Connect CSV file sep_char option

    XMLWordPrintable

    Details

      Description

      Hi,

      I have a file with separators "(#]" I need to load it ,using CONNECT engine:

      name.csv

      Name(#]birth(#]children
      "Archibald"(#]17/05/01(#]3
      "Nabucho"(#]12/08/03(#]2
      

      create table people (
        name char(12) not null,
        birth date not null date_format='DD/MM/YY',
        children smallint(2) not null)
      engine=CONNECT table_type=CSV file_name='C:\\MariaDB\\data\\name.csv'
      header=1 sep_char='(#]' quoted=1;
      

      It gives :

      Erreur SQL (1296) : Got error 122 'Field 2 too long for birth line 1 of C:\MariaDB\data\name.csv' from CONNECT */
      

      Is there any way to load this kind of file?

      Thanks for help.

      Regards

        Attachments

          Activity

            People

            Assignee:
            bertrandop Olivier Bertrand
            Reporter:
            Mariabti Btissam
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration