You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@carbondata.apache.org by Apache Jenkins Server <je...@builds.apache.org> on 2019/12/17 09:46:57 UTC

Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Materialized View Core #3909

See <https://builds.apache.org/job/carbondata-master-spark-2.1/org.apache.carbondata$carbondata-mv-core/3909/display/redirect>

Changes:


------------------------------------------
[...truncated 1.14 MB...]
2019-12-17 09:45:14 AUDIT audit:72 - {"time":"December 17, 2019 1:45:14 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763028101697134","opStatus":"START"}
2019-12-17 09:45:16 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-17 09:45:16 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-17 09:45:16 ERROR DataTypeUtil:385 - Problem while converting data typeconfigManagement
2019-12-17 09:45:16 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-17 09:45:16 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-17 09:45:16 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-17 09:45:16 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-17 09:45:16 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-17 09:45:16 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-17 09:45:16 AUDIT audit:93 - {"time":"December 17, 2019 1:45:16 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763028101697134","opStatus":"SUCCESS","opTime":"2183 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-17 09:45:16 AUDIT audit:93 - {"time":"December 17, 2019 1:45:16 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9763027146790969","opStatus":"SUCCESS","opTime":"3145 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-17 09:45:16 AUDIT audit:72 - {"time":"December 17, 2019 1:45:16 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9763030297916388","opStatus":"START"}
2019-12-17 09:45:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:17 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:18 AUDIT audit:72 - {"time":"December 17, 2019 1:45:18 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763031900057274","opStatus":"START"}
2019-12-17 09:45:20 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-17 09:45:20 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-17 09:45:20 AUDIT audit:93 - {"time":"December 17, 2019 1:45:20 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763031900057274","opStatus":"SUCCESS","opTime":"2135 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-17 09:45:20 AUDIT audit:93 - {"time":"December 17, 2019 1:45:20 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9763030297916388","opStatus":"SUCCESS","opTime":"3743 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-17 09:45:20 AUDIT audit:72 - {"time":"December 17, 2019 1:45:20 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9763034044546942","opStatus":"START"}
2019-12-17 09:45:20 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:20 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:21 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:21 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:21 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:21 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:21 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:21 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:21 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:21 AUDIT audit:72 - {"time":"December 17, 2019 1:45:21 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763035056343498","opStatus":"START"}
2019-12-17 09:45:23 ERROR DataTypeUtil:385 - Problem while converting data typeconfigManagement
2019-12-17 09:45:23 AUDIT audit:93 - {"time":"December 17, 2019 1:45:23 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763035056343498","opStatus":"SUCCESS","opTime":"2197 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-17 09:45:23 AUDIT audit:93 - {"time":"December 17, 2019 1:45:23 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9763034044546942","opStatus":"SUCCESS","opTime":"3215 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-17 09:45:23 AUDIT audit:72 - {"time":"December 17, 2019 1:45:23 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9763037263047196","opStatus":"START"}
2019-12-17 09:45:24 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:24 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:24 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:24 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:24 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:24 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:24 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:24 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:24 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:24 AUDIT audit:72 - {"time":"December 17, 2019 1:45:24 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763038224638516","opStatus":"START"}
2019-12-17 09:45:26 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-17 09:45:26 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-17 09:45:26 AUDIT audit:93 - {"time":"December 17, 2019 1:45:26 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763038224638516","opStatus":"SUCCESS","opTime":"1859 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-17 09:45:26 AUDIT audit:93 - {"time":"December 17, 2019 1:45:26 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9763037263047196","opStatus":"SUCCESS","opTime":"2827 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-17 09:45:26 AUDIT audit:72 - {"time":"December 17, 2019 1:45:26 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9763040092817409","opStatus":"START"}
2019-12-17 09:45:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:27 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:27 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:27 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:27 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:27 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:27 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:27 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:27 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:27 AUDIT audit:72 - {"time":"December 17, 2019 1:45:27 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763041114223897","opStatus":"START"}
2019-12-17 09:45:29 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-17 09:45:29 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-17 09:45:29 AUDIT audit:93 - {"time":"December 17, 2019 1:45:29 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763041114223897","opStatus":"SUCCESS","opTime":"2157 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-17 09:45:29 AUDIT audit:93 - {"time":"December 17, 2019 1:45:29 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9763040092817409","opStatus":"SUCCESS","opTime":"3183 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-17 09:45:29 AUDIT audit:72 - {"time":"December 17, 2019 1:45:29 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9763043279012791","opStatus":"START"}
2019-12-17 09:45:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:30 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-17 09:45:30 AUDIT audit:72 - {"time":"December 17, 2019 1:45:30 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763044293902300","opStatus":"START"}
2019-12-17 09:45:32 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-17 09:45:32 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-17 09:45:32 AUDIT audit:93 - {"time":"December 17, 2019 1:45:32 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763044293902300","opStatus":"SUCCESS","opTime":"1913 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-17 09:45:32 AUDIT audit:93 - {"time":"December 17, 2019 1:45:32 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9763043279012791","opStatus":"SUCCESS","opTime":"2934 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-17 09:45:32 AUDIT audit:72 - {"time":"December 17, 2019 1:45:32 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9763046215706592","opStatus":"START"}
2019-12-17 09:45:33 AUDIT audit:72 - {"time":"December 17, 2019 1:45:33 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9763047411223027","opStatus":"START"}
2019-12-17 09:45:35 AUDIT audit:93 - {"time":"December 17, 2019 1:45:35 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9763047411223027","opStatus":"SUCCESS","opTime":"1406 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-17 09:45:35 AUDIT audit:93 - {"time":"December 17, 2019 1:45:35 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9763046215706592","opStatus":"SUCCESS","opTime":"2738 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-17 09:45:35 AUDIT audit:72 - {"time":"December 17, 2019 1:45:35 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9763049090801455","opStatus":"START"}
2019-12-17 09:45:36 AUDIT audit:93 - {"time":"December 17, 2019 1:45:36 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9763049090801455","opStatus":"SUCCESS","opTime":"987 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
- Test data updation after compaction on Partition with mv tables
2019-12-17 09:45:36 AUDIT audit:72 - {"time":"December 17, 2019 1:45:36 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763050085272571","opStatus":"START"}
2019-12-17 09:45:36 AUDIT audit:93 - {"time":"December 17, 2019 1:45:36 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763050085272571","opStatus":"SUCCESS","opTime":"64 ms","table":"partition_mv.updatetime_8","extraInfo":{"bad_record_path":"","table_blocksize":"256","sort_scope":"global_sort","local_dictionary_enable":"true","external":"false","sort_columns":"countryid,imex,hs_len,minstartdate,startdate,newdate,minnewdate","comment":""}}
2019-12-17 09:45:36 AUDIT audit:72 - {"time":"December 17, 2019 1:45:36 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"9763050151776004","opStatus":"START"}
2019-12-17 09:45:36 AUDIT audit:93 - {"time":"December 17, 2019 1:45:36 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"9763050151776004","opStatus":"SUCCESS","opTime":"3 ms","table":"NA","extraInfo":{"dmName":"ag"}}
2019-12-17 09:45:36 AUDIT audit:72 - {"time":"December 17, 2019 1:45:36 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9763050158775453","opStatus":"START"}
2019-12-17 09:45:36 AUDIT audit:72 - {"time":"December 17, 2019 1:45:36 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763050302830844","opStatus":"START"}
2019-12-17 09:45:36 AUDIT audit:93 - {"time":"December 17, 2019 1:45:36 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763050302830844","opStatus":"SUCCESS","opTime":"116 ms","table":"partition_mv.ag_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"256","sort_scope":"global_sort","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"updatetime_8","sort_columns":"updatetime_8_imex","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"ag"}}
2019-12-17 09:45:37 AUDIT audit:93 - {"time":"December 17, 2019 1:45:37 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9763050158775453","opStatus":"SUCCESS","opTime":"415 ms","table":"partition_mv.updatetime_8","extraInfo":{"provider":"mv","dmName":"ag"}}
2019-12-17 09:45:37 AUDIT audit:72 - {"time":"December 17, 2019 1:45:37 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9763050582211852","opStatus":"START"}
2019-12-17 09:45:37 AUDIT audit:72 - {"time":"December 17, 2019 1:45:37 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763051062200998","opStatus":"START"}
2019-12-17 09:45:39 AUDIT audit:93 - {"time":"December 17, 2019 1:45:39 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763051062200998","opStatus":"SUCCESS","opTime":"2349 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-17 09:45:39 AUDIT audit:93 - {"time":"December 17, 2019 1:45:39 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9763050582211852","opStatus":"SUCCESS","opTime":"2836 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-17 09:45:40 AUDIT audit:72 - {"time":"December 17, 2019 1:45:40 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9763053428564659","opStatus":"START"}
2019-12-17 09:45:40 AUDIT audit:72 - {"time":"December 17, 2019 1:45:40 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763053857417478","opStatus":"START"}
2019-12-17 09:45:42 AUDIT audit:93 - {"time":"December 17, 2019 1:45:42 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763053857417478","opStatus":"SUCCESS","opTime":"2138 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-17 09:45:42 AUDIT audit:93 - {"time":"December 17, 2019 1:45:42 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9763053428564659","opStatus":"SUCCESS","opTime":"2573 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-17 09:45:42 AUDIT audit:72 - {"time":"December 17, 2019 1:45:42 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9763056011547050","opStatus":"START"}
2019-12-17 09:45:42 AUDIT audit:72 - {"time":"December 17, 2019 1:45:42 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763056380573325","opStatus":"START"}
2019-12-17 09:45:45 AUDIT audit:93 - {"time":"December 17, 2019 1:45:45 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763056380573325","opStatus":"SUCCESS","opTime":"2244 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-17 09:45:45 AUDIT audit:93 - {"time":"December 17, 2019 1:45:45 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9763056011547050","opStatus":"SUCCESS","opTime":"2621 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-17 09:45:45 AUDIT audit:72 - {"time":"December 17, 2019 1:45:45 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9763058642223834","opStatus":"START"}
2019-12-17 09:45:45 AUDIT audit:72 - {"time":"December 17, 2019 1:45:45 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763059012220134","opStatus":"START"}
2019-12-17 09:45:47 AUDIT audit:93 - {"time":"December 17, 2019 1:45:47 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763059012220134","opStatus":"SUCCESS","opTime":"1979 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-17 09:45:47 AUDIT audit:93 - {"time":"December 17, 2019 1:45:47 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9763058642223834","opStatus":"SUCCESS","opTime":"2356 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-17 09:45:47 AUDIT audit:72 - {"time":"December 17, 2019 1:45:47 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9763061008162594","opStatus":"START"}
2019-12-17 09:45:47 AUDIT audit:72 - {"time":"December 17, 2019 1:45:47 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763061356131158","opStatus":"START"}
2019-12-17 09:45:49 AUDIT audit:93 - {"time":"December 17, 2019 1:45:49 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763061356131158","opStatus":"SUCCESS","opTime":"1786 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-17 09:45:49 AUDIT audit:93 - {"time":"December 17, 2019 1:45:49 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9763061008162594","opStatus":"SUCCESS","opTime":"2140 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-17 09:45:49 AUDIT audit:72 - {"time":"December 17, 2019 1:45:49 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9763063155708380","opStatus":"START"}
2019-12-17 09:45:50 AUDIT audit:72 - {"time":"December 17, 2019 1:45:50 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763063485096436","opStatus":"START"}
2019-12-17 09:45:52 AUDIT audit:93 - {"time":"December 17, 2019 1:45:52 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763063485096436","opStatus":"SUCCESS","opTime":"2094 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-17 09:45:52 AUDIT audit:93 - {"time":"December 17, 2019 1:45:52 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9763063155708380","opStatus":"SUCCESS","opTime":"2431 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-17 09:45:52 AUDIT audit:72 - {"time":"December 17, 2019 1:45:52 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9763065594995329","opStatus":"START"}
2019-12-17 09:45:52 AUDIT audit:72 - {"time":"December 17, 2019 1:45:52 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763065999583929","opStatus":"START"}
2019-12-17 09:45:54 AUDIT audit:93 - {"time":"December 17, 2019 1:45:54 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763065999583929","opStatus":"SUCCESS","opTime":"1949 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-17 09:45:54 AUDIT audit:93 - {"time":"December 17, 2019 1:45:54 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9763065594995329","opStatus":"SUCCESS","opTime":"2360 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-17 09:45:54 AUDIT audit:72 - {"time":"December 17, 2019 1:45:54 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9763067963100153","opStatus":"START"}
2019-12-17 09:45:54 AUDIT audit:72 - {"time":"December 17, 2019 1:45:54 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763068291798289","opStatus":"START"}
2019-12-17 09:45:56 AUDIT audit:93 - {"time":"December 17, 2019 1:45:56 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763068291798289","opStatus":"SUCCESS","opTime":"2068 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-17 09:45:56 AUDIT audit:93 - {"time":"December 17, 2019 1:45:56 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9763067963100153","opStatus":"SUCCESS","opTime":"2404 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-17 09:45:56 AUDIT audit:72 - {"time":"December 17, 2019 1:45:56 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9763070369323364","opStatus":"START"}
2019-12-17 09:45:57 AUDIT audit:72 - {"time":"December 17, 2019 1:45:57 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9763070495816951","opStatus":"START"}
2019-12-17 09:45:57 AUDIT audit:93 - {"time":"December 17, 2019 1:45:57 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9763070495816951","opStatus":"SUCCESS","opTime":"337 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-17 09:45:57 AUDIT audit:72 - {"time":"December 17, 2019 1:45:57 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9763070986187513","opStatus":"START"}
2019-12-17 09:45:57 AUDIT audit:93 - {"time":"December 17, 2019 1:45:57 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9763070986187513","opStatus":"SUCCESS","opTime":"22 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-17 09:45:57 AUDIT audit:93 - {"time":"December 17, 2019 1:45:57 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9763070369323364","opStatus":"SUCCESS","opTime":"677 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-17 09:45:57 AUDIT audit:72 - {"time":"December 17, 2019 1:45:57 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9763071054054942","opStatus":"START"}
2019-12-17 09:45:57 AUDIT audit:93 - {"time":"December 17, 2019 1:45:57 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9763071054054942","opStatus":"SUCCESS","opTime":"21 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
- Test data updation in Aggregate query after compaction on Partitioned table with mv table
2019-12-17 09:45:58 AUDIT audit:72 - {"time":"December 17, 2019 1:45:58 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9763071550969779","opStatus":"START"}
2019-12-17 09:45:58 AUDIT audit:93 - {"time":"December 17, 2019 1:45:58 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9763071550969779","opStatus":"SUCCESS","opTime":"264 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-17 09:45:58 AUDIT audit:72 - {"time":"December 17, 2019 1:45:58 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763071817920460","opStatus":"START"}
2019-12-17 09:45:58 AUDIT audit:93 - {"time":"December 17, 2019 1:45:58 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763071817920460","opStatus":"SUCCESS","opTime":"57 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-17 09:45:58 AUDIT audit:72 - {"time":"December 17, 2019 1:45:58 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9763071879123159","opStatus":"START"}
2019-12-17 09:45:58 AUDIT audit:72 - {"time":"December 17, 2019 1:45:58 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763072018984712","opStatus":"START"}
2019-12-17 09:45:58 AUDIT audit:93 - {"time":"December 17, 2019 1:45:58 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763072018984712","opStatus":"SUCCESS","opTime":"40 ms","table":"partition_mv.p7_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"p7"}}
2019-12-17 09:45:58 AUDIT audit:93 - {"time":"December 17, 2019 1:45:58 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9763071879123159","opStatus":"SUCCESS","opTime":"335 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p7"}}
2019-12-17 09:45:58 AUDIT audit:72 - {"time":"December 17, 2019 1:45:58 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9763072217594850","opStatus":"START"}
2019-12-17 09:45:58 AUDIT audit:72 - {"time":"December 17, 2019 1:45:58 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763072235607421","opStatus":"START"}
2019-12-17 09:45:58 AUDIT audit:93 - {"time":"December 17, 2019 1:45:58 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763072235607421","opStatus":"SUCCESS","opTime":"38 ms","table":"partition_mv.p1_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"p1"}}
2019-12-17 09:45:58 AUDIT audit:93 - {"time":"December 17, 2019 1:45:58 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9763072217594850","opStatus":"SUCCESS","opTime":"205 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p1"}}
2019-12-17 09:45:59 AUDIT audit:72 - {"time":"December 17, 2019 1:45:59 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9763072426314967","opStatus":"START"}
2019-12-17 09:45:59 AUDIT audit:72 - {"time":"December 17, 2019 1:45:59 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763072446180722","opStatus":"START"}
2019-12-17 09:45:59 AUDIT audit:93 - {"time":"December 17, 2019 1:45:59 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763072446180722","opStatus":"SUCCESS","opTime":"39 ms","table":"partition_mv.p2_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"p2"}}
2019-12-17 09:45:59 AUDIT audit:93 - {"time":"December 17, 2019 1:45:59 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9763072426314967","opStatus":"SUCCESS","opTime":"280 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p2"}}
2019-12-17 09:45:59 AUDIT audit:72 - {"time":"December 17, 2019 1:45:59 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9763072710436000","opStatus":"START"}
2019-12-17 09:45:59 AUDIT audit:72 - {"time":"December 17, 2019 1:45:59 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763072732687193","opStatus":"START"}
2019-12-17 09:45:59 AUDIT audit:93 - {"time":"December 17, 2019 1:45:59 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763072732687193","opStatus":"SUCCESS","opTime":"37 ms","table":"partition_mv.p3_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"p3"}}
2019-12-17 09:45:59 AUDIT audit:93 - {"time":"December 17, 2019 1:45:59 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9763072710436000","opStatus":"SUCCESS","opTime":"217 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p3"}}
2019-12-17 09:45:59 AUDIT audit:72 - {"time":"December 17, 2019 1:45:59 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9763072931195981","opStatus":"START"}
2019-12-17 09:45:59 AUDIT audit:72 - {"time":"December 17, 2019 1:45:59 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763072954239646","opStatus":"START"}
2019-12-17 09:45:59 AUDIT audit:93 - {"time":"December 17, 2019 1:45:59 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763072954239646","opStatus":"SUCCESS","opTime":"36 ms","table":"partition_mv.p4_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"p4"}}
2019-12-17 09:45:59 AUDIT audit:93 - {"time":"December 17, 2019 1:45:59 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9763072931195981","opStatus":"SUCCESS","opTime":"219 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p4"}}
2019-12-17 09:45:59 AUDIT audit:72 - {"time":"December 17, 2019 1:45:59 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9763073154469272","opStatus":"START"}
2019-12-17 09:45:59 AUDIT audit:72 - {"time":"December 17, 2019 1:45:59 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763073177241501","opStatus":"START"}
2019-12-17 09:45:59 AUDIT audit:93 - {"time":"December 17, 2019 1:45:59 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763073177241501","opStatus":"SUCCESS","opTime":"36 ms","table":"partition_mv.p5_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"p5"}}
2019-12-17 09:45:59 AUDIT audit:93 - {"time":"December 17, 2019 1:45:59 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9763073154469272","opStatus":"SUCCESS","opTime":"217 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p5"}}
2019-12-17 09:45:59 AUDIT audit:72 - {"time":"December 17, 2019 1:45:59 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9763073375155554","opStatus":"START"}
2019-12-17 09:45:59 AUDIT audit:72 - {"time":"December 17, 2019 1:45:59 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763073400230548","opStatus":"START"}
2019-12-17 09:46:00 AUDIT audit:93 - {"time":"December 17, 2019 1:46:00 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763073400230548","opStatus":"SUCCESS","opTime":"36 ms","table":"partition_mv.p6_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"p6"}}
2019-12-17 09:46:00 AUDIT audit:93 - {"time":"December 17, 2019 1:46:00 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9763073375155554","opStatus":"SUCCESS","opTime":"227 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p6"}}
2019-12-17 09:46:00 AUDIT audit:72 - {"time":"December 17, 2019 1:46:00 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9763073609239150","opStatus":"START"}
2019-12-17 09:46:00 AUDIT audit:93 - {"time":"December 17, 2019 1:46:00 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9763073609239150","opStatus":"SUCCESS","opTime":"567 ms","table":"partition_mv.partitionone","extraInfo":{}}
- check partitioning for child tables with various combinations
2019-12-17 09:46:00 AUDIT audit:72 - {"time":"December 17, 2019 1:46:00 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763074182762866","opStatus":"START"}
2019-12-17 09:46:01 AUDIT audit:93 - {"time":"December 17, 2019 1:46:01 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763074182762866","opStatus":"SUCCESS","opTime":"496 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-17 09:46:01 AUDIT audit:72 - {"time":"December 17, 2019 1:46:01 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9763074767852657","opStatus":"START"}
2019-12-17 09:46:01 AUDIT audit:93 - {"time":"December 17, 2019 1:46:01 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9763074767852657","opStatus":"SUCCESS","opTime":"376 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-17 09:46:01 AUDIT audit:72 - {"time":"December 17, 2019 1:46:01 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"9763075145328349","opStatus":"START"}
2019-12-17 09:46:01 AUDIT audit:93 - {"time":"December 17, 2019 1:46:01 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"9763075145328349","opStatus":"SUCCESS","opTime":"4 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-17 09:46:01 AUDIT audit:72 - {"time":"December 17, 2019 1:46:01 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9763075152324855","opStatus":"START"}
2019-12-17 09:46:01 AUDIT audit:72 - {"time":"December 17, 2019 1:46:01 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763075169787070","opStatus":"START"}
2019-12-17 09:46:01 AUDIT audit:93 - {"time":"December 17, 2019 1:46:01 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763075169787070","opStatus":"SUCCESS","opTime":"38 ms","table":"partition_mv.dm1_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"dm1"}}
2019-12-17 09:46:01 AUDIT audit:72 - {"time":"December 17, 2019 1:46:01 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763075366615503","opStatus":"START"}
2019-12-17 09:46:03 AUDIT audit:93 - {"time":"December 17, 2019 1:46:03 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763075366615503","opStatus":"SUCCESS","opTime":"1603 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-17 09:46:03 AUDIT audit:93 - {"time":"December 17, 2019 1:46:03 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9763075152324855","opStatus":"SUCCESS","opTime":"1829 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-17 09:46:04 AUDIT audit:72 - {"time":"December 17, 2019 1:46:04 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9763077526699824","opStatus":"START"}
2019-12-17 09:46:04 AUDIT audit:93 - {"time":"December 17, 2019 1:46:04 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9763077526699824","opStatus":"SUCCESS","opTime":"231 ms","table":"partition_mv.partitionone","extraInfo":{}}
- test partition at last column
2019-12-17 09:46:04 AUDIT audit:72 - {"time":"December 17, 2019 1:46:04 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763077768204194","opStatus":"START"}
2019-12-17 09:46:04 AUDIT audit:93 - {"time":"December 17, 2019 1:46:04 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763077768204194","opStatus":"SUCCESS","opTime":"46 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-17 09:46:04 AUDIT audit:72 - {"time":"December 17, 2019 1:46:04 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9763077906530815","opStatus":"START"}
2019-12-17 09:46:04 AUDIT audit:93 - {"time":"December 17, 2019 1:46:04 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9763077906530815","opStatus":"SUCCESS","opTime":"393 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-17 09:46:04 AUDIT audit:72 - {"time":"December 17, 2019 1:46:04 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"9763078303040913","opStatus":"START"}
2019-12-17 09:46:04 AUDIT audit:93 - {"time":"December 17, 2019 1:46:04 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"9763078303040913","opStatus":"SUCCESS","opTime":"6 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-17 09:46:04 AUDIT audit:72 - {"time":"December 17, 2019 1:46:04 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9763078314784363","opStatus":"START"}
2019-12-17 09:46:04 AUDIT audit:72 - {"time":"December 17, 2019 1:46:04 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763078341355151","opStatus":"START"}
2019-12-17 09:46:04 AUDIT audit:93 - {"time":"December 17, 2019 1:46:04 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763078341355151","opStatus":"SUCCESS","opTime":"40 ms","table":"partition_mv.dm1_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"dm1"}}
2019-12-17 09:46:05 AUDIT audit:72 - {"time":"December 17, 2019 1:46:05 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763078556393764","opStatus":"START"}
2019-12-17 09:46:05 AUDIT audit:93 - {"time":"December 17, 2019 1:46:05 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763078556393764","opStatus":"SUCCESS","opTime":"795 ms","table":"partition_mv.dm1_table","extraInfo":{"SegmentId":"0","DataSize":"666.0B","IndexSize":"435.0B"}}
2019-12-17 09:46:05 AUDIT audit:93 - {"time":"December 17, 2019 1:46:05 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9763078314784363","opStatus":"SUCCESS","opTime":"1048 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-17 09:46:06 AUDIT audit:72 - {"time":"December 17, 2019 1:46:06 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9763079860966532","opStatus":"START"}
2019-12-17 09:46:06 AUDIT audit:93 - {"time":"December 17, 2019 1:46:06 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9763079860966532","opStatus":"SUCCESS","opTime":"224 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-17 09:46:06 AUDIT audit:72 - {"time":"December 17, 2019 1:46:06 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763080086969767","opStatus":"START"}
2019-12-17 09:46:06 AUDIT audit:93 - {"time":"December 17, 2019 1:46:06 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763080086969767","opStatus":"SUCCESS","opTime":"73 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-17 09:46:06 AUDIT audit:72 - {"time":"December 17, 2019 1:46:06 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9763080281509300","opStatus":"START"}
2019-12-17 09:46:07 AUDIT audit:93 - {"time":"December 17, 2019 1:46:07 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9763080281509300","opStatus":"SUCCESS","opTime":"395 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-17 09:46:07 AUDIT audit:72 - {"time":"December 17, 2019 1:46:07 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"9763080678266341","opStatus":"START"}
2019-12-17 09:46:07 AUDIT audit:93 - {"time":"December 17, 2019 1:46:07 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"9763080678266341","opStatus":"SUCCESS","opTime":"3 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-17 09:46:07 AUDIT audit:72 - {"time":"December 17, 2019 1:46:07 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9763080685165311","opStatus":"START"}
2019-12-17 09:46:07 AUDIT audit:72 - {"time":"December 17, 2019 1:46:07 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763080703595175","opStatus":"START"}
2019-12-17 09:46:07 AUDIT audit:93 - {"time":"December 17, 2019 1:46:07 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9763080703595175","opStatus":"SUCCESS","opTime":"41 ms","table":"partition_mv.dm1_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"dm1"}}
2019-12-17 09:46:07 AUDIT audit:72 - {"time":"December 17, 2019 1:46:07 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763080898554542","opStatus":"START"}
2019-12-17 09:46:09 AUDIT audit:93 - {"time":"December 17, 2019 1:46:09 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9763080898554542","opStatus":"SUCCESS","opTime":"1648 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-17 09:46:09 AUDIT audit:93 - {"time":"December 17, 2019 1:46:09 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9763080685165311","opStatus":"SUCCESS","opTime":"1873 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-17 09:46:09 AUDIT audit:72 - {"time":"December 17, 2019 1:46:09 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9763083086544227","opStatus":"START"}
2019-12-17 09:46:09 AUDIT audit:93 - {"time":"December 17, 2019 1:46:09 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9763083086544227","opStatus":"SUCCESS","opTime":"192 ms","table":"partition_mv.partitionone","extraInfo":{}}
- test partition on timeseries column
2019-12-17 09:46:09 AUDIT audit:72 - {"time":"December 17, 2019 1:46:09 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9763083284416482","opStatus":"START"}
2019-12-17 09:46:09 AUDIT audit:93 - {"time":"December 17, 2019 1:46:09 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9763083284416482","opStatus":"SUCCESS","opTime":"1 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-17 09:46:09 AUDIT audit:72 - {"time":"December 17, 2019 1:46:09 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9763083285631569","opStatus":"START"}
2019-12-17 09:46:09 AUDIT audit:93 - {"time":"December 17, 2019 1:46:09 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9763083285631569","opStatus":"SUCCESS","opTime":"99 ms","table":"partition_mv.droppartition","extraInfo":{}}
2019-12-17 09:46:09 AUDIT audit:72 - {"time":"December 17, 2019 1:46:09 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9763083385389436","opStatus":"START"}
2019-12-17 09:46:10 AUDIT audit:93 - {"time":"December 17, 2019 1:46:10 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9763083385389436","opStatus":"SUCCESS","opTime":"140 ms","table":"partition_mv.maintable","extraInfo":{}}
2019-12-17 09:46:10 AUDIT audit:72 - {"time":"December 17, 2019 1:46:10 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9763083525541558","opStatus":"START"}
2019-12-17 09:46:10 AUDIT audit:93 - {"time":"December 17, 2019 1:46:10 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9763083525541558","opStatus":"SUCCESS","opTime":"54 ms","table":"partition_mv.par","extraInfo":{}}
2019-12-17 09:46:10 AUDIT audit:72 - {"time":"December 17, 2019 1:46:10 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9763083579519119","opStatus":"START"}
2019-12-17 09:46:10 AUDIT audit:93 - {"time":"December 17, 2019 1:46:10 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9763083579519119","opStatus":"SUCCESS","opTime":"136 ms","table":"partition_mv.partitiontable","extraInfo":{}}
2019-12-17 09:46:10 AUDIT audit:72 - {"time":"December 17, 2019 1:46:10 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9763083716298745","opStatus":"START"}
2019-12-17 09:46:10 AUDIT audit:93 - {"time":"December 17, 2019 1:46:10 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9763083716298745","opStatus":"SUCCESS","opTime":"256 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
MVTPCDSTestCase:
- test create datamap with tpcds_1_4_testCases case_1 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_3 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_4 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_5 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_6 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_8 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_11 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_15 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_16 !!! IGNORED !!!
Run completed in 11 minutes, 53 seconds.
Total number of tests run: 224
Suites: completed 21, aborted 0
Tests: succeeded 222, failed 2, canceled 0, ignored 27, pending 0
*** 2 TESTS FAILED ***
[JENKINS] Recording test results

Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Materialized View Core #3910

Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://builds.apache.org/job/carbondata-master-spark-2.1/org.apache.carbondata$carbondata-mv-core/3910/display/redirect>

Changes:


------------------------------------------
[...truncated 1.14 MB...]
2019-12-18 09:44:50 AUDIT audit:72 - {"time":"December 18, 2019 1:44:50 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849403812162295","opStatus":"START"}
2019-12-18 09:44:51 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-18 09:44:51 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-18 09:44:52 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-18 09:44:52 ERROR DataTypeUtil:385 - Problem while converting data typeconfigManagement
2019-12-18 09:44:52 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-18 09:44:52 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-18 09:44:52 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-18 09:44:52 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-18 09:44:52 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-18 09:44:52 AUDIT audit:93 - {"time":"December 18, 2019 1:44:52 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849403812162295","opStatus":"SUCCESS","opTime":"2064 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-18 09:44:52 AUDIT audit:93 - {"time":"December 18, 2019 1:44:52 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9849402711001734","opStatus":"SUCCESS","opTime":"3171 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-18 09:44:52 AUDIT audit:72 - {"time":"December 18, 2019 1:44:52 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9849405887910640","opStatus":"START"}
2019-12-18 09:44:52 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:52 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:52 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:53 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:53 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:53 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:53 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:53 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:53 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:53 AUDIT audit:72 - {"time":"December 18, 2019 1:44:53 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849406966684363","opStatus":"START"}
2019-12-18 09:44:55 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-18 09:44:55 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-18 09:44:55 AUDIT audit:93 - {"time":"December 18, 2019 1:44:55 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849406966684363","opStatus":"SUCCESS","opTime":"2001 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-18 09:44:55 AUDIT audit:93 - {"time":"December 18, 2019 1:44:55 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9849405887910640","opStatus":"SUCCESS","opTime":"3086 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-18 09:44:55 AUDIT audit:72 - {"time":"December 18, 2019 1:44:55 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9849408977549361","opStatus":"START"}
2019-12-18 09:44:55 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:55 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:55 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:56 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:56 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:56 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:56 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:56 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:56 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:56 AUDIT audit:72 - {"time":"December 18, 2019 1:44:56 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849410035207432","opStatus":"START"}
2019-12-18 09:44:58 ERROR DataTypeUtil:385 - Problem while converting data typeconfigManagement
2019-12-18 09:44:58 AUDIT audit:93 - {"time":"December 18, 2019 1:44:58 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849410035207432","opStatus":"SUCCESS","opTime":"1946 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-18 09:44:58 AUDIT audit:93 - {"time":"December 18, 2019 1:44:58 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9849408977549361","opStatus":"SUCCESS","opTime":"3008 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-18 09:44:58 AUDIT audit:72 - {"time":"December 18, 2019 1:44:58 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9849411989194826","opStatus":"START"}
2019-12-18 09:44:58 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:58 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:58 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:59 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:59 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:59 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:59 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:59 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:59 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:44:59 AUDIT audit:72 - {"time":"December 18, 2019 1:44:59 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849413018966198","opStatus":"START"}
2019-12-18 09:45:01 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-18 09:45:01 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-18 09:45:01 AUDIT audit:93 - {"time":"December 18, 2019 1:45:01 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849413018966198","opStatus":"SUCCESS","opTime":"2294 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-18 09:45:01 AUDIT audit:93 - {"time":"December 18, 2019 1:45:01 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9849411989194826","opStatus":"SUCCESS","opTime":"3331 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-18 09:45:01 AUDIT audit:72 - {"time":"December 18, 2019 1:45:01 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9849415322859750","opStatus":"START"}
2019-12-18 09:45:02 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:45:02 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:45:02 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:45:02 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:45:02 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:45:02 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:45:02 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:45:02 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:45:02 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:45:02 AUDIT audit:72 - {"time":"December 18, 2019 1:45:02 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849416410754316","opStatus":"START"}
2019-12-18 09:45:04 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-18 09:45:04 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-18 09:45:05 AUDIT audit:93 - {"time":"December 18, 2019 1:45:05 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849416410754316","opStatus":"SUCCESS","opTime":"2053 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-18 09:45:05 AUDIT audit:93 - {"time":"December 18, 2019 1:45:05 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9849415322859750","opStatus":"SUCCESS","opTime":"3148 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-18 09:45:05 AUDIT audit:72 - {"time":"December 18, 2019 1:45:05 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9849418473725189","opStatus":"START"}
2019-12-18 09:45:05 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:45:05 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:45:05 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:45:05 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:45:05 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:45:05 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:45:05 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:45:05 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:45:05 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-18 09:45:06 AUDIT audit:72 - {"time":"December 18, 2019 1:45:06 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849419543802358","opStatus":"START"}
2019-12-18 09:45:08 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-18 09:45:08 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-18 09:45:08 AUDIT audit:93 - {"time":"December 18, 2019 1:45:08 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849419543802358","opStatus":"SUCCESS","opTime":"2280 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-18 09:45:08 AUDIT audit:93 - {"time":"December 18, 2019 1:45:08 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9849418473725189","opStatus":"SUCCESS","opTime":"3357 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-18 09:45:08 AUDIT audit:72 - {"time":"December 18, 2019 1:45:08 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9849421833610166","opStatus":"START"}
2019-12-18 09:45:09 AUDIT audit:72 - {"time":"December 18, 2019 1:45:09 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9849423034357403","opStatus":"START"}
2019-12-18 09:45:11 AUDIT audit:93 - {"time":"December 18, 2019 1:45:11 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9849423034357403","opStatus":"SUCCESS","opTime":"1464 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-18 09:45:11 AUDIT audit:93 - {"time":"December 18, 2019 1:45:11 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9849421833610166","opStatus":"SUCCESS","opTime":"2840 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-18 09:45:11 AUDIT audit:72 - {"time":"December 18, 2019 1:45:11 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9849424847949554","opStatus":"START"}
2019-12-18 09:45:12 AUDIT audit:93 - {"time":"December 18, 2019 1:45:12 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9849424847949554","opStatus":"SUCCESS","opTime":"1110 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
- Test data updation after compaction on Partition with mv tables
2019-12-18 09:45:12 AUDIT audit:72 - {"time":"December 18, 2019 1:45:12 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849425965635501","opStatus":"START"}
2019-12-18 09:45:12 AUDIT audit:93 - {"time":"December 18, 2019 1:45:12 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849425965635501","opStatus":"SUCCESS","opTime":"74 ms","table":"partition_mv.updatetime_8","extraInfo":{"bad_record_path":"","table_blocksize":"256","sort_scope":"global_sort","local_dictionary_enable":"true","external":"false","sort_columns":"countryid,imex,hs_len,minstartdate,startdate,newdate,minnewdate","comment":""}}
2019-12-18 09:45:12 AUDIT audit:72 - {"time":"December 18, 2019 1:45:12 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"9849426042121203","opStatus":"START"}
2019-12-18 09:45:12 AUDIT audit:93 - {"time":"December 18, 2019 1:45:12 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"9849426042121203","opStatus":"SUCCESS","opTime":"4 ms","table":"NA","extraInfo":{"dmName":"ag"}}
2019-12-18 09:45:12 AUDIT audit:72 - {"time":"December 18, 2019 1:45:12 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9849426049300714","opStatus":"START"}
2019-12-18 09:45:12 AUDIT audit:72 - {"time":"December 18, 2019 1:45:12 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849426241962867","opStatus":"START"}
2019-12-18 09:45:12 AUDIT audit:93 - {"time":"December 18, 2019 1:45:12 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849426241962867","opStatus":"SUCCESS","opTime":"90 ms","table":"partition_mv.ag_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"256","sort_scope":"global_sort","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"updatetime_8","sort_columns":"updatetime_8_imex","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"ag"}}
2019-12-18 09:45:13 AUDIT audit:93 - {"time":"December 18, 2019 1:45:13 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9849426049300714","opStatus":"SUCCESS","opTime":"443 ms","table":"partition_mv.updatetime_8","extraInfo":{"provider":"mv","dmName":"ag"}}
2019-12-18 09:45:13 AUDIT audit:72 - {"time":"December 18, 2019 1:45:13 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9849426501156847","opStatus":"START"}
2019-12-18 09:45:13 AUDIT audit:72 - {"time":"December 18, 2019 1:45:13 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849427035591568","opStatus":"START"}
2019-12-18 09:45:15 AUDIT audit:93 - {"time":"December 18, 2019 1:45:15 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849427035591568","opStatus":"SUCCESS","opTime":"2238 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-18 09:45:15 AUDIT audit:93 - {"time":"December 18, 2019 1:45:15 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9849426501156847","opStatus":"SUCCESS","opTime":"2782 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-18 09:45:15 AUDIT audit:72 - {"time":"December 18, 2019 1:45:15 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9849429294001679","opStatus":"START"}
2019-12-18 09:45:16 AUDIT audit:72 - {"time":"December 18, 2019 1:45:16 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849429719747992","opStatus":"START"}
2019-12-18 09:45:18 AUDIT audit:93 - {"time":"December 18, 2019 1:45:18 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849429719747992","opStatus":"SUCCESS","opTime":"2353 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-18 09:45:18 AUDIT audit:93 - {"time":"December 18, 2019 1:45:18 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9849429294001679","opStatus":"SUCCESS","opTime":"2787 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-18 09:45:18 AUDIT audit:72 - {"time":"December 18, 2019 1:45:18 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9849432092310085","opStatus":"START"}
2019-12-18 09:45:19 AUDIT audit:72 - {"time":"December 18, 2019 1:45:19 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849432457436742","opStatus":"START"}
2019-12-18 09:45:21 AUDIT audit:93 - {"time":"December 18, 2019 1:45:21 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849432457436742","opStatus":"SUCCESS","opTime":"2010 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-18 09:45:21 AUDIT audit:93 - {"time":"December 18, 2019 1:45:21 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9849432092310085","opStatus":"SUCCESS","opTime":"2381 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-18 09:45:21 AUDIT audit:72 - {"time":"December 18, 2019 1:45:21 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9849434483784204","opStatus":"START"}
2019-12-18 09:45:21 AUDIT audit:72 - {"time":"December 18, 2019 1:45:21 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849434854630849","opStatus":"START"}
2019-12-18 09:45:23 AUDIT audit:93 - {"time":"December 18, 2019 1:45:23 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849434854630849","opStatus":"SUCCESS","opTime":"2210 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-18 09:45:23 AUDIT audit:93 - {"time":"December 18, 2019 1:45:23 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9849434483784204","opStatus":"SUCCESS","opTime":"2586 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-18 09:45:23 AUDIT audit:72 - {"time":"December 18, 2019 1:45:23 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9849437087988794","opStatus":"START"}
2019-12-18 09:45:24 AUDIT audit:72 - {"time":"December 18, 2019 1:45:24 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849437456927533","opStatus":"START"}
2019-12-18 09:45:26 AUDIT audit:93 - {"time":"December 18, 2019 1:45:26 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849437456927533","opStatus":"SUCCESS","opTime":"2003 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-18 09:45:26 AUDIT audit:93 - {"time":"December 18, 2019 1:45:26 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9849437087988794","opStatus":"SUCCESS","opTime":"2377 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-18 09:45:26 AUDIT audit:72 - {"time":"December 18, 2019 1:45:26 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9849439478081763","opStatus":"START"}
2019-12-18 09:45:26 AUDIT audit:72 - {"time":"December 18, 2019 1:45:26 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849439835588605","opStatus":"START"}
2019-12-18 09:45:28 AUDIT audit:93 - {"time":"December 18, 2019 1:45:28 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849439835588605","opStatus":"SUCCESS","opTime":"2042 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-18 09:45:28 AUDIT audit:93 - {"time":"December 18, 2019 1:45:28 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9849439478081763","opStatus":"SUCCESS","opTime":"2403 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-18 09:45:28 AUDIT audit:72 - {"time":"December 18, 2019 1:45:28 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9849441891483234","opStatus":"START"}
2019-12-18 09:45:28 AUDIT audit:72 - {"time":"December 18, 2019 1:45:28 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849442423668361","opStatus":"START"}
2019-12-18 09:45:31 AUDIT audit:93 - {"time":"December 18, 2019 1:45:31 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849442423668361","opStatus":"SUCCESS","opTime":"2072 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-18 09:45:31 AUDIT audit:93 - {"time":"December 18, 2019 1:45:31 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9849441891483234","opStatus":"SUCCESS","opTime":"2608 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-18 09:45:31 AUDIT audit:72 - {"time":"December 18, 2019 1:45:31 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9849444508198235","opStatus":"START"}
2019-12-18 09:45:31 AUDIT audit:72 - {"time":"December 18, 2019 1:45:31 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849444844280985","opStatus":"START"}
2019-12-18 09:45:33 AUDIT audit:93 - {"time":"December 18, 2019 1:45:33 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849444844280985","opStatus":"SUCCESS","opTime":"2036 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-18 09:45:33 AUDIT audit:93 - {"time":"December 18, 2019 1:45:33 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9849444508198235","opStatus":"SUCCESS","opTime":"2375 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-18 09:45:33 AUDIT audit:72 - {"time":"December 18, 2019 1:45:33 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9849446886204438","opStatus":"START"}
2019-12-18 09:45:33 AUDIT audit:72 - {"time":"December 18, 2019 1:45:33 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9849447011998421","opStatus":"START"}
2019-12-18 09:45:33 AUDIT audit:93 - {"time":"December 18, 2019 1:45:33 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9849447011998421","opStatus":"SUCCESS","opTime":"311 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-18 09:45:34 AUDIT audit:72 - {"time":"December 18, 2019 1:45:34 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9849447468029441","opStatus":"START"}
2019-12-18 09:45:34 AUDIT audit:93 - {"time":"December 18, 2019 1:45:34 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9849447468029441","opStatus":"SUCCESS","opTime":"22 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-18 09:45:34 AUDIT audit:93 - {"time":"December 18, 2019 1:45:34 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9849446886204438","opStatus":"SUCCESS","opTime":"640 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-18 09:45:34 AUDIT audit:72 - {"time":"December 18, 2019 1:45:34 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9849447534934805","opStatus":"START"}
2019-12-18 09:45:34 AUDIT audit:93 - {"time":"December 18, 2019 1:45:34 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9849447534934805","opStatus":"SUCCESS","opTime":"16 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
- Test data updation in Aggregate query after compaction on Partitioned table with mv table
2019-12-18 09:45:34 AUDIT audit:72 - {"time":"December 18, 2019 1:45:34 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9849448147435130","opStatus":"START"}
2019-12-18 09:45:34 AUDIT audit:93 - {"time":"December 18, 2019 1:45:34 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9849448147435130","opStatus":"SUCCESS","opTime":"237 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-18 09:45:34 AUDIT audit:72 - {"time":"December 18, 2019 1:45:34 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849448388495849","opStatus":"START"}
2019-12-18 09:45:35 AUDIT audit:93 - {"time":"December 18, 2019 1:45:35 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849448388495849","opStatus":"SUCCESS","opTime":"64 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-18 09:45:35 AUDIT audit:72 - {"time":"December 18, 2019 1:45:35 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9849448456815043","opStatus":"START"}
2019-12-18 09:45:35 AUDIT audit:72 - {"time":"December 18, 2019 1:45:35 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849448609770397","opStatus":"START"}
2019-12-18 09:45:35 AUDIT audit:93 - {"time":"December 18, 2019 1:45:35 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849448609770397","opStatus":"SUCCESS","opTime":"45 ms","table":"partition_mv.p7_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"p7"}}
2019-12-18 09:45:35 AUDIT audit:93 - {"time":"December 18, 2019 1:45:35 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9849448456815043","opStatus":"SUCCESS","opTime":"369 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p7"}}
2019-12-18 09:45:35 AUDIT audit:72 - {"time":"December 18, 2019 1:45:35 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9849448830051131","opStatus":"START"}
2019-12-18 09:45:35 AUDIT audit:72 - {"time":"December 18, 2019 1:45:35 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849448848911353","opStatus":"START"}
2019-12-18 09:45:35 AUDIT audit:93 - {"time":"December 18, 2019 1:45:35 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849448848911353","opStatus":"SUCCESS","opTime":"48 ms","table":"partition_mv.p1_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"p1"}}
2019-12-18 09:45:35 AUDIT audit:93 - {"time":"December 18, 2019 1:45:35 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9849448830051131","opStatus":"SUCCESS","opTime":"223 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p1"}}
2019-12-18 09:45:35 AUDIT audit:72 - {"time":"December 18, 2019 1:45:35 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9849449057473993","opStatus":"START"}
2019-12-18 09:45:35 AUDIT audit:72 - {"time":"December 18, 2019 1:45:35 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849449078680307","opStatus":"START"}
2019-12-18 09:45:35 AUDIT audit:93 - {"time":"December 18, 2019 1:45:35 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849449078680307","opStatus":"SUCCESS","opTime":"46 ms","table":"partition_mv.p2_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"p2"}}
2019-12-18 09:45:35 AUDIT audit:93 - {"time":"December 18, 2019 1:45:35 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9849449057473993","opStatus":"SUCCESS","opTime":"229 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p2"}}
2019-12-18 09:45:35 AUDIT audit:72 - {"time":"December 18, 2019 1:45:35 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9849449291645034","opStatus":"START"}
2019-12-18 09:45:35 AUDIT audit:72 - {"time":"December 18, 2019 1:45:35 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849449315059807","opStatus":"START"}
2019-12-18 09:45:35 AUDIT audit:93 - {"time":"December 18, 2019 1:45:35 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849449315059807","opStatus":"SUCCESS","opTime":"48 ms","table":"partition_mv.p3_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"p3"}}
2019-12-18 09:45:36 AUDIT audit:93 - {"time":"December 18, 2019 1:45:36 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9849449291645034","opStatus":"SUCCESS","opTime":"238 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p3"}}
2019-12-18 09:45:36 AUDIT audit:72 - {"time":"December 18, 2019 1:45:36 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9849449534103992","opStatus":"START"}
2019-12-18 09:45:36 AUDIT audit:72 - {"time":"December 18, 2019 1:45:36 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849449558475027","opStatus":"START"}
2019-12-18 09:45:36 AUDIT audit:93 - {"time":"December 18, 2019 1:45:36 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849449558475027","opStatus":"SUCCESS","opTime":"42 ms","table":"partition_mv.p4_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"p4"}}
2019-12-18 09:45:36 AUDIT audit:93 - {"time":"December 18, 2019 1:45:36 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9849449534103992","opStatus":"SUCCESS","opTime":"237 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p4"}}
2019-12-18 09:45:36 AUDIT audit:72 - {"time":"December 18, 2019 1:45:36 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9849449775502451","opStatus":"START"}
2019-12-18 09:45:36 AUDIT audit:72 - {"time":"December 18, 2019 1:45:36 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849449804679943","opStatus":"START"}
2019-12-18 09:45:36 AUDIT audit:93 - {"time":"December 18, 2019 1:45:36 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849449804679943","opStatus":"SUCCESS","opTime":"43 ms","table":"partition_mv.p5_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"p5"}}
2019-12-18 09:45:36 AUDIT audit:93 - {"time":"December 18, 2019 1:45:36 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9849449775502451","opStatus":"SUCCESS","opTime":"255 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p5"}}
2019-12-18 09:45:36 AUDIT audit:72 - {"time":"December 18, 2019 1:45:36 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9849450035305281","opStatus":"START"}
2019-12-18 09:45:36 AUDIT audit:72 - {"time":"December 18, 2019 1:45:36 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849450061617135","opStatus":"START"}
2019-12-18 09:45:36 AUDIT audit:93 - {"time":"December 18, 2019 1:45:36 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849450061617135","opStatus":"SUCCESS","opTime":"43 ms","table":"partition_mv.p6_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"p6"}}
2019-12-18 09:45:36 AUDIT audit:93 - {"time":"December 18, 2019 1:45:36 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9849450035305281","opStatus":"SUCCESS","opTime":"239 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p6"}}
2019-12-18 09:45:36 AUDIT audit:72 - {"time":"December 18, 2019 1:45:36 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9849450281455854","opStatus":"START"}
2019-12-18 09:45:37 AUDIT audit:93 - {"time":"December 18, 2019 1:45:37 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9849450281455854","opStatus":"SUCCESS","opTime":"605 ms","table":"partition_mv.partitionone","extraInfo":{}}
- check partitioning for child tables with various combinations
2019-12-18 09:45:37 AUDIT audit:72 - {"time":"December 18, 2019 1:45:37 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849450894866895","opStatus":"START"}
2019-12-18 09:45:37 AUDIT audit:93 - {"time":"December 18, 2019 1:45:37 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849450894866895","opStatus":"SUCCESS","opTime":"44 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-18 09:45:37 AUDIT audit:72 - {"time":"December 18, 2019 1:45:37 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9849451032452045","opStatus":"START"}
2019-12-18 09:45:38 AUDIT audit:93 - {"time":"December 18, 2019 1:45:38 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9849451032452045","opStatus":"SUCCESS","opTime":"405 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-18 09:45:38 AUDIT audit:72 - {"time":"December 18, 2019 1:45:38 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"9849451439644551","opStatus":"START"}
2019-12-18 09:45:38 AUDIT audit:93 - {"time":"December 18, 2019 1:45:38 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"9849451439644551","opStatus":"SUCCESS","opTime":"3 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-18 09:45:38 AUDIT audit:72 - {"time":"December 18, 2019 1:45:38 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9849451446495005","opStatus":"START"}
2019-12-18 09:45:38 AUDIT audit:72 - {"time":"December 18, 2019 1:45:38 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849451464625551","opStatus":"START"}
2019-12-18 09:45:38 AUDIT audit:93 - {"time":"December 18, 2019 1:45:38 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849451464625551","opStatus":"SUCCESS","opTime":"34 ms","table":"partition_mv.dm1_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"dm1"}}
2019-12-18 09:45:38 AUDIT audit:72 - {"time":"December 18, 2019 1:45:38 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849451674791225","opStatus":"START"}
2019-12-18 09:45:39 AUDIT audit:93 - {"time":"December 18, 2019 1:45:39 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849451674791225","opStatus":"SUCCESS","opTime":"1607 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-18 09:45:39 AUDIT audit:93 - {"time":"December 18, 2019 1:45:39 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9849451446495005","opStatus":"SUCCESS","opTime":"1848 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-18 09:45:40 AUDIT audit:72 - {"time":"December 18, 2019 1:45:40 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9849453770294468","opStatus":"START"}
2019-12-18 09:45:40 AUDIT audit:93 - {"time":"December 18, 2019 1:45:40 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9849453770294468","opStatus":"SUCCESS","opTime":"212 ms","table":"partition_mv.partitionone","extraInfo":{}}
- test partition at last column
2019-12-18 09:45:40 AUDIT audit:72 - {"time":"December 18, 2019 1:45:40 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849453989977848","opStatus":"START"}
2019-12-18 09:45:40 AUDIT audit:93 - {"time":"December 18, 2019 1:45:40 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849453989977848","opStatus":"SUCCESS","opTime":"47 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-18 09:45:40 AUDIT audit:72 - {"time":"December 18, 2019 1:45:40 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9849454135134567","opStatus":"START"}
2019-12-18 09:45:41 AUDIT audit:93 - {"time":"December 18, 2019 1:45:41 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9849454135134567","opStatus":"SUCCESS","opTime":"401 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-18 09:45:41 AUDIT audit:72 - {"time":"December 18, 2019 1:45:41 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"9849454538127969","opStatus":"START"}
2019-12-18 09:45:41 AUDIT audit:93 - {"time":"December 18, 2019 1:45:41 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"9849454538127969","opStatus":"SUCCESS","opTime":"4 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-18 09:45:41 AUDIT audit:72 - {"time":"December 18, 2019 1:45:41 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9849454545310430","opStatus":"START"}
2019-12-18 09:45:41 AUDIT audit:72 - {"time":"December 18, 2019 1:45:41 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849454567623447","opStatus":"START"}
2019-12-18 09:45:41 AUDIT audit:93 - {"time":"December 18, 2019 1:45:41 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849454567623447","opStatus":"SUCCESS","opTime":"45 ms","table":"partition_mv.dm1_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"dm1"}}
2019-12-18 09:45:41 AUDIT audit:72 - {"time":"December 18, 2019 1:45:41 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849454774259144","opStatus":"START"}
2019-12-18 09:45:42 AUDIT audit:93 - {"time":"December 18, 2019 1:45:42 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849454774259144","opStatus":"SUCCESS","opTime":"764 ms","table":"partition_mv.dm1_table","extraInfo":{"SegmentId":"0","DataSize":"666.0B","IndexSize":"435.0B"}}
2019-12-18 09:45:42 AUDIT audit:93 - {"time":"December 18, 2019 1:45:42 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9849454545310430","opStatus":"SUCCESS","opTime":"1004 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-18 09:45:42 AUDIT audit:72 - {"time":"December 18, 2019 1:45:42 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9849456009636147","opStatus":"START"}
2019-12-18 09:45:42 AUDIT audit:93 - {"time":"December 18, 2019 1:45:42 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9849456009636147","opStatus":"SUCCESS","opTime":"200 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-18 09:45:42 AUDIT audit:72 - {"time":"December 18, 2019 1:45:42 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849456212105818","opStatus":"START"}
2019-12-18 09:45:42 AUDIT audit:93 - {"time":"December 18, 2019 1:45:42 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849456212105818","opStatus":"SUCCESS","opTime":"78 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-18 09:45:42 AUDIT audit:72 - {"time":"December 18, 2019 1:45:42 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9849456380379098","opStatus":"START"}
2019-12-18 09:45:43 AUDIT audit:93 - {"time":"December 18, 2019 1:45:43 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9849456380379098","opStatus":"SUCCESS","opTime":"391 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-18 09:45:43 AUDIT audit:72 - {"time":"December 18, 2019 1:45:43 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"9849456773143260","opStatus":"START"}
2019-12-18 09:45:43 AUDIT audit:93 - {"time":"December 18, 2019 1:45:43 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"9849456773143260","opStatus":"SUCCESS","opTime":"3 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-18 09:45:43 AUDIT audit:72 - {"time":"December 18, 2019 1:45:43 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9849456778968044","opStatus":"START"}
2019-12-18 09:45:43 AUDIT audit:72 - {"time":"December 18, 2019 1:45:43 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849456795234193","opStatus":"START"}
2019-12-18 09:45:43 AUDIT audit:93 - {"time":"December 18, 2019 1:45:43 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9849456795234193","opStatus":"SUCCESS","opTime":"45 ms","table":"partition_mv.dm1_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"dm1"}}
2019-12-18 09:45:43 AUDIT audit:72 - {"time":"December 18, 2019 1:45:43 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849457002436220","opStatus":"START"}
2019-12-18 09:45:45 AUDIT audit:93 - {"time":"December 18, 2019 1:45:45 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9849457002436220","opStatus":"SUCCESS","opTime":"1575 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-18 09:45:45 AUDIT audit:93 - {"time":"December 18, 2019 1:45:45 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9849456778968044","opStatus":"SUCCESS","opTime":"1809 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-18 09:45:45 AUDIT audit:72 - {"time":"December 18, 2019 1:45:45 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9849459244336000","opStatus":"START"}
2019-12-18 09:45:45 AUDIT audit:93 - {"time":"December 18, 2019 1:45:45 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9849459244336000","opStatus":"SUCCESS","opTime":"176 ms","table":"partition_mv.partitionone","extraInfo":{}}
- test partition on timeseries column
2019-12-18 09:45:46 AUDIT audit:72 - {"time":"December 18, 2019 1:45:46 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9849459428157272","opStatus":"START"}
2019-12-18 09:45:46 AUDIT audit:93 - {"time":"December 18, 2019 1:45:46 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9849459428157272","opStatus":"SUCCESS","opTime":"2 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-18 09:45:46 AUDIT audit:72 - {"time":"December 18, 2019 1:45:46 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9849459429639820","opStatus":"START"}
2019-12-18 09:45:46 AUDIT audit:93 - {"time":"December 18, 2019 1:45:46 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9849459429639820","opStatus":"SUCCESS","opTime":"100 ms","table":"partition_mv.droppartition","extraInfo":{}}
2019-12-18 09:45:46 AUDIT audit:72 - {"time":"December 18, 2019 1:45:46 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9849459530373825","opStatus":"START"}
2019-12-18 09:45:46 AUDIT audit:93 - {"time":"December 18, 2019 1:45:46 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9849459530373825","opStatus":"SUCCESS","opTime":"139 ms","table":"partition_mv.maintable","extraInfo":{}}
2019-12-18 09:45:46 AUDIT audit:72 - {"time":"December 18, 2019 1:45:46 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9849459669928194","opStatus":"START"}
2019-12-18 09:45:46 AUDIT audit:93 - {"time":"December 18, 2019 1:45:46 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9849459669928194","opStatus":"SUCCESS","opTime":"57 ms","table":"partition_mv.par","extraInfo":{}}
2019-12-18 09:45:46 AUDIT audit:72 - {"time":"December 18, 2019 1:45:46 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9849459727025792","opStatus":"START"}
2019-12-18 09:45:46 AUDIT audit:93 - {"time":"December 18, 2019 1:45:46 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9849459727025792","opStatus":"SUCCESS","opTime":"130 ms","table":"partition_mv.partitiontable","extraInfo":{}}
2019-12-18 09:45:46 AUDIT audit:72 - {"time":"December 18, 2019 1:45:46 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9849459857135072","opStatus":"START"}
2019-12-18 09:45:46 AUDIT audit:93 - {"time":"December 18, 2019 1:45:46 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9849459857135072","opStatus":"SUCCESS","opTime":"255 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
MVTPCDSTestCase:
- test create datamap with tpcds_1_4_testCases case_1 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_3 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_4 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_5 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_6 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_8 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_11 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_15 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_16 !!! IGNORED !!!
Run completed in 11 minutes, 31 seconds.
Total number of tests run: 224
Suites: completed 21, aborted 0
Tests: succeeded 222, failed 2, canceled 0, ignored 27, pending 0
*** 2 TESTS FAILED ***
[JENKINS] Recording test results