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

Remote mcsimport tool is trowing Warning message : Column size of input file is higher than the column size of the target table.Remaining csv columns won't be injected.

    XMLWordPrintable

    Details

      Description

      Remote mcsimport tool is trowing Warning message : Column size of input file is higher than the column size of the target table.Remaining csv columns won't be injected.

      A.
      file loaded with the local cpimport tool

       ./cpimport  tpcds_1000 catalog_page  /home/qa-user/MDC1/mariadb-columnstore-tpcds/mm1/QA/tpcds_1000/catalog_page.tbl
      2018-10-15 17:42:28 (30383) INFO : Running distributed import (mode 1) on all PMs...
      2018-10-15 17:42:31 (30383) INFO : For table tpcds_1000.catalog_page: 30000 rows processed and 30000 rows inserted.
      2018-10-15 17:42:31 (30383) INFO : Bulk load completed, total run time : 2.76213 seconds
      
      

      B.the same file loaded with the remote mcsimport tool

      ./mcsimport tpcds_1000 catalog_page  dd/tpcds_1000/catalog_page.tbl -c Columnstore.xml -d "|"
      Warning: Column size of input file is higher than the column size of the target table.
      Remaining csv columns won't be injected.
      Execution time: 1.62413s
      Rows inserted: 30000
      Truncation count: 0
      Saturated count: 0
      Invalid count: 0
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jens.rowekamp Jens Röwekamp (Inactive)
              Reporter:
              winstone Zdravelina Sokolovska (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration

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