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

Mariadb columnstore problem with BATCH INSERT

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • None
    • Icebox
    • DMLProc
    • None
    • github.com/mariadb-corporation/mariadb-columnstore-docker.gi‌​t
      mariadb-columnstore-1.0.9-1-centos7.x86_64.rpm.tar.gz

    Description

      I'm using Pentaho Kettle to load data into the DW.

      I'm trying to store data using the step 'Table Output' in 'batch mode' with batch size 1000.

      After run the transformation, Kettle throw an exception (see the the kettle.log file attached).

      If I change the connection string to:

      jdbc:mysql://localhost:3306/dbtest?sessionVariables=sql_mode='MSSQL'
      

      I'm able to run the transformation without errors, but no record is stored in the database.

      If the 'batch mode' is disable the records are stored successfully one by one.

      Attached the Kettle images showing the process in batch and non-batch mode.

      IAttached the columnstoreSupportReport.columnstore-1.tar.gz file as well.

      Best Regards.

      Attachments

        1. columnstoreSupportReport.columnstore-1.tar.gz
          34 kB
          Kleyson Rios
        2. kettle.log
          10 kB
          Kleyson Rios
        3. pdi-batch.png
          172 kB
          Kleyson Rios
        4. pdi-non-batch.png
          172 kB
          Kleyson Rios
        5. slow-load.png
          215 kB
          Kleyson Rios

        Activity

          People

            Unassigned Unassigned
            kleysonr Kleyson Rios
            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.