Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-5139

cpimport mode 3 -p , -f , -l flags not working

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 5.6.2
    • Icebox
    • None
    • None

    Description

      Works

      cpimport -m1 -j1337 -p $PWD -f $PWD  -l small.tbl
      

      Does not work - clients expect this to work

      cpimport -m3 -j1337 -p $PWD -f $PWD  -l small.tbl
      

      Work around with mode 3 is to move the file to the actual file name used to create the colxml job file which is /tmp/dailyTest/parthourlyAgg.tbl in this case

      mv small.tbl /tmp/dailyTest/parthourlyAgg.tbl
      cpimport -m3 -j1337 
      

      Attaching col.xml, ddl and sample csv
      colxml was created with the following then heavily editted to force default values for over 100 dims
      colxml mariadb_actixone_owner -t LTE_ALL_MESH3_DAILY -j1337 -d '\t' -l /tmp/dailyTest/parthourlyAgg.tbl

      Reproduction setup

      mariadb -e "create database mariadb_actixone_owner"
      mariadb mariadb_actixone_owner < LTE_ALL_MESH3_DAILY.ddl
      mv small.tbl /tmp/small.tbl
      mv colxmlJob1337.xml /var/log/mariadb/columnstore/data/bulk/job/Job_1337.xml
      cp /var/log/mariadb/columnstore/data/bulk/job/Job_1337.xml Job_1337.xml
      cpimport -m3 -j1337 -p $PWD -f $PWD  -l small.tbl
      cpimport -m1 -j1337 -p $PWD -f $PWD  -l small.tbl
      

      Attachments

        1. colxmlJob1337.xml
          22 kB
          Allen Herrera
        2. LTE_ALL_MESH3_DAILY.ddl
          20 kB
          Allen Herrera
        3. small.tbl
          11 kB
          Allen Herrera

        Activity

          People

            Unassigned Unassigned
            allen.herrera Allen Herrera
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.