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

Not able to import data from a csv file (LOAD DATA LOCAL INFILE)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Cannot Reproduce
    • 1.0.7
    • Icebox
    • cpimport
    • None
    • CentOS 7.2

    Description

      My csv file is generated by tpc-ds tools. the data scale is 20T and partioned to 10 chunk. When I use 'LOAD DATA LOCAL INFILE' to import this csv, most are successful, but several failed. The err msg mcsmysql got is "ERROR 1030 (HY000) at line 1: Got error -1 "Internal error < 0 (Not system error)" from storage engine Columnstore". There is not any err log related found in UM or PMs.

      My ColumnStore system is composed of 1 UM and 3 PMs in seperate mode, and the csv file is stored on another seperate server which run the 'LOAD DATA'.

      Attachments

        1. err.log
          114 kB
        2. info.log
          752 kB
        3. warning.log
          522 kB

        Activity

          People

            Unassigned Unassigned
            solargg 胡彬
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.