Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-5201

sph-partition does not support BLOB fields

    Details

    • Type: Bug
    • Status: To Do
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: partition
    • Labels:
      None
    • Templates:
    • Story Points:
      15
    • Team:
      Data Access and Database

      Description

      Next command fails with BLOB field in input file:

      dev@clrinfoport09:~/src/qserv_testdata/datasets/case01/data$ sph-partition --out.dir /home/dev/qserv-run/git/tmp/qserv_data_loader/Object --part.prefix chunk --config-file /home/dev/src/qserv_testdata/datasets/case01/data/common.cfg --config-file /home/dev/src/qserv_testdata/datasets/case01/data/Object.cfg --in Object.tsv
      CSV record contains an embedded line terminator, a trailing escape character, or a quoted field without a trailing quote character.
      

      Note that the command works in input file is reduced to its first line.

      Note that mysql import works fine:

      MariaDB [qservTest_case01_mysql]> LOAD DATA INFILE "/tmp/Object.tsv" INTO TABLE Object FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';
      

        Attachments

          Container Issues

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  jammes Fabrice Jammes
                  Watchers:
                  Fabrice Jammes, Jacek Becla, Serge Monkewitz
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:

                    Summary Panel