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. pdi-batch.png
          pdi-batch.png
          172 kB
        2. pdi-non-batch.png
          pdi-non-batch.png
          172 kB
        3. kettle.log
          10 kB
        4. columnstoreSupportReport.columnstore-1.tar.gz
          34 kB
        5. slow-load.png
          slow-load.png
          215 kB

        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.