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 07:11:53 UTC

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

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

Changes:

[jacky.likun] wip


------------------------------------------
[...truncated 1.13 MB...]
2019-12-29 07:07:03 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:03 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:04 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:04 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:04 AUDIT audit:72 - {"time":"December 28, 2019 11:07:04 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289273431375404","opStatus":"START"}
2019-12-29 07:07:07 AUDIT audit:93 - {"time":"December 28, 2019 11:07:07 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289273431375404","opStatus":"SUCCESS","opTime":"3482 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 07:07:07 AUDIT audit:93 - {"time":"December 28, 2019 11:07:07 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289271982398270","opStatus":"SUCCESS","opTime":"4942 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 07:07:07 AUDIT audit:72 - {"time":"December 28, 2019 11:07:07 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289276928160139","opStatus":"START"}
2019-12-29 07:07:08 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:08 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:08 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:08 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:08 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:08 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:08 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:08 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:08 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:08 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:09 AUDIT audit:72 - {"time":"December 28, 2019 11:07:09 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289278053982617","opStatus":"START"}
2019-12-29 07:07:11 AUDIT audit:93 - {"time":"December 28, 2019 11:07:11 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289278053982617","opStatus":"SUCCESS","opTime":"2833 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 07:07:11 AUDIT audit:93 - {"time":"December 28, 2019 11:07:11 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289276928160139","opStatus":"SUCCESS","opTime":"3966 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 07:07:11 AUDIT audit:72 - {"time":"December 28, 2019 11:07:11 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289280902023504","opStatus":"START"}
2019-12-29 07:07:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:12 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:13 AUDIT audit:72 - {"time":"December 28, 2019 11:07:13 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289282292592388","opStatus":"START"}
2019-12-29 07:07:16 AUDIT audit:93 - {"time":"December 28, 2019 11:07:16 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289282292592388","opStatus":"SUCCESS","opTime":"3328 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 07:07:16 AUDIT audit:93 - {"time":"December 28, 2019 11:07:16 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289280902023504","opStatus":"SUCCESS","opTime":"4727 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 07:07:16 AUDIT audit:72 - {"time":"December 28, 2019 11:07:16 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289285633643082","opStatus":"START"}
2019-12-29 07:07:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:17 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:17 AUDIT audit:72 - {"time":"December 28, 2019 11:07:17 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289286903646477","opStatus":"START"}
2019-12-29 07:07:21 AUDIT audit:93 - {"time":"December 28, 2019 11:07:21 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289286903646477","opStatus":"SUCCESS","opTime":"3217 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 07:07:21 AUDIT audit:93 - {"time":"December 28, 2019 11:07:21 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289285633643082","opStatus":"SUCCESS","opTime":"4496 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 07:07:21 AUDIT audit:72 - {"time":"December 28, 2019 11:07:21 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289290135182533","opStatus":"START"}
2019-12-29 07:07:21 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:21 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:21 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:21 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:21 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:22 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:22 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:22 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:22 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:22 AUDIT audit:72 - {"time":"December 28, 2019 11:07:22 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289291573453244","opStatus":"START"}
2019-12-29 07:07:25 AUDIT audit:93 - {"time":"December 28, 2019 11:07:25 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289291573453244","opStatus":"SUCCESS","opTime":"3033 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 07:07:25 AUDIT audit:93 - {"time":"December 28, 2019 11:07:25 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289290135182533","opStatus":"SUCCESS","opTime":"4481 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 07:07:25 AUDIT audit:72 - {"time":"December 28, 2019 11:07:25 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289294619991513","opStatus":"START"}
2019-12-29 07:07:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:26 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:27 AUDIT audit:72 - {"time":"December 28, 2019 11:07:27 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289296155362417","opStatus":"START"}
2019-12-29 07:07:30 AUDIT audit:93 - {"time":"December 28, 2019 11:07:30 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289296155362417","opStatus":"SUCCESS","opTime":"3149 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 07:07:30 AUDIT audit:93 - {"time":"December 28, 2019 11:07:30 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289294619991513","opStatus":"SUCCESS","opTime":"4695 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 07:07:30 AUDIT audit:72 - {"time":"December 28, 2019 11:07:30 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289299319369378","opStatus":"START"}
2019-12-29 07:07:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:31 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:31 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:31 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:31 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:31 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:07:31 AUDIT audit:72 - {"time":"December 28, 2019 11:07:31 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289300590131975","opStatus":"START"}
2019-12-29 07:07:35 AUDIT audit:93 - {"time":"December 28, 2019 11:07:35 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289300590131975","opStatus":"SUCCESS","opTime":"3463 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 07:07:35 AUDIT audit:93 - {"time":"December 28, 2019 11:07:35 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289299319369378","opStatus":"SUCCESS","opTime":"4744 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 07:07:35 AUDIT audit:72 - {"time":"December 28, 2019 11:07:35 PM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5289304067255493","opStatus":"START"}
2019-12-29 07:07:36 AUDIT audit:72 - {"time":"December 28, 2019 11:07:36 PM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5289305339376487","opStatus":"START"}
2019-12-29 07:07:38 AUDIT audit:93 - {"time":"December 28, 2019 11:07:38 PM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5289305339376487","opStatus":"SUCCESS","opTime":"1842 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 07:07:38 AUDIT audit:93 - {"time":"December 28, 2019 11:07:38 PM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5289304067255493","opStatus":"SUCCESS","opTime":"3339 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 07:07:38 AUDIT audit:72 - {"time":"December 28, 2019 11:07:38 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289307639830621","opStatus":"START"}
2019-12-29 07:07:40 AUDIT audit:93 - {"time":"December 28, 2019 11:07:40 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289307639830621","opStatus":"SUCCESS","opTime":"1740 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
- Test data updation after compaction on Partition with mv tables
2019-12-29 07:07:40 AUDIT audit:72 - {"time":"December 28, 2019 11:07:40 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289309391898148","opStatus":"START"}
2019-12-29 07:07:40 AUDIT audit:93 - {"time":"December 28, 2019 11:07:40 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289309391898148","opStatus":"SUCCESS","opTime":"97 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 07:07:40 AUDIT audit:72 - {"time":"December 28, 2019 11:07:40 PM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5289309492339112","opStatus":"START"}
2019-12-29 07:07:40 AUDIT audit:93 - {"time":"December 28, 2019 11:07:40 PM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5289309492339112","opStatus":"SUCCESS","opTime":"6 ms","table":"NA","extraInfo":{"dmName":"ag"}}
2019-12-29 07:07:40 AUDIT audit:72 - {"time":"December 28, 2019 11:07:40 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289309503224694","opStatus":"START"}
2019-12-29 07:07:40 AUDIT audit:72 - {"time":"December 28, 2019 11:07:40 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289309775602146","opStatus":"START"}
2019-12-29 07:07:40 AUDIT audit:93 - {"time":"December 28, 2019 11:07:40 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289309775602146","opStatus":"SUCCESS","opTime":"56 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 07:07:41 AUDIT audit:93 - {"time":"December 28, 2019 11:07:41 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289309503224694","opStatus":"SUCCESS","opTime":"625 ms","table":"partition_mv.updatetime_8","extraInfo":{"provider":"mv","dmName":"ag"}}
2019-12-29 07:07:41 AUDIT audit:72 - {"time":"December 28, 2019 11:07:41 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289310140561868","opStatus":"START"}
2019-12-29 07:07:41 AUDIT audit:72 - {"time":"December 28, 2019 11:07:41 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289310907605822","opStatus":"START"}
2019-12-29 07:07:45 AUDIT audit:93 - {"time":"December 28, 2019 11:07:45 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289310907605822","opStatus":"SUCCESS","opTime":"3688 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 07:07:45 AUDIT audit:93 - {"time":"December 28, 2019 11:07:45 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289310140561868","opStatus":"SUCCESS","opTime":"4461 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 07:07:45 AUDIT audit:72 - {"time":"December 28, 2019 11:07:45 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289314615448741","opStatus":"START"}
2019-12-29 07:07:46 AUDIT audit:72 - {"time":"December 28, 2019 11:07:46 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289315220238571","opStatus":"START"}
2019-12-29 07:07:49 AUDIT audit:93 - {"time":"December 28, 2019 11:07:49 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289315220238571","opStatus":"SUCCESS","opTime":"3630 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 07:07:49 AUDIT audit:93 - {"time":"December 28, 2019 11:07:49 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289314615448741","opStatus":"SUCCESS","opTime":"4244 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 07:07:49 AUDIT audit:72 - {"time":"December 28, 2019 11:07:49 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289318873529310","opStatus":"START"}
2019-12-29 07:07:50 AUDIT audit:72 - {"time":"December 28, 2019 11:07:50 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289319360368256","opStatus":"START"}
2019-12-29 07:07:53 AUDIT audit:93 - {"time":"December 28, 2019 11:07:53 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289319360368256","opStatus":"SUCCESS","opTime":"3340 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 07:07:53 AUDIT audit:93 - {"time":"December 28, 2019 11:07:53 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289318873529310","opStatus":"SUCCESS","opTime":"3833 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 07:07:53 AUDIT audit:72 - {"time":"December 28, 2019 11:07:53 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289322722823403","opStatus":"START"}
2019-12-29 07:07:54 AUDIT audit:72 - {"time":"December 28, 2019 11:07:54 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289323364180369","opStatus":"START"}
2019-12-29 07:07:57 AUDIT audit:93 - {"time":"December 28, 2019 11:07:57 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289323364180369","opStatus":"SUCCESS","opTime":"3231 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 07:07:57 AUDIT audit:93 - {"time":"December 28, 2019 11:07:57 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289322722823403","opStatus":"SUCCESS","opTime":"3883 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 07:07:57 AUDIT audit:72 - {"time":"December 28, 2019 11:07:57 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289326620104693","opStatus":"START"}
2019-12-29 07:07:58 AUDIT audit:72 - {"time":"December 28, 2019 11:07:58 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289327098560925","opStatus":"START"}
2019-12-29 07:08:01 AUDIT audit:93 - {"time":"December 28, 2019 11:08:01 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289327098560925","opStatus":"SUCCESS","opTime":"3449 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 07:08:01 AUDIT audit:93 - {"time":"December 28, 2019 11:08:01 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289326620104693","opStatus":"SUCCESS","opTime":"3939 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 07:08:01 AUDIT audit:72 - {"time":"December 28, 2019 11:08:01 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289330591043528","opStatus":"START"}
2019-12-29 07:08:02 AUDIT audit:72 - {"time":"December 28, 2019 11:08:02 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289331095863283","opStatus":"START"}
2019-12-29 07:08:05 AUDIT audit:93 - {"time":"December 28, 2019 11:08:05 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289331095863283","opStatus":"SUCCESS","opTime":"3543 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 07:08:05 AUDIT audit:93 - {"time":"December 28, 2019 11:08:05 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289330591043528","opStatus":"SUCCESS","opTime":"4060 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 07:08:05 AUDIT audit:72 - {"time":"December 28, 2019 11:08:05 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289334665929398","opStatus":"START"}
2019-12-29 07:08:06 AUDIT audit:72 - {"time":"December 28, 2019 11:08:06 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289335271953462","opStatus":"START"}
2019-12-29 07:08:09 AUDIT audit:93 - {"time":"December 28, 2019 11:08:09 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289335271953462","opStatus":"SUCCESS","opTime":"3435 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 07:08:09 AUDIT audit:93 - {"time":"December 28, 2019 11:08:09 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289334665929398","opStatus":"SUCCESS","opTime":"4049 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 07:08:09 AUDIT audit:72 - {"time":"December 28, 2019 11:08:09 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289338727138294","opStatus":"START"}
2019-12-29 07:08:10 AUDIT audit:72 - {"time":"December 28, 2019 11:08:10 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289339204925986","opStatus":"START"}
2019-12-29 07:08:13 AUDIT audit:93 - {"time":"December 28, 2019 11:08:13 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289339204925986","opStatus":"SUCCESS","opTime":"3454 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 07:08:13 AUDIT audit:93 - {"time":"December 28, 2019 11:08:13 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289338727138294","opStatus":"SUCCESS","opTime":"3940 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 07:08:13 AUDIT audit:72 - {"time":"December 28, 2019 11:08:13 PM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5289342669128390","opStatus":"START"}
2019-12-29 07:08:14 AUDIT audit:72 - {"time":"December 28, 2019 11:08:14 PM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5289343028155879","opStatus":"START"}
2019-12-29 07:08:14 AUDIT audit:93 - {"time":"December 28, 2019 11:08:14 PM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5289343028155879","opStatus":"SUCCESS","opTime":"482 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 07:08:14 AUDIT audit:72 - {"time":"December 28, 2019 11:08:14 PM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5289343706943469","opStatus":"START"}
2019-12-29 07:08:14 AUDIT audit:93 - {"time":"December 28, 2019 11:08:14 PM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5289343706943469","opStatus":"SUCCESS","opTime":"31 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 07:08:14 AUDIT audit:93 - {"time":"December 28, 2019 11:08:14 PM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5289342669128390","opStatus":"SUCCESS","opTime":"1131 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 07:08:14 AUDIT audit:72 - {"time":"December 28, 2019 11:08:14 PM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5289343811024356","opStatus":"START"}
2019-12-29 07:08:14 AUDIT audit:93 - {"time":"December 28, 2019 11:08:14 PM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5289343811024356","opStatus":"SUCCESS","opTime":"32 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
- Test data updation in Aggregate query after compaction on Partitioned table with mv table
2019-12-29 07:08:15 AUDIT audit:72 - {"time":"December 28, 2019 11:08:15 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289344545686339","opStatus":"START"}
2019-12-29 07:08:16 AUDIT audit:93 - {"time":"December 28, 2019 11:08:16 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289344545686339","opStatus":"SUCCESS","opTime":"533 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 07:08:16 AUDIT audit:72 - {"time":"December 28, 2019 11:08:16 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289345085952598","opStatus":"START"}
2019-12-29 07:08:16 AUDIT audit:93 - {"time":"December 28, 2019 11:08:16 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289345085952598","opStatus":"SUCCESS","opTime":"100 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 07:08:16 AUDIT audit:72 - {"time":"December 28, 2019 11:08:16 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289345191352663","opStatus":"START"}
2019-12-29 07:08:16 AUDIT audit:72 - {"time":"December 28, 2019 11:08:16 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289345506633853","opStatus":"START"}
2019-12-29 07:08:16 AUDIT audit:93 - {"time":"December 28, 2019 11:08:16 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289345506633853","opStatus":"SUCCESS","opTime":"81 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 07:08:16 AUDIT audit:93 - {"time":"December 28, 2019 11:08:16 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289345191352663","opStatus":"SUCCESS","opTime":"699 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p7"}}
2019-12-29 07:08:16 AUDIT audit:72 - {"time":"December 28, 2019 11:08:16 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289345897843749","opStatus":"START"}
2019-12-29 07:08:16 AUDIT audit:72 - {"time":"December 28, 2019 11:08:16 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289345928365609","opStatus":"START"}
2019-12-29 07:08:17 AUDIT audit:93 - {"time":"December 28, 2019 11:08:17 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289345928365609","opStatus":"SUCCESS","opTime":"50 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 07:08:17 AUDIT audit:93 - {"time":"December 28, 2019 11:08:17 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289345897843749","opStatus":"SUCCESS","opTime":"437 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p1"}}
2019-12-29 07:08:17 AUDIT audit:72 - {"time":"December 28, 2019 11:08:17 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289346340761128","opStatus":"START"}
2019-12-29 07:08:17 AUDIT audit:72 - {"time":"December 28, 2019 11:08:17 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289346373953465","opStatus":"START"}
2019-12-29 07:08:17 AUDIT audit:93 - {"time":"December 28, 2019 11:08:17 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289346373953465","opStatus":"SUCCESS","opTime":"56 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 07:08:17 AUDIT audit:93 - {"time":"December 28, 2019 11:08:17 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289346340761128","opStatus":"SUCCESS","opTime":"448 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p2"}}
2019-12-29 07:08:17 AUDIT audit:72 - {"time":"December 28, 2019 11:08:17 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289346794635524","opStatus":"START"}
2019-12-29 07:08:17 AUDIT audit:72 - {"time":"December 28, 2019 11:08:17 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289346836742458","opStatus":"START"}
2019-12-29 07:08:17 AUDIT audit:93 - {"time":"December 28, 2019 11:08:17 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289346836742458","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 07:08:18 AUDIT audit:93 - {"time":"December 28, 2019 11:08:18 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289346794635524","opStatus":"SUCCESS","opTime":"410 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p3"}}
2019-12-29 07:08:18 AUDIT audit:72 - {"time":"December 28, 2019 11:08:18 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289347210525871","opStatus":"START"}
2019-12-29 07:08:18 AUDIT audit:72 - {"time":"December 28, 2019 11:08:18 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289347253278133","opStatus":"START"}
2019-12-29 07:08:18 AUDIT audit:93 - {"time":"December 28, 2019 11:08:18 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289347253278133","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 07:08:18 AUDIT audit:93 - {"time":"December 28, 2019 11:08:18 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289347210525871","opStatus":"SUCCESS","opTime":"386 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p4"}}
2019-12-29 07:08:18 AUDIT audit:72 - {"time":"December 28, 2019 11:08:18 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289347602225449","opStatus":"START"}
2019-12-29 07:08:18 AUDIT audit:72 - {"time":"December 28, 2019 11:08:18 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289347645227269","opStatus":"START"}
2019-12-29 07:08:18 AUDIT audit:93 - {"time":"December 28, 2019 11:08:18 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289347645227269","opStatus":"SUCCESS","opTime":"92 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 07:08:19 AUDIT audit:93 - {"time":"December 28, 2019 11:08:19 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289347602225449","opStatus":"SUCCESS","opTime":"420 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p5"}}
2019-12-29 07:08:19 AUDIT audit:72 - {"time":"December 28, 2019 11:08:19 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289348028088701","opStatus":"START"}
2019-12-29 07:08:19 AUDIT audit:72 - {"time":"December 28, 2019 11:08:19 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289348081377455","opStatus":"START"}
2019-12-29 07:08:19 AUDIT audit:93 - {"time":"December 28, 2019 11:08:19 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289348081377455","opStatus":"SUCCESS","opTime":"65 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 07:08:19 AUDIT audit:93 - {"time":"December 28, 2019 11:08:19 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289348028088701","opStatus":"SUCCESS","opTime":"428 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p6"}}
2019-12-29 07:08:19 AUDIT audit:72 - {"time":"December 28, 2019 11:08:19 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289348467288590","opStatus":"START"}
2019-12-29 07:08:20 AUDIT audit:93 - {"time":"December 28, 2019 11:08:20 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289348467288590","opStatus":"SUCCESS","opTime":"1120 ms","table":"partition_mv.partitionone","extraInfo":{}}
- check partitioning for child tables with various combinations
2019-12-29 07:08:20 AUDIT audit:72 - {"time":"December 28, 2019 11:08:20 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289349596758853","opStatus":"START"}
2019-12-29 07:08:20 AUDIT audit:93 - {"time":"December 28, 2019 11:08:20 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289349596758853","opStatus":"SUCCESS","opTime":"57 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 07:08:20 AUDIT audit:72 - {"time":"December 28, 2019 11:08:20 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289349827546061","opStatus":"START"}
2019-12-29 07:08:21 AUDIT audit:93 - {"time":"December 28, 2019 11:08:21 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289349827546061","opStatus":"SUCCESS","opTime":"594 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 07:08:21 AUDIT audit:72 - {"time":"December 28, 2019 11:08:21 PM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5289350424264655","opStatus":"START"}
2019-12-29 07:08:21 AUDIT audit:93 - {"time":"December 28, 2019 11:08:21 PM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5289350424264655","opStatus":"SUCCESS","opTime":"4 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-29 07:08:21 AUDIT audit:72 - {"time":"December 28, 2019 11:08:21 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289350432703443","opStatus":"START"}
2019-12-29 07:08:21 AUDIT audit:72 - {"time":"December 28, 2019 11:08:21 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289350468707120","opStatus":"START"}
2019-12-29 07:08:21 AUDIT audit:93 - {"time":"December 28, 2019 11:08:21 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289350468707120","opStatus":"SUCCESS","opTime":"44 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 07:08:21 AUDIT audit:72 - {"time":"December 28, 2019 11:08:21 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289350840582743","opStatus":"START"}
2019-12-29 07:08:24 AUDIT audit:93 - {"time":"December 28, 2019 11:08:24 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289350840582743","opStatus":"SUCCESS","opTime":"2595 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-29 07:08:24 AUDIT audit:93 - {"time":"December 28, 2019 11:08:24 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289350432703443","opStatus":"SUCCESS","opTime":"3031 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-29 07:08:25 AUDIT audit:72 - {"time":"December 28, 2019 11:08:25 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289354276856188","opStatus":"START"}
2019-12-29 07:08:25 AUDIT audit:93 - {"time":"December 28, 2019 11:08:25 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289354276856188","opStatus":"SUCCESS","opTime":"379 ms","table":"partition_mv.partitionone","extraInfo":{}}
- test partition at last column
2019-12-29 07:08:25 AUDIT audit:72 - {"time":"December 28, 2019 11:08:25 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289354666288120","opStatus":"START"}
2019-12-29 07:08:25 AUDIT audit:93 - {"time":"December 28, 2019 11:08:25 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289354666288120","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 07:08:25 AUDIT audit:72 - {"time":"December 28, 2019 11:08:25 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289354889633369","opStatus":"START"}
2019-12-29 07:08:26 AUDIT audit:93 - {"time":"December 28, 2019 11:08:26 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289354889633369","opStatus":"SUCCESS","opTime":"553 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 07:08:26 AUDIT audit:72 - {"time":"December 28, 2019 11:08:26 PM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5289355445303291","opStatus":"START"}
2019-12-29 07:08:26 AUDIT audit:93 - {"time":"December 28, 2019 11:08:26 PM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5289355445303291","opStatus":"SUCCESS","opTime":"5 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-29 07:08:26 AUDIT audit:72 - {"time":"December 28, 2019 11:08:26 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289355455266845","opStatus":"START"}
2019-12-29 07:08:26 AUDIT audit:72 - {"time":"December 28, 2019 11:08:26 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289355493973594","opStatus":"START"}
2019-12-29 07:08:26 AUDIT audit:93 - {"time":"December 28, 2019 11:08:26 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289355493973594","opStatus":"SUCCESS","opTime":"85 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 07:08:26 AUDIT audit:72 - {"time":"December 28, 2019 11:08:26 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289355881799373","opStatus":"START"}
2019-12-29 07:08:28 AUDIT audit:93 - {"time":"December 28, 2019 11:08:28 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289355881799373","opStatus":"SUCCESS","opTime":"1190 ms","table":"partition_mv.dm1_table","extraInfo":{"SegmentId":"0","DataSize":"688.0B","IndexSize":"446.0B"}}
2019-12-29 07:08:28 AUDIT audit:93 - {"time":"December 28, 2019 11:08:28 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289355455266845","opStatus":"SUCCESS","opTime":"1636 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-29 07:08:28 AUDIT audit:72 - {"time":"December 28, 2019 11:08:28 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289357944722665","opStatus":"START"}
2019-12-29 07:08:29 AUDIT audit:93 - {"time":"December 28, 2019 11:08:29 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289357944722665","opStatus":"SUCCESS","opTime":"515 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 07:08:29 AUDIT audit:72 - {"time":"December 28, 2019 11:08:29 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289358463343190","opStatus":"START"}
2019-12-29 07:08:29 AUDIT audit:93 - {"time":"December 28, 2019 11:08:29 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289358463343190","opStatus":"SUCCESS","opTime":"290 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 07:08:29 AUDIT audit:72 - {"time":"December 28, 2019 11:08:29 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289358933233010","opStatus":"START"}
2019-12-29 07:08:30 AUDIT audit:93 - {"time":"December 28, 2019 11:08:30 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289358933233010","opStatus":"SUCCESS","opTime":"575 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 07:08:30 AUDIT audit:72 - {"time":"December 28, 2019 11:08:30 PM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5289359510115438","opStatus":"START"}
2019-12-29 07:08:30 AUDIT audit:93 - {"time":"December 28, 2019 11:08:30 PM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5289359510115438","opStatus":"SUCCESS","opTime":"5 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-29 07:08:30 AUDIT audit:72 - {"time":"December 28, 2019 11:08:30 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289359519069424","opStatus":"START"}
2019-12-29 07:08:30 AUDIT audit:72 - {"time":"December 28, 2019 11:08:30 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289359556531939","opStatus":"START"}
2019-12-29 07:08:30 AUDIT audit:93 - {"time":"December 28, 2019 11:08:30 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289359556531939","opStatus":"SUCCESS","opTime":"55 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 07:08:30 AUDIT audit:72 - {"time":"December 28, 2019 11:08:30 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289359894092994","opStatus":"START"}
2019-12-29 07:08:33 AUDIT audit:93 - {"time":"December 28, 2019 11:08:33 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289359894092994","opStatus":"SUCCESS","opTime":"2562 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-29 07:08:33 AUDIT audit:93 - {"time":"December 28, 2019 11:08:33 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289359519069424","opStatus":"SUCCESS","opTime":"2961 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-29 07:08:34 AUDIT audit:72 - {"time":"December 28, 2019 11:08:34 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289363338054614","opStatus":"START"}
2019-12-29 07:08:35 AUDIT audit:93 - {"time":"December 28, 2019 11:08:35 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289363338054614","opStatus":"SUCCESS","opTime":"635 ms","table":"partition_mv.partitionone","extraInfo":{}}
- test partition on timeseries column
2019-12-29 07:08:35 AUDIT audit:72 - {"time":"December 28, 2019 11:08:35 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289363983100672","opStatus":"START"}
2019-12-29 07:08:35 AUDIT audit:93 - {"time":"December 28, 2019 11:08:35 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289363983100672","opStatus":"SUCCESS","opTime":"2 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 07:08:35 AUDIT audit:72 - {"time":"December 28, 2019 11:08:35 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289363985065680","opStatus":"START"}
2019-12-29 07:08:35 AUDIT audit:93 - {"time":"December 28, 2019 11:08:35 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289363985065680","opStatus":"SUCCESS","opTime":"178 ms","table":"partition_mv.droppartition","extraInfo":{}}
2019-12-29 07:08:35 AUDIT audit:72 - {"time":"December 28, 2019 11:08:35 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289364163261074","opStatus":"START"}
2019-12-29 07:08:35 AUDIT audit:93 - {"time":"December 28, 2019 11:08:35 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289364163261074","opStatus":"SUCCESS","opTime":"312 ms","table":"partition_mv.maintable","extraInfo":{}}
2019-12-29 07:08:35 AUDIT audit:72 - {"time":"December 28, 2019 11:08:35 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289364475856635","opStatus":"START"}
2019-12-29 07:08:35 AUDIT audit:93 - {"time":"December 28, 2019 11:08:35 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289364475856635","opStatus":"SUCCESS","opTime":"117 ms","table":"partition_mv.par","extraInfo":{}}
2019-12-29 07:08:35 AUDIT audit:72 - {"time":"December 28, 2019 11:08:35 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289364593184448","opStatus":"START"}
2019-12-29 07:08:35 AUDIT audit:93 - {"time":"December 28, 2019 11:08:35 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289364593184448","opStatus":"SUCCESS","opTime":"253 ms","table":"partition_mv.partitiontable","extraInfo":{}}
2019-12-29 07:08:35 AUDIT audit:72 - {"time":"December 28, 2019 11:08:35 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289364847012728","opStatus":"START"}
2019-12-29 07:08:36 AUDIT audit:93 - {"time":"December 28, 2019 11:08:36 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289364847012728","opStatus":"SUCCESS","opTime":"484 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
MVTPCDSTestCase:
- test create datamap with tpcds_1_4_testCases case_1 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_3 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_4 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_5 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_6 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_8 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_11 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_15 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_16 !!! IGNORED !!!
Run completed in 18 minutes, 56 seconds.
Total number of tests run: 232
Suites: completed 21, aborted 0
Tests: succeeded 231, failed 1, canceled 0, ignored 18, pending 0
*** 1 TEST FAILED ***
[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":{}}
- Test data updation after compaction on Partition with mv tables
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":{}}
- Test data updation in Aggregate query after compaction on Partitioned table with mv table
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":{}}
- check partitioning for child tables with various combinations
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":{}}
- test partition at last column
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":{}}
- test partition on timeseries column
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":{}}
MVTPCDSTestCase:
- test create datamap with tpcds_1_4_testCases case_1 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_3 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_4 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_5 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_6 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_8 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_11 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_15 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_16 !!! IGNORED !!!
Run completed in 20 minutes, 10 seconds.
Total number of tests run: 234
Suites: completed 21, aborted 0
Tests: succeeded 233, failed 1, canceled 0, ignored 18, pending 0
*** 1 TEST FAILED ***
[JENKINS] Recording test results

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

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/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":{}}
- Test data updation after compaction on Partition with mv tables
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":{}}
- Test data updation in Aggregate query after compaction on Partitioned table with mv table
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":{}}
- check partitioning for child tables with various combinations
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":{}}
- test partition at last column
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":{}}
- test partition on timeseries column
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":{}}
MVTPCDSTestCase:
- test create datamap with tpcds_1_4_testCases case_1 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_3 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_4 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_5 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_6 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_8 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_11 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_15 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_16 !!! IGNORED !!!
Run completed in 18 minutes, 44 seconds.
Total number of tests run: 234
Suites: completed 21, aborted 0
Tests: succeeded 233, failed 1, canceled 0, ignored 18, pending 0
*** 1 TEST FAILED ***
[JENKINS] Recording test results

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

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/2155/display/redirect>

Changes:


------------------------------------------
[...truncated 1.13 MB...]
2019-12-29 08:22:23 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:23 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:23 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:23 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:23 AUDIT audit:72 - {"time":"December 29, 2019 12:22:23 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732293119096939","opStatus":"START"}
2019-12-29 08:22:26 AUDIT audit:93 - {"time":"December 29, 2019 12:22:26 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732293119096939","opStatus":"SUCCESS","opTime":"2564 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 08:22:26 AUDIT audit:93 - {"time":"December 29, 2019 12:22:26 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"7732291744880784","opStatus":"SUCCESS","opTime":"3947 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 08:22:26 AUDIT audit:72 - {"time":"December 29, 2019 12:22:26 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"7732295695819218","opStatus":"START"}
2019-12-29 08:22:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:27 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:27 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:27 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:27 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:27 AUDIT audit:72 - {"time":"December 29, 2019 12:22:27 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732296694985180","opStatus":"START"}
2019-12-29 08:22:29 AUDIT audit:93 - {"time":"December 29, 2019 12:22:29 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732296694985180","opStatus":"SUCCESS","opTime":"1991 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 08:22:29 AUDIT audit:93 - {"time":"December 29, 2019 12:22:29 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"7732295695819218","opStatus":"SUCCESS","opTime":"2994 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 08:22:29 AUDIT audit:72 - {"time":"December 29, 2019 12:22:29 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"7732298696493752","opStatus":"START"}
2019-12-29 08:22:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:30 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:30 AUDIT audit:72 - {"time":"December 29, 2019 12:22:30 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732299894833986","opStatus":"START"}
2019-12-29 08:22:33 AUDIT audit:93 - {"time":"December 29, 2019 12:22:33 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732299894833986","opStatus":"SUCCESS","opTime":"2625 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 08:22:33 AUDIT audit:93 - {"time":"December 29, 2019 12:22:33 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"7732298696493752","opStatus":"SUCCESS","opTime":"3830 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 08:22:33 AUDIT audit:72 - {"time":"December 29, 2019 12:22:33 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"7732302529737201","opStatus":"START"}
2019-12-29 08:22:33 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:33 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:33 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:33 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:33 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:33 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:33 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:33 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:33 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:34 AUDIT audit:72 - {"time":"December 29, 2019 12:22:34 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732303686858300","opStatus":"START"}
2019-12-29 08:22:36 AUDIT audit:93 - {"time":"December 29, 2019 12:22:36 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732303686858300","opStatus":"SUCCESS","opTime":"2281 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 08:22:36 AUDIT audit:93 - {"time":"December 29, 2019 12:22:36 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"7732302529737201","opStatus":"SUCCESS","opTime":"3443 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 08:22:36 AUDIT audit:72 - {"time":"December 29, 2019 12:22:36 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"7732305975928271","opStatus":"START"}
2019-12-29 08:22:36 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:36 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:37 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:37 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:37 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:37 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:37 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:37 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:37 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:38 AUDIT audit:72 - {"time":"December 29, 2019 12:22:38 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732307390074082","opStatus":"START"}
2019-12-29 08:22:40 AUDIT audit:93 - {"time":"December 29, 2019 12:22:40 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732307390074082","opStatus":"SUCCESS","opTime":"2331 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 08:22:40 AUDIT audit:93 - {"time":"December 29, 2019 12:22:40 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"7732305975928271","opStatus":"SUCCESS","opTime":"3754 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 08:22:40 AUDIT audit:72 - {"time":"December 29, 2019 12:22:40 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"7732309739026025","opStatus":"START"}
2019-12-29 08:22:40 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:40 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:40 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:40 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:40 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:40 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:41 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:41 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:41 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:41 AUDIT audit:72 - {"time":"December 29, 2019 12:22:41 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732310799239064","opStatus":"START"}
2019-12-29 08:22:43 AUDIT audit:93 - {"time":"December 29, 2019 12:22:43 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732310799239064","opStatus":"SUCCESS","opTime":"2413 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 08:22:43 AUDIT audit:93 - {"time":"December 29, 2019 12:22:43 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"7732309739026025","opStatus":"SUCCESS","opTime":"3483 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 08:22:43 AUDIT audit:72 - {"time":"December 29, 2019 12:22:43 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"7732313227746021","opStatus":"START"}
2019-12-29 08:22:44 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:44 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:44 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:44 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:44 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:44 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:44 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:44 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:44 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:22:45 AUDIT audit:72 - {"time":"December 29, 2019 12:22:45 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732314331255748","opStatus":"START"}
2019-12-29 08:22:47 AUDIT audit:93 - {"time":"December 29, 2019 12:22:47 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732314331255748","opStatus":"SUCCESS","opTime":"2363 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 08:22:47 AUDIT audit:93 - {"time":"December 29, 2019 12:22:47 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"7732313227746021","opStatus":"SUCCESS","opTime":"3472 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 08:22:47 AUDIT audit:72 - {"time":"December 29, 2019 12:22:47 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"7732316703242087","opStatus":"START"}
2019-12-29 08:22:48 AUDIT audit:72 - {"time":"December 29, 2019 12:22:48 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"7732318061584073","opStatus":"START"}
2019-12-29 08:22:50 AUDIT audit:93 - {"time":"December 29, 2019 12:22:50 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"7732318061584073","opStatus":"SUCCESS","opTime":"1753 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 08:22:50 AUDIT audit:93 - {"time":"December 29, 2019 12:22:50 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"7732316703242087","opStatus":"SUCCESS","opTime":"3358 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 08:22:50 AUDIT audit:72 - {"time":"December 29, 2019 12:22:50 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"7732320265414183","opStatus":"START"}
2019-12-29 08:22:55 AUDIT audit:93 - {"time":"December 29, 2019 12:22:55 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"7732320265414183","opStatus":"SUCCESS","opTime":"4200 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
- Test data updation after compaction on Partition with mv tables
2019-12-29 08:22:55 AUDIT audit:72 - {"time":"December 29, 2019 12:22:55 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732324475076577","opStatus":"START"}
2019-12-29 08:22:55 AUDIT audit:93 - {"time":"December 29, 2019 12:22:55 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732324475076577","opStatus":"SUCCESS","opTime":"194 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 08:22:55 AUDIT audit:72 - {"time":"December 29, 2019 12:22:55 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"7732324672986543","opStatus":"START"}
2019-12-29 08:22:55 AUDIT audit:93 - {"time":"December 29, 2019 12:22:55 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"7732324672986543","opStatus":"SUCCESS","opTime":"6 ms","table":"NA","extraInfo":{"dmName":"ag"}}
2019-12-29 08:22:55 AUDIT audit:72 - {"time":"December 29, 2019 12:22:55 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"7732324685165339","opStatus":"START"}
2019-12-29 08:22:55 AUDIT audit:72 - {"time":"December 29, 2019 12:22:55 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732324907428401","opStatus":"START"}
2019-12-29 08:22:55 AUDIT audit:93 - {"time":"December 29, 2019 12:22:55 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732324907428401","opStatus":"SUCCESS","opTime":"81 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 08:22:55 AUDIT audit:93 - {"time":"December 29, 2019 12:22:55 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"7732324685165339","opStatus":"SUCCESS","opTime":"571 ms","table":"partition_mv.updatetime_8","extraInfo":{"provider":"mv","dmName":"ag"}}
2019-12-29 08:22:55 AUDIT audit:72 - {"time":"December 29, 2019 12:22:55 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"7732325267035836","opStatus":"START"}
2019-12-29 08:22:56 AUDIT audit:72 - {"time":"December 29, 2019 12:22:56 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732326015733997","opStatus":"START"}
2019-12-29 08:23:00 AUDIT audit:93 - {"time":"December 29, 2019 12:23:00 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732326015733997","opStatus":"SUCCESS","opTime":"3640 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 08:23:00 AUDIT audit:93 - {"time":"December 29, 2019 12:23:00 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"7732325267035836","opStatus":"SUCCESS","opTime":"4397 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 08:23:00 AUDIT audit:72 - {"time":"December 29, 2019 12:23:00 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"7732329673790928","opStatus":"START"}
2019-12-29 08:23:01 AUDIT audit:72 - {"time":"December 29, 2019 12:23:01 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732331189235878","opStatus":"START"}
2019-12-29 08:23:07 AUDIT audit:93 - {"time":"December 29, 2019 12:23:07 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732331189235878","opStatus":"SUCCESS","opTime":"5420 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 08:23:07 AUDIT audit:93 - {"time":"December 29, 2019 12:23:07 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"7732329673790928","opStatus":"SUCCESS","opTime":"6949 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 08:23:07 AUDIT audit:72 - {"time":"December 29, 2019 12:23:07 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"7732336643057394","opStatus":"START"}
2019-12-29 08:23:08 AUDIT audit:72 - {"time":"December 29, 2019 12:23:08 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732337908189792","opStatus":"START"}
2019-12-29 08:23:11 AUDIT audit:93 - {"time":"December 29, 2019 12:23:11 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732337908189792","opStatus":"SUCCESS","opTime":"3059 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 08:23:11 AUDIT audit:93 - {"time":"December 29, 2019 12:23:11 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"7732336643057394","opStatus":"SUCCESS","opTime":"4331 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 08:23:11 AUDIT audit:72 - {"time":"December 29, 2019 12:23:11 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"7732340989954721","opStatus":"START"}
2019-12-29 08:23:12 AUDIT audit:72 - {"time":"December 29, 2019 12:23:12 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732341791244771","opStatus":"START"}
2019-12-29 08:23:15 AUDIT audit:93 - {"time":"December 29, 2019 12:23:15 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732341791244771","opStatus":"SUCCESS","opTime":"2638 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 08:23:15 AUDIT audit:93 - {"time":"December 29, 2019 12:23:15 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"7732340989954721","opStatus":"SUCCESS","opTime":"3447 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 08:23:15 AUDIT audit:72 - {"time":"December 29, 2019 12:23:15 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"7732344454491329","opStatus":"START"}
2019-12-29 08:23:15 AUDIT audit:72 - {"time":"December 29, 2019 12:23:15 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732344859819601","opStatus":"START"}
2019-12-29 08:23:18 AUDIT audit:93 - {"time":"December 29, 2019 12:23:18 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732344859819601","opStatus":"SUCCESS","opTime":"2495 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 08:23:18 AUDIT audit:93 - {"time":"December 29, 2019 12:23:18 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"7732344454491329","opStatus":"SUCCESS","opTime":"2908 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 08:23:18 AUDIT audit:72 - {"time":"December 29, 2019 12:23:18 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"7732347380726569","opStatus":"START"}
2019-12-29 08:23:18 AUDIT audit:72 - {"time":"December 29, 2019 12:23:18 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732347824789416","opStatus":"START"}
2019-12-29 08:23:21 AUDIT audit:93 - {"time":"December 29, 2019 12:23:21 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732347824789416","opStatus":"SUCCESS","opTime":"2776 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 08:23:21 AUDIT audit:93 - {"time":"December 29, 2019 12:23:21 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"7732347380726569","opStatus":"SUCCESS","opTime":"3230 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 08:23:21 AUDIT audit:72 - {"time":"December 29, 2019 12:23:21 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"7732350628515969","opStatus":"START"}
2019-12-29 08:23:21 AUDIT audit:72 - {"time":"December 29, 2019 12:23:21 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732351196812214","opStatus":"START"}
2019-12-29 08:23:24 AUDIT audit:93 - {"time":"December 29, 2019 12:23:24 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732351196812214","opStatus":"SUCCESS","opTime":"2755 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 08:23:24 AUDIT audit:93 - {"time":"December 29, 2019 12:23:24 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"7732350628515969","opStatus":"SUCCESS","opTime":"3332 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 08:23:24 AUDIT audit:72 - {"time":"December 29, 2019 12:23:24 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"7732353977619144","opStatus":"START"}
2019-12-29 08:23:25 AUDIT audit:72 - {"time":"December 29, 2019 12:23:25 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732354400311430","opStatus":"START"}
2019-12-29 08:23:27 AUDIT audit:93 - {"time":"December 29, 2019 12:23:27 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732354400311430","opStatus":"SUCCESS","opTime":"2685 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 08:23:27 AUDIT audit:93 - {"time":"December 29, 2019 12:23:27 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"7732353977619144","opStatus":"SUCCESS","opTime":"3115 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 08:23:27 AUDIT audit:72 - {"time":"December 29, 2019 12:23:27 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"7732357094605256","opStatus":"START"}
2019-12-29 08:23:27 AUDIT audit:72 - {"time":"December 29, 2019 12:23:27 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"7732357244283352","opStatus":"START"}
2019-12-29 08:23:28 AUDIT audit:93 - {"time":"December 29, 2019 12:23:28 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"7732357244283352","opStatus":"SUCCESS","opTime":"378 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 08:23:28 AUDIT audit:72 - {"time":"December 29, 2019 12:23:28 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"7732357772735326","opStatus":"START"}
2019-12-29 08:23:28 AUDIT audit:93 - {"time":"December 29, 2019 12:23:28 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"7732357772735326","opStatus":"SUCCESS","opTime":"20 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 08:23:28 AUDIT audit:93 - {"time":"December 29, 2019 12:23:28 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"7732357094605256","opStatus":"SUCCESS","opTime":"732 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 08:23:28 AUDIT audit:72 - {"time":"December 29, 2019 12:23:28 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"7732357837413599","opStatus":"START"}
2019-12-29 08:23:28 AUDIT audit:93 - {"time":"December 29, 2019 12:23:28 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"7732357837413599","opStatus":"SUCCESS","opTime":"22 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
- Test data updation in Aggregate query after compaction on Partitioned table with mv table
2019-12-29 08:23:29 AUDIT audit:72 - {"time":"December 29, 2019 12:23:29 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"7732358342319326","opStatus":"START"}
2019-12-29 08:23:29 AUDIT audit:93 - {"time":"December 29, 2019 12:23:29 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"7732358342319326","opStatus":"SUCCESS","opTime":"548 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 08:23:29 AUDIT audit:72 - {"time":"December 29, 2019 12:23:29 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732358894224468","opStatus":"START"}
2019-12-29 08:23:29 AUDIT audit:93 - {"time":"December 29, 2019 12:23:29 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732358894224468","opStatus":"SUCCESS","opTime":"121 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 08:23:29 AUDIT audit:72 - {"time":"December 29, 2019 12:23:29 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"7732359019707851","opStatus":"START"}
2019-12-29 08:23:29 AUDIT audit:72 - {"time":"December 29, 2019 12:23:29 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732359193927213","opStatus":"START"}
2019-12-29 08:23:29 AUDIT audit:93 - {"time":"December 29, 2019 12:23:29 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732359193927213","opStatus":"SUCCESS","opTime":"89 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 08:23:30 AUDIT audit:93 - {"time":"December 29, 2019 12:23:30 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"7732359019707851","opStatus":"SUCCESS","opTime":"448 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p7"}}
2019-12-29 08:23:30 AUDIT audit:72 - {"time":"December 29, 2019 12:23:30 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"7732359470739160","opStatus":"START"}
2019-12-29 08:23:30 AUDIT audit:72 - {"time":"December 29, 2019 12:23:30 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732359492846710","opStatus":"START"}
2019-12-29 08:23:30 AUDIT audit:93 - {"time":"December 29, 2019 12:23:30 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732359492846710","opStatus":"SUCCESS","opTime":"74 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 08:23:30 AUDIT audit:93 - {"time":"December 29, 2019 12:23:30 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"7732359470739160","opStatus":"SUCCESS","opTime":"286 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p1"}}
2019-12-29 08:23:30 AUDIT audit:72 - {"time":"December 29, 2019 12:23:30 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"7732359759727492","opStatus":"START"}
2019-12-29 08:23:30 AUDIT audit:72 - {"time":"December 29, 2019 12:23:30 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732359782408740","opStatus":"START"}
2019-12-29 08:23:30 AUDIT audit:93 - {"time":"December 29, 2019 12:23:30 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732359782408740","opStatus":"SUCCESS","opTime":"56 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 08:23:30 AUDIT audit:93 - {"time":"December 29, 2019 12:23:30 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"7732359759727492","opStatus":"SUCCESS","opTime":"269 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p2"}}
2019-12-29 08:23:30 AUDIT audit:72 - {"time":"December 29, 2019 12:23:30 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"7732360032308736","opStatus":"START"}
2019-12-29 08:23:30 AUDIT audit:72 - {"time":"December 29, 2019 12:23:30 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732360058794129","opStatus":"START"}
2019-12-29 08:23:30 AUDIT audit:93 - {"time":"December 29, 2019 12:23:30 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732360058794129","opStatus":"SUCCESS","opTime":"91 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 08:23:31 AUDIT audit:93 - {"time":"December 29, 2019 12:23:31 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"7732360032308736","opStatus":"SUCCESS","opTime":"356 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p3"}}
2019-12-29 08:23:31 AUDIT audit:72 - {"time":"December 29, 2019 12:23:31 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"7732360392017045","opStatus":"START"}
2019-12-29 08:23:31 AUDIT audit:72 - {"time":"December 29, 2019 12:23:31 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732360418430245","opStatus":"START"}
2019-12-29 08:23:31 AUDIT audit:93 - {"time":"December 29, 2019 12:23:31 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732360418430245","opStatus":"SUCCESS","opTime":"57 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 08:23:31 AUDIT audit:93 - {"time":"December 29, 2019 12:23:31 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"7732360392017045","opStatus":"SUCCESS","opTime":"271 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p4"}}
2019-12-29 08:23:31 AUDIT audit:72 - {"time":"December 29, 2019 12:23:31 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"7732360666480473","opStatus":"START"}
2019-12-29 08:23:31 AUDIT audit:72 - {"time":"December 29, 2019 12:23:31 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732360694812150","opStatus":"START"}
2019-12-29 08:23:31 AUDIT audit:93 - {"time":"December 29, 2019 12:23:31 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732360694812150","opStatus":"SUCCESS","opTime":"80 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 08:23:31 AUDIT audit:93 - {"time":"December 29, 2019 12:23:31 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"7732360666480473","opStatus":"SUCCESS","opTime":"307 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p5"}}
2019-12-29 08:23:31 AUDIT audit:72 - {"time":"December 29, 2019 12:23:31 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"7732360976924706","opStatus":"START"}
2019-12-29 08:23:31 AUDIT audit:72 - {"time":"December 29, 2019 12:23:31 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732361005994538","opStatus":"START"}
2019-12-29 08:23:31 AUDIT audit:93 - {"time":"December 29, 2019 12:23:31 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732361005994538","opStatus":"SUCCESS","opTime":"145 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 08:23:32 AUDIT audit:93 - {"time":"December 29, 2019 12:23:32 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"7732360976924706","opStatus":"SUCCESS","opTime":"400 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p6"}}
2019-12-29 08:23:32 AUDIT audit:72 - {"time":"December 29, 2019 12:23:32 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"7732361385729409","opStatus":"START"}
2019-12-29 08:23:33 AUDIT audit:93 - {"time":"December 29, 2019 12:23:33 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"7732361385729409","opStatus":"SUCCESS","opTime":"1265 ms","table":"partition_mv.partitionone","extraInfo":{}}
- check partitioning for child tables with various combinations
2019-12-29 08:23:33 AUDIT audit:72 - {"time":"December 29, 2019 12:23:33 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732362661390827","opStatus":"START"}
2019-12-29 08:23:33 AUDIT audit:93 - {"time":"December 29, 2019 12:23:33 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732362661390827","opStatus":"SUCCESS","opTime":"56 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 08:23:33 AUDIT audit:72 - {"time":"December 29, 2019 12:23:33 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"7732362914305557","opStatus":"START"}
2019-12-29 08:23:34 AUDIT audit:93 - {"time":"December 29, 2019 12:23:34 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"7732362914305557","opStatus":"SUCCESS","opTime":"510 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 08:23:34 AUDIT audit:72 - {"time":"December 29, 2019 12:23:34 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"7732363426450441","opStatus":"START"}
2019-12-29 08:23:34 AUDIT audit:93 - {"time":"December 29, 2019 12:23:34 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"7732363426450441","opStatus":"SUCCESS","opTime":"4 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-29 08:23:34 AUDIT audit:72 - {"time":"December 29, 2019 12:23:34 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"7732363434223271","opStatus":"START"}
2019-12-29 08:23:34 AUDIT audit:72 - {"time":"December 29, 2019 12:23:34 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732363468583270","opStatus":"START"}
2019-12-29 08:23:34 AUDIT audit:93 - {"time":"December 29, 2019 12:23:34 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732363468583270","opStatus":"SUCCESS","opTime":"49 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 08:23:34 AUDIT audit:72 - {"time":"December 29, 2019 12:23:34 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732363767988659","opStatus":"START"}
2019-12-29 08:23:36 AUDIT audit:93 - {"time":"December 29, 2019 12:23:36 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732363767988659","opStatus":"SUCCESS","opTime":"1991 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-29 08:23:36 AUDIT audit:93 - {"time":"December 29, 2019 12:23:36 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"7732363434223271","opStatus":"SUCCESS","opTime":"2342 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-29 08:23:36 AUDIT audit:72 - {"time":"December 29, 2019 12:23:36 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"7732366240270707","opStatus":"START"}
2019-12-29 08:23:39 AUDIT audit:93 - {"time":"December 29, 2019 12:23:39 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"7732366240270707","opStatus":"SUCCESS","opTime":"2172 ms","table":"partition_mv.partitionone","extraInfo":{}}
- test partition at last column
2019-12-29 08:23:39 AUDIT audit:72 - {"time":"December 29, 2019 12:23:39 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732368423736855","opStatus":"START"}
2019-12-29 08:23:39 AUDIT audit:93 - {"time":"December 29, 2019 12:23:39 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732368423736855","opStatus":"SUCCESS","opTime":"68 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 08:23:39 AUDIT audit:72 - {"time":"December 29, 2019 12:23:39 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"7732368651285486","opStatus":"START"}
2019-12-29 08:23:39 AUDIT audit:93 - {"time":"December 29, 2019 12:23:39 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"7732368651285486","opStatus":"SUCCESS","opTime":"584 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 08:23:39 AUDIT audit:72 - {"time":"December 29, 2019 12:23:39 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"7732369237617936","opStatus":"START"}
2019-12-29 08:23:39 AUDIT audit:93 - {"time":"December 29, 2019 12:23:39 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"7732369237617936","opStatus":"SUCCESS","opTime":"5 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-29 08:23:39 AUDIT audit:72 - {"time":"December 29, 2019 12:23:39 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"7732369247370728","opStatus":"START"}
2019-12-29 08:23:39 AUDIT audit:72 - {"time":"December 29, 2019 12:23:39 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732369278375793","opStatus":"START"}
2019-12-29 08:23:40 AUDIT audit:93 - {"time":"December 29, 2019 12:23:40 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732369278375793","opStatus":"SUCCESS","opTime":"131 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 08:23:40 AUDIT audit:72 - {"time":"December 29, 2019 12:23:40 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732369637810216","opStatus":"START"}
2019-12-29 08:23:41 AUDIT audit:93 - {"time":"December 29, 2019 12:23:41 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732369637810216","opStatus":"SUCCESS","opTime":"913 ms","table":"partition_mv.dm1_table","extraInfo":{"SegmentId":"0","DataSize":"688.0B","IndexSize":"446.0B"}}
2019-12-29 08:23:41 AUDIT audit:93 - {"time":"December 29, 2019 12:23:41 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"7732369247370728","opStatus":"SUCCESS","opTime":"1316 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-29 08:23:41 AUDIT audit:72 - {"time":"December 29, 2019 12:23:41 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"7732371201648295","opStatus":"START"}
2019-12-29 08:23:42 AUDIT audit:93 - {"time":"December 29, 2019 12:23:42 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"7732371201648295","opStatus":"SUCCESS","opTime":"429 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 08:23:42 AUDIT audit:72 - {"time":"December 29, 2019 12:23:42 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732371635256267","opStatus":"START"}
2019-12-29 08:23:42 AUDIT audit:93 - {"time":"December 29, 2019 12:23:42 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732371635256267","opStatus":"SUCCESS","opTime":"131 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 08:23:42 AUDIT audit:72 - {"time":"December 29, 2019 12:23:42 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"7732371930441713","opStatus":"START"}
2019-12-29 08:23:43 AUDIT audit:93 - {"time":"December 29, 2019 12:23:43 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"7732371930441713","opStatus":"SUCCESS","opTime":"1185 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 08:23:43 AUDIT audit:72 - {"time":"December 29, 2019 12:23:43 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"7732373116353975","opStatus":"START"}
2019-12-29 08:23:43 AUDIT audit:93 - {"time":"December 29, 2019 12:23:43 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"7732373116353975","opStatus":"SUCCESS","opTime":"4 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-29 08:23:43 AUDIT audit:72 - {"time":"December 29, 2019 12:23:43 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"7732373124135958","opStatus":"START"}
2019-12-29 08:23:43 AUDIT audit:72 - {"time":"December 29, 2019 12:23:43 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732373150581721","opStatus":"START"}
2019-12-29 08:23:45 AUDIT audit:93 - {"time":"December 29, 2019 12:23:45 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"7732373150581721","opStatus":"SUCCESS","opTime":"1767 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 08:23:45 AUDIT audit:72 - {"time":"December 29, 2019 12:23:45 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732375149576079","opStatus":"START"}
2019-12-29 08:23:49 AUDIT audit:93 - {"time":"December 29, 2019 12:23:49 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"7732375149576079","opStatus":"SUCCESS","opTime":"3567 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-29 08:23:49 AUDIT audit:93 - {"time":"December 29, 2019 12:23:49 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"7732373124135958","opStatus":"SUCCESS","opTime":"5615 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-29 08:23:50 AUDIT audit:72 - {"time":"December 29, 2019 12:23:50 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"7732379388724648","opStatus":"START"}
2019-12-29 08:23:50 AUDIT audit:93 - {"time":"December 29, 2019 12:23:50 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"7732379388724648","opStatus":"SUCCESS","opTime":"359 ms","table":"partition_mv.partitionone","extraInfo":{}}
- test partition on timeseries column
2019-12-29 08:23:50 AUDIT audit:72 - {"time":"December 29, 2019 12:23:50 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"7732379756636448","opStatus":"START"}
2019-12-29 08:23:50 AUDIT audit:93 - {"time":"December 29, 2019 12:23:50 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"7732379756636448","opStatus":"SUCCESS","opTime":"1 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 08:23:50 AUDIT audit:72 - {"time":"December 29, 2019 12:23:50 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"7732379757965730","opStatus":"START"}
2019-12-29 08:23:50 AUDIT audit:93 - {"time":"December 29, 2019 12:23:50 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"7732379757965730","opStatus":"SUCCESS","opTime":"175 ms","table":"partition_mv.droppartition","extraInfo":{}}
2019-12-29 08:23:50 AUDIT audit:72 - {"time":"December 29, 2019 12:23:50 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"7732379933741591","opStatus":"START"}
2019-12-29 08:23:50 AUDIT audit:93 - {"time":"December 29, 2019 12:23:50 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"7732379933741591","opStatus":"SUCCESS","opTime":"279 ms","table":"partition_mv.maintable","extraInfo":{}}
2019-12-29 08:23:50 AUDIT audit:72 - {"time":"December 29, 2019 12:23:50 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"7732380213845752","opStatus":"START"}
2019-12-29 08:23:51 AUDIT audit:93 - {"time":"December 29, 2019 12:23:51 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"7732380213845752","opStatus":"SUCCESS","opTime":"160 ms","table":"partition_mv.par","extraInfo":{}}
2019-12-29 08:23:51 AUDIT audit:72 - {"time":"December 29, 2019 12:23:51 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"7732380375014243","opStatus":"START"}
2019-12-29 08:23:51 AUDIT audit:93 - {"time":"December 29, 2019 12:23:51 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"7732380375014243","opStatus":"SUCCESS","opTime":"295 ms","table":"partition_mv.partitiontable","extraInfo":{}}
2019-12-29 08:23:51 AUDIT audit:72 - {"time":"December 29, 2019 12:23:51 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"7732380670842332","opStatus":"START"}
2019-12-29 08:23:51 AUDIT audit:93 - {"time":"December 29, 2019 12:23:51 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"7732380670842332","opStatus":"SUCCESS","opTime":"550 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
MVTPCDSTestCase:
- test create datamap with tpcds_1_4_testCases case_1 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_3 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_4 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_5 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_6 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_8 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_11 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_15 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_16 !!! IGNORED !!!
Run completed in 14 minutes, 51 seconds.
Total number of tests run: 232
Suites: completed 21, aborted 0
Tests: succeeded 231, failed 1, canceled 0, ignored 18, pending 0
*** 1 TEST FAILED ***
[JENKINS] Recording test results

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

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/2154/display/redirect>

Changes:


------------------------------------------
[...truncated 1.13 MB...]
2019-12-29 07:12:19 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:19 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:19 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:19 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:20 AUDIT audit:72 - {"time":"December 28, 2019 11:12:20 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289589184899958","opStatus":"START"}
2019-12-29 07:12:23 AUDIT audit:93 - {"time":"December 28, 2019 11:12:23 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289589184899958","opStatus":"SUCCESS","opTime":"3475 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 07:12:23 AUDIT audit:93 - {"time":"December 28, 2019 11:12:23 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289587759137664","opStatus":"SUCCESS","opTime":"4909 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 07:12:23 AUDIT audit:72 - {"time":"December 28, 2019 11:12:23 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289592670630353","opStatus":"START"}
2019-12-29 07:12:24 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:24 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:24 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:24 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:24 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:24 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:24 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:24 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:24 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:24 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:24 AUDIT audit:72 - {"time":"December 28, 2019 11:12:24 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289593821102858","opStatus":"START"}
2019-12-29 07:12:27 AUDIT audit:93 - {"time":"December 28, 2019 11:12:27 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289593821102858","opStatus":"SUCCESS","opTime":"3006 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 07:12:27 AUDIT audit:93 - {"time":"December 28, 2019 11:12:27 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289592670630353","opStatus":"SUCCESS","opTime":"4165 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 07:12:27 AUDIT audit:72 - {"time":"December 28, 2019 11:12:27 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289596840653855","opStatus":"START"}
2019-12-29 07:12:28 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:28 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:28 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:28 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:28 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:28 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:28 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:28 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:28 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:29 AUDIT audit:72 - {"time":"December 28, 2019 11:12:29 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289598157923851","opStatus":"START"}
2019-12-29 07:12:32 AUDIT audit:93 - {"time":"December 28, 2019 11:12:32 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289598157923851","opStatus":"SUCCESS","opTime":"3368 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 07:12:32 AUDIT audit:93 - {"time":"December 28, 2019 11:12:32 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289596840653855","opStatus":"SUCCESS","opTime":"4695 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 07:12:32 AUDIT audit:72 - {"time":"December 28, 2019 11:12:32 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289601539120126","opStatus":"START"}
2019-12-29 07:12:32 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:33 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:33 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:33 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:33 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:33 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:33 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:33 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:33 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:34 AUDIT audit:72 - {"time":"December 28, 2019 11:12:34 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289603035232871","opStatus":"START"}
2019-12-29 07:12:37 AUDIT audit:93 - {"time":"December 28, 2019 11:12:37 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289603035232871","opStatus":"SUCCESS","opTime":"2926 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 07:12:37 AUDIT audit:93 - {"time":"December 28, 2019 11:12:37 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289601539120126","opStatus":"SUCCESS","opTime":"4428 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 07:12:37 AUDIT audit:72 - {"time":"December 28, 2019 11:12:37 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289605971225002","opStatus":"START"}
2019-12-29 07:12:37 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:37 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:37 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:37 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:37 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:37 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:37 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:37 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:37 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:38 AUDIT audit:72 - {"time":"December 28, 2019 11:12:38 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289607230807788","opStatus":"START"}
2019-12-29 07:12:41 AUDIT audit:93 - {"time":"December 28, 2019 11:12:41 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289607230807788","opStatus":"SUCCESS","opTime":"3006 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 07:12:41 AUDIT audit:93 - {"time":"December 28, 2019 11:12:41 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289605971225002","opStatus":"SUCCESS","opTime":"4276 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 07:12:41 AUDIT audit:72 - {"time":"December 28, 2019 11:12:41 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289610249803001","opStatus":"START"}
2019-12-29 07:12:41 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:41 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:41 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:41 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:41 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:41 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:42 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:42 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:42 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:43 AUDIT audit:72 - {"time":"December 28, 2019 11:12:43 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289611961815594","opStatus":"START"}
2019-12-29 07:12:46 AUDIT audit:93 - {"time":"December 28, 2019 11:12:46 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289611961815594","opStatus":"SUCCESS","opTime":"3150 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 07:12:46 AUDIT audit:93 - {"time":"December 28, 2019 11:12:46 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289610249803001","opStatus":"SUCCESS","opTime":"4873 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 07:12:46 AUDIT audit:72 - {"time":"December 28, 2019 11:12:46 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289615126194359","opStatus":"START"}
2019-12-29 07:12:46 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:46 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:46 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:46 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:46 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:46 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:46 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:46 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:46 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 07:12:47 AUDIT audit:72 - {"time":"December 28, 2019 11:12:47 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289616379113971","opStatus":"START"}
2019-12-29 07:12:50 AUDIT audit:93 - {"time":"December 28, 2019 11:12:50 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289616379113971","opStatus":"SUCCESS","opTime":"3141 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 07:12:50 AUDIT audit:93 - {"time":"December 28, 2019 11:12:50 PM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5289615126194359","opStatus":"SUCCESS","opTime":"4405 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 07:12:50 AUDIT audit:72 - {"time":"December 28, 2019 11:12:50 PM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5289619533748244","opStatus":"START"}
2019-12-29 07:12:51 AUDIT audit:72 - {"time":"December 28, 2019 11:12:51 PM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5289620799249742","opStatus":"START"}
2019-12-29 07:12:53 AUDIT audit:93 - {"time":"December 28, 2019 11:12:53 PM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5289620799249742","opStatus":"SUCCESS","opTime":"2034 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 07:12:54 AUDIT audit:93 - {"time":"December 28, 2019 11:12:54 PM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5289619533748244","opStatus":"SUCCESS","opTime":"3649 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 07:12:54 AUDIT audit:72 - {"time":"December 28, 2019 11:12:54 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289623436952767","opStatus":"START"}
2019-12-29 07:12:56 AUDIT audit:93 - {"time":"December 28, 2019 11:12:56 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289623436952767","opStatus":"SUCCESS","opTime":"1776 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
- Test data updation after compaction on Partition with mv tables
2019-12-29 07:12:56 AUDIT audit:72 - {"time":"December 28, 2019 11:12:56 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289625225726719","opStatus":"START"}
2019-12-29 07:12:56 AUDIT audit:93 - {"time":"December 28, 2019 11:12:56 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289625225726719","opStatus":"SUCCESS","opTime":"102 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 07:12:56 AUDIT audit:72 - {"time":"December 28, 2019 11:12:56 PM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5289625331298490","opStatus":"START"}
2019-12-29 07:12:56 AUDIT audit:93 - {"time":"December 28, 2019 11:12:56 PM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5289625331298490","opStatus":"SUCCESS","opTime":"6 ms","table":"NA","extraInfo":{"dmName":"ag"}}
2019-12-29 07:12:56 AUDIT audit:72 - {"time":"December 28, 2019 11:12:56 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289625342084582","opStatus":"START"}
2019-12-29 07:12:56 AUDIT audit:72 - {"time":"December 28, 2019 11:12:56 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289625650429187","opStatus":"START"}
2019-12-29 07:12:56 AUDIT audit:93 - {"time":"December 28, 2019 11:12:56 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289625650429187","opStatus":"SUCCESS","opTime":"45 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 07:12:57 AUDIT audit:93 - {"time":"December 28, 2019 11:12:57 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289625342084582","opStatus":"SUCCESS","opTime":"654 ms","table":"partition_mv.updatetime_8","extraInfo":{"provider":"mv","dmName":"ag"}}
2019-12-29 07:12:57 AUDIT audit:72 - {"time":"December 28, 2019 11:12:57 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289626014549533","opStatus":"START"}
2019-12-29 07:12:57 AUDIT audit:72 - {"time":"December 28, 2019 11:12:57 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289626796854247","opStatus":"START"}
2019-12-29 07:13:01 AUDIT audit:93 - {"time":"December 28, 2019 11:13:01 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289626796854247","opStatus":"SUCCESS","opTime":"3791 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 07:13:01 AUDIT audit:93 - {"time":"December 28, 2019 11:13:01 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289626014549533","opStatus":"SUCCESS","opTime":"4581 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 07:13:01 AUDIT audit:72 - {"time":"December 28, 2019 11:13:01 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289630609487746","opStatus":"START"}
2019-12-29 07:13:02 AUDIT audit:72 - {"time":"December 28, 2019 11:13:02 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289631187913396","opStatus":"START"}
2019-12-29 07:13:05 AUDIT audit:93 - {"time":"December 28, 2019 11:13:05 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289631187913396","opStatus":"SUCCESS","opTime":"3674 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 07:13:05 AUDIT audit:93 - {"time":"December 28, 2019 11:13:05 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289630609487746","opStatus":"SUCCESS","opTime":"4262 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 07:13:05 AUDIT audit:72 - {"time":"December 28, 2019 11:13:05 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289634883209954","opStatus":"START"}
2019-12-29 07:13:06 AUDIT audit:72 - {"time":"December 28, 2019 11:13:06 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289635371548463","opStatus":"START"}
2019-12-29 07:13:09 AUDIT audit:93 - {"time":"December 28, 2019 11:13:09 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289635371548463","opStatus":"SUCCESS","opTime":"3264 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 07:13:09 AUDIT audit:93 - {"time":"December 28, 2019 11:13:09 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289634883209954","opStatus":"SUCCESS","opTime":"3763 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 07:13:09 AUDIT audit:72 - {"time":"December 28, 2019 11:13:09 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289638661813612","opStatus":"START"}
2019-12-29 07:13:10 AUDIT audit:72 - {"time":"December 28, 2019 11:13:10 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289639188733312","opStatus":"START"}
2019-12-29 07:13:13 AUDIT audit:93 - {"time":"December 28, 2019 11:13:13 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289639188733312","opStatus":"SUCCESS","opTime":"3394 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 07:13:13 AUDIT audit:93 - {"time":"December 28, 2019 11:13:13 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289638661813612","opStatus":"SUCCESS","opTime":"3932 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 07:13:13 AUDIT audit:72 - {"time":"December 28, 2019 11:13:13 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289642605715632","opStatus":"START"}
2019-12-29 07:13:14 AUDIT audit:72 - {"time":"December 28, 2019 11:13:14 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289643150891681","opStatus":"START"}
2019-12-29 07:13:17 AUDIT audit:93 - {"time":"December 28, 2019 11:13:17 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289643150891681","opStatus":"SUCCESS","opTime":"3215 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 07:13:17 AUDIT audit:93 - {"time":"December 28, 2019 11:13:17 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289642605715632","opStatus":"SUCCESS","opTime":"3771 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 07:13:17 AUDIT audit:72 - {"time":"December 28, 2019 11:13:17 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289646397276215","opStatus":"START"}
2019-12-29 07:13:17 AUDIT audit:72 - {"time":"December 28, 2019 11:13:17 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289646907897524","opStatus":"START"}
2019-12-29 07:13:21 AUDIT audit:93 - {"time":"December 28, 2019 11:13:21 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289646907897524","opStatus":"SUCCESS","opTime":"3391 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 07:13:21 AUDIT audit:93 - {"time":"December 28, 2019 11:13:21 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289646397276215","opStatus":"SUCCESS","opTime":"3912 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 07:13:21 AUDIT audit:72 - {"time":"December 28, 2019 11:13:21 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289650326118112","opStatus":"START"}
2019-12-29 07:13:22 AUDIT audit:72 - {"time":"December 28, 2019 11:13:22 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289650945904890","opStatus":"START"}
2019-12-29 07:13:25 AUDIT audit:93 - {"time":"December 28, 2019 11:13:25 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289650945904890","opStatus":"SUCCESS","opTime":"3331 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 07:13:25 AUDIT audit:93 - {"time":"December 28, 2019 11:13:25 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289650326118112","opStatus":"SUCCESS","opTime":"3961 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 07:13:25 AUDIT audit:72 - {"time":"December 28, 2019 11:13:25 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289654300515292","opStatus":"START"}
2019-12-29 07:13:25 AUDIT audit:72 - {"time":"December 28, 2019 11:13:25 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289654805025643","opStatus":"START"}
2019-12-29 07:13:29 AUDIT audit:93 - {"time":"December 28, 2019 11:13:29 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289654805025643","opStatus":"SUCCESS","opTime":"3319 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 07:13:29 AUDIT audit:93 - {"time":"December 28, 2019 11:13:29 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289654300515292","opStatus":"SUCCESS","opTime":"3834 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 07:13:29 AUDIT audit:72 - {"time":"December 28, 2019 11:13:29 PM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5289658137214069","opStatus":"START"}
2019-12-29 07:13:29 AUDIT audit:72 - {"time":"December 28, 2019 11:13:29 PM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5289658304726584","opStatus":"START"}
2019-12-29 07:13:29 AUDIT audit:93 - {"time":"December 28, 2019 11:13:29 PM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5289658304726584","opStatus":"SUCCESS","opTime":"435 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 07:13:29 AUDIT audit:72 - {"time":"December 28, 2019 11:13:29 PM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5289658930672894","opStatus":"START"}
2019-12-29 07:13:30 AUDIT audit:93 - {"time":"December 28, 2019 11:13:30 PM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5289658930672894","opStatus":"SUCCESS","opTime":"33 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 07:13:30 AUDIT audit:93 - {"time":"December 28, 2019 11:13:30 PM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5289658137214069","opStatus":"SUCCESS","opTime":"884 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 07:13:30 AUDIT audit:72 - {"time":"December 28, 2019 11:13:30 PM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5289659033273097","opStatus":"START"}
2019-12-29 07:13:30 AUDIT audit:93 - {"time":"December 28, 2019 11:13:30 PM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5289659033273097","opStatus":"SUCCESS","opTime":"29 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
- Test data updation in Aggregate query after compaction on Partitioned table with mv table
2019-12-29 07:13:30 AUDIT audit:72 - {"time":"December 28, 2019 11:13:30 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289659790451578","opStatus":"START"}
2019-12-29 07:13:31 AUDIT audit:93 - {"time":"December 28, 2019 11:13:31 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289659790451578","opStatus":"SUCCESS","opTime":"437 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 07:13:31 AUDIT audit:72 - {"time":"December 28, 2019 11:13:31 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289660233158331","opStatus":"START"}
2019-12-29 07:13:31 AUDIT audit:93 - {"time":"December 28, 2019 11:13:31 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289660233158331","opStatus":"SUCCESS","opTime":"74 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 07:13:31 AUDIT audit:72 - {"time":"December 28, 2019 11:13:31 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289660313644037","opStatus":"START"}
2019-12-29 07:13:31 AUDIT audit:72 - {"time":"December 28, 2019 11:13:31 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289660591160716","opStatus":"START"}
2019-12-29 07:13:31 AUDIT audit:93 - {"time":"December 28, 2019 11:13:31 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289660591160716","opStatus":"SUCCESS","opTime":"75 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 07:13:31 AUDIT audit:93 - {"time":"December 28, 2019 11:13:31 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289660313644037","opStatus":"SUCCESS","opTime":"626 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p7"}}
2019-12-29 07:13:32 AUDIT audit:72 - {"time":"December 28, 2019 11:13:32 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289660945331806","opStatus":"START"}
2019-12-29 07:13:32 AUDIT audit:72 - {"time":"December 28, 2019 11:13:32 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289660980888961","opStatus":"START"}
2019-12-29 07:13:32 AUDIT audit:93 - {"time":"December 28, 2019 11:13:32 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289660980888961","opStatus":"SUCCESS","opTime":"52 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 07:13:32 AUDIT audit:93 - {"time":"December 28, 2019 11:13:32 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289660945331806","opStatus":"SUCCESS","opTime":"464 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p1"}}
2019-12-29 07:13:32 AUDIT audit:72 - {"time":"December 28, 2019 11:13:32 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289661414747156","opStatus":"START"}
2019-12-29 07:13:32 AUDIT audit:72 - {"time":"December 28, 2019 11:13:32 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289661454154873","opStatus":"START"}
2019-12-29 07:13:32 AUDIT audit:93 - {"time":"December 28, 2019 11:13:32 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289661454154873","opStatus":"SUCCESS","opTime":"46 ms","table":"partition_mv.p2_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"p2"}}
2019-12-29 07:13:32 AUDIT audit:93 - {"time":"December 28, 2019 11:13:32 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289661414747156","opStatus":"SUCCESS","opTime":"385 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p2"}}
2019-12-29 07:13:32 AUDIT audit:72 - {"time":"December 28, 2019 11:13:32 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289661805943034","opStatus":"START"}
2019-12-29 07:13:32 AUDIT audit:72 - {"time":"December 28, 2019 11:13:32 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289661845578833","opStatus":"START"}
2019-12-29 07:13:32 AUDIT audit:93 - {"time":"December 28, 2019 11:13:32 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289661845578833","opStatus":"SUCCESS","opTime":"62 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 07:13:33 AUDIT audit:93 - {"time":"December 28, 2019 11:13:33 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289661805943034","opStatus":"SUCCESS","opTime":"397 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p3"}}
2019-12-29 07:13:33 AUDIT audit:72 - {"time":"December 28, 2019 11:13:33 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289662208827264","opStatus":"START"}
2019-12-29 07:13:33 AUDIT audit:72 - {"time":"December 28, 2019 11:13:33 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289662252116539","opStatus":"START"}
2019-12-29 07:13:33 AUDIT audit:93 - {"time":"December 28, 2019 11:13:33 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289662252116539","opStatus":"SUCCESS","opTime":"56 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 07:13:33 AUDIT audit:93 - {"time":"December 28, 2019 11:13:33 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289662208827264","opStatus":"SUCCESS","opTime":"398 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p4"}}
2019-12-29 07:13:33 AUDIT audit:72 - {"time":"December 28, 2019 11:13:33 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289662612711498","opStatus":"START"}
2019-12-29 07:13:33 AUDIT audit:72 - {"time":"December 28, 2019 11:13:33 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289662653642120","opStatus":"START"}
2019-12-29 07:13:33 AUDIT audit:93 - {"time":"December 28, 2019 11:13:33 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289662653642120","opStatus":"SUCCESS","opTime":"79 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 07:13:34 AUDIT audit:93 - {"time":"December 28, 2019 11:13:34 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289662612711498","opStatus":"SUCCESS","opTime":"412 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p5"}}
2019-12-29 07:13:34 AUDIT audit:72 - {"time":"December 28, 2019 11:13:34 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289663030481840","opStatus":"START"}
2019-12-29 07:13:34 AUDIT audit:72 - {"time":"December 28, 2019 11:13:34 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289663079028647","opStatus":"START"}
2019-12-29 07:13:34 AUDIT audit:93 - {"time":"December 28, 2019 11:13:34 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289663079028647","opStatus":"SUCCESS","opTime":"146 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 07:13:35 AUDIT audit:93 - {"time":"December 28, 2019 11:13:35 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289663030481840","opStatus":"SUCCESS","opTime":"1081 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p6"}}
2019-12-29 07:13:35 AUDIT audit:72 - {"time":"December 28, 2019 11:13:35 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289664123156564","opStatus":"START"}
2019-12-29 07:13:36 AUDIT audit:93 - {"time":"December 28, 2019 11:13:36 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289664123156564","opStatus":"SUCCESS","opTime":"1144 ms","table":"partition_mv.partitionone","extraInfo":{}}
- check partitioning for child tables with various combinations
2019-12-29 07:13:36 AUDIT audit:72 - {"time":"December 28, 2019 11:13:36 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289665280240922","opStatus":"START"}
2019-12-29 07:13:36 AUDIT audit:93 - {"time":"December 28, 2019 11:13:36 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289665280240922","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 07:13:36 AUDIT audit:72 - {"time":"December 28, 2019 11:13:36 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289665523417307","opStatus":"START"}
2019-12-29 07:13:37 AUDIT audit:93 - {"time":"December 28, 2019 11:13:37 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289665523417307","opStatus":"SUCCESS","opTime":"567 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 07:13:37 AUDIT audit:72 - {"time":"December 28, 2019 11:13:37 PM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5289666093473939","opStatus":"START"}
2019-12-29 07:13:37 AUDIT audit:93 - {"time":"December 28, 2019 11:13:37 PM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5289666093473939","opStatus":"SUCCESS","opTime":"5 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-29 07:13:37 AUDIT audit:72 - {"time":"December 28, 2019 11:13:37 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289666103479398","opStatus":"START"}
2019-12-29 07:13:37 AUDIT audit:72 - {"time":"December 28, 2019 11:13:37 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289666138927515","opStatus":"START"}
2019-12-29 07:13:37 AUDIT audit:93 - {"time":"December 28, 2019 11:13:37 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289666138927515","opStatus":"SUCCESS","opTime":"53 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 07:13:37 AUDIT audit:72 - {"time":"December 28, 2019 11:13:37 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289666491601943","opStatus":"START"}
2019-12-29 07:13:39 AUDIT audit:93 - {"time":"December 28, 2019 11:13:39 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289666491601943","opStatus":"SUCCESS","opTime":"2432 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-29 07:13:39 AUDIT audit:93 - {"time":"December 28, 2019 11:13:39 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289666103479398","opStatus":"SUCCESS","opTime":"2833 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-29 07:13:40 AUDIT audit:72 - {"time":"December 28, 2019 11:13:40 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289669767840611","opStatus":"START"}
2019-12-29 07:13:41 AUDIT audit:93 - {"time":"December 28, 2019 11:13:41 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289669767840611","opStatus":"SUCCESS","opTime":"532 ms","table":"partition_mv.partitionone","extraInfo":{}}
- test partition at last column
2019-12-29 07:13:41 AUDIT audit:72 - {"time":"December 28, 2019 11:13:41 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289670309762361","opStatus":"START"}
2019-12-29 07:13:41 AUDIT audit:93 - {"time":"December 28, 2019 11:13:41 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289670309762361","opStatus":"SUCCESS","opTime":"115 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 07:13:41 AUDIT audit:72 - {"time":"December 28, 2019 11:13:41 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289670605605019","opStatus":"START"}
2019-12-29 07:13:42 AUDIT audit:93 - {"time":"December 28, 2019 11:13:42 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289670605605019","opStatus":"SUCCESS","opTime":"577 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 07:13:42 AUDIT audit:72 - {"time":"December 28, 2019 11:13:42 PM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5289671185321581","opStatus":"START"}
2019-12-29 07:13:42 AUDIT audit:93 - {"time":"December 28, 2019 11:13:42 PM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5289671185321581","opStatus":"SUCCESS","opTime":"3 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-29 07:13:42 AUDIT audit:72 - {"time":"December 28, 2019 11:13:42 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289671191919144","opStatus":"START"}
2019-12-29 07:13:42 AUDIT audit:72 - {"time":"December 28, 2019 11:13:42 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289671227720906","opStatus":"START"}
2019-12-29 07:13:42 AUDIT audit:93 - {"time":"December 28, 2019 11:13:42 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289671227720906","opStatus":"SUCCESS","opTime":"80 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 07:13:42 AUDIT audit:72 - {"time":"December 28, 2019 11:13:42 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289671594993367","opStatus":"START"}
2019-12-29 07:13:43 AUDIT audit:93 - {"time":"December 28, 2019 11:13:43 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289671594993367","opStatus":"SUCCESS","opTime":"1182 ms","table":"partition_mv.dm1_table","extraInfo":{"SegmentId":"0","DataSize":"688.0B","IndexSize":"446.0B"}}
2019-12-29 07:13:43 AUDIT audit:93 - {"time":"December 28, 2019 11:13:43 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289671191919144","opStatus":"SUCCESS","opTime":"1601 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-29 07:13:44 AUDIT audit:72 - {"time":"December 28, 2019 11:13:44 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289673576482370","opStatus":"START"}
2019-12-29 07:13:45 AUDIT audit:93 - {"time":"December 28, 2019 11:13:45 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289673576482370","opStatus":"SUCCESS","opTime":"370 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 07:13:45 AUDIT audit:72 - {"time":"December 28, 2019 11:13:45 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289673950920952","opStatus":"START"}
2019-12-29 07:13:45 AUDIT audit:93 - {"time":"December 28, 2019 11:13:45 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289673950920952","opStatus":"SUCCESS","opTime":"349 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 07:13:45 AUDIT audit:72 - {"time":"December 28, 2019 11:13:45 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289674478575429","opStatus":"START"}
2019-12-29 07:13:46 AUDIT audit:93 - {"time":"December 28, 2019 11:13:46 PM PST","username":"jenkins","opName":"INSERT INTO","opId":"5289674478575429","opStatus":"SUCCESS","opTime":"561 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 07:13:46 AUDIT audit:72 - {"time":"December 28, 2019 11:13:46 PM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5289675041628245","opStatus":"START"}
2019-12-29 07:13:46 AUDIT audit:93 - {"time":"December 28, 2019 11:13:46 PM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5289675041628245","opStatus":"SUCCESS","opTime":"6 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-29 07:13:46 AUDIT audit:72 - {"time":"December 28, 2019 11:13:46 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289675050809435","opStatus":"START"}
2019-12-29 07:13:46 AUDIT audit:72 - {"time":"December 28, 2019 11:13:46 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289675086676865","opStatus":"START"}
2019-12-29 07:13:46 AUDIT audit:93 - {"time":"December 28, 2019 11:13:46 PM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5289675086676865","opStatus":"SUCCESS","opTime":"46 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 07:13:46 AUDIT audit:72 - {"time":"December 28, 2019 11:13:46 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289675436285249","opStatus":"START"}
2019-12-29 07:13:48 AUDIT audit:93 - {"time":"December 28, 2019 11:13:48 PM PST","username":"jenkins","opName":"LOAD DATA","opId":"5289675436285249","opStatus":"SUCCESS","opTime":"2454 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-29 07:13:48 AUDIT audit:93 - {"time":"December 28, 2019 11:13:48 PM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5289675050809435","opStatus":"SUCCESS","opTime":"2851 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-29 07:13:49 AUDIT audit:72 - {"time":"December 28, 2019 11:13:49 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289678678804143","opStatus":"START"}
2019-12-29 07:13:50 AUDIT audit:93 - {"time":"December 28, 2019 11:13:50 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289678678804143","opStatus":"SUCCESS","opTime":"312 ms","table":"partition_mv.partitionone","extraInfo":{}}
- test partition on timeseries column
2019-12-29 07:13:50 AUDIT audit:72 - {"time":"December 28, 2019 11:13:50 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289679001466607","opStatus":"START"}
2019-12-29 07:13:50 AUDIT audit:93 - {"time":"December 28, 2019 11:13:50 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289679001466607","opStatus":"SUCCESS","opTime":"2 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 07:13:50 AUDIT audit:72 - {"time":"December 28, 2019 11:13:50 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289679003449045","opStatus":"START"}
2019-12-29 07:13:50 AUDIT audit:93 - {"time":"December 28, 2019 11:13:50 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289679003449045","opStatus":"SUCCESS","opTime":"155 ms","table":"partition_mv.droppartition","extraInfo":{}}
2019-12-29 07:13:50 AUDIT audit:72 - {"time":"December 28, 2019 11:13:50 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289679158666074","opStatus":"START"}
2019-12-29 07:13:50 AUDIT audit:93 - {"time":"December 28, 2019 11:13:50 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289679158666074","opStatus":"SUCCESS","opTime":"244 ms","table":"partition_mv.maintable","extraInfo":{}}
2019-12-29 07:13:50 AUDIT audit:72 - {"time":"December 28, 2019 11:13:50 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289679403532829","opStatus":"START"}
2019-12-29 07:13:50 AUDIT audit:93 - {"time":"December 28, 2019 11:13:50 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289679403532829","opStatus":"SUCCESS","opTime":"312 ms","table":"partition_mv.par","extraInfo":{}}
2019-12-29 07:13:50 AUDIT audit:72 - {"time":"December 28, 2019 11:13:50 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289679716833081","opStatus":"START"}
2019-12-29 07:13:51 AUDIT audit:93 - {"time":"December 28, 2019 11:13:51 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289679716833081","opStatus":"SUCCESS","opTime":"339 ms","table":"partition_mv.partitiontable","extraInfo":{}}
2019-12-29 07:13:51 AUDIT audit:72 - {"time":"December 28, 2019 11:13:51 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289680056561950","opStatus":"START"}
2019-12-29 07:13:51 AUDIT audit:93 - {"time":"December 28, 2019 11:13:51 PM PST","username":"jenkins","opName":"DROP TABLE","opId":"5289680056561950","opStatus":"SUCCESS","opTime":"478 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
MVTPCDSTestCase:
- test create datamap with tpcds_1_4_testCases case_1 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_3 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_4 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_5 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_6 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_8 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_11 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_15 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_16 !!! IGNORED !!!
Run completed in 18 minutes, 42 seconds.
Total number of tests run: 232
Suites: completed 21, aborted 0
Tests: succeeded 231, failed 1, canceled 0, ignored 18, pending 0
*** 1 TEST FAILED ***
[JENKINS] Recording test results