Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
None
-
None
-
github.com/mariadb-corporation/mariadb-columnstore-docker.git
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.