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

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 1.2.0
    • Icebox
    • None
    • None
    • linux

    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

          relates to

          New Feature - A new feature of the product, which has yet to be developed. MCOL-1774 mcsimport - enclose by character support and escape character for enclose by char

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MCOL-1842 missing options escape character and enclosed by character of the remote mcsimport tool

          • Major - Major loss of function.
          • Closed

          Activity

            People

              jens.rowekamp Jens Röwekamp (Inactive)
              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.