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/29 12:20:25 UTC

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

See <https://builds.apache.org/job/carbondata-master-spark-2.2/org.apache.carbondata$carbondata-mv-core/2156/display/redirect?page=changes>

Changes:

[jacky.likun] [CARBONDATA-3629] Fix Select query failure on aggregation of same column


------------------------------------------
[...truncated 1.15 MB...]
2019-12-29 12:14:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:17 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:18 AUDIT audit:72 - {"time":"December 29, 2019 4:14:18 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307707169463614","opStatus":"START"}
2019-12-29 12:14:21 AUDIT audit:93 - {"time":"December 29, 2019 4:14:21 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307707169463614","opStatus":"SUCCESS","opTime":"3173 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 12:14:21 AUDIT audit:93 - {"time":"December 29, 2019 4:14:21 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5307705820329484","opStatus":"SUCCESS","opTime":"4531 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 12:14:21 AUDIT audit:72 - {"time":"December 29, 2019 4:14:21 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5307710354375071","opStatus":"START"}
2019-12-29 12:14:21 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:21 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:21 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:21 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:22 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:22 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:22 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:22 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:22 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:22 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:22 AUDIT audit:72 - {"time":"December 29, 2019 4:14:22 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307711608779808","opStatus":"START"}
2019-12-29 12:14:25 AUDIT audit:93 - {"time":"December 29, 2019 4:14:25 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307711608779808","opStatus":"SUCCESS","opTime":"3044 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 12:14:25 AUDIT audit:93 - {"time":"December 29, 2019 4:14:25 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5307710354375071","opStatus":"SUCCESS","opTime":"4309 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 12:14:25 AUDIT audit:72 - {"time":"December 29, 2019 4:14:25 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5307714670750868","opStatus":"START"}
2019-12-29 12:14:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:26 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:27 AUDIT audit:72 - {"time":"December 29, 2019 4:14:27 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307716023748268","opStatus":"START"}
2019-12-29 12:14:30 AUDIT audit:93 - {"time":"December 29, 2019 4:14:30 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307716023748268","opStatus":"SUCCESS","opTime":"2946 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 12:14:30 AUDIT audit:93 - {"time":"December 29, 2019 4:14:30 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5307714670750868","opStatus":"SUCCESS","opTime":"4308 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 12:14:30 AUDIT audit:72 - {"time":"December 29, 2019 4:14:30 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5307718983114915","opStatus":"START"}
2019-12-29 12:14:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:30 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:31 AUDIT audit:72 - {"time":"December 29, 2019 4:14:31 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307720331581004","opStatus":"START"}
2019-12-29 12:14:34 AUDIT audit:93 - {"time":"December 29, 2019 4:14:34 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307720331581004","opStatus":"SUCCESS","opTime":"2963 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 12:14:34 AUDIT audit:93 - {"time":"December 29, 2019 4:14:34 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5307718983114915","opStatus":"SUCCESS","opTime":"4319 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 12:14:34 AUDIT audit:72 - {"time":"December 29, 2019 4:14:34 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5307723305888674","opStatus":"START"}
2019-12-29 12:14:34 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:34 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:34 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:34 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:35 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:35 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:35 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:35 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:35 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:36 AUDIT audit:72 - {"time":"December 29, 2019 4:14:36 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307725130280424","opStatus":"START"}
2019-12-29 12:14:39 AUDIT audit:93 - {"time":"December 29, 2019 4:14:39 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307725130280424","opStatus":"SUCCESS","opTime":"2957 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 12:14:39 AUDIT audit:93 - {"time":"December 29, 2019 4:14:39 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5307723305888674","opStatus":"SUCCESS","opTime":"4792 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 12:14:39 AUDIT audit:72 - {"time":"December 29, 2019 4:14:39 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5307728102562188","opStatus":"START"}
2019-12-29 12:14:39 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:39 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:39 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:39 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:39 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:39 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:40 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:40 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:40 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:40 AUDIT audit:72 - {"time":"December 29, 2019 4:14:40 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307729487476132","opStatus":"START"}
2019-12-29 12:14:43 AUDIT audit:93 - {"time":"December 29, 2019 4:14:43 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307729487476132","opStatus":"SUCCESS","opTime":"2982 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 12:14:43 AUDIT audit:93 - {"time":"December 29, 2019 4:14:43 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5307728102562188","opStatus":"SUCCESS","opTime":"4377 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 12:14:43 AUDIT audit:72 - {"time":"December 29, 2019 4:14:43 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5307732483413201","opStatus":"START"}
2019-12-29 12:14:43 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:43 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:44 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:44 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:44 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:44 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:44 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:44 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:44 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 12:14:44 AUDIT audit:72 - {"time":"December 29, 2019 4:14:44 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307733733528093","opStatus":"START"}
2019-12-29 12:14:48 AUDIT audit:93 - {"time":"December 29, 2019 4:14:48 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307733733528093","opStatus":"SUCCESS","opTime":"3247 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 12:14:48 AUDIT audit:93 - {"time":"December 29, 2019 4:14:48 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5307732483413201","opStatus":"SUCCESS","opTime":"4504 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 12:14:48 AUDIT audit:72 - {"time":"December 29, 2019 4:14:48 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5307736990773258","opStatus":"START"}
2019-12-29 12:14:49 AUDIT audit:72 - {"time":"December 29, 2019 4:14:49 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5307738296615790","opStatus":"START"}
2019-12-29 12:14:50 AUDIT audit:93 - {"time":"December 29, 2019 4:14:50 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5307738296615790","opStatus":"SUCCESS","opTime":"1587 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 12:14:51 AUDIT audit:93 - {"time":"December 29, 2019 4:14:51 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5307736990773258","opStatus":"SUCCESS","opTime":"3132 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 12:14:51 AUDIT audit:72 - {"time":"December 29, 2019 4:14:51 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5307740373933248","opStatus":"START"}
2019-12-29 12:14:53 AUDIT audit:93 - {"time":"December 29, 2019 4:14:53 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5307740373933248","opStatus":"SUCCESS","opTime":"1730 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
[32m- Test data updation after compaction on Partition with mv tables[0m
2019-12-29 12:14:53 AUDIT audit:72 - {"time":"December 29, 2019 4:14:53 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307742116467616","opStatus":"START"}
2019-12-29 12:14:53 AUDIT audit:93 - {"time":"December 29, 2019 4:14:53 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307742116467616","opStatus":"SUCCESS","opTime":"100 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-29 12:14:53 AUDIT audit:72 - {"time":"December 29, 2019 4:14:53 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5307742219613976","opStatus":"START"}
2019-12-29 12:14:53 AUDIT audit:93 - {"time":"December 29, 2019 4:14:53 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5307742219613976","opStatus":"SUCCESS","opTime":"5 ms","table":"NA","extraInfo":{"dmName":"ag"}}
2019-12-29 12:14:53 AUDIT audit:72 - {"time":"December 29, 2019 4:14:53 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5307742229158098","opStatus":"START"}
2019-12-29 12:14:53 AUDIT audit:72 - {"time":"December 29, 2019 4:14:53 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307742539020258","opStatus":"START"}
2019-12-29 12:14:53 AUDIT audit:93 - {"time":"December 29, 2019 4:14:53 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307742539020258","opStatus":"SUCCESS","opTime":"53 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-29 12:14:53 AUDIT audit:93 - {"time":"December 29, 2019 4:14:53 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5307742229158098","opStatus":"SUCCESS","opTime":"646 ms","table":"partition_mv.updatetime_8","extraInfo":{"provider":"mv","dmName":"ag"}}
2019-12-29 12:14:53 AUDIT audit:72 - {"time":"December 29, 2019 4:14:53 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5307742889610739","opStatus":"START"}
2019-12-29 12:14:54 AUDIT audit:72 - {"time":"December 29, 2019 4:14:54 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307743686338063","opStatus":"START"}
2019-12-29 12:14:58 AUDIT audit:93 - {"time":"December 29, 2019 4:14:58 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307743686338063","opStatus":"SUCCESS","opTime":"3541 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 12:14:58 AUDIT audit:93 - {"time":"December 29, 2019 4:14:58 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5307742889610739","opStatus":"SUCCESS","opTime":"4349 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 12:14:58 AUDIT audit:72 - {"time":"December 29, 2019 4:14:58 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5307747254216875","opStatus":"START"}
2019-12-29 12:14:58 AUDIT audit:72 - {"time":"December 29, 2019 4:14:58 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307747825697746","opStatus":"START"}
2019-12-29 12:15:02 AUDIT audit:93 - {"time":"December 29, 2019 4:15:02 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307747825697746","opStatus":"SUCCESS","opTime":"3509 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 12:15:02 AUDIT audit:93 - {"time":"December 29, 2019 4:15:02 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5307747254216875","opStatus":"SUCCESS","opTime":"4091 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 12:15:02 AUDIT audit:72 - {"time":"December 29, 2019 4:15:02 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5307751358002362","opStatus":"START"}
2019-12-29 12:15:03 AUDIT audit:72 - {"time":"December 29, 2019 4:15:03 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307751995042824","opStatus":"START"}
2019-12-29 12:15:06 AUDIT audit:93 - {"time":"December 29, 2019 4:15:06 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307751995042824","opStatus":"SUCCESS","opTime":"3293 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 12:15:06 AUDIT audit:93 - {"time":"December 29, 2019 4:15:06 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5307751358002362","opStatus":"SUCCESS","opTime":"3942 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 12:15:06 AUDIT audit:72 - {"time":"December 29, 2019 4:15:06 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5307755312643557","opStatus":"START"}
2019-12-29 12:15:06 AUDIT audit:72 - {"time":"December 29, 2019 4:15:06 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307755807618899","opStatus":"START"}
2019-12-29 12:15:10 AUDIT audit:93 - {"time":"December 29, 2019 4:15:10 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307755807618899","opStatus":"SUCCESS","opTime":"3249 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 12:15:10 AUDIT audit:93 - {"time":"December 29, 2019 4:15:10 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5307755312643557","opStatus":"SUCCESS","opTime":"3756 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 12:15:10 AUDIT audit:72 - {"time":"December 29, 2019 4:15:10 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5307759083366944","opStatus":"START"}
2019-12-29 12:15:10 AUDIT audit:72 - {"time":"December 29, 2019 4:15:10 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307759558606814","opStatus":"START"}
2019-12-29 12:15:14 AUDIT audit:93 - {"time":"December 29, 2019 4:15:14 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307759558606814","opStatus":"SUCCESS","opTime":"3452 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 12:15:14 AUDIT audit:93 - {"time":"December 29, 2019 4:15:14 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5307759083366944","opStatus":"SUCCESS","opTime":"3938 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 12:15:14 AUDIT audit:72 - {"time":"December 29, 2019 4:15:14 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5307763036344170","opStatus":"START"}
2019-12-29 12:15:14 AUDIT audit:72 - {"time":"December 29, 2019 4:15:14 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307763508808674","opStatus":"START"}
2019-12-29 12:15:17 AUDIT audit:93 - {"time":"December 29, 2019 4:15:17 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307763508808674","opStatus":"SUCCESS","opTime":"3407 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 12:15:17 AUDIT audit:93 - {"time":"December 29, 2019 4:15:17 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5307763036344170","opStatus":"SUCCESS","opTime":"3891 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 12:15:17 AUDIT audit:72 - {"time":"December 29, 2019 4:15:17 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5307766936743092","opStatus":"START"}
2019-12-29 12:15:18 AUDIT audit:72 - {"time":"December 29, 2019 4:15:18 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307767500749761","opStatus":"START"}
2019-12-29 12:15:22 AUDIT audit:93 - {"time":"December 29, 2019 4:15:22 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307767500749761","opStatus":"SUCCESS","opTime":"3530 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 12:15:22 AUDIT audit:93 - {"time":"December 29, 2019 4:15:22 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5307766936743092","opStatus":"SUCCESS","opTime":"4106 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 12:15:22 AUDIT audit:72 - {"time":"December 29, 2019 4:15:22 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5307771057814849","opStatus":"START"}
2019-12-29 12:15:22 AUDIT audit:72 - {"time":"December 29, 2019 4:15:22 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307771620218379","opStatus":"START"}
2019-12-29 12:15:26 AUDIT audit:93 - {"time":"December 29, 2019 4:15:26 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307771620218379","opStatus":"SUCCESS","opTime":"3560 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 12:15:26 AUDIT audit:93 - {"time":"December 29, 2019 4:15:26 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5307771057814849","opStatus":"SUCCESS","opTime":"4134 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 12:15:26 AUDIT audit:72 - {"time":"December 29, 2019 4:15:26 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5307775194006963","opStatus":"START"}
2019-12-29 12:15:26 AUDIT audit:72 - {"time":"December 29, 2019 4:15:26 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5307775369190866","opStatus":"START"}
2019-12-29 12:15:26 AUDIT audit:93 - {"time":"December 29, 2019 4:15:26 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5307775369190866","opStatus":"SUCCESS","opTime":"470 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 12:15:27 AUDIT audit:72 - {"time":"December 29, 2019 4:15:27 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5307776036439058","opStatus":"START"}
2019-12-29 12:15:27 AUDIT audit:93 - {"time":"December 29, 2019 4:15:27 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5307776036439058","opStatus":"SUCCESS","opTime":"25 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 12:15:27 AUDIT audit:93 - {"time":"December 29, 2019 4:15:27 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5307775194006963","opStatus":"SUCCESS","opTime":"927 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 12:15:27 AUDIT audit:72 - {"time":"December 29, 2019 4:15:27 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5307776133197729","opStatus":"START"}
2019-12-29 12:15:27 AUDIT audit:93 - {"time":"December 29, 2019 4:15:27 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5307776133197729","opStatus":"SUCCESS","opTime":"25 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
[32m- Test data updation in Aggregate query after compaction on Partitioned table with mv table[0m
2019-12-29 12:15:28 AUDIT audit:72 - {"time":"December 29, 2019 4:15:28 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5307776991005786","opStatus":"START"}
2019-12-29 12:15:28 AUDIT audit:93 - {"time":"December 29, 2019 4:15:28 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5307776991005786","opStatus":"SUCCESS","opTime":"387 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 12:15:28 AUDIT audit:72 - {"time":"December 29, 2019 4:15:28 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307777382545833","opStatus":"START"}
2019-12-29 12:15:28 AUDIT audit:93 - {"time":"December 29, 2019 4:15:28 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307777382545833","opStatus":"SUCCESS","opTime":"72 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 12:15:28 AUDIT audit:72 - {"time":"December 29, 2019 4:15:28 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5307777459049331","opStatus":"START"}
2019-12-29 12:15:28 AUDIT audit:72 - {"time":"December 29, 2019 4:15:28 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307777741584099","opStatus":"START"}
2019-12-29 12:15:28 AUDIT audit:93 - {"time":"December 29, 2019 4:15:28 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307777741584099","opStatus":"SUCCESS","opTime":"63 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-29 12:15:29 AUDIT audit:93 - {"time":"December 29, 2019 4:15:29 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5307777459049331","opStatus":"SUCCESS","opTime":"626 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p7"}}
2019-12-29 12:15:29 AUDIT audit:72 - {"time":"December 29, 2019 4:15:29 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5307778090039042","opStatus":"START"}
2019-12-29 12:15:29 AUDIT audit:72 - {"time":"December 29, 2019 4:15:29 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307778125851277","opStatus":"START"}
2019-12-29 12:15:29 AUDIT audit:93 - {"time":"December 29, 2019 4:15:29 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307778125851277","opStatus":"SUCCESS","opTime":"63 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-29 12:15:29 AUDIT audit:93 - {"time":"December 29, 2019 4:15:29 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5307778090039042","opStatus":"SUCCESS","opTime":"399 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p1"}}
2019-12-29 12:15:29 AUDIT audit:72 - {"time":"December 29, 2019 4:15:29 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5307778494517791","opStatus":"START"}
2019-12-29 12:15:29 AUDIT audit:72 - {"time":"December 29, 2019 4:15:29 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307778522025309","opStatus":"START"}
2019-12-29 12:15:29 AUDIT audit:93 - {"time":"December 29, 2019 4:15:29 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307778522025309","opStatus":"SUCCESS","opTime":"49 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-29 12:15:29 AUDIT audit:93 - {"time":"December 29, 2019 4:15:29 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5307778494517791","opStatus":"SUCCESS","opTime":"380 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p2"}}
2019-12-29 12:15:29 AUDIT audit:72 - {"time":"December 29, 2019 4:15:29 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5307778879917823","opStatus":"START"}
2019-12-29 12:15:29 AUDIT audit:72 - {"time":"December 29, 2019 4:15:29 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307778920918302","opStatus":"START"}
2019-12-29 12:15:30 AUDIT audit:93 - {"time":"December 29, 2019 4:15:30 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307778920918302","opStatus":"SUCCESS","opTime":"67 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-29 12:15:30 AUDIT audit:93 - {"time":"December 29, 2019 4:15:30 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5307778879917823","opStatus":"SUCCESS","opTime":"425 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p3"}}
2019-12-29 12:15:30 AUDIT audit:72 - {"time":"December 29, 2019 4:15:30 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5307779308790709","opStatus":"START"}
2019-12-29 12:15:30 AUDIT audit:72 - {"time":"December 29, 2019 4:15:30 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307779343310498","opStatus":"START"}
2019-12-29 12:15:30 AUDIT audit:93 - {"time":"December 29, 2019 4:15:30 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307779343310498","opStatus":"SUCCESS","opTime":"53 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-29 12:15:30 AUDIT audit:93 - {"time":"December 29, 2019 4:15:30 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5307779308790709","opStatus":"SUCCESS","opTime":"382 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p4"}}
2019-12-29 12:15:30 AUDIT audit:72 - {"time":"December 29, 2019 4:15:30 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5307779696107908","opStatus":"START"}
2019-12-29 12:15:30 AUDIT audit:72 - {"time":"December 29, 2019 4:15:30 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307779739383845","opStatus":"START"}
2019-12-29 12:15:30 AUDIT audit:93 - {"time":"December 29, 2019 4:15:30 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307779739383845","opStatus":"SUCCESS","opTime":"58 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-29 12:15:31 AUDIT audit:93 - {"time":"December 29, 2019 4:15:31 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5307779696107908","opStatus":"SUCCESS","opTime":"394 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p5"}}
2019-12-29 12:15:31 AUDIT audit:72 - {"time":"December 29, 2019 4:15:31 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5307780096496104","opStatus":"START"}
2019-12-29 12:15:31 AUDIT audit:72 - {"time":"December 29, 2019 4:15:31 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307780144873087","opStatus":"START"}
2019-12-29 12:15:31 AUDIT audit:93 - {"time":"December 29, 2019 4:15:31 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307780144873087","opStatus":"SUCCESS","opTime":"60 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-29 12:15:31 AUDIT audit:93 - {"time":"December 29, 2019 4:15:31 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5307780096496104","opStatus":"SUCCESS","opTime":"404 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p6"}}
2019-12-29 12:15:31 AUDIT audit:72 - {"time":"December 29, 2019 4:15:31 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5307780512329955","opStatus":"START"}
2019-12-29 12:15:32 AUDIT audit:93 - {"time":"December 29, 2019 4:15:32 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5307780512329955","opStatus":"SUCCESS","opTime":"1163 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- check partitioning for child tables with various combinations[0m
2019-12-29 12:15:32 AUDIT audit:72 - {"time":"December 29, 2019 4:15:32 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307781685569749","opStatus":"START"}
2019-12-29 12:15:32 AUDIT audit:93 - {"time":"December 29, 2019 4:15:32 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307781685569749","opStatus":"SUCCESS","opTime":"53 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 12:15:33 AUDIT audit:72 - {"time":"December 29, 2019 4:15:33 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5307781946861876","opStatus":"START"}
2019-12-29 12:15:33 AUDIT audit:93 - {"time":"December 29, 2019 4:15:33 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5307781946861876","opStatus":"SUCCESS","opTime":"585 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 12:15:33 AUDIT audit:72 - {"time":"December 29, 2019 4:15:33 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5307782533915858","opStatus":"START"}
2019-12-29 12:15:33 AUDIT audit:93 - {"time":"December 29, 2019 4:15:33 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5307782533915858","opStatus":"SUCCESS","opTime":"5 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-29 12:15:33 AUDIT audit:72 - {"time":"December 29, 2019 4:15:33 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5307782542385648","opStatus":"START"}
2019-12-29 12:15:33 AUDIT audit:72 - {"time":"December 29, 2019 4:15:33 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307782580241700","opStatus":"START"}
2019-12-29 12:15:33 AUDIT audit:93 - {"time":"December 29, 2019 4:15:33 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307782580241700","opStatus":"SUCCESS","opTime":"50 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-29 12:15:34 AUDIT audit:72 - {"time":"December 29, 2019 4:15:34 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307782954222465","opStatus":"START"}
2019-12-29 12:15:36 AUDIT audit:93 - {"time":"December 29, 2019 4:15:36 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307782954222465","opStatus":"SUCCESS","opTime":"2735 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-29 12:15:36 AUDIT audit:93 - {"time":"December 29, 2019 4:15:36 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5307782542385648","opStatus":"SUCCESS","opTime":"3165 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-29 12:15:37 AUDIT audit:72 - {"time":"December 29, 2019 4:15:37 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5307786794374570","opStatus":"START"}
2019-12-29 12:15:38 AUDIT audit:93 - {"time":"December 29, 2019 4:15:38 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5307786794374570","opStatus":"SUCCESS","opTime":"356 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- test partition at last column[0m
2019-12-29 12:15:38 AUDIT audit:72 - {"time":"December 29, 2019 4:15:38 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307787162956285","opStatus":"START"}
2019-12-29 12:15:38 AUDIT audit:93 - {"time":"December 29, 2019 4:15:38 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307787162956285","opStatus":"SUCCESS","opTime":"49 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 12:15:38 AUDIT audit:72 - {"time":"December 29, 2019 4:15:38 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5307787425859048","opStatus":"START"}
2019-12-29 12:15:39 AUDIT audit:93 - {"time":"December 29, 2019 4:15:39 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5307787425859048","opStatus":"SUCCESS","opTime":"597 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 12:15:39 AUDIT audit:72 - {"time":"December 29, 2019 4:15:39 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5307788025082372","opStatus":"START"}
2019-12-29 12:15:39 AUDIT audit:93 - {"time":"December 29, 2019 4:15:39 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5307788025082372","opStatus":"SUCCESS","opTime":"4 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-29 12:15:39 AUDIT audit:72 - {"time":"December 29, 2019 4:15:39 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5307788034140047","opStatus":"START"}
2019-12-29 12:15:39 AUDIT audit:72 - {"time":"December 29, 2019 4:15:39 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307788079081210","opStatus":"START"}
2019-12-29 12:15:39 AUDIT audit:93 - {"time":"December 29, 2019 4:15:39 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307788079081210","opStatus":"SUCCESS","opTime":"84 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-29 12:15:39 AUDIT audit:72 - {"time":"December 29, 2019 4:15:39 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307788478497882","opStatus":"START"}
2019-12-29 12:15:40 AUDIT audit:93 - {"time":"December 29, 2019 4:15:40 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307788478497882","opStatus":"SUCCESS","opTime":"1290 ms","table":"partition_mv.dm1_table","extraInfo":{"SegmentId":"0","DataSize":"688.0B","IndexSize":"446.0B"}}
2019-12-29 12:15:40 AUDIT audit:93 - {"time":"December 29, 2019 4:15:40 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5307788034140047","opStatus":"SUCCESS","opTime":"1752 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-29 12:15:41 AUDIT audit:72 - {"time":"December 29, 2019 4:15:41 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5307790561018471","opStatus":"START"}
2019-12-29 12:15:42 AUDIT audit:93 - {"time":"December 29, 2019 4:15:42 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5307790561018471","opStatus":"SUCCESS","opTime":"401 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 12:15:42 AUDIT audit:72 - {"time":"December 29, 2019 4:15:42 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307790966457495","opStatus":"START"}
2019-12-29 12:15:42 AUDIT audit:93 - {"time":"December 29, 2019 4:15:42 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307790966457495","opStatus":"SUCCESS","opTime":"200 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 12:15:42 AUDIT audit:72 - {"time":"December 29, 2019 4:15:42 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5307791363095770","opStatus":"START"}
2019-12-29 12:15:42 AUDIT audit:93 - {"time":"December 29, 2019 4:15:42 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5307791363095770","opStatus":"SUCCESS","opTime":"567 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 12:15:42 AUDIT audit:72 - {"time":"December 29, 2019 4:15:42 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5307791932705743","opStatus":"START"}
2019-12-29 12:15:42 AUDIT audit:93 - {"time":"December 29, 2019 4:15:42 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5307791932705743","opStatus":"SUCCESS","opTime":"5 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-29 12:15:42 AUDIT audit:72 - {"time":"December 29, 2019 4:15:42 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5307791943390176","opStatus":"START"}
2019-12-29 12:15:43 AUDIT audit:72 - {"time":"December 29, 2019 4:15:43 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307791982225382","opStatus":"START"}
2019-12-29 12:15:43 AUDIT audit:93 - {"time":"December 29, 2019 4:15:43 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5307791982225382","opStatus":"SUCCESS","opTime":"56 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-29 12:15:43 AUDIT audit:72 - {"time":"December 29, 2019 4:15:43 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307792314217887","opStatus":"START"}
2019-12-29 12:15:45 AUDIT audit:93 - {"time":"December 29, 2019 4:15:45 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5307792314217887","opStatus":"SUCCESS","opTime":"2357 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-29 12:15:45 AUDIT audit:93 - {"time":"December 29, 2019 4:15:45 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5307791943390176","opStatus":"SUCCESS","opTime":"2744 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-29 12:15:46 AUDIT audit:72 - {"time":"December 29, 2019 4:15:46 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5307795613785387","opStatus":"START"}
2019-12-29 12:15:47 AUDIT audit:93 - {"time":"December 29, 2019 4:15:47 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5307795613785387","opStatus":"SUCCESS","opTime":"401 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- test partition on timeseries column[0m
2019-12-29 12:15:47 AUDIT audit:72 - {"time":"December 29, 2019 4:15:47 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5307796025495931","opStatus":"START"}
2019-12-29 12:15:47 AUDIT audit:93 - {"time":"December 29, 2019 4:15:47 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5307796025495931","opStatus":"SUCCESS","opTime":"1 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 12:15:47 AUDIT audit:72 - {"time":"December 29, 2019 4:15:47 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5307796027302681","opStatus":"START"}
2019-12-29 12:15:47 AUDIT audit:93 - {"time":"December 29, 2019 4:15:47 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5307796027302681","opStatus":"SUCCESS","opTime":"172 ms","table":"partition_mv.droppartition","extraInfo":{}}
2019-12-29 12:15:47 AUDIT audit:72 - {"time":"December 29, 2019 4:15:47 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5307796199816469","opStatus":"START"}
2019-12-29 12:15:47 AUDIT audit:93 - {"time":"December 29, 2019 4:15:47 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5307796199816469","opStatus":"SUCCESS","opTime":"298 ms","table":"partition_mv.maintable","extraInfo":{}}
2019-12-29 12:15:47 AUDIT audit:72 - {"time":"December 29, 2019 4:15:47 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5307796498927550","opStatus":"START"}
2019-12-29 12:15:47 AUDIT audit:93 - {"time":"December 29, 2019 4:15:47 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5307796498927550","opStatus":"SUCCESS","opTime":"118 ms","table":"partition_mv.par","extraInfo":{}}
2019-12-29 12:15:47 AUDIT audit:72 - {"time":"December 29, 2019 4:15:47 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5307796617574673","opStatus":"START"}
2019-12-29 12:15:47 AUDIT audit:93 - {"time":"December 29, 2019 4:15:47 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5307796617574673","opStatus":"SUCCESS","opTime":"287 ms","table":"partition_mv.partitiontable","extraInfo":{}}
2019-12-29 12:15:47 AUDIT audit:72 - {"time":"December 29, 2019 4:15:47 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5307796905611711","opStatus":"START"}
2019-12-29 12:15:48 AUDIT audit:93 - {"time":"December 29, 2019 4:15:48 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5307796905611711","opStatus":"SUCCESS","opTime":"645 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
[32mMVTPCDSTestCase:[0m
[33m- test create datamap with tpcds_1_4_testCases case_1 !!! IGNORED !!![0m
[33m- test create datamap with tpcds_1_4_testCases case_3 !!! IGNORED !!![0m
[33m- test create datamap with tpcds_1_4_testCases case_4 !!! IGNORED !!![0m
[33m- test create datamap with tpcds_1_4_testCases case_5 !!! IGNORED !!![0m
[33m- test create datamap with tpcds_1_4_testCases case_6 !!! IGNORED !!![0m
[33m- test create datamap with tpcds_1_4_testCases case_8 !!! IGNORED !!![0m
[33m- test create datamap with tpcds_1_4_testCases case_11 !!! IGNORED !!![0m
[33m- test create datamap with tpcds_1_4_testCases case_15 !!! IGNORED !!![0m
[33m- test create datamap with tpcds_1_4_testCases case_16 !!! IGNORED !!![0m
[36mRun completed in 18 minutes, 44 seconds.[0m
[36mTotal number of tests run: 234[0m
[36mSuites: completed 21, aborted 0[0m
[36mTests: succeeded 233, failed 1, canceled 0, ignored 18, pending 0[0m
[31m*** 1 TEST FAILED ***[0m
[JENKINS] Recording test results

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

Posted by Apache Jenkins Server <je...@builds.apache.org>.

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

Changes:


------------------------------------------
[...truncated 1.15 MB...]
2019-12-29 13:52:07 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:07 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:07 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:07 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:08 AUDIT audit:72 - {"time":"December 29, 2019 5:52:08 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313577216219898","opStatus":"START"}
2019-12-29 13:52:11 AUDIT audit:93 - {"time":"December 29, 2019 5:52:11 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313577216219898","opStatus":"SUCCESS","opTime":"3297 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 13:52:11 AUDIT audit:93 - {"time":"December 29, 2019 5:52:11 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5313575715770732","opStatus":"SUCCESS","opTime":"4805 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 13:52:11 AUDIT audit:72 - {"time":"December 29, 2019 5:52:11 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5313580524689566","opStatus":"START"}
2019-12-29 13:52:11 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:12 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:12 AUDIT audit:72 - {"time":"December 29, 2019 5:52:12 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313581688957219","opStatus":"START"}
2019-12-29 13:52:15 AUDIT audit:93 - {"time":"December 29, 2019 5:52:15 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313581688957219","opStatus":"SUCCESS","opTime":"3229 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 13:52:15 AUDIT audit:93 - {"time":"December 29, 2019 5:52:15 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5313580524689566","opStatus":"SUCCESS","opTime":"4402 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 13:52:15 AUDIT audit:72 - {"time":"December 29, 2019 5:52:15 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5313584935072957","opStatus":"START"}
2019-12-29 13:52:16 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:16 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:16 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:16 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:16 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:16 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:16 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:16 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:16 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:17 AUDIT audit:72 - {"time":"December 29, 2019 5:52:17 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313586265622799","opStatus":"START"}
2019-12-29 13:52:20 AUDIT audit:93 - {"time":"December 29, 2019 5:52:20 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313586265622799","opStatus":"SUCCESS","opTime":"2992 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 13:52:20 AUDIT audit:93 - {"time":"December 29, 2019 5:52:20 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5313584935072957","opStatus":"SUCCESS","opTime":"4333 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 13:52:20 AUDIT audit:72 - {"time":"December 29, 2019 5:52:20 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5313589272708839","opStatus":"START"}
2019-12-29 13:52:20 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:20 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:20 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:20 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:20 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:21 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:21 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:21 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:21 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:21 AUDIT audit:72 - {"time":"December 29, 2019 5:52:21 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313590522007148","opStatus":"START"}
2019-12-29 13:52:24 AUDIT audit:93 - {"time":"December 29, 2019 5:52:24 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313590522007148","opStatus":"SUCCESS","opTime":"3211 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 13:52:24 AUDIT audit:93 - {"time":"December 29, 2019 5:52:24 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5313589272708839","opStatus":"SUCCESS","opTime":"4471 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 13:52:24 AUDIT audit:72 - {"time":"December 29, 2019 5:52:24 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5313593747400087","opStatus":"START"}
2019-12-29 13:52:25 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:25 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:25 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:25 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:25 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:25 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:25 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:25 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:25 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:26 AUDIT audit:72 - {"time":"December 29, 2019 5:52:26 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313595027109698","opStatus":"START"}
2019-12-29 13:52:30 AUDIT audit:93 - {"time":"December 29, 2019 5:52:30 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313595027109698","opStatus":"SUCCESS","opTime":"4079 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 13:52:30 AUDIT audit:93 - {"time":"December 29, 2019 5:52:30 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5313593747400087","opStatus":"SUCCESS","opTime":"5365 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 13:52:30 AUDIT audit:72 - {"time":"December 29, 2019 5:52:30 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5313599115424468","opStatus":"START"}
2019-12-29 13:52:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:30 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:31 AUDIT audit:72 - {"time":"December 29, 2019 5:52:31 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313600452107544","opStatus":"START"}
2019-12-29 13:52:34 AUDIT audit:93 - {"time":"December 29, 2019 5:52:34 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313600452107544","opStatus":"SUCCESS","opTime":"3372 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 13:52:34 AUDIT audit:93 - {"time":"December 29, 2019 5:52:34 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5313599115424468","opStatus":"SUCCESS","opTime":"4719 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 13:52:34 AUDIT audit:72 - {"time":"December 29, 2019 5:52:34 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5313603837988438","opStatus":"START"}
2019-12-29 13:52:35 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:35 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:35 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:35 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:35 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:35 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:35 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:35 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:35 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:52:36 AUDIT audit:72 - {"time":"December 29, 2019 5:52:36 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313605087542229","opStatus":"START"}
2019-12-29 13:52:39 AUDIT audit:93 - {"time":"December 29, 2019 5:52:39 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313605087542229","opStatus":"SUCCESS","opTime":"3120 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 13:52:39 AUDIT audit:93 - {"time":"December 29, 2019 5:52:39 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5313603837988438","opStatus":"SUCCESS","opTime":"4381 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 13:52:39 AUDIT audit:72 - {"time":"December 29, 2019 5:52:39 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5313608223427306","opStatus":"START"}
2019-12-29 13:52:41 AUDIT audit:72 - {"time":"December 29, 2019 5:52:41 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5313610153307508","opStatus":"START"}
2019-12-29 13:52:42 AUDIT audit:93 - {"time":"December 29, 2019 5:52:42 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5313610153307508","opStatus":"SUCCESS","opTime":"1717 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 13:52:43 AUDIT audit:93 - {"time":"December 29, 2019 5:52:43 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5313608223427306","opStatus":"SUCCESS","opTime":"3882 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 13:52:43 AUDIT audit:72 - {"time":"December 29, 2019 5:52:43 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5313612375434035","opStatus":"START"}
2019-12-29 13:52:45 AUDIT audit:93 - {"time":"December 29, 2019 5:52:45 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5313612375434035","opStatus":"SUCCESS","opTime":"1787 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
[32m- Test data updation after compaction on Partition with mv tables[0m
2019-12-29 13:52:45 AUDIT audit:72 - {"time":"December 29, 2019 5:52:45 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313614177623778","opStatus":"START"}
2019-12-29 13:52:45 AUDIT audit:93 - {"time":"December 29, 2019 5:52:45 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313614177623778","opStatus":"SUCCESS","opTime":"109 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-29 13:52:45 AUDIT audit:72 - {"time":"December 29, 2019 5:52:45 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5313614289634096","opStatus":"START"}
2019-12-29 13:52:45 AUDIT audit:93 - {"time":"December 29, 2019 5:52:45 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5313614289634096","opStatus":"SUCCESS","opTime":"4 ms","table":"NA","extraInfo":{"dmName":"ag"}}
2019-12-29 13:52:45 AUDIT audit:72 - {"time":"December 29, 2019 5:52:45 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5313614298609031","opStatus":"START"}
2019-12-29 13:52:45 AUDIT audit:72 - {"time":"December 29, 2019 5:52:45 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313614585077973","opStatus":"START"}
2019-12-29 13:52:45 AUDIT audit:93 - {"time":"December 29, 2019 5:52:45 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313614585077973","opStatus":"SUCCESS","opTime":"52 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-29 13:52:45 AUDIT audit:93 - {"time":"December 29, 2019 5:52:45 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5313614298609031","opStatus":"SUCCESS","opTime":"627 ms","table":"partition_mv.updatetime_8","extraInfo":{"provider":"mv","dmName":"ag"}}
2019-12-29 13:52:45 AUDIT audit:72 - {"time":"December 29, 2019 5:52:45 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5313614937601403","opStatus":"START"}
2019-12-29 13:52:46 AUDIT audit:72 - {"time":"December 29, 2019 5:52:46 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313615727084358","opStatus":"START"}
2019-12-29 13:52:50 AUDIT audit:93 - {"time":"December 29, 2019 5:52:50 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313615727084358","opStatus":"SUCCESS","opTime":"3787 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:52:50 AUDIT audit:93 - {"time":"December 29, 2019 5:52:50 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5313614937601403","opStatus":"SUCCESS","opTime":"4586 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:52:50 AUDIT audit:72 - {"time":"December 29, 2019 5:52:50 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5313619532671100","opStatus":"START"}
2019-12-29 13:52:51 AUDIT audit:72 - {"time":"December 29, 2019 5:52:51 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313620119675134","opStatus":"START"}
2019-12-29 13:52:54 AUDIT audit:93 - {"time":"December 29, 2019 5:52:54 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313620119675134","opStatus":"SUCCESS","opTime":"3453 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:52:54 AUDIT audit:93 - {"time":"December 29, 2019 5:52:54 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5313619532671100","opStatus":"SUCCESS","opTime":"4050 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:52:54 AUDIT audit:72 - {"time":"December 29, 2019 5:52:54 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5313623597780421","opStatus":"START"}
2019-12-29 13:52:55 AUDIT audit:72 - {"time":"December 29, 2019 5:52:55 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313624099139082","opStatus":"START"}
2019-12-29 13:52:58 AUDIT audit:93 - {"time":"December 29, 2019 5:52:58 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313624099139082","opStatus":"SUCCESS","opTime":"3738 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:52:58 AUDIT audit:93 - {"time":"December 29, 2019 5:52:58 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5313623597780421","opStatus":"SUCCESS","opTime":"4250 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:52:58 AUDIT audit:72 - {"time":"December 29, 2019 5:52:58 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5313627862802920","opStatus":"START"}
2019-12-29 13:52:59 AUDIT audit:72 - {"time":"December 29, 2019 5:52:59 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313628527077864","opStatus":"START"}
2019-12-29 13:53:02 AUDIT audit:93 - {"time":"December 29, 2019 5:53:02 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313628527077864","opStatus":"SUCCESS","opTime":"3377 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:53:02 AUDIT audit:93 - {"time":"December 29, 2019 5:53:02 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5313627862802920","opStatus":"SUCCESS","opTime":"4052 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:53:02 AUDIT audit:72 - {"time":"December 29, 2019 5:53:02 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5313631928090343","opStatus":"START"}
2019-12-29 13:53:04 AUDIT audit:72 - {"time":"December 29, 2019 5:53:04 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313633183002106","opStatus":"START"}
2019-12-29 13:53:08 AUDIT audit:93 - {"time":"December 29, 2019 5:53:08 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313633183002106","opStatus":"SUCCESS","opTime":"3798 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:53:08 AUDIT audit:93 - {"time":"December 29, 2019 5:53:08 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5313631928090343","opStatus":"SUCCESS","opTime":"5065 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:53:08 AUDIT audit:72 - {"time":"December 29, 2019 5:53:08 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5313637015916456","opStatus":"START"}
2019-12-29 13:53:08 AUDIT audit:72 - {"time":"December 29, 2019 5:53:08 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313637532308675","opStatus":"START"}
2019-12-29 13:53:11 AUDIT audit:93 - {"time":"December 29, 2019 5:53:11 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313637532308675","opStatus":"SUCCESS","opTime":"3411 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:53:12 AUDIT audit:93 - {"time":"December 29, 2019 5:53:12 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5313637015916456","opStatus":"SUCCESS","opTime":"3939 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:53:12 AUDIT audit:72 - {"time":"December 29, 2019 5:53:12 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5313640970119787","opStatus":"START"}
2019-12-29 13:53:12 AUDIT audit:72 - {"time":"December 29, 2019 5:53:12 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313641591196985","opStatus":"START"}
2019-12-29 13:53:16 AUDIT audit:93 - {"time":"December 29, 2019 5:53:16 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313641591196985","opStatus":"SUCCESS","opTime":"3518 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:53:16 AUDIT audit:93 - {"time":"December 29, 2019 5:53:16 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5313640970119787","opStatus":"SUCCESS","opTime":"4148 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:53:16 AUDIT audit:72 - {"time":"December 29, 2019 5:53:16 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5313645127946517","opStatus":"START"}
2019-12-29 13:53:16 AUDIT audit:72 - {"time":"December 29, 2019 5:53:16 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313645620987422","opStatus":"START"}
2019-12-29 13:53:20 AUDIT audit:93 - {"time":"December 29, 2019 5:53:20 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313645620987422","opStatus":"SUCCESS","opTime":"3614 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:53:20 AUDIT audit:93 - {"time":"December 29, 2019 5:53:20 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5313645127946517","opStatus":"SUCCESS","opTime":"4119 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:53:20 AUDIT audit:72 - {"time":"December 29, 2019 5:53:20 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5313649249216517","opStatus":"START"}
2019-12-29 13:53:20 AUDIT audit:72 - {"time":"December 29, 2019 5:53:20 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5313649418855389","opStatus":"START"}
2019-12-29 13:53:20 AUDIT audit:93 - {"time":"December 29, 2019 5:53:20 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5313649418855389","opStatus":"SUCCESS","opTime":"494 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:53:21 AUDIT audit:72 - {"time":"December 29, 2019 5:53:21 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5313650140801224","opStatus":"START"}
2019-12-29 13:53:21 AUDIT audit:93 - {"time":"December 29, 2019 5:53:21 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5313650140801224","opStatus":"SUCCESS","opTime":"34 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:53:21 AUDIT audit:93 - {"time":"December 29, 2019 5:53:21 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5313649249216517","opStatus":"SUCCESS","opTime":"1005 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:53:21 AUDIT audit:72 - {"time":"December 29, 2019 5:53:21 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5313650265051401","opStatus":"START"}
2019-12-29 13:53:21 AUDIT audit:93 - {"time":"December 29, 2019 5:53:21 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5313650265051401","opStatus":"SUCCESS","opTime":"31 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
[32m- Test data updation in Aggregate query after compaction on Partitioned table with mv table[0m
2019-12-29 13:53:22 AUDIT audit:72 - {"time":"December 29, 2019 5:53:22 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5313651038706551","opStatus":"START"}
2019-12-29 13:53:22 AUDIT audit:93 - {"time":"December 29, 2019 5:53:22 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5313651038706551","opStatus":"SUCCESS","opTime":"523 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 13:53:22 AUDIT audit:72 - {"time":"December 29, 2019 5:53:22 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313651567126174","opStatus":"START"}
2019-12-29 13:53:22 AUDIT audit:93 - {"time":"December 29, 2019 5:53:22 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313651567126174","opStatus":"SUCCESS","opTime":"90 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 13:53:22 AUDIT audit:72 - {"time":"December 29, 2019 5:53:22 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5313651663276154","opStatus":"START"}
2019-12-29 13:53:23 AUDIT audit:72 - {"time":"December 29, 2019 5:53:23 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313651965592869","opStatus":"START"}
2019-12-29 13:53:23 AUDIT audit:93 - {"time":"December 29, 2019 5:53:23 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313651965592869","opStatus":"SUCCESS","opTime":"67 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-29 13:53:23 AUDIT audit:93 - {"time":"December 29, 2019 5:53:23 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5313651663276154","opStatus":"SUCCESS","opTime":"664 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p7"}}
2019-12-29 13:53:23 AUDIT audit:72 - {"time":"December 29, 2019 5:53:23 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5313652332725442","opStatus":"START"}
2019-12-29 13:53:23 AUDIT audit:72 - {"time":"December 29, 2019 5:53:23 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313652369797462","opStatus":"START"}
2019-12-29 13:53:23 AUDIT audit:93 - {"time":"December 29, 2019 5:53:23 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313652369797462","opStatus":"SUCCESS","opTime":"54 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-29 13:53:23 AUDIT audit:93 - {"time":"December 29, 2019 5:53:23 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5313652332725442","opStatus":"SUCCESS","opTime":"487 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p1"}}
2019-12-29 13:53:23 AUDIT audit:72 - {"time":"December 29, 2019 5:53:23 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5313652826314042","opStatus":"START"}
2019-12-29 13:53:23 AUDIT audit:72 - {"time":"December 29, 2019 5:53:23 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313652863433458","opStatus":"START"}
2019-12-29 13:53:23 AUDIT audit:93 - {"time":"December 29, 2019 5:53:23 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313652863433458","opStatus":"SUCCESS","opTime":"53 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-29 13:53:24 AUDIT audit:93 - {"time":"December 29, 2019 5:53:24 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5313652826314042","opStatus":"SUCCESS","opTime":"380 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p2"}}
2019-12-29 13:53:24 AUDIT audit:72 - {"time":"December 29, 2019 5:53:24 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5313653211731765","opStatus":"START"}
2019-12-29 13:53:24 AUDIT audit:72 - {"time":"December 29, 2019 5:53:24 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313653252063570","opStatus":"START"}
2019-12-29 13:53:24 AUDIT audit:93 - {"time":"December 29, 2019 5:53:24 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313653252063570","opStatus":"SUCCESS","opTime":"72 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-29 13:53:24 AUDIT audit:93 - {"time":"December 29, 2019 5:53:24 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5313653211731765","opStatus":"SUCCESS","opTime":"433 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p3"}}
2019-12-29 13:53:24 AUDIT audit:72 - {"time":"December 29, 2019 5:53:24 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5313653650647209","opStatus":"START"}
2019-12-29 13:53:24 AUDIT audit:72 - {"time":"December 29, 2019 5:53:24 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313653692209153","opStatus":"START"}
2019-12-29 13:53:24 AUDIT audit:93 - {"time":"December 29, 2019 5:53:24 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313653692209153","opStatus":"SUCCESS","opTime":"58 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-29 13:53:25 AUDIT audit:93 - {"time":"December 29, 2019 5:53:25 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5313653650647209","opStatus":"SUCCESS","opTime":"417 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p4"}}
2019-12-29 13:53:25 AUDIT audit:72 - {"time":"December 29, 2019 5:53:25 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5313654074085135","opStatus":"START"}
2019-12-29 13:53:25 AUDIT audit:72 - {"time":"December 29, 2019 5:53:25 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313654120832501","opStatus":"START"}
2019-12-29 13:53:25 AUDIT audit:93 - {"time":"December 29, 2019 5:53:25 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313654120832501","opStatus":"SUCCESS","opTime":"61 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-29 13:53:25 AUDIT audit:93 - {"time":"December 29, 2019 5:53:25 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5313654074085135","opStatus":"SUCCESS","opTime":"429 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p5"}}
2019-12-29 13:53:25 AUDIT audit:72 - {"time":"December 29, 2019 5:53:25 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5313654508575298","opStatus":"START"}
2019-12-29 13:53:25 AUDIT audit:72 - {"time":"December 29, 2019 5:53:25 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313654558386193","opStatus":"START"}
2019-12-29 13:53:25 AUDIT audit:93 - {"time":"December 29, 2019 5:53:25 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313654558386193","opStatus":"SUCCESS","opTime":"67 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-29 13:53:26 AUDIT audit:93 - {"time":"December 29, 2019 5:53:26 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5313654508575298","opStatus":"SUCCESS","opTime":"965 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p6"}}
2019-12-29 13:53:26 AUDIT audit:72 - {"time":"December 29, 2019 5:53:26 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5313655484971049","opStatus":"START"}
2019-12-29 13:53:27 AUDIT audit:93 - {"time":"December 29, 2019 5:53:27 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5313655484971049","opStatus":"SUCCESS","opTime":"1113 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- check partitioning for child tables with various combinations[0m
2019-12-29 13:53:27 AUDIT audit:72 - {"time":"December 29, 2019 5:53:27 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313656611809813","opStatus":"START"}
2019-12-29 13:53:27 AUDIT audit:93 - {"time":"December 29, 2019 5:53:27 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313656611809813","opStatus":"SUCCESS","opTime":"45 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 13:53:27 AUDIT audit:72 - {"time":"December 29, 2019 5:53:27 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5313656852505512","opStatus":"START"}
2019-12-29 13:53:28 AUDIT audit:93 - {"time":"December 29, 2019 5:53:28 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5313656852505512","opStatus":"SUCCESS","opTime":"597 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 13:53:28 AUDIT audit:72 - {"time":"December 29, 2019 5:53:28 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5313657452139346","opStatus":"START"}
2019-12-29 13:53:28 AUDIT audit:93 - {"time":"December 29, 2019 5:53:28 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5313657452139346","opStatus":"SUCCESS","opTime":"4 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-29 13:53:28 AUDIT audit:72 - {"time":"December 29, 2019 5:53:28 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5313657459578331","opStatus":"START"}
2019-12-29 13:53:28 AUDIT audit:72 - {"time":"December 29, 2019 5:53:28 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313657493831467","opStatus":"START"}
2019-12-29 13:53:28 AUDIT audit:93 - {"time":"December 29, 2019 5:53:28 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313657493831467","opStatus":"SUCCESS","opTime":"65 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-29 13:53:28 AUDIT audit:72 - {"time":"December 29, 2019 5:53:28 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313657882953118","opStatus":"START"}
2019-12-29 13:53:31 AUDIT audit:93 - {"time":"December 29, 2019 5:53:31 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313657882953118","opStatus":"SUCCESS","opTime":"2692 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-29 13:53:31 AUDIT audit:93 - {"time":"December 29, 2019 5:53:31 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5313657459578331","opStatus":"SUCCESS","opTime":"3187 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-29 13:53:32 AUDIT audit:72 - {"time":"December 29, 2019 5:53:32 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5313661525962148","opStatus":"START"}
2019-12-29 13:53:32 AUDIT audit:93 - {"time":"December 29, 2019 5:53:32 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5313661525962148","opStatus":"SUCCESS","opTime":"368 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- test partition at last column[0m
2019-12-29 13:53:32 AUDIT audit:72 - {"time":"December 29, 2019 5:53:32 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313661904823702","opStatus":"START"}
2019-12-29 13:53:33 AUDIT audit:93 - {"time":"December 29, 2019 5:53:33 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313661904823702","opStatus":"SUCCESS","opTime":"62 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 13:53:33 AUDIT audit:72 - {"time":"December 29, 2019 5:53:33 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5313662160773963","opStatus":"START"}
2019-12-29 13:53:33 AUDIT audit:93 - {"time":"December 29, 2019 5:53:33 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5313662160773963","opStatus":"SUCCESS","opTime":"592 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 13:53:33 AUDIT audit:72 - {"time":"December 29, 2019 5:53:33 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5313662755985422","opStatus":"START"}
2019-12-29 13:53:33 AUDIT audit:93 - {"time":"December 29, 2019 5:53:33 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5313662755985422","opStatus":"SUCCESS","opTime":"7 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-29 13:53:33 AUDIT audit:72 - {"time":"December 29, 2019 5:53:33 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5313662770058296","opStatus":"START"}
2019-12-29 13:53:33 AUDIT audit:72 - {"time":"December 29, 2019 5:53:33 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313662815990706","opStatus":"START"}
2019-12-29 13:53:33 AUDIT audit:93 - {"time":"December 29, 2019 5:53:33 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313662815990706","opStatus":"SUCCESS","opTime":"84 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-29 13:53:34 AUDIT audit:72 - {"time":"December 29, 2019 5:53:34 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313663221651941","opStatus":"START"}
2019-12-29 13:53:35 AUDIT audit:93 - {"time":"December 29, 2019 5:53:35 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313663221651941","opStatus":"SUCCESS","opTime":"1212 ms","table":"partition_mv.dm1_table","extraInfo":{"SegmentId":"0","DataSize":"688.0B","IndexSize":"446.0B"}}
2019-12-29 13:53:35 AUDIT audit:93 - {"time":"December 29, 2019 5:53:35 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5313662770058296","opStatus":"SUCCESS","opTime":"1679 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-29 13:53:36 AUDIT audit:72 - {"time":"December 29, 2019 5:53:36 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5313665335055138","opStatus":"START"}
2019-12-29 13:53:36 AUDIT audit:93 - {"time":"December 29, 2019 5:53:36 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5313665335055138","opStatus":"SUCCESS","opTime":"420 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 13:53:36 AUDIT audit:72 - {"time":"December 29, 2019 5:53:36 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313665759265941","opStatus":"START"}
2019-12-29 13:53:36 AUDIT audit:93 - {"time":"December 29, 2019 5:53:36 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313665759265941","opStatus":"SUCCESS","opTime":"123 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 13:53:37 AUDIT audit:72 - {"time":"December 29, 2019 5:53:37 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5313666069812938","opStatus":"START"}
2019-12-29 13:53:37 AUDIT audit:93 - {"time":"December 29, 2019 5:53:37 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5313666069812938","opStatus":"SUCCESS","opTime":"621 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 13:53:37 AUDIT audit:72 - {"time":"December 29, 2019 5:53:37 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5313666693105197","opStatus":"START"}
2019-12-29 13:53:37 AUDIT audit:93 - {"time":"December 29, 2019 5:53:37 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5313666693105197","opStatus":"SUCCESS","opTime":"5 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-29 13:53:37 AUDIT audit:72 - {"time":"December 29, 2019 5:53:37 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5313666703145258","opStatus":"START"}
2019-12-29 13:53:37 AUDIT audit:72 - {"time":"December 29, 2019 5:53:37 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313666736178111","opStatus":"START"}
2019-12-29 13:53:37 AUDIT audit:93 - {"time":"December 29, 2019 5:53:37 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5313666736178111","opStatus":"SUCCESS","opTime":"64 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-29 13:53:38 AUDIT audit:72 - {"time":"December 29, 2019 5:53:38 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313667175790962","opStatus":"START"}
2019-12-29 13:53:41 AUDIT audit:93 - {"time":"December 29, 2019 5:53:41 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5313667175790962","opStatus":"SUCCESS","opTime":"3255 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-29 13:53:41 AUDIT audit:93 - {"time":"December 29, 2019 5:53:41 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5313666703145258","opStatus":"SUCCESS","opTime":"3746 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-29 13:53:42 AUDIT audit:72 - {"time":"December 29, 2019 5:53:42 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5313671571138768","opStatus":"START"}
2019-12-29 13:53:42 AUDIT audit:93 - {"time":"December 29, 2019 5:53:42 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5313671571138768","opStatus":"SUCCESS","opTime":"328 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- test partition on timeseries column[0m
2019-12-29 13:53:42 AUDIT audit:72 - {"time":"December 29, 2019 5:53:42 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5313671910237007","opStatus":"START"}
2019-12-29 13:53:42 AUDIT audit:93 - {"time":"December 29, 2019 5:53:42 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5313671910237007","opStatus":"SUCCESS","opTime":"2 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:53:42 AUDIT audit:72 - {"time":"December 29, 2019 5:53:42 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5313671912511853","opStatus":"START"}
2019-12-29 13:53:43 AUDIT audit:93 - {"time":"December 29, 2019 5:53:43 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5313671912511853","opStatus":"SUCCESS","opTime":"183 ms","table":"partition_mv.droppartition","extraInfo":{}}
2019-12-29 13:53:43 AUDIT audit:72 - {"time":"December 29, 2019 5:53:43 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5313672096645780","opStatus":"START"}
2019-12-29 13:53:43 AUDIT audit:93 - {"time":"December 29, 2019 5:53:43 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5313672096645780","opStatus":"SUCCESS","opTime":"257 ms","table":"partition_mv.maintable","extraInfo":{}}
2019-12-29 13:53:43 AUDIT audit:72 - {"time":"December 29, 2019 5:53:43 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5313672354174451","opStatus":"START"}
2019-12-29 13:53:43 AUDIT audit:93 - {"time":"December 29, 2019 5:53:43 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5313672354174451","opStatus":"SUCCESS","opTime":"111 ms","table":"partition_mv.par","extraInfo":{}}
2019-12-29 13:53:43 AUDIT audit:72 - {"time":"December 29, 2019 5:53:43 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5313672465119504","opStatus":"START"}
2019-12-29 13:53:43 AUDIT audit:93 - {"time":"December 29, 2019 5:53:43 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5313672465119504","opStatus":"SUCCESS","opTime":"312 ms","table":"partition_mv.partitiontable","extraInfo":{}}
2019-12-29 13:53:43 AUDIT audit:72 - {"time":"December 29, 2019 5:53:43 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5313672777189582","opStatus":"START"}
2019-12-29 13:53:44 AUDIT audit:93 - {"time":"December 29, 2019 5:53:44 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5313672777189582","opStatus":"SUCCESS","opTime":"702 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
[32mMVTPCDSTestCase:[0m
[33m- test create datamap with tpcds_1_4_testCases case_1 !!! IGNORED !!![0m
[33m- test create datamap with tpcds_1_4_testCases case_3 !!! IGNORED !!![0m
[33m- test create datamap with tpcds_1_4_testCases case_4 !!! IGNORED !!![0m
[33m- test create datamap with tpcds_1_4_testCases case_5 !!! IGNORED !!![0m
[33m- test create datamap with tpcds_1_4_testCases case_6 !!! IGNORED !!![0m
[33m- test create datamap with tpcds_1_4_testCases case_8 !!! IGNORED !!![0m
[33m- test create datamap with tpcds_1_4_testCases case_11 !!! IGNORED !!![0m
[33m- test create datamap with tpcds_1_4_testCases case_15 !!! IGNORED !!![0m
[33m- test create datamap with tpcds_1_4_testCases case_16 !!! IGNORED !!![0m
[36mRun completed in 20 minutes, 10 seconds.[0m
[36mTotal number of tests run: 234[0m
[36mSuites: completed 21, aborted 0[0m
[36mTests: succeeded 233, failed 1, canceled 0, ignored 18, pending 0[0m
[31m*** 1 TEST FAILED ***[0m
[JENKINS] Recording test results