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