2018/03/07 19:51:13 - Spoon - Starting job... 2018/03/07 19:51:13 - test-upd - Start of job execution 2018/03/07 19:51:13 - test-upd - exec(0, 0, START.0) 2018/03/07 19:51:13 - START - Starting job entry 2018/03/07 19:51:13 - test-upd - Starting entry [prepare tables] 2018/03/07 19:51:13 - test-upd - exec(1, 0, prepare tables.0) 2018/03/07 19:51:13 - prepare tables - Starting job entry 2018/03/07 19:51:13 - MariaDB JDBC - New database connection defined 2018/03/07 19:51:13 - prepare tables - Running SQL :DROP TABLE IF EXISTS test.kettle_test_data; 2018/03/07 19:51:13 - prepare tables - CREATE TABLE IF NOT EXISTS test.kettle_test_data 2018/03/07 19:51:13 - prepare tables - ( 2018/03/07 19:51:13 - prepare tables - uint64 BIGINT UNSIGNED 2018/03/07 19:51:13 - prepare tables - , int64 BIGINT 2018/03/07 19:51:13 - prepare tables - , uint32 INT UNSIGNED 2018/03/07 19:51:13 - prepare tables - , int32 INT 2018/03/07 19:51:13 - prepare tables - , uint16 SMALLINT UNSIGNED 2018/03/07 19:51:13 - prepare tables - , int16 SMALLINT 2018/03/07 19:51:13 - prepare tables - , uint8 TINYINT UNSIGNED 2018/03/07 19:51:13 - prepare tables - , intEight TINYINT 2018/03/07 19:51:13 - prepare tables - , f FLOAT 2018/03/07 19:51:13 - prepare tables - , d DOUBLE 2018/03/07 19:51:13 - prepare tables - , ch4 VARCHAR(5) 2018/03/07 19:51:13 - prepare tables - , vch30 VARCHAR(30) 2018/03/07 19:51:13 - prepare tables - , dt DATE 2018/03/07 19:51:13 - prepare tables - , dtm DATETIME 2018/03/07 19:51:13 - prepare tables - , dc DECIMAL(18) 2018/03/07 19:51:13 - prepare tables - , tx TEXT 2018/03/07 19:51:13 - prepare tables - , bit TINYINT(1) 2018/03/07 19:51:13 - prepare tables - , mathInt BIGINT UNSIGNED 2018/03/07 19:51:13 - prepare tables - , dc2 DECIMAL(18,9) 2018/03/07 19:51:13 - prepare tables - ) 2018/03/07 19:51:13 - prepare tables - ; 2018/03/07 19:51:13 - prepare tables - INSERT INTO test.kettle_test_data VALUES (1, 2, 3, 4, 5, 6, 7, 8, 1.234, 2.34567, "ABCD", "Hello World", "2017-09-08", "2017-09-08 13:58:23", 123, "Hello World Longer", true, 9223372036854775807, -0.000000001); 2018/03/07 19:51:13 - prepare tables - INSERT INTO test.kettle_test_data VALUES (0, -9223372036854775806, 0, -2147483646, 0, -32766, 0, -126, 1.234, 2.34567, "A", "B", "1000-01-01", "1000-01-01 00:00:00", -123, "C", false, 18446744073709551613, 100000000.999999999); 2018/03/07 19:51:13 - prepare tables - INSERT INTO test.kettle_test_data VALUES (9223372036854775807, 9223372036854775807, 4294967293, 2147483647, 65533, 32767, 253, 127, 1.234, 2.34567, "ZYXW", "012345678901234567890123456789", "9999-12-31", "9999-12-31 23:59:59", 123, "012345678901234567890123456789", true, 2342, 23.42); 2018/03/07 19:51:13 - prepare tables - 2018/03/07 19:51:13 - prepare tables - DROP TABLE IF EXISTS test.kettle_jdbc_innodb; 2018/03/07 19:51:13 - prepare tables - CREATE TABLE IF NOT EXISTS test.kettle_jdbc_innodb 2018/03/07 19:51:13 - prepare tables - ( 2018/03/07 19:51:13 - prepare tables - uint64 BIGINT UNSIGNED 2018/03/07 19:51:13 - prepare tables - , int64 BIGINT 2018/03/07 19:51:13 - prepare tables - , uint32 INT UNSIGNED 2018/03/07 19:51:13 - prepare tables - , int32 INT 2018/03/07 19:51:13 - prepare tables - , uint16 SMALLINT UNSIGNED 2018/03/07 19:51:13 - prepare tables - , int16 SMALLINT 2018/03/07 19:51:13 - prepare tables - , uint8 TINYINT UNSIGNED 2018/03/07 19:51:13 - prepare tables - , intEight TINYINT 2018/03/07 19:51:13 - prepare tables - , f FLOAT 2018/03/07 19:51:13 - prepare tables - , d DOUBLE 2018/03/07 19:51:13 - prepare tables - , ch4 VARCHAR(5) 2018/03/07 19:51:13 - prepare tables - , vch30 VARCHAR(30) 2018/03/07 19:51:13 - prepare tables - , dt DATE 2018/03/07 19:51:13 - prepare tables - , dtm DATETIME 2018/03/07 19:51:13 - prepare tables - , dc DECIMAL(18) 2018/03/07 19:51:13 - prepare tables - , tx TEXT 2018/03/07 19:51:13 - prepare tables - , bit TINYINT(1) 2018/03/07 19:51:13 - prepare tables - , mathInt BIGINT UNSIGNED 2018/03/07 19:51:13 - prepare tables - , dc2 DECIMAL(18,9) 2018/03/07 19:51:13 - prepare tables - ) 2018/03/07 19:51:13 - prepare tables - ; 2018/03/07 19:51:13 - prepare tables - 2018/03/07 19:51:13 - prepare tables - DROP TABLE IF EXISTS test.kettle_jdbc_columnstore; 2018/03/07 19:51:13 - prepare tables - CREATE TABLE IF NOT EXISTS test.kettle_jdbc_columnstore 2018/03/07 19:51:13 - prepare tables - ( 2018/03/07 19:51:13 - prepare tables - uint64 BIGINT UNSIGNED 2018/03/07 19:51:13 - prepare tables - , int64 BIGINT 2018/03/07 19:51:13 - prepare tables - , uint32 INT UNSIGNED 2018/03/07 19:51:13 - prepare tables - , int32 INT 2018/03/07 19:51:13 - prepare tables - , uint16 SMALLINT UNSIGNED 2018/03/07 19:51:13 - prepare tables - , int16 SMALLINT 2018/03/07 19:51:13 - prepare tables - , uint8 TINYINT UNSIGNED 2018/03/07 19:51:13 - prepare tables - , intEight TINYINT 2018/03/07 19:51:13 - prepare tables - , f FLOAT 2018/03/07 19:51:13 - prepare tables - , d DOUBLE 2018/03/07 19:51:13 - prepare tables - , ch4 VARCHAR(5) 2018/03/07 19:51:13 - prepare tables - , vch30 VARCHAR(30) 2018/03/07 19:51:13 - prepare tables - , dt DATE 2018/03/07 19:51:13 - prepare tables - , dtm DATETIME 2018/03/07 19:51:13 - prepare tables - , dc DECIMAL(18) 2018/03/07 19:51:13 - prepare tables - , tx TEXT 2018/03/07 19:51:13 - prepare tables - , bit TINYINT(1) 2018/03/07 19:51:13 - prepare tables - , mathInt BIGINT UNSIGNED 2018/03/07 19:51:13 - prepare tables - , dc2 DECIMAL(18,9) 2018/03/07 19:51:13 - prepare tables - ) 2018/03/07 19:51:13 - prepare tables - engine=columnstore 2018/03/07 19:51:13 - prepare tables - ; 2018/03/07 19:51:13 - prepare tables - 2018/03/07 19:51:13 - prepare tables - DROP TABLE IF EXISTS test.kettle_api_columnstore; 2018/03/07 19:51:13 - prepare tables - CREATE TABLE IF NOT EXISTS test.kettle_api_columnstore 2018/03/07 19:51:13 - prepare tables - ( 2018/03/07 19:51:13 - prepare tables - uint64 BIGINT UNSIGNED 2018/03/07 19:51:13 - prepare tables - , vch30 VARCHAR(30) 2018/03/07 19:51:13 - prepare tables - , int64 BIGINT 2018/03/07 19:51:13 - prepare tables - , uint32 INT UNSIGNED 2018/03/07 19:51:13 - prepare tables - , tx TEXT 2018/03/07 19:51:13 - prepare tables - , int32 INT 2018/03/07 19:51:13 - prepare tables - , uint16 SMALLINT UNSIGNED 2018/03/07 19:51:13 - prepare tables - , int16 SMALLINT 2018/03/07 19:51:13 - prepare tables - , uint8 TINYINT UNSIGNED 2018/03/07 19:51:13 - prepare tables - , intEight TINYINT 2018/03/07 19:51:13 - prepare tables - , f FLOAT 2018/03/07 19:51:13 - prepare tables - , d DOUBLE 2018/03/07 19:51:13 - prepare tables - , ch4 VARCHAR(5) 2018/03/07 19:51:13 - prepare tables - , bit TINYINT(1) 2018/03/07 19:51:13 - prepare tables - , dt DATE 2018/03/07 19:51:13 - prepare tables - , dtm DATETIME 2018/03/07 19:51:13 - prepare tables - , dc DECIMAL(18) 2018/03/07 19:51:13 - prepare tables - , mathInt BIGINT UNSIGNED 2018/03/07 19:51:13 - prepare tables - , dc2 DECIMAL(18,9) 2018/03/07 19:51:13 - prepare tables - ) 2018/03/07 19:51:13 - prepare tables - engine=columnstore 2018/03/07 19:51:13 - prepare tables - ; 2018/03/07 19:51:13 - MariaDB JDBC - launch DDL statement: 2018/03/07 19:51:13 - MariaDB JDBC - DROP TABLE IF EXISTS test.kettle_test_data 2018/03/07 19:51:13 - MariaDB JDBC - launch DDL statement: 2018/03/07 19:51:13 - MariaDB JDBC - CREATE TABLE IF NOT EXISTS test.kettle_test_data 2018/03/07 19:51:13 - MariaDB JDBC - ( 2018/03/07 19:51:13 - MariaDB JDBC - uint64 BIGINT UNSIGNED 2018/03/07 19:51:13 - MariaDB JDBC - , int64 BIGINT 2018/03/07 19:51:13 - MariaDB JDBC - , uint32 INT UNSIGNED 2018/03/07 19:51:13 - MariaDB JDBC - , int32 INT 2018/03/07 19:51:13 - MariaDB JDBC - , uint16 SMALLINT UNSIGNED 2018/03/07 19:51:13 - MariaDB JDBC - , int16 SMALLINT 2018/03/07 19:51:13 - MariaDB JDBC - , uint8 TINYINT UNSIGNED 2018/03/07 19:51:13 - MariaDB JDBC - , intEight TINYINT 2018/03/07 19:51:13 - MariaDB JDBC - , f FLOAT 2018/03/07 19:51:13 - MariaDB JDBC - , d DOUBLE 2018/03/07 19:51:13 - MariaDB JDBC - , ch4 VARCHAR(5) 2018/03/07 19:51:13 - MariaDB JDBC - , vch30 VARCHAR(30) 2018/03/07 19:51:13 - MariaDB JDBC - , dt DATE 2018/03/07 19:51:13 - MariaDB JDBC - , dtm DATETIME 2018/03/07 19:51:13 - MariaDB JDBC - , dc DECIMAL(18) 2018/03/07 19:51:13 - MariaDB JDBC - , tx TEXT 2018/03/07 19:51:13 - MariaDB JDBC - , bit TINYINT(1) 2018/03/07 19:51:13 - MariaDB JDBC - , mathInt BIGINT UNSIGNED 2018/03/07 19:51:13 - MariaDB JDBC - , dc2 DECIMAL(18,9) 2018/03/07 19:51:13 - MariaDB JDBC - ) 2018/03/07 19:51:13 - MariaDB JDBC - launch DDL statement: 2018/03/07 19:51:13 - MariaDB JDBC - INSERT INTO test.kettle_test_data VALUES (1, 2, 3, 4, 5, 6, 7, 8, 1.234, 2.34567, "ABCD", "Hello World", "2017-09-08", "2017-09-08 13:58:23", 123, "Hello World Longer", true, 9223372036854775807, -0.000000001) 2018/03/07 19:51:13 - MariaDB JDBC - launch DDL statement: 2018/03/07 19:51:13 - MariaDB JDBC - INSERT INTO test.kettle_test_data VALUES (0, -9223372036854775806, 0, -2147483646, 0, -32766, 0, -126, 1.234, 2.34567, "A", "B", "1000-01-01", "1000-01-01 00:00:00", -123, "C", false, 18446744073709551613, 100000000.999999999) 2018/03/07 19:51:13 - MariaDB JDBC - launch DDL statement: 2018/03/07 19:51:13 - MariaDB JDBC - INSERT INTO test.kettle_test_data VALUES (9223372036854775807, 9223372036854775807, 4294967293, 2147483647, 65533, 32767, 253, 127, 1.234, 2.34567, "ZYXW", "012345678901234567890123456789", "9999-12-31", "9999-12-31 23:59:59", 123, "012345678901234567890123456789", true, 2342, 23.42) 2018/03/07 19:51:13 - MariaDB JDBC - launch DDL statement: 2018/03/07 19:51:13 - MariaDB JDBC - DROP TABLE IF EXISTS test.kettle_jdbc_innodb 2018/03/07 19:51:13 - MariaDB JDBC - launch DDL statement: 2018/03/07 19:51:13 - MariaDB JDBC - CREATE TABLE IF NOT EXISTS test.kettle_jdbc_innodb 2018/03/07 19:51:13 - MariaDB JDBC - ( 2018/03/07 19:51:13 - MariaDB JDBC - uint64 BIGINT UNSIGNED 2018/03/07 19:51:13 - MariaDB JDBC - , int64 BIGINT 2018/03/07 19:51:13 - MariaDB JDBC - , uint32 INT UNSIGNED 2018/03/07 19:51:13 - MariaDB JDBC - , int32 INT 2018/03/07 19:51:13 - MariaDB JDBC - , uint16 SMALLINT UNSIGNED 2018/03/07 19:51:13 - MariaDB JDBC - , int16 SMALLINT 2018/03/07 19:51:13 - MariaDB JDBC - , uint8 TINYINT UNSIGNED 2018/03/07 19:51:13 - MariaDB JDBC - , intEight TINYINT 2018/03/07 19:51:13 - MariaDB JDBC - , f FLOAT 2018/03/07 19:51:13 - MariaDB JDBC - , d DOUBLE 2018/03/07 19:51:13 - MariaDB JDBC - , ch4 VARCHAR(5) 2018/03/07 19:51:13 - MariaDB JDBC - , vch30 VARCHAR(30) 2018/03/07 19:51:13 - MariaDB JDBC - , dt DATE 2018/03/07 19:51:13 - MariaDB JDBC - , dtm DATETIME 2018/03/07 19:51:13 - MariaDB JDBC - , dc DECIMAL(18) 2018/03/07 19:51:13 - MariaDB JDBC - , tx TEXT 2018/03/07 19:51:13 - MariaDB JDBC - , bit TINYINT(1) 2018/03/07 19:51:13 - MariaDB JDBC - , mathInt BIGINT UNSIGNED 2018/03/07 19:51:13 - MariaDB JDBC - , dc2 DECIMAL(18,9) 2018/03/07 19:51:13 - MariaDB JDBC - ) 2018/03/07 19:51:13 - MariaDB JDBC - launch DDL statement: 2018/03/07 19:51:13 - MariaDB JDBC - DROP TABLE IF EXISTS test.kettle_jdbc_columnstore 2018/03/07 19:51:13 - MariaDB JDBC - launch DDL statement: 2018/03/07 19:51:13 - MariaDB JDBC - CREATE TABLE IF NOT EXISTS test.kettle_jdbc_columnstore 2018/03/07 19:51:13 - MariaDB JDBC - ( 2018/03/07 19:51:13 - MariaDB JDBC - uint64 BIGINT UNSIGNED 2018/03/07 19:51:13 - MariaDB JDBC - , int64 BIGINT 2018/03/07 19:51:13 - MariaDB JDBC - , uint32 INT UNSIGNED 2018/03/07 19:51:13 - MariaDB JDBC - , int32 INT 2018/03/07 19:51:13 - MariaDB JDBC - , uint16 SMALLINT UNSIGNED 2018/03/07 19:51:13 - MariaDB JDBC - , int16 SMALLINT 2018/03/07 19:51:13 - MariaDB JDBC - , uint8 TINYINT UNSIGNED 2018/03/07 19:51:13 - MariaDB JDBC - , intEight TINYINT 2018/03/07 19:51:13 - MariaDB JDBC - , f FLOAT 2018/03/07 19:51:13 - MariaDB JDBC - , d DOUBLE 2018/03/07 19:51:13 - MariaDB JDBC - , ch4 VARCHAR(5) 2018/03/07 19:51:13 - MariaDB JDBC - , vch30 VARCHAR(30) 2018/03/07 19:51:13 - MariaDB JDBC - , dt DATE 2018/03/07 19:51:13 - MariaDB JDBC - , dtm DATETIME 2018/03/07 19:51:13 - MariaDB JDBC - , dc DECIMAL(18) 2018/03/07 19:51:13 - MariaDB JDBC - , tx TEXT 2018/03/07 19:51:13 - MariaDB JDBC - , bit TINYINT(1) 2018/03/07 19:51:13 - MariaDB JDBC - , mathInt BIGINT UNSIGNED 2018/03/07 19:51:13 - MariaDB JDBC - , dc2 DECIMAL(18,9) 2018/03/07 19:51:13 - MariaDB JDBC - ) 2018/03/07 19:51:13 - MariaDB JDBC - engine=columnstore 2018/03/07 19:51:14 - MariaDB JDBC - launch DDL statement: 2018/03/07 19:51:14 - MariaDB JDBC - DROP TABLE IF EXISTS test.kettle_api_columnstore 2018/03/07 19:51:14 - MariaDB JDBC - launch DDL statement: 2018/03/07 19:51:14 - MariaDB JDBC - CREATE TABLE IF NOT EXISTS test.kettle_api_columnstore 2018/03/07 19:51:14 - MariaDB JDBC - ( 2018/03/07 19:51:14 - MariaDB JDBC - uint64 BIGINT UNSIGNED 2018/03/07 19:51:14 - MariaDB JDBC - , vch30 VARCHAR(30) 2018/03/07 19:51:14 - MariaDB JDBC - , int64 BIGINT 2018/03/07 19:51:14 - MariaDB JDBC - , uint32 INT UNSIGNED 2018/03/07 19:51:14 - MariaDB JDBC - , tx TEXT 2018/03/07 19:51:14 - MariaDB JDBC - , int32 INT 2018/03/07 19:51:14 - MariaDB JDBC - , uint16 SMALLINT UNSIGNED 2018/03/07 19:51:14 - MariaDB JDBC - , int16 SMALLINT 2018/03/07 19:51:14 - MariaDB JDBC - , uint8 TINYINT UNSIGNED 2018/03/07 19:51:14 - MariaDB JDBC - , intEight TINYINT 2018/03/07 19:51:14 - MariaDB JDBC - , f FLOAT 2018/03/07 19:51:14 - MariaDB JDBC - , d DOUBLE 2018/03/07 19:51:14 - MariaDB JDBC - , ch4 VARCHAR(5) 2018/03/07 19:51:14 - MariaDB JDBC - , bit TINYINT(1) 2018/03/07 19:51:14 - MariaDB JDBC - , dt DATE 2018/03/07 19:51:14 - MariaDB JDBC - , dtm DATETIME 2018/03/07 19:51:14 - MariaDB JDBC - , dc DECIMAL(18) 2018/03/07 19:51:14 - MariaDB JDBC - , mathInt BIGINT UNSIGNED 2018/03/07 19:51:14 - MariaDB JDBC - , dc2 DECIMAL(18,9) 2018/03/07 19:51:14 - MariaDB JDBC - ) 2018/03/07 19:51:14 - MariaDB JDBC - engine=columnstore 2018/03/07 19:51:14 - MariaDB JDBC - 11 statements executed 2018/03/07 19:51:14 - MariaDB JDBC - Connection to database closed! 2018/03/07 19:51:14 - test-upd - Starting entry [export to database] 2018/03/07 19:51:14 - test-upd - exec(2, 0, export to database.0) 2018/03/07 19:51:14 - export to database - Starting job entry 2018/03/07 19:51:14 - export to database - Opening transformation: [file:///home/pentaho/Downloads/test-job/export-to-mariadb.ktr] 2018/03/07 19:51:14 - export to database - Loading transformation from XML file [file:///home/pentaho/Downloads/test-job/export-to-mariadb.ktr] 2018/03/07 19:51:14 - export to database - Starting transformation...(file=${Internal.Entry.Current.Directory}/export-to-mariadb.ktr, name=export to database, repinfo=null) 2018/03/07 19:51:14 - export to database - Using run configuration [Pentaho local] 2018/03/07 19:51:14 - export to database - Using legacy execution engine 2018/03/07 19:51:14 - export-to-mariadb - Transformation is pre-loaded. 2018/03/07 19:51:14 - export-to-mariadb - nr of steps to run : 6 , nr of hops : 5 2018/03/07 19:51:14 - export-to-mariadb - Dispatching started for transformation [export-to-mariadb] 2018/03/07 19:51:14 - export-to-mariadb - Nr of arguments detected:0 2018/03/07 19:51:14 - export-to-mariadb - This is not a replay transformation 2018/03/07 19:51:14 - export-to-mariadb - I found 6 different steps to launch. 2018/03/07 19:51:14 - export-to-mariadb - Allocating rowsets... 2018/03/07 19:51:14 - export-to-mariadb - Allocating rowsets for step 0 --> MariaDB input table 2018/03/07 19:51:14 - export-to-mariadb - prevcopies = 1, nextcopies=1 2018/03/07 19:51:14 - export-to-mariadb - Transformation allocated new rowset [MariaDB input table.0 - Sort rows.0] 2018/03/07 19:51:14 - export-to-mariadb - Allocated 1 rowsets for step 0 --> MariaDB input table 2018/03/07 19:51:14 - export-to-mariadb - Allocating rowsets for step 1 --> Sort rows 2018/03/07 19:51:14 - export-to-mariadb - prevcopies = 1, nextcopies=1 2018/03/07 19:51:14 - export-to-mariadb - Transformation allocated new rowset [Sort rows.0 - JDBC InnoDB Output.0] 2018/03/07 19:51:14 - export-to-mariadb - prevcopies = 1, nextcopies=1 2018/03/07 19:51:14 - export-to-mariadb - Transformation allocated new rowset [Sort rows.0 - JDBC ColumnStore Output.0] 2018/03/07 19:51:14 - export-to-mariadb - prevcopies = 1, nextcopies=1 2018/03/07 19:51:14 - export-to-mariadb - Transformation allocated new rowset [Sort rows.0 - MariaDB ColumnStore Bulk Loader.0] 2018/03/07 19:51:14 - export-to-mariadb - Allocated 4 rowsets for step 1 --> Sort rows 2018/03/07 19:51:14 - export-to-mariadb - Allocating rowsets for step 2 --> Native Pentaho Input 2018/03/07 19:51:14 - export-to-mariadb - prevcopies = 1, nextcopies=1 2018/03/07 19:51:14 - export-to-mariadb - Transformation allocated new rowset [Native Pentaho Input.0 - Sort rows.0] 2018/03/07 19:51:14 - export-to-mariadb - Allocated 5 rowsets for step 2 --> Native Pentaho Input 2018/03/07 19:51:14 - export-to-mariadb - Allocating rowsets for step 3 --> JDBC InnoDB Output 2018/03/07 19:51:14 - export-to-mariadb - Allocated 5 rowsets for step 3 --> JDBC InnoDB Output 2018/03/07 19:51:14 - export-to-mariadb - Allocating rowsets for step 4 --> JDBC ColumnStore Output 2018/03/07 19:51:14 - export-to-mariadb - Allocated 5 rowsets for step 4 --> JDBC ColumnStore Output 2018/03/07 19:51:14 - export-to-mariadb - Allocating rowsets for step 5 --> MariaDB ColumnStore Bulk Loader 2018/03/07 19:51:14 - export-to-mariadb - Allocated 5 rowsets for step 5 --> MariaDB ColumnStore Bulk Loader 2018/03/07 19:51:14 - export-to-mariadb - Allocating Steps & StepData... 2018/03/07 19:51:14 - export-to-mariadb - Transformation is about to allocate step [MariaDB input table] of type [TableInput] 2018/03/07 19:51:14 - export-to-mariadb - Step has nrcopies=1 2018/03/07 19:51:14 - MariaDB input table.0 - distribution de-activated 2018/03/07 19:51:14 - MariaDB input table.0 - Starting allocation of buffers & new threads... 2018/03/07 19:51:14 - MariaDB input table.0 - Step info: nrinput=0 nroutput=1 2018/03/07 19:51:14 - MariaDB input table.0 - output rel. is 1:1 2018/03/07 19:51:14 - MariaDB input table.0 - Found output rowset [MariaDB input table.0 - Sort rows.0] 2018/03/07 19:51:14 - MariaDB input table.0 - Finished dispatching 2018/03/07 19:51:14 - export-to-mariadb - Transformation has allocated a new step: [MariaDB input table].0 2018/03/07 19:51:14 - export-to-mariadb - Transformation is about to allocate step [Sort rows] of type [SortRows] 2018/03/07 19:51:14 - export-to-mariadb - Step has nrcopies=1 2018/03/07 19:51:14 - Sort rows.0 - distribution de-activated 2018/03/07 19:51:14 - Sort rows.0 - Starting allocation of buffers & new threads... 2018/03/07 19:51:14 - Sort rows.0 - Step info: nrinput=2 nroutput=3 2018/03/07 19:51:14 - Sort rows.0 - Got previous step from [Sort rows] #0 --> MariaDB input table 2018/03/07 19:51:14 - Sort rows.0 - input rel is 1:1 2018/03/07 19:51:14 - Sort rows.0 - Found input rowset [MariaDB input table.0 - Sort rows.0] 2018/03/07 19:51:14 - Sort rows.0 - Got previous step from [Sort rows] #1 --> Native Pentaho Input 2018/03/07 19:51:14 - Sort rows.0 - input rel is 1:1 2018/03/07 19:51:14 - Sort rows.0 - Found input rowset [Native Pentaho Input.0 - Sort rows.0] 2018/03/07 19:51:14 - Sort rows.0 - output rel. is 1:1 2018/03/07 19:51:14 - Sort rows.0 - Found output rowset [Sort rows.0 - JDBC InnoDB Output.0] 2018/03/07 19:51:14 - Sort rows.0 - output rel. is 1:1 2018/03/07 19:51:14 - Sort rows.0 - Found output rowset [Sort rows.0 - JDBC ColumnStore Output.0] 2018/03/07 19:51:14 - Sort rows.0 - output rel. is 1:1 2018/03/07 19:51:14 - Sort rows.0 - Found output rowset [Sort rows.0 - MariaDB ColumnStore Bulk Loader.0] 2018/03/07 19:51:14 - Sort rows.0 - Finished dispatching 2018/03/07 19:51:14 - export-to-mariadb - Transformation has allocated a new step: [Sort rows].0 2018/03/07 19:51:14 - export-to-mariadb - Transformation is about to allocate step [Native Pentaho Input] of type [DataGrid] 2018/03/07 19:51:14 - export-to-mariadb - Step has nrcopies=1 2018/03/07 19:51:14 - Native Pentaho Input.0 - distribution de-activated 2018/03/07 19:51:14 - Native Pentaho Input.0 - Starting allocation of buffers & new threads... 2018/03/07 19:51:14 - Native Pentaho Input.0 - Step info: nrinput=0 nroutput=1 2018/03/07 19:51:14 - Native Pentaho Input.0 - output rel. is 1:1 2018/03/07 19:51:14 - Native Pentaho Input.0 - Found output rowset [Native Pentaho Input.0 - Sort rows.0] 2018/03/07 19:51:14 - Native Pentaho Input.0 - Finished dispatching 2018/03/07 19:51:14 - export-to-mariadb - Transformation has allocated a new step: [Native Pentaho Input].0 2018/03/07 19:51:14 - export-to-mariadb - Transformation is about to allocate step [JDBC InnoDB Output] of type [TableOutput] 2018/03/07 19:51:14 - export-to-mariadb - Step has nrcopies=1 2018/03/07 19:51:14 - JDBC InnoDB Output.0 - distribution activated 2018/03/07 19:51:14 - JDBC InnoDB Output.0 - Starting allocation of buffers & new threads... 2018/03/07 19:51:14 - JDBC InnoDB Output.0 - Step info: nrinput=1 nroutput=0 2018/03/07 19:51:14 - JDBC InnoDB Output.0 - Got previous step from [JDBC InnoDB Output] #0 --> Sort rows 2018/03/07 19:51:14 - JDBC InnoDB Output.0 - input rel is 1:1 2018/03/07 19:51:14 - JDBC InnoDB Output.0 - Found input rowset [Sort rows.0 - JDBC InnoDB Output.0] 2018/03/07 19:51:14 - JDBC InnoDB Output.0 - Finished dispatching 2018/03/07 19:51:14 - export-to-mariadb - Transformation has allocated a new step: [JDBC InnoDB Output].0 2018/03/07 19:51:14 - export-to-mariadb - Transformation is about to allocate step [JDBC ColumnStore Output] of type [TableOutput] 2018/03/07 19:51:14 - export-to-mariadb - Step has nrcopies=1 2018/03/07 19:51:14 - JDBC ColumnStore Output.0 - distribution activated 2018/03/07 19:51:14 - JDBC ColumnStore Output.0 - Starting allocation of buffers & new threads... 2018/03/07 19:51:14 - JDBC ColumnStore Output.0 - Step info: nrinput=1 nroutput=0 2018/03/07 19:51:14 - JDBC ColumnStore Output.0 - Got previous step from [JDBC ColumnStore Output] #0 --> Sort rows 2018/03/07 19:51:14 - JDBC ColumnStore Output.0 - input rel is 1:1 2018/03/07 19:51:14 - JDBC ColumnStore Output.0 - Found input rowset [Sort rows.0 - JDBC ColumnStore Output.0] 2018/03/07 19:51:14 - JDBC ColumnStore Output.0 - Finished dispatching 2018/03/07 19:51:14 - export-to-mariadb - Transformation has allocated a new step: [JDBC ColumnStore Output].0 2018/03/07 19:51:14 - export-to-mariadb - Transformation is about to allocate step [MariaDB ColumnStore Bulk Loader] of type [KettleColumnStoreBulkExporterPlugin] 2018/03/07 19:51:14 - export-to-mariadb - Step has nrcopies=1 2018/03/07 19:51:14 - MariaDB ColumnStore Bulk Loader.0 - distribution activated 2018/03/07 19:51:14 - MariaDB ColumnStore Bulk Loader.0 - Starting allocation of buffers & new threads... 2018/03/07 19:51:14 - MariaDB ColumnStore Bulk Loader.0 - Step info: nrinput=1 nroutput=0 2018/03/07 19:51:14 - MariaDB ColumnStore Bulk Loader.0 - Got previous step from [MariaDB ColumnStore Bulk Loader] #0 --> Sort rows 2018/03/07 19:51:14 - MariaDB ColumnStore Bulk Loader.0 - input rel is 1:1 2018/03/07 19:51:14 - MariaDB ColumnStore Bulk Loader.0 - Found input rowset [Sort rows.0 - MariaDB ColumnStore Bulk Loader.0] 2018/03/07 19:51:14 - MariaDB ColumnStore Bulk Loader.0 - Finished dispatching 2018/03/07 19:51:14 - export-to-mariadb - Transformation has allocated a new step: [MariaDB ColumnStore Bulk Loader].0 2018/03/07 19:51:14 - export-to-mariadb - This transformation can be replayed with replay date: 2018/03/07 19:51:14 2018/03/07 19:51:14 - export-to-mariadb - Initialising 6 steps... 2018/03/07 19:51:14 - MariaDB input table.0 - Released server socket on port 0 2018/03/07 19:51:14 - ColumnStore JDBC - New database connection defined 2018/03/07 19:51:14 - Sort rows.0 - Released server socket on port 0 2018/03/07 19:51:14 - Native Pentaho Input.0 - Released server socket on port 0 2018/03/07 19:51:14 - JDBC InnoDB Output.0 - Released server socket on port 0 2018/03/07 19:51:14 - ColumnStore JDBC - New database connection defined 2018/03/07 19:51:14 - JDBC ColumnStore Output.0 - Released server socket on port 0 2018/03/07 19:51:14 - ColumnStore JDBC - New database connection defined 2018/03/07 19:51:14 - MariaDB ColumnStore Bulk Loader.0 - Released server socket on port 0 2018/03/07 19:51:14 - MariaDB input table.0 - Connected to database... 2018/03/07 19:51:14 - JDBC InnoDB Output.0 - Connected to database [ColumnStore JDBC] (commit=1000) 2018/03/07 19:51:14 - JDBC ColumnStore Output.0 - Connected to database [ColumnStore JDBC] (commit=1000) 2018/03/07 19:51:14 - ColumnStore JDBC - Auto commit off 2018/03/07 19:51:14 - ColumnStore JDBC - Auto commit off 2018/03/07 19:51:15 - export-to-mariadb - Step [MariaDB input table.0] initialized flawlessly. 2018/03/07 19:51:15 - export-to-mariadb - Step [Sort rows.0] initialized flawlessly. 2018/03/07 19:51:15 - export-to-mariadb - Step [Native Pentaho Input.0] initialized flawlessly. 2018/03/07 19:51:15 - export-to-mariadb - Step [JDBC InnoDB Output.0] initialized flawlessly. 2018/03/07 19:51:15 - export-to-mariadb - Step [JDBC ColumnStore Output.0] initialized flawlessly. 2018/03/07 19:51:15 - export-to-mariadb - Step [MariaDB ColumnStore Bulk Loader.0] initialized flawlessly. 2018/03/07 19:51:15 - MariaDB input table.0 - Starting to run... 2018/03/07 19:51:15 - MariaDB input table.0 - SQL query : SELECT 2018/03/07 19:51:15 - MariaDB input table.0 - uint64 2018/03/07 19:51:15 - MariaDB input table.0 - , int64 2018/03/07 19:51:15 - MariaDB input table.0 - , uint32 2018/03/07 19:51:15 - MariaDB input table.0 - , int32 2018/03/07 19:51:15 - MariaDB input table.0 - , uint16 2018/03/07 19:51:15 - MariaDB input table.0 - , int16 2018/03/07 19:51:15 - MariaDB input table.0 - , uint8 2018/03/07 19:51:15 - MariaDB input table.0 - , intEight 2018/03/07 19:51:15 - MariaDB input table.0 - , f 2018/03/07 19:51:15 - MariaDB input table.0 - , d 2018/03/07 19:51:15 - MariaDB input table.0 - , ch4 2018/03/07 19:51:15 - MariaDB input table.0 - , vch30 2018/03/07 19:51:15 - MariaDB input table.0 - , dt 2018/03/07 19:51:15 - MariaDB input table.0 - , dtm 2018/03/07 19:51:15 - MariaDB input table.0 - , dc 2018/03/07 19:51:15 - MariaDB input table.0 - , tx 2018/03/07 19:51:15 - MariaDB input table.0 - , bit 2018/03/07 19:51:15 - MariaDB input table.0 - , mathInt 2018/03/07 19:51:15 - MariaDB input table.0 - , dc2 2018/03/07 19:51:15 - MariaDB input table.0 - FROM kettle_test_data 2018/03/07 19:51:15 - Sort rows.0 - Starting to run... 2018/03/07 19:51:15 - Native Pentaho Input.0 - Starting to run... 2018/03/07 19:51:15 - Native Pentaho Input.0 - Native Pentaho Input.0 2018/03/07 19:51:15 - Native Pentaho Input.0 - Native Pentaho Input.0 2018/03/07 19:51:15 - Native Pentaho Input.0 - Signaling 'output done' to 1 output rowsets. 2018/03/07 19:51:15 - Native Pentaho Input.0 - Finished processing (I=0, O=0, R=0, W=2, U=0, E=0) 2018/03/07 19:51:15 - Sort rows.0 - Start dump buffer to disk, memory = 0%, buffer size: 1 2018/03/07 19:51:15 - JDBC InnoDB Output.0 - Starting to run... 2018/03/07 19:51:15 - Sort rows.0 - Start dump buffer to disk, memory = 0%, buffer size: 2 2018/03/07 19:51:15 - Sort rows.0 - Start dump buffer to disk, memory = 0%, buffer size: 3 2018/03/07 19:51:15 - JDBC ColumnStore Output.0 - Starting to run... 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Starting to run... 2018/03/07 19:51:15 - export-to-mariadb - Transformation has allocated 6 threads and 5 rowsets. 2018/03/07 19:51:15 - MariaDB input table.0 - Signaling 'output done' to 1 output rowsets. 2018/03/07 19:51:15 - MariaDB input table.0 - Finished reading query, closing connection. 2018/03/07 19:51:15 - Sort rows.0 - Start dump buffer to disk, memory = 0%, buffer size: 4 2018/03/07 19:51:15 - Sort rows.0 - Start dump buffer to disk, memory = 0%, buffer size: 5 2018/03/07 19:51:15 - ColumnStore JDBC - Connection to database closed! 2018/03/07 19:51:15 - MariaDB input table.0 - Finished processing (I=3, O=0, R=0, W=3, U=0, E=0) 2018/03/07 19:51:15 - Sort rows.0 - The number of binary string to data type conversions done in this sort block is 0 2018/03/07 19:51:15 - Sort rows.0 - Read row: [0.0], [-9223372036854775806], [0], [-2147483646], [0], [-32766], [0], [-126], [1.234], [2.34567], [A], [B], [1000/01/01 00:00:00.000], [1000/01/01 00:00:00.000000000], [-123], [C], [N], [18446744073709551613.0], [100000000.999999999] 2018/03/07 19:51:15 - Sort rows.0 - Read row: [1.0], [2], [3], [4], [5], [6], [7], [8], [1.234], [2.34567], [ABCD], [Hello World], [2017/09/08 00:00:00.000], [2017/09/08 13:58:23.000000000], [123], [Hello World Longer], [Y], [9223372036854775807.0], [-0.000000001] 2018/03/07 19:51:15 - Sort rows.0 - Read row: [12345.0], [-99999999], [456], [-456], [567], [76], [3], [1], [1.245], [9.876543], [oWor], [nonononono], [2018/02/14 00:00:00.000], [2018/02/14 00:00:00.000000000], [0], [Lorem Ipsum], [Y], [42424242.0], [0.01] 2018/03/07 19:51:15 - Sort rows.0 - Read row: [99999999.0], [-2000], [123], [-123], [234], [98], [4], [-12], [2.4444], [4.2222222222], [hell], [yesyesyesyes], [1988/09/25 00:00:00.000], [1988/09/25 00:00:00.000000000], [4], [Some sample text], [N], [23232323.0], [-0.1] 2018/03/07 19:51:15 - Sort rows.0 - Read row: [9223372036854775807.0], [9223372036854775807], [4294967293], [2147483647], [65533], [32767], [253], [127], [1.234], [2.34567], [ZYXW], [012345678901234567890123456789], [9999/12/31 00:00:00.000], [9999/12/31 23:59:59.000000000], [123], [012345678901234567890123456789], [Y], [2342.0], [23.42] 2018/03/07 19:51:15 - Sort rows.0 - Signaling 'output done' to 3 output rowsets. 2018/03/07 19:51:15 - Sort rows.0 - Finished processing (I=0, O=0, R=5, W=15, U=0, E=0) 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Input field names and types 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 0 : uint64 (BigNumber) 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 1 : int64 (Integer) 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 2 : uint32 (Integer) 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 3 : int32 (Integer) 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 4 : uint16 (Integer) 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 5 : int16 (Integer) 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 6 : uint8 (Integer) 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 7 : intEight (Integer) 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 8 : f (Number) 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 9 : d (Number) 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 10 : ch4 (String) 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 11 : vch30 (String) 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 12 : dt (Date) 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 13 : dtm (Timestamp) 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 14 : dc (Integer) 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 15 : tx (String) 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 16 : bit (Boolean) 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 17 : mathInt (BigNumber) 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 18 : dc2 (BigNumber) 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - ColumnStore rows and types 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 0 : uint64 : DATA_TYPE_UBIGINT 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 1 : vch30 : DATA_TYPE_VARCHAR 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 2 : int64 : DATA_TYPE_BIGINT 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 3 : uint32 : DATA_TYPE_UINT 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 4 : tx : DATA_TYPE_TEXT 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 5 : int32 : DATA_TYPE_INT 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 6 : uint16 : DATA_TYPE_USMALLINT 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 7 : int16 : DATA_TYPE_SMALLINT 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 8 : uint8 : DATA_TYPE_UTINYINT 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 9 : inteight : DATA_TYPE_TINYINT 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 10 : f : DATA_TYPE_FLOAT 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 11 : d : DATA_TYPE_DOUBLE 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 12 : ch4 : DATA_TYPE_VARCHAR 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 13 : bit : DATA_TYPE_TINYINT 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 14 : dt : DATA_TYPE_DATE 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 15 : dtm : DATA_TYPE_DATETIME 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 16 : dc : DATA_TYPE_DECIMAL 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 17 : mathint : DATA_TYPE_UBIGINT 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - 18 : dc2 : DATA_TYPE_DECIMAL 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Iterating through the ColumnStore table to set the row object 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 0 - uint64 - trying to insert item: 0, value to String: 0 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Detect ColumnStore row type 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - ColumnStore column is of type 'decimal' 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 0 as BigInteger 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Value to insert: 0 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 0 as BigInteger 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 1 - vch30 - trying to insert item: 11, value to String: B 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 11 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 11 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 2 - int64 - trying to insert item: 1, value to String: -9223372036854775806 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 1 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 1 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 3 - uint32 - trying to insert item: 2, value to String: 0 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 2 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 2 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 4 - tx - trying to insert item: 15, value to String: C 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 15 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 15 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 5 - int32 - trying to insert item: 3, value to String: -2147483646 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 3 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 3 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 6 - uint16 - trying to insert item: 4, value to String: 0 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 4 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 4 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 7 - int16 - trying to insert item: 5, value to String: -32766 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 5 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 5 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 8 - uint8 - trying to insert item: 6, value to String: 0 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 6 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 6 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 9 - inteight - trying to insert item: 7, value to String: -126 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 7 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 7 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 10 - f - trying to insert item: 8, value to String: 1.234 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 8 as Double 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 8 as Double 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 11 - d - trying to insert item: 9, value to String: 2.34567 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 9 as Double 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 9 as Double 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 12 - ch4 - trying to insert item: 10, value to String: A 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 10 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 10 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 13 - bit - trying to insert item: 16, value to String: false 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 16 as Boolean 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 16 as Boolean 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 14 - dt - trying to insert item: 12, value to String: 1000-01-01 00:00:00.0 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 12 as Date 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Value to insert: 1000-01-01 00:00:00.000 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 12 as Date 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 15 - dtm - trying to insert item: 13, value to String: 1000-01-01 00:00:00.0 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 13 as Timestamp 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Value to insert: 1000-01-01 00:00:00.000 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 13 as Timestamp 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 16 - dc - trying to insert item: 14, value to String: -123 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 14 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 14 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 17 - mathint - trying to insert item: 17, value to String: 18446744073709551613 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Detect ColumnStore row type 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - ColumnStore column is of type 'decimal' 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 17 as BigInteger 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Value to insert: 18446744073709551613 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 17 as BigInteger 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 18 - dc2 - trying to insert item: 18, value to String: 100000000.999999999 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Detect ColumnStore row type 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - ColumnStore column is of type 'real' 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 18 as BigDecimal 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Value to insert: 100000000.999999999 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 18 as BigDecimal 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Iterating through the ColumnStore table to set the row object 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 0 - uint64 - trying to insert item: 0, value to String: 1 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Detect ColumnStore row type 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - ColumnStore column is of type 'decimal' 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 0 as BigInteger 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Value to insert: 1 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 0 as BigInteger 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 1 - vch30 - trying to insert item: 11, value to String: Hello World 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 11 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 11 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 2 - int64 - trying to insert item: 1, value to String: 2 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 1 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 1 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 3 - uint32 - trying to insert item: 2, value to String: 3 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 2 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 2 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 4 - tx - trying to insert item: 15, value to String: Hello World Longer 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 15 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 15 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 5 - int32 - trying to insert item: 3, value to String: 4 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 3 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 3 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 6 - uint16 - trying to insert item: 4, value to String: 5 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 4 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 4 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 7 - int16 - trying to insert item: 5, value to String: 6 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 5 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 5 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 8 - uint8 - trying to insert item: 6, value to String: 7 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 6 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 6 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 9 - inteight - trying to insert item: 7, value to String: 8 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 7 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 7 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 10 - f - trying to insert item: 8, value to String: 1.234 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 8 as Double 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 8 as Double 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 11 - d - trying to insert item: 9, value to String: 2.34567 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 9 as Double 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 9 as Double 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 12 - ch4 - trying to insert item: 10, value to String: ABCD 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 10 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 10 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 13 - bit - trying to insert item: 16, value to String: true 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 16 as Boolean 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 16 as Boolean 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 14 - dt - trying to insert item: 12, value to String: 2017-09-08 00:00:00.0 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 12 as Date 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Value to insert: 2017-09-08 00:00:00.000 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 12 as Date 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 15 - dtm - trying to insert item: 13, value to String: 2017-09-08 13:58:23.0 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 13 as Timestamp 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Value to insert: 2017-09-08 13:58:23.000 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 13 as Timestamp 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 16 - dc - trying to insert item: 14, value to String: 123 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 14 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 14 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 17 - mathint - trying to insert item: 17, value to String: 9223372036854775807 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Detect ColumnStore row type 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - ColumnStore column is of type 'decimal' 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 17 as BigInteger 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Value to insert: 9223372036854775807 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 17 as BigInteger 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 18 - dc2 - trying to insert item: 18, value to String: -1E-9 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Detect ColumnStore row type 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - ColumnStore column is of type 'real' 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 18 as BigDecimal 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Value to insert: -0.000000001 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 18 as BigDecimal 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Iterating through the ColumnStore table to set the row object 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 0 - uint64 - trying to insert item: 0, value to String: 12345 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Detect ColumnStore row type 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - ColumnStore column is of type 'decimal' 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 0 as BigInteger 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Value to insert: 12345 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 0 as BigInteger 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 1 - vch30 - trying to insert item: 11, value to String: nonononono 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 11 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 11 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 2 - int64 - trying to insert item: 1, value to String: -99999999 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 1 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 1 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 3 - uint32 - trying to insert item: 2, value to String: 456 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 2 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 2 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 4 - tx - trying to insert item: 15, value to String: Lorem Ipsum 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 15 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 15 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 5 - int32 - trying to insert item: 3, value to String: -456 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 3 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 3 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 6 - uint16 - trying to insert item: 4, value to String: 567 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 4 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 4 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 7 - int16 - trying to insert item: 5, value to String: 76 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 5 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 5 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 8 - uint8 - trying to insert item: 6, value to String: 3 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 6 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 6 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 9 - inteight - trying to insert item: 7, value to String: 1 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 7 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 7 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 10 - f - trying to insert item: 8, value to String: 1.245 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 8 as Double 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 8 as Double 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 11 - d - trying to insert item: 9, value to String: 9.876543 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 9 as Double 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 9 as Double 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 12 - ch4 - trying to insert item: 10, value to String: oWor 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 10 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 10 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 13 - bit - trying to insert item: 16, value to String: true 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 16 as Boolean 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 16 as Boolean 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 14 - dt - trying to insert item: 12, value to String: Wed Feb 14 00:00:00 EET 2018 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 12 as Date 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Value to insert: 2018-02-14 00:00:00.000 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 12 as Date 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 15 - dtm - trying to insert item: 13, value to String: 2018-02-14 00:00:00.0 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 13 as Timestamp 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Value to insert: 2018-02-14 00:00:00.000 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 13 as Timestamp 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 16 - dc - trying to insert item: 14, value to String: 0 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 14 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 14 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 17 - mathint - trying to insert item: 17, value to String: 42424242 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Detect ColumnStore row type 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - ColumnStore column is of type 'decimal' 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 17 as BigInteger 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Value to insert: 42424242 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 17 as BigInteger 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 18 - dc2 - trying to insert item: 18, value to String: 0.01 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Detect ColumnStore row type 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - ColumnStore column is of type 'real' 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 18 as BigDecimal 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Value to insert: 0.01 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 18 as BigDecimal 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Iterating through the ColumnStore table to set the row object 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 0 - uint64 - trying to insert item: 0, value to String: 99999999 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Detect ColumnStore row type 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - ColumnStore column is of type 'decimal' 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 0 as BigInteger 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Value to insert: 99999999 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 0 as BigInteger 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 1 - vch30 - trying to insert item: 11, value to String: yesyesyesyes 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 11 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 11 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 2 - int64 - trying to insert item: 1, value to String: -2000 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 1 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 1 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 3 - uint32 - trying to insert item: 2, value to String: 123 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 2 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 2 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 4 - tx - trying to insert item: 15, value to String: Some sample text 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 15 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 15 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 5 - int32 - trying to insert item: 3, value to String: -123 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 3 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 3 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 6 - uint16 - trying to insert item: 4, value to String: 234 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 4 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 4 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 7 - int16 - trying to insert item: 5, value to String: 98 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 5 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 5 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 8 - uint8 - trying to insert item: 6, value to String: 4 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 6 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 6 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 9 - inteight - trying to insert item: 7, value to String: -12 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 7 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 7 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 10 - f - trying to insert item: 8, value to String: 2.4444 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 8 as Double 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 8 as Double 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 11 - d - trying to insert item: 9, value to String: 4.2222222222 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 9 as Double 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 9 as Double 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 12 - ch4 - trying to insert item: 10, value to String: hell 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 10 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 10 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 13 - bit - trying to insert item: 16, value to String: false 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 16 as Boolean 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 16 as Boolean 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 14 - dt - trying to insert item: 12, value to String: Sun Sep 25 00:00:00 EEST 1988 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 12 as Date 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Value to insert: 1988-09-25 00:00:00.000 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 12 as Date 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 15 - dtm - trying to insert item: 13, value to String: 1988-09-25 00:00:00.0 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 13 as Timestamp 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Value to insert: 1988-09-25 00:00:00.000 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 13 as Timestamp 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 16 - dc - trying to insert item: 14, value to String: 4 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 14 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 14 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 17 - mathint - trying to insert item: 17, value to String: 23232323 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Detect ColumnStore row type 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - ColumnStore column is of type 'decimal' 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 17 as BigInteger 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Value to insert: 23232323 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 17 as BigInteger 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 18 - dc2 - trying to insert item: 18, value to String: -0.1 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Detect ColumnStore row type 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - ColumnStore column is of type 'real' 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 18 as BigDecimal 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Value to insert: -0.1 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 18 as BigDecimal 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Iterating through the ColumnStore table to set the row object 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 0 - uint64 - trying to insert item: 0, value to String: 9223372036854775807 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Detect ColumnStore row type 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - ColumnStore column is of type 'decimal' 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 0 as BigInteger 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Value to insert: 9223372036854775807 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 0 as BigInteger 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 1 - vch30 - trying to insert item: 11, value to String: 012345678901234567890123456789 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 11 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 11 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 2 - int64 - trying to insert item: 1, value to String: 9223372036854775807 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 1 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 1 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 3 - uint32 - trying to insert item: 2, value to String: 4294967293 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 2 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 2 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 4 - tx - trying to insert item: 15, value to String: 012345678901234567890123456789 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 15 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 15 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 5 - int32 - trying to insert item: 3, value to String: 2147483647 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 3 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 3 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 6 - uint16 - trying to insert item: 4, value to String: 65533 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 4 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 4 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 7 - int16 - trying to insert item: 5, value to String: 32767 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 5 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 5 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 8 - uint8 - trying to insert item: 6, value to String: 253 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 6 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 6 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 9 - inteight - trying to insert item: 7, value to String: 127 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 7 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 7 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 10 - f - trying to insert item: 8, value to String: 1.234 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 8 as Double 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 8 as Double 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 11 - d - trying to insert item: 9, value to String: 2.34567 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 9 as Double 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 9 as Double 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 12 - ch4 - trying to insert item: 10, value to String: ZYXW 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 10 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 10 as String 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 13 - bit - trying to insert item: 16, value to String: true 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 16 as Boolean 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 16 as Boolean 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 14 - dt - trying to insert item: 12, value to String: 9999-12-31 00:00:00.0 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 12 as Date 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Value to insert: 9999-12-31 00:00:00.000 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 12 as Date 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 15 - dtm - trying to insert item: 13, value to String: 9999-12-31 23:59:59.0 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 13 as Timestamp 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Value to insert: 9999-12-31 23:59:59.000 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 13 as Timestamp 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 16 - dc - trying to insert item: 14, value to String: 123 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 14 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 14 as Long 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 17 - mathint - trying to insert item: 17, value to String: 2342 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Detect ColumnStore row type 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - ColumnStore column is of type 'decimal' 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 17 as BigInteger 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Value to insert: 2342 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 17 as BigInteger 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Column 18 - dc2 - trying to insert item: 18, value to String: 23.420000000 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Detect ColumnStore row type 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - ColumnStore column is of type 'real' 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Try to insert item 18 as BigDecimal 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Value to insert: 23.420000000 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Inserted item 18 as BigDecimal 2018/03/07 19:51:15 - JDBC InnoDB Output.0 - Prepared statement : INSERT INTO kettle_jdbc_innodb (uint64, int64, uint32, int32, uint16, int16, uint8, intEight, f, d, ch4, vch30, dt, dtm, dc, tx, bit, mathInt, dc2) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 2018/03/07 19:51:15 - JDBC InnoDB Output.0 - Written row: [0.0], [-9223372036854775806], [0], [-2147483646], [0], [-32766], [0], [-126], [1.234], [2.34567], [A], [B], [1000/01/01 00:00:00.000], [1000/01/01 00:00:00.000000000], [-123], [C], [N], [18446744073709551613.0], [100000000.999999999] 2018/03/07 19:51:15 - JDBC InnoDB Output.0 - Written row: [1.0], [2], [3], [4], [5], [6], [7], [8], [1.234], [2.34567], [ABCD], [Hello World], [2017/09/08 00:00:00.000], [2017/09/08 13:58:23.000000000], [123], [Hello World Longer], [Y], [9223372036854775807.0], [-0.000000001] 2018/03/07 19:51:15 - JDBC InnoDB Output.0 - Written row: [12345.0], [-99999999], [456], [-456], [567], [76], [3], [1], [1.245], [9.876543], [oWor], [nonononono], [2018/02/14 00:00:00.000], [2018/02/14 00:00:00.000000000], [0], [Lorem Ipsum], [Y], [42424242.0], [0.01] 2018/03/07 19:51:15 - JDBC InnoDB Output.0 - Written row: [99999999.0], [-2000], [123], [-123], [234], [98], [4], [-12], [2.4444], [4.2222222222], [hell], [yesyesyesyes], [1988/09/25 00:00:00.000], [1988/09/25 00:00:00.000000000], [4], [Some sample text], [N], [23232323.0], [-0.1] 2018/03/07 19:51:15 - JDBC InnoDB Output.0 - Written row: [9223372036854775807.0], [9223372036854775807], [4294967293], [2147483647], [65533], [32767], [253], [127], [1.234], [2.34567], [ZYXW], [012345678901234567890123456789], [9999/12/31 00:00:00.000], [9999/12/31 23:59:59.000000000], [123], [012345678901234567890123456789], [Y], [2342.0], [23.42] 2018/03/07 19:51:15 - MariaDB ColumnStore Bulk Loader.0 - Signaling 'output done' to 0 output rowsets. 2018/03/07 19:51:15 - ColumnStore JDBC - Commit on database connection [ColumnStore JDBC] 2018/03/07 19:51:15 - JDBC InnoDB Output.0 - Signaling 'output done' to 0 output rowsets. 2018/03/07 19:51:15 - ColumnStore JDBC - Commit on database connection [ColumnStore JDBC] 2018/03/07 19:51:15 - ColumnStore JDBC - Connection to database closed! 2018/03/07 19:51:15 - JDBC InnoDB Output.0 - Finished processing (I=0, O=5, R=5, W=5, U=0, E=0) 2018/03/07 19:51:16 - MariaDB ColumnStore Bulk Loader.0 - bulk insert committed 2018/03/07 19:51:16 - MariaDB ColumnStore Bulk Loader.0 - Execution time: 0.256983444 2018/03/07 19:51:16 - MariaDB ColumnStore Bulk Loader.0 - Rows inserted: 5 2018/03/07 19:51:16 - MariaDB ColumnStore Bulk Loader.0 - Truncation count: 0 2018/03/07 19:51:16 - MariaDB ColumnStore Bulk Loader.0 - Saturated count: 0 2018/03/07 19:51:16 - MariaDB ColumnStore Bulk Loader.0 - Invalid count: 0 2018/03/07 19:51:16 - MariaDB ColumnStore Bulk Loader.0 - Finished processing (I=0, O=0, R=5, W=5, U=0, E=0) 2018/03/07 19:51:16 - JDBC ColumnStore Output.0 - Prepared statement : INSERT INTO kettle_jdbc_columnstore (uint64, int64, uint32, int32, uint16, int16, uint8, intEight, f, d, ch4, vch30, dt, dtm, dc, tx, bit, mathInt, dc2) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 2018/03/07 19:51:16 - JDBC ColumnStore Output.0 - Written row: [0.0], [-9223372036854775806], [0], [-2147483646], [0], [-32766], [0], [-126], [1.234], [2.34567], [A], [B], [1000/01/01 00:00:00.000], [1000/01/01 00:00:00.000000000], [-123], [C], [N], [18446744073709551613.0], [100000000.999999999] 2018/03/07 19:51:16 - JDBC ColumnStore Output.0 - Written row: [1.0], [2], [3], [4], [5], [6], [7], [8], [1.234], [2.34567], [ABCD], [Hello World], [2017/09/08 00:00:00.000], [2017/09/08 13:58:23.000000000], [123], [Hello World Longer], [Y], [9223372036854775807.0], [-0.000000001] 2018/03/07 19:51:16 - JDBC ColumnStore Output.0 - Written row: [12345.0], [-99999999], [456], [-456], [567], [76], [3], [1], [1.245], [9.876543], [oWor], [nonononono], [2018/02/14 00:00:00.000], [2018/02/14 00:00:00.000000000], [0], [Lorem Ipsum], [Y], [42424242.0], [0.01] 2018/03/07 19:51:16 - JDBC ColumnStore Output.0 - Written row: [99999999.0], [-2000], [123], [-123], [234], [98], [4], [-12], [2.4444], [4.2222222222], [hell], [yesyesyesyes], [1988/09/25 00:00:00.000], [1988/09/25 00:00:00.000000000], [4], [Some sample text], [N], [23232323.0], [-0.1] 2018/03/07 19:51:16 - JDBC ColumnStore Output.0 - Written row: [9223372036854775807.0], [9223372036854775807], [4294967293], [2147483647], [65533], [32767], [253], [127], [1.234], [2.34567], [ZYXW], [012345678901234567890123456789], [9999/12/31 00:00:00.000], [9999/12/31 23:59:59.000000000], [123], [012345678901234567890123456789], [Y], [2342.0], [23.42] 2018/03/07 19:51:17 - ColumnStore JDBC - Commit on database connection [ColumnStore JDBC] 2018/03/07 19:51:17 - JDBC ColumnStore Output.0 - Signaling 'output done' to 0 output rowsets. 2018/03/07 19:51:17 - ColumnStore JDBC - Commit on database connection [ColumnStore JDBC] 2018/03/07 19:51:17 - ColumnStore JDBC - Connection to database closed! 2018/03/07 19:51:17 - JDBC ColumnStore Output.0 - Finished processing (I=0, O=5, R=5, W=5, U=0, E=0) 2018/03/07 19:51:17 - export-to-mariadb - searching for annotations 2018/03/07 19:51:17 - export-to-mariadb - no annotations found 2018/03/07 19:51:17 - test-upd - Starting entry [write into csv] 2018/03/07 19:51:17 - test-upd - exec(3, 0, write into csv.0) 2018/03/07 19:51:17 - write into csv - Starting job entry 2018/03/07 19:51:17 - write into csv - Opening transformation: [file:///home/pentaho/Downloads/test-job/export-to-csv.ktr] 2018/03/07 19:51:17 - write into csv - Loading transformation from XML file [file:///home/pentaho/Downloads/test-job/export-to-csv.ktr] 2018/03/07 19:51:18 - write into csv - Starting transformation...(file=${Internal.Entry.Current.Directory}/export-to-csv.ktr, name=write into csv, repinfo=null) 2018/03/07 19:51:18 - write into csv - Using run configuration [Pentaho local] 2018/03/07 19:51:18 - write into csv - Using legacy execution engine 2018/03/07 19:51:18 - export-to-csv - Transformation is pre-loaded. 2018/03/07 19:51:18 - export-to-csv - nr of steps to run : 6 , nr of hops : 3 2018/03/07 19:51:18 - export-to-csv - Dispatching started for transformation [export-to-csv] 2018/03/07 19:51:18 - export-to-csv - Nr of arguments detected:0 2018/03/07 19:51:18 - export-to-csv - This is not a replay transformation 2018/03/07 19:51:18 - export-to-csv - I found 6 different steps to launch. 2018/03/07 19:51:18 - export-to-csv - Allocating rowsets... 2018/03/07 19:51:18 - export-to-csv - Allocating rowsets for step 0 --> jdbc columnstore input 2018/03/07 19:51:18 - export-to-csv - prevcopies = 1, nextcopies=1 2018/03/07 19:51:18 - export-to-csv - Transformation allocated new rowset [jdbc columnstore input.0 - jdbc columnstore csv output.0] 2018/03/07 19:51:18 - export-to-csv - Allocated 1 rowsets for step 0 --> jdbc columnstore input 2018/03/07 19:51:18 - export-to-csv - Allocating rowsets for step 1 --> jdbc columnstore csv output 2018/03/07 19:51:18 - export-to-csv - Allocated 1 rowsets for step 1 --> jdbc columnstore csv output 2018/03/07 19:51:18 - export-to-csv - Allocating rowsets for step 2 --> jdbc innodb input 2018/03/07 19:51:18 - export-to-csv - prevcopies = 1, nextcopies=1 2018/03/07 19:51:18 - export-to-csv - Transformation allocated new rowset [jdbc innodb input.0 - jdbc innodb csv output.0] 2018/03/07 19:51:18 - export-to-csv - Allocated 2 rowsets for step 2 --> jdbc innodb input 2018/03/07 19:51:18 - export-to-csv - Allocating rowsets for step 3 --> jdbc innodb csv output 2018/03/07 19:51:18 - export-to-csv - Allocated 2 rowsets for step 3 --> jdbc innodb csv output 2018/03/07 19:51:18 - export-to-csv - Allocating rowsets for step 4 --> api columnstore input 2018/03/07 19:51:18 - export-to-csv - prevcopies = 1, nextcopies=1 2018/03/07 19:51:18 - export-to-csv - Transformation allocated new rowset [api columnstore input.0 - api columnstore csv output.0] 2018/03/07 19:51:18 - export-to-csv - Allocated 3 rowsets for step 4 --> api columnstore input 2018/03/07 19:51:18 - export-to-csv - Allocating rowsets for step 5 --> api columnstore csv output 2018/03/07 19:51:18 - export-to-csv - Allocated 3 rowsets for step 5 --> api columnstore csv output 2018/03/07 19:51:18 - export-to-csv - Allocating Steps & StepData... 2018/03/07 19:51:18 - export-to-csv - Transformation is about to allocate step [jdbc columnstore input] of type [TableInput] 2018/03/07 19:51:18 - export-to-csv - Step has nrcopies=1 2018/03/07 19:51:18 - jdbc columnstore input.0 - distribution de-activated 2018/03/07 19:51:18 - jdbc columnstore input.0 - Starting allocation of buffers & new threads... 2018/03/07 19:51:18 - jdbc columnstore input.0 - Step info: nrinput=0 nroutput=1 2018/03/07 19:51:18 - jdbc columnstore input.0 - output rel. is 1:1 2018/03/07 19:51:18 - jdbc columnstore input.0 - Found output rowset [jdbc columnstore input.0 - jdbc columnstore csv output.0] 2018/03/07 19:51:18 - jdbc columnstore input.0 - Finished dispatching 2018/03/07 19:51:18 - export-to-csv - Transformation has allocated a new step: [jdbc columnstore input].0 2018/03/07 19:51:18 - export-to-csv - Transformation is about to allocate step [jdbc columnstore csv output] of type [TextFileOutput] 2018/03/07 19:51:18 - export-to-csv - Step has nrcopies=1 2018/03/07 19:51:18 - jdbc columnstore csv output.0 - distribution activated 2018/03/07 19:51:18 - jdbc columnstore csv output.0 - Starting allocation of buffers & new threads... 2018/03/07 19:51:18 - jdbc columnstore csv output.0 - Step info: nrinput=1 nroutput=0 2018/03/07 19:51:18 - jdbc columnstore csv output.0 - Got previous step from [jdbc columnstore csv output] #0 --> jdbc columnstore input 2018/03/07 19:51:18 - jdbc columnstore csv output.0 - input rel is 1:1 2018/03/07 19:51:18 - jdbc columnstore csv output.0 - Found input rowset [jdbc columnstore input.0 - jdbc columnstore csv output.0] 2018/03/07 19:51:18 - jdbc columnstore csv output.0 - Finished dispatching 2018/03/07 19:51:18 - export-to-csv - Transformation has allocated a new step: [jdbc columnstore csv output].0 2018/03/07 19:51:18 - export-to-csv - Transformation is about to allocate step [jdbc innodb input] of type [TableInput] 2018/03/07 19:51:18 - export-to-csv - Step has nrcopies=1 2018/03/07 19:51:18 - jdbc innodb input.0 - distribution de-activated 2018/03/07 19:51:18 - jdbc innodb input.0 - Starting allocation of buffers & new threads... 2018/03/07 19:51:18 - jdbc innodb input.0 - Step info: nrinput=0 nroutput=1 2018/03/07 19:51:18 - jdbc innodb input.0 - output rel. is 1:1 2018/03/07 19:51:18 - jdbc innodb input.0 - Found output rowset [jdbc innodb input.0 - jdbc innodb csv output.0] 2018/03/07 19:51:18 - jdbc innodb input.0 - Finished dispatching 2018/03/07 19:51:18 - export-to-csv - Transformation has allocated a new step: [jdbc innodb input].0 2018/03/07 19:51:18 - export-to-csv - Transformation is about to allocate step [jdbc innodb csv output] of type [TextFileOutput] 2018/03/07 19:51:18 - export-to-csv - Step has nrcopies=1 2018/03/07 19:51:18 - jdbc innodb csv output.0 - distribution activated 2018/03/07 19:51:18 - jdbc innodb csv output.0 - Starting allocation of buffers & new threads... 2018/03/07 19:51:18 - jdbc innodb csv output.0 - Step info: nrinput=1 nroutput=0 2018/03/07 19:51:18 - jdbc innodb csv output.0 - Got previous step from [jdbc innodb csv output] #0 --> jdbc innodb input 2018/03/07 19:51:18 - jdbc innodb csv output.0 - input rel is 1:1 2018/03/07 19:51:18 - jdbc innodb csv output.0 - Found input rowset [jdbc innodb input.0 - jdbc innodb csv output.0] 2018/03/07 19:51:18 - jdbc innodb csv output.0 - Finished dispatching 2018/03/07 19:51:18 - export-to-csv - Transformation has allocated a new step: [jdbc innodb csv output].0 2018/03/07 19:51:18 - export-to-csv - Transformation is about to allocate step [api columnstore input] of type [TableInput] 2018/03/07 19:51:18 - export-to-csv - Step has nrcopies=1 2018/03/07 19:51:18 - api columnstore input.0 - distribution de-activated 2018/03/07 19:51:18 - api columnstore input.0 - Starting allocation of buffers & new threads... 2018/03/07 19:51:18 - api columnstore input.0 - Step info: nrinput=0 nroutput=1 2018/03/07 19:51:18 - api columnstore input.0 - output rel. is 1:1 2018/03/07 19:51:18 - api columnstore input.0 - Found output rowset [api columnstore input.0 - api columnstore csv output.0] 2018/03/07 19:51:18 - api columnstore input.0 - Finished dispatching 2018/03/07 19:51:18 - export-to-csv - Transformation has allocated a new step: [api columnstore input].0 2018/03/07 19:51:18 - export-to-csv - Transformation is about to allocate step [api columnstore csv output] of type [TextFileOutput] 2018/03/07 19:51:18 - export-to-csv - Step has nrcopies=1 2018/03/07 19:51:18 - api columnstore csv output.0 - distribution activated 2018/03/07 19:51:18 - api columnstore csv output.0 - Starting allocation of buffers & new threads... 2018/03/07 19:51:18 - api columnstore csv output.0 - Step info: nrinput=1 nroutput=0 2018/03/07 19:51:18 - api columnstore csv output.0 - Got previous step from [api columnstore csv output] #0 --> api columnstore input 2018/03/07 19:51:18 - api columnstore csv output.0 - input rel is 1:1 2018/03/07 19:51:18 - api columnstore csv output.0 - Found input rowset [api columnstore input.0 - api columnstore csv output.0] 2018/03/07 19:51:18 - api columnstore csv output.0 - Finished dispatching 2018/03/07 19:51:18 - export-to-csv - Transformation has allocated a new step: [api columnstore csv output].0 2018/03/07 19:51:18 - export-to-csv - This transformation can be replayed with replay date: 2018/03/07 19:51:18 2018/03/07 19:51:18 - export-to-csv - Initialising 6 steps... 2018/03/07 19:51:18 - jdbc columnstore input.0 - Released server socket on port 0 2018/03/07 19:51:18 - MariaDB JDBC - New database connection defined 2018/03/07 19:51:18 - jdbc columnstore csv output.0 - Released server socket on port 0 2018/03/07 19:51:18 - jdbc columnstore csv output.0 - Parent folder exists [file:///home/pentaho/Downloads/test-job]! 2018/03/07 19:51:18 - jdbc columnstore csv output.0 - Opening output stream using provider: None 2018/03/07 19:51:18 - jdbc columnstore csv output.0 - Opening output stream in default encoding 2018/03/07 19:51:18 - jdbc columnstore csv output.0 - Opened new file with name [file:///home/pentaho/Downloads/test-job/jdbc-columnstore.csv] 2018/03/07 19:51:18 - jdbc columnstore input.0 - Connected to database... 2018/03/07 19:51:18 - jdbc innodb input.0 - Released server socket on port 0 2018/03/07 19:51:18 - MariaDB JDBC - New database connection defined 2018/03/07 19:51:18 - jdbc innodb input.0 - Connected to database... 2018/03/07 19:51:18 - jdbc innodb csv output.0 - Released server socket on port 0 2018/03/07 19:51:18 - jdbc innodb csv output.0 - Parent folder exists [file:///home/pentaho/Downloads/test-job]! 2018/03/07 19:51:18 - jdbc innodb csv output.0 - Opening output stream using provider: None 2018/03/07 19:51:18 - jdbc innodb csv output.0 - Opening output stream in default encoding 2018/03/07 19:51:18 - jdbc innodb csv output.0 - Opened new file with name [file:///home/pentaho/Downloads/test-job/jdbc-innodb.csv] 2018/03/07 19:51:18 - api columnstore input.0 - Released server socket on port 0 2018/03/07 19:51:18 - MariaDB JDBC - New database connection defined 2018/03/07 19:51:18 - api columnstore csv output.0 - Released server socket on port 0 2018/03/07 19:51:18 - api columnstore csv output.0 - Parent folder exists [file:///home/pentaho/Downloads/test-job]! 2018/03/07 19:51:18 - api columnstore csv output.0 - Opening output stream using provider: None 2018/03/07 19:51:18 - api columnstore csv output.0 - Opening output stream in default encoding 2018/03/07 19:51:18 - api columnstore csv output.0 - Opened new file with name [file:///home/pentaho/Downloads/test-job/api-columnstore.csv] 2018/03/07 19:51:18 - api columnstore input.0 - Connected to database... 2018/03/07 19:51:18 - export-to-csv - Step [jdbc columnstore input.0] initialized flawlessly. 2018/03/07 19:51:18 - export-to-csv - Step [jdbc columnstore csv output.0] initialized flawlessly. 2018/03/07 19:51:18 - export-to-csv - Step [jdbc innodb input.0] initialized flawlessly. 2018/03/07 19:51:18 - export-to-csv - Step [jdbc innodb csv output.0] initialized flawlessly. 2018/03/07 19:51:18 - export-to-csv - Step [api columnstore input.0] initialized flawlessly. 2018/03/07 19:51:18 - export-to-csv - Step [api columnstore csv output.0] initialized flawlessly. 2018/03/07 19:51:18 - jdbc columnstore input.0 - Starting to run... 2018/03/07 19:51:18 - jdbc columnstore input.0 - SQL query : SELECT 2018/03/07 19:51:18 - jdbc columnstore input.0 - uint64 2018/03/07 19:51:18 - jdbc columnstore input.0 - , int64 2018/03/07 19:51:18 - jdbc columnstore input.0 - , uint32 2018/03/07 19:51:18 - jdbc columnstore input.0 - , int32 2018/03/07 19:51:18 - jdbc columnstore input.0 - , uint16 2018/03/07 19:51:18 - jdbc columnstore input.0 - , int16 2018/03/07 19:51:18 - jdbc columnstore input.0 - , uint8 2018/03/07 19:51:18 - jdbc columnstore input.0 - , intEight 2018/03/07 19:51:18 - jdbc columnstore input.0 - , f 2018/03/07 19:51:18 - jdbc columnstore input.0 - , d 2018/03/07 19:51:18 - jdbc columnstore input.0 - , ch4 2018/03/07 19:51:18 - jdbc columnstore input.0 - , vch30 2018/03/07 19:51:18 - jdbc columnstore input.0 - , dt 2018/03/07 19:51:18 - jdbc columnstore input.0 - , dtm 2018/03/07 19:51:18 - jdbc columnstore input.0 - , dc 2018/03/07 19:51:18 - jdbc columnstore input.0 - , tx 2018/03/07 19:51:18 - jdbc columnstore input.0 - , bit 2018/03/07 19:51:18 - jdbc columnstore input.0 - , mathInt 2018/03/07 19:51:18 - jdbc columnstore input.0 - , dc2 2018/03/07 19:51:18 - jdbc columnstore input.0 - FROM kettle_jdbc_columnstore 2018/03/07 19:51:18 - jdbc columnstore csv output.0 - Starting to run... 2018/03/07 19:51:18 - jdbc innodb input.0 - Starting to run... 2018/03/07 19:51:18 - jdbc innodb input.0 - SQL query : SELECT 2018/03/07 19:51:18 - jdbc innodb input.0 - uint64 2018/03/07 19:51:18 - jdbc innodb input.0 - , int64 2018/03/07 19:51:18 - jdbc innodb input.0 - , uint32 2018/03/07 19:51:18 - jdbc innodb input.0 - , int32 2018/03/07 19:51:18 - jdbc innodb input.0 - , uint16 2018/03/07 19:51:18 - jdbc innodb input.0 - , int16 2018/03/07 19:51:18 - jdbc innodb input.0 - , uint8 2018/03/07 19:51:18 - jdbc innodb input.0 - , intEight 2018/03/07 19:51:18 - jdbc innodb input.0 - , f 2018/03/07 19:51:18 - jdbc innodb input.0 - , d 2018/03/07 19:51:18 - jdbc innodb input.0 - , ch4 2018/03/07 19:51:18 - jdbc innodb input.0 - , vch30 2018/03/07 19:51:18 - jdbc innodb input.0 - , dt 2018/03/07 19:51:18 - jdbc innodb input.0 - , dtm 2018/03/07 19:51:18 - jdbc innodb input.0 - , dc 2018/03/07 19:51:18 - jdbc innodb input.0 - , tx 2018/03/07 19:51:18 - jdbc innodb input.0 - , bit 2018/03/07 19:51:18 - jdbc innodb input.0 - , mathInt 2018/03/07 19:51:18 - jdbc innodb input.0 - , dc2 2018/03/07 19:51:18 - jdbc innodb input.0 - FROM kettle_jdbc_innodb 2018/03/07 19:51:18 - jdbc innodb input.0 - Signaling 'output done' to 1 output rowsets. 2018/03/07 19:51:18 - jdbc innodb input.0 - Finished reading query, closing connection. 2018/03/07 19:51:18 - MariaDB JDBC - Connection to database closed! 2018/03/07 19:51:18 - jdbc innodb input.0 - Finished processing (I=5, O=0, R=0, W=5, U=0, E=0) 2018/03/07 19:51:18 - jdbc innodb csv output.0 - Starting to run... 2018/03/07 19:51:18 - jdbc innodb csv output.0 - Signaling 'output done' to 0 output rowsets. 2018/03/07 19:51:18 - jdbc innodb csv output.0 - Closing normal file ... 2018/03/07 19:51:18 - jdbc innodb csv output.0 - Finished processing (I=0, O=6, R=5, W=5, U=0, E=0) 2018/03/07 19:51:18 - api columnstore input.0 - Starting to run... 2018/03/07 19:51:18 - api columnstore input.0 - SQL query : SELECT 2018/03/07 19:51:18 - api columnstore input.0 - uint64 2018/03/07 19:51:18 - api columnstore input.0 - , int64 2018/03/07 19:51:18 - api columnstore input.0 - , uint32 2018/03/07 19:51:18 - api columnstore input.0 - , int32 2018/03/07 19:51:18 - api columnstore input.0 - , uint16 2018/03/07 19:51:18 - api columnstore input.0 - , int16 2018/03/07 19:51:18 - api columnstore input.0 - , uint8 2018/03/07 19:51:18 - api columnstore input.0 - , intEight 2018/03/07 19:51:18 - api columnstore input.0 - , f 2018/03/07 19:51:18 - api columnstore input.0 - , d 2018/03/07 19:51:18 - api columnstore input.0 - , ch4 2018/03/07 19:51:18 - api columnstore input.0 - , vch30 2018/03/07 19:51:18 - api columnstore input.0 - , dt 2018/03/07 19:51:18 - api columnstore input.0 - , dtm 2018/03/07 19:51:18 - api columnstore input.0 - , dc 2018/03/07 19:51:18 - api columnstore input.0 - , tx 2018/03/07 19:51:18 - api columnstore input.0 - , bit 2018/03/07 19:51:18 - api columnstore input.0 - , mathInt 2018/03/07 19:51:18 - api columnstore input.0 - , dc2 2018/03/07 19:51:18 - api columnstore input.0 - FROM kettle_api_columnstore 2018/03/07 19:51:18 - api columnstore csv output.0 - Starting to run... 2018/03/07 19:51:18 - export-to-csv - Transformation has allocated 6 threads and 3 rowsets. 2018/03/07 19:51:18 - api columnstore input.0 - Signaling 'output done' to 1 output rowsets. 2018/03/07 19:51:18 - api columnstore input.0 - Finished reading query, closing connection. 2018/03/07 19:51:18 - api columnstore csv output.0 - Signaling 'output done' to 0 output rowsets. 2018/03/07 19:51:18 - api columnstore csv output.0 - Closing normal file ... 2018/03/07 19:51:18 - api columnstore csv output.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0) 2018/03/07 19:51:18 - MariaDB JDBC - Connection to database closed! 2018/03/07 19:51:18 - api columnstore input.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0) 2018/03/07 19:51:18 - jdbc columnstore input.0 - Signaling 'output done' to 1 output rowsets. 2018/03/07 19:51:18 - jdbc columnstore input.0 - Finished reading query, closing connection. 2018/03/07 19:51:18 - MariaDB JDBC - Connection to database closed! 2018/03/07 19:51:18 - jdbc columnstore input.0 - Finished processing (I=5, O=0, R=0, W=5, U=0, E=0) 2018/03/07 19:51:18 - jdbc columnstore csv output.0 - Signaling 'output done' to 0 output rowsets. 2018/03/07 19:51:18 - jdbc columnstore csv output.0 - Closing normal file ... 2018/03/07 19:51:18 - jdbc columnstore csv output.0 - Finished processing (I=0, O=6, R=5, W=5, U=0, E=0) 2018/03/07 19:51:18 - export-to-csv - searching for annotations 2018/03/07 19:51:18 - export-to-csv - no annotations found 2018/03/07 19:51:18 - test-upd - Starting entry [validate test] 2018/03/07 19:51:18 - test-upd - exec(4, 0, validate test.0) 2018/03/07 19:51:18 - validate test - Starting job entry 2018/03/07 19:51:18 - validate test - Found 0 previous result rows 2018/03/07 19:51:18 - validate test - Running on platform : Linux 2018/03/07 19:51:18 - validate test - Executing command : /tmp/kettle_2394d0b7-2230-11e8-86e5-19c62df4c26eshell 2018/03/07 19:51:18 - validate test - (stdout) csv exports JDBC innodb and JDBC columnstore match - OK 2018/03/07 19:51:18 - validate test - (stdout) 1,6d0 2018/03/07 19:51:18 - validate test - (stdout) < uint64;int64;uint32;int32;uint16;int16;uint8;intEight;f;d;ch4;vch30;dt;dtm;dc;tx;bit;mathInt;dc2 2018/03/07 19:51:18 - validate test - (stdout) < 0.0;-9223372036854775806;0;-2147483646;0;-32766;0;-126;1.234;2.34567;A ;B ;1000/01/01 00:00:00.000;1000/01/01 00:00:00.000000000;-123;C ;N;18446744073709551613.0;100000000.999999999 2018/03/07 19:51:18 - validate test - (stdout) < 1.0;2;3;4;5;6;7;8;1.234;2.34567;ABCD ;Hello World ;2017/09/08 00:00:00.000;2017/09/08 13:58:23.000000000;123;Hello World Longer ;Y;9223372036854775807.0;-0.000000001 2018/03/07 19:51:18 - validate test - (stdout) < 12345.0;-99999999;456;-456;567;76;3;1;1.245;9.876543;oWor ;nonononono ;2018/02/14 00:00:00.000;2018/02/14 00:00:00.000000000;0;Lorem Ipsum ;Y;42424242.0;0.01 2018/03/07 19:51:18 - validate test - (stdout) < 99999999.0;-2000;123;-123;234;98;4;-12;2.4444;4.2222222222;hell ;yesyesyesyes ;1988/09/25 00:00:00.000;1988/09/25 00:00:00.000000000;4;Some sample text ;N;23232323.0;-0.1 2018/03/07 19:51:18 - validate test - (stdout) < 9223372036854775807.0;9223372036854775807;4294967293;2147483647;65533;32767;253;127;1.234;2.34567;ZYXW ;012345678901234567890123456789;9999/12/31 00:00:00.000;9999/12/31 23:59:59.000000000;123;012345678901234567890123456789 ;Y;2342.0;23.42 2018/03/07 19:51:18 - validate test - (stdout) csv exports JDBC innodb and API columnstore don't match - FAILURE 2018/03/07 19:51:18 - validate test - (stdout) 0a1,6 2018/03/07 19:51:18 - validate test - (stdout) > uint64;int64;uint32;int32;uint16;int16;uint8;intEight;f;d;ch4;vch30;dt;dtm;dc;tx;bit;mathInt;dc2 2018/03/07 19:51:18 - validate test - (stdout) > 0.0;-9223372036854775806;0;-2147483646;0;-32766;0;-126;1.234;2.34567;A ;B ;1000/01/01 00:00:00.000;1000/01/01 00:00:00.000000000;-123;C ;N;18446744073709551613.0;100000000.999999999 2018/03/07 19:51:18 - validate test - (stdout) > 1.0;2;3;4;5;6;7;8;1.234;2.34567;ABCD ;Hello World ;2017/09/08 00:00:00.000;2017/09/08 13:58:23.000000000;123;Hello World Longer ;Y;9223372036854775807.0;-0.000000001 2018/03/07 19:51:18 - validate test - (stdout) > 12345.0;-99999999;456;-456;567;76;3;1;1.245;9.876543;oWor ;nonononono ;2018/02/14 00:00:00.000;2018/02/14 00:00:00.000000000;0;Lorem Ipsum ;Y;42424242.0;0.01 2018/03/07 19:51:18 - validate test - (stdout) > 99999999.0;-2000;123;-123;234;98;4;-12;2.4444;4.2222222222;hell ;yesyesyesyes ;1988/09/25 00:00:00.000;1988/09/25 00:00:00.000000000;4;Some sample text ;N;23232323.0;-0.1 2018/03/07 19:51:18 - validate test - Command /tmp/kettle_2394d0b7-2230-11e8-86e5-19c62df4c26eshell has finished 2018/03/07 19:51:18 - validate test - Exit status of shell [file:///home/pentaho/Downloads/test-job/validate.sh] was 1 2018/03/07 19:51:18 - validate test - (stdout) > 9223372036854775807.0;9223372036854775807;4294967293;2147483647;65533;32767;253;127;1.234;2.34567;ZYXW ;012345678901234567890123456789;9999/12/31 00:00:00.000;9999/12/31 23:59:59.000000000;123;012345678901234567890123456789 ;Y;2342.0;23.42 2018/03/07 19:51:18 - validate test - (stdout) csv exports API columnstore and JDBC columnstore don't match - FAILURE 2018/03/07 19:51:18 - validate test - (stdout) test failed 2018/03/07 19:51:18 - test-upd - Finished job entry [validate test] (result=[false]) 2018/03/07 19:51:18 - test-upd - Finished job entry [write into csv] (result=[false]) 2018/03/07 19:51:18 - test-upd - Finished job entry [export to database] (result=[false]) 2018/03/07 19:51:18 - test-upd - Finished job entry [prepare tables] (result=[false]) 2018/03/07 19:51:18 - test-upd - Job execution finished 2018/03/07 19:51:18 - Spoon - Job has ended.