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 08:39:45 UTC

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

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

Changes:


------------------------------------------
[...truncated 1.14 MB...]
2019-12-29 08:36:26 AUDIT audit:72 - {"time":"December 29, 2019 12:36:26 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795700027393628","opStatus":"START"}
2019-12-29 08:36:28 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-29 08:36:28 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-29 08:36:28 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-29 08:36:28 ERROR DataTypeUtil:385 - Problem while converting data typeconfigManagement
2019-12-29 08:36:28 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-29 08:36:28 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-29 08:36:28 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-29 08:36:28 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-29 08:36:28 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-29 08:36:28 AUDIT audit:93 - {"time":"December 29, 2019 12:36:28 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795700027393628","opStatus":"SUCCESS","opTime":"1996 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 08:36:28 AUDIT audit:93 - {"time":"December 29, 2019 12:36:28 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10795699057020181","opStatus":"SUCCESS","opTime":"2973 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 08:36:28 AUDIT audit:72 - {"time":"December 29, 2019 12:36:28 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10795702037385172","opStatus":"START"}
2019-12-29 08:36:28 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:29 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:29 AUDIT audit:72 - {"time":"December 29, 2019 12:36:29 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795703159068857","opStatus":"START"}
2019-12-29 08:36:31 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-29 08:36:31 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-29 08:36:31 AUDIT audit:93 - {"time":"December 29, 2019 12:36:31 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795703159068857","opStatus":"SUCCESS","opTime":"1891 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 08:36:31 AUDIT audit:93 - {"time":"December 29, 2019 12:36:31 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10795702037385172","opStatus":"SUCCESS","opTime":"3018 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 08:36:31 AUDIT audit:72 - {"time":"December 29, 2019 12:36:31 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10795705059132210","opStatus":"START"}
2019-12-29 08:36:31 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:31 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:32 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:32 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:32 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:32 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:32 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:32 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:32 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:32 AUDIT audit:72 - {"time":"December 29, 2019 12:36:32 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795706169882563","opStatus":"START"}
2019-12-29 08:36:34 ERROR DataTypeUtil:385 - Problem while converting data typeconfigManagement
2019-12-29 08:36:34 AUDIT audit:93 - {"time":"December 29, 2019 12:36:34 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795706169882563","opStatus":"SUCCESS","opTime":"2006 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 08:36:34 AUDIT audit:93 - {"time":"December 29, 2019 12:36:34 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10795705059132210","opStatus":"SUCCESS","opTime":"3123 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 08:36:34 AUDIT audit:72 - {"time":"December 29, 2019 12:36:34 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10795708185635903","opStatus":"START"}
2019-12-29 08:36:35 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:35 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:35 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:35 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:35 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:35 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:35 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:35 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:35 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:35 AUDIT audit:72 - {"time":"December 29, 2019 12:36:35 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795709212626507","opStatus":"START"}
2019-12-29 08:36:37 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-29 08:36:37 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-29 08:36:37 AUDIT audit:93 - {"time":"December 29, 2019 12:36:37 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795709212626507","opStatus":"SUCCESS","opTime":"1959 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 08:36:37 AUDIT audit:93 - {"time":"December 29, 2019 12:36:37 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10795708185635903","opStatus":"SUCCESS","opTime":"2993 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 08:36:37 AUDIT audit:72 - {"time":"December 29, 2019 12:36:37 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10795711181740845","opStatus":"START"}
2019-12-29 08:36:38 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:38 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:38 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:38 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:38 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:38 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:38 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:38 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:38 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:38 AUDIT audit:72 - {"time":"December 29, 2019 12:36:38 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795712418884416","opStatus":"START"}
2019-12-29 08:36:40 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-29 08:36:40 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-29 08:36:40 AUDIT audit:93 - {"time":"December 29, 2019 12:36:40 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795712418884416","opStatus":"SUCCESS","opTime":"1923 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 08:36:40 AUDIT audit:93 - {"time":"December 29, 2019 12:36:40 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10795711181740845","opStatus":"SUCCESS","opTime":"3166 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 08:36:40 AUDIT audit:72 - {"time":"December 29, 2019 12:36:40 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10795714351718112","opStatus":"START"}
2019-12-29 08:36:41 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:41 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:41 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:41 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:41 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:41 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:41 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:41 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:41 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 08:36:42 AUDIT audit:72 - {"time":"December 29, 2019 12:36:42 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795715432245717","opStatus":"START"}
2019-12-29 08:36:43 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-29 08:36:43 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-29 08:36:43 AUDIT audit:93 - {"time":"December 29, 2019 12:36:43 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795715432245717","opStatus":"SUCCESS","opTime":"1878 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 08:36:43 AUDIT audit:93 - {"time":"December 29, 2019 12:36:43 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10795714351718112","opStatus":"SUCCESS","opTime":"2965 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 08:36:43 AUDIT audit:72 - {"time":"December 29, 2019 12:36:43 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10795717319649050","opStatus":"START"}
2019-12-29 08:36:45 AUDIT audit:72 - {"time":"December 29, 2019 12:36:45 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10795718611538629","opStatus":"START"}
2019-12-29 08:36:46 AUDIT audit:93 - {"time":"December 29, 2019 12:36:46 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10795718611538629","opStatus":"SUCCESS","opTime":"1383 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 08:36:46 AUDIT audit:93 - {"time":"December 29, 2019 12:36:46 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10795717319649050","opStatus":"SUCCESS","opTime":"2847 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 08:36:46 AUDIT audit:72 - {"time":"December 29, 2019 12:36:46 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10795720325416259","opStatus":"START"}
2019-12-29 08:36:48 AUDIT audit:93 - {"time":"December 29, 2019 12:36:48 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10795720325416259","opStatus":"SUCCESS","opTime":"1210 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
- Test data updation after compaction on Partition with mv tables
2019-12-29 08:36:48 AUDIT audit:72 - {"time":"December 29, 2019 12:36:48 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795721544152344","opStatus":"START"}
2019-12-29 08:36:48 AUDIT audit:93 - {"time":"December 29, 2019 12:36:48 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795721544152344","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 08:36:48 AUDIT audit:72 - {"time":"December 29, 2019 12:36:48 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10795721646623860","opStatus":"START"}
2019-12-29 08:36:48 AUDIT audit:93 - {"time":"December 29, 2019 12:36:48 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10795721646623860","opStatus":"SUCCESS","opTime":"3 ms","table":"NA","extraInfo":{"dmName":"ag"}}
2019-12-29 08:36:48 AUDIT audit:72 - {"time":"December 29, 2019 12:36:48 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10795721653334250","opStatus":"START"}
2019-12-29 08:36:48 AUDIT audit:72 - {"time":"December 29, 2019 12:36:48 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795721813828791","opStatus":"START"}
2019-12-29 08:36:48 AUDIT audit:93 - {"time":"December 29, 2019 12:36:48 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795721813828791","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 08:36:48 AUDIT audit:93 - {"time":"December 29, 2019 12:36:48 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10795721653334250","opStatus":"SUCCESS","opTime":"373 ms","table":"partition_mv.updatetime_8","extraInfo":{"provider":"mv","dmName":"ag"}}
2019-12-29 08:36:48 AUDIT audit:72 - {"time":"December 29, 2019 12:36:48 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10795722036150645","opStatus":"START"}
2019-12-29 08:36:49 AUDIT audit:72 - {"time":"December 29, 2019 12:36:49 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795722532642499","opStatus":"START"}
2019-12-29 08:36:51 AUDIT audit:93 - {"time":"December 29, 2019 12:36:51 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795722532642499","opStatus":"SUCCESS","opTime":"2200 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 08:36:51 AUDIT audit:93 - {"time":"December 29, 2019 12:36:51 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10795722036150645","opStatus":"SUCCESS","opTime":"2706 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 08:36:51 AUDIT audit:72 - {"time":"December 29, 2019 12:36:51 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10795724751784877","opStatus":"START"}
2019-12-29 08:36:51 AUDIT audit:72 - {"time":"December 29, 2019 12:36:51 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795725176824636","opStatus":"START"}
2019-12-29 08:36:53 AUDIT audit:93 - {"time":"December 29, 2019 12:36:53 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795725176824636","opStatus":"SUCCESS","opTime":"2045 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 08:36:53 AUDIT audit:93 - {"time":"December 29, 2019 12:36:53 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10795724751784877","opStatus":"SUCCESS","opTime":"2477 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 08:36:53 AUDIT audit:72 - {"time":"December 29, 2019 12:36:53 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10795727237945258","opStatus":"START"}
2019-12-29 08:36:54 AUDIT audit:72 - {"time":"December 29, 2019 12:36:54 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795727607445770","opStatus":"START"}
2019-12-29 08:36:56 AUDIT audit:93 - {"time":"December 29, 2019 12:36:56 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795727607445770","opStatus":"SUCCESS","opTime":"2182 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 08:36:56 AUDIT audit:93 - {"time":"December 29, 2019 12:36:56 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10795727237945258","opStatus":"SUCCESS","opTime":"2558 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 08:36:56 AUDIT audit:72 - {"time":"December 29, 2019 12:36:56 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10795729805822087","opStatus":"START"}
2019-12-29 08:36:56 AUDIT audit:72 - {"time":"December 29, 2019 12:36:56 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795730173978983","opStatus":"START"}
2019-12-29 08:36:58 AUDIT audit:93 - {"time":"December 29, 2019 12:36:58 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795730173978983","opStatus":"SUCCESS","opTime":"2011 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 08:36:58 AUDIT audit:93 - {"time":"December 29, 2019 12:36:58 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10795729805822087","opStatus":"SUCCESS","opTime":"2387 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 08:36:58 AUDIT audit:72 - {"time":"December 29, 2019 12:36:58 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10795732201622513","opStatus":"START"}
2019-12-29 08:36:59 AUDIT audit:72 - {"time":"December 29, 2019 12:36:59 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795732560340512","opStatus":"START"}
2019-12-29 08:37:01 AUDIT audit:93 - {"time":"December 29, 2019 12:37:01 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795732560340512","opStatus":"SUCCESS","opTime":"2020 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 08:37:01 AUDIT audit:93 - {"time":"December 29, 2019 12:37:01 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10795732201622513","opStatus":"SUCCESS","opTime":"2385 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 08:37:01 AUDIT audit:72 - {"time":"December 29, 2019 12:37:01 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10795734596232754","opStatus":"START"}
2019-12-29 08:37:01 AUDIT audit:72 - {"time":"December 29, 2019 12:37:01 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795734959131763","opStatus":"START"}
2019-12-29 08:37:03 AUDIT audit:93 - {"time":"December 29, 2019 12:37:03 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795734959131763","opStatus":"SUCCESS","opTime":"2145 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 08:37:03 AUDIT audit:93 - {"time":"December 29, 2019 12:37:03 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10795734596232754","opStatus":"SUCCESS","opTime":"2514 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 08:37:03 AUDIT audit:72 - {"time":"December 29, 2019 12:37:03 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10795737119767015","opStatus":"START"}
2019-12-29 08:37:04 AUDIT audit:72 - {"time":"December 29, 2019 12:37:04 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795737525116070","opStatus":"START"}
2019-12-29 08:37:06 AUDIT audit:93 - {"time":"December 29, 2019 12:37:06 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795737525116070","opStatus":"SUCCESS","opTime":"2015 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 08:37:06 AUDIT audit:93 - {"time":"December 29, 2019 12:37:06 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10795737119767015","opStatus":"SUCCESS","opTime":"2427 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 08:37:06 AUDIT audit:72 - {"time":"December 29, 2019 12:37:06 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10795739553924012","opStatus":"START"}
2019-12-29 08:37:06 AUDIT audit:72 - {"time":"December 29, 2019 12:37:06 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795739890190115","opStatus":"START"}
2019-12-29 08:37:08 AUDIT audit:93 - {"time":"December 29, 2019 12:37:08 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795739890190115","opStatus":"SUCCESS","opTime":"2009 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 08:37:08 AUDIT audit:93 - {"time":"December 29, 2019 12:37:08 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10795739553924012","opStatus":"SUCCESS","opTime":"2353 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 08:37:08 AUDIT audit:72 - {"time":"December 29, 2019 12:37:08 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10795741908200168","opStatus":"START"}
2019-12-29 08:37:08 AUDIT audit:72 - {"time":"December 29, 2019 12:37:08 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10795742046707087","opStatus":"START"}
2019-12-29 08:37:09 AUDIT audit:93 - {"time":"December 29, 2019 12:37:09 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10795742046707087","opStatus":"SUCCESS","opTime":"480 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 08:37:09 AUDIT audit:72 - {"time":"December 29, 2019 12:37:09 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10795742678810138","opStatus":"START"}
2019-12-29 08:37:09 AUDIT audit:93 - {"time":"December 29, 2019 12:37:09 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10795742678810138","opStatus":"SUCCESS","opTime":"23 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 08:37:09 AUDIT audit:93 - {"time":"December 29, 2019 12:37:09 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10795741908200168","opStatus":"SUCCESS","opTime":"833 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 08:37:09 AUDIT audit:72 - {"time":"December 29, 2019 12:37:09 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10795742748888504","opStatus":"START"}
2019-12-29 08:37:09 AUDIT audit:93 - {"time":"December 29, 2019 12:37:09 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10795742748888504","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 08:37:09 AUDIT audit:72 - {"time":"December 29, 2019 12:37:09 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10795743248628795","opStatus":"START"}
2019-12-29 08:37:10 AUDIT audit:93 - {"time":"December 29, 2019 12:37:10 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10795743248628795","opStatus":"SUCCESS","opTime":"206 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 08:37:10 AUDIT audit:72 - {"time":"December 29, 2019 12:37:10 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795743458263171","opStatus":"START"}
2019-12-29 08:37:10 AUDIT audit:93 - {"time":"December 29, 2019 12:37:10 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795743458263171","opStatus":"SUCCESS","opTime":"69 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 08:37:10 AUDIT audit:72 - {"time":"December 29, 2019 12:37:10 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10795743530586906","opStatus":"START"}
2019-12-29 08:37:10 AUDIT audit:72 - {"time":"December 29, 2019 12:37:10 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795743674556813","opStatus":"START"}
2019-12-29 08:37:10 AUDIT audit:93 - {"time":"December 29, 2019 12:37:10 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795743674556813","opStatus":"SUCCESS","opTime":"50 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:37:10 AUDIT audit:93 - {"time":"December 29, 2019 12:37:10 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10795743530586906","opStatus":"SUCCESS","opTime":"348 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p7"}}
2019-12-29 08:37:10 AUDIT audit:72 - {"time":"December 29, 2019 12:37:10 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10795743882367063","opStatus":"START"}
2019-12-29 08:37:10 AUDIT audit:72 - {"time":"December 29, 2019 12:37:10 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795743900943902","opStatus":"START"}
2019-12-29 08:37:10 AUDIT audit:93 - {"time":"December 29, 2019 12:37:10 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795743900943902","opStatus":"SUCCESS","opTime":"45 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:37:10 AUDIT audit:93 - {"time":"December 29, 2019 12:37:10 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10795743882367063","opStatus":"SUCCESS","opTime":"215 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p1"}}
2019-12-29 08:37:10 AUDIT audit:72 - {"time":"December 29, 2019 12:37:10 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10795744101344326","opStatus":"START"}
2019-12-29 08:37:10 AUDIT audit:72 - {"time":"December 29, 2019 12:37:10 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795744121365648","opStatus":"START"}
2019-12-29 08:37:10 AUDIT audit:93 - {"time":"December 29, 2019 12:37:10 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795744121365648","opStatus":"SUCCESS","opTime":"44 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:37:10 AUDIT audit:93 - {"time":"December 29, 2019 12:37:10 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10795744101344326","opStatus":"SUCCESS","opTime":"221 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p2"}}
2019-12-29 08:37:10 AUDIT audit:72 - {"time":"December 29, 2019 12:37:10 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10795744326305570","opStatus":"START"}
2019-12-29 08:37:10 AUDIT audit:72 - {"time":"December 29, 2019 12:37:10 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795744348927964","opStatus":"START"}
2019-12-29 08:37:10 AUDIT audit:93 - {"time":"December 29, 2019 12:37:10 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795744348927964","opStatus":"SUCCESS","opTime":"44 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:37:11 AUDIT audit:93 - {"time":"December 29, 2019 12:37:11 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10795744326305570","opStatus":"SUCCESS","opTime":"225 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p3"}}
2019-12-29 08:37:11 AUDIT audit:72 - {"time":"December 29, 2019 12:37:11 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10795744555644559","opStatus":"START"}
2019-12-29 08:37:11 AUDIT audit:72 - {"time":"December 29, 2019 12:37:11 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795744578723886","opStatus":"START"}
2019-12-29 08:37:11 AUDIT audit:93 - {"time":"December 29, 2019 12:37:11 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795744578723886","opStatus":"SUCCESS","opTime":"42 ms","table":"partition_mv.p4_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"p4"}}
2019-12-29 08:37:11 AUDIT audit:93 - {"time":"December 29, 2019 12:37:11 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10795744555644559","opStatus":"SUCCESS","opTime":"229 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p4"}}
2019-12-29 08:37:11 AUDIT audit:72 - {"time":"December 29, 2019 12:37:11 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10795744789083645","opStatus":"START"}
2019-12-29 08:37:11 AUDIT audit:72 - {"time":"December 29, 2019 12:37:11 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795744811645594","opStatus":"START"}
2019-12-29 08:37:11 AUDIT audit:93 - {"time":"December 29, 2019 12:37:11 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795744811645594","opStatus":"SUCCESS","opTime":"42 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:37:11 AUDIT audit:93 - {"time":"December 29, 2019 12:37:11 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10795744789083645","opStatus":"SUCCESS","opTime":"223 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p5"}}
2019-12-29 08:37:11 AUDIT audit:72 - {"time":"December 29, 2019 12:37:11 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10795745061061713","opStatus":"START"}
2019-12-29 08:37:11 AUDIT audit:72 - {"time":"December 29, 2019 12:37:11 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795745092384939","opStatus":"START"}
2019-12-29 08:37:11 AUDIT audit:93 - {"time":"December 29, 2019 12:37:11 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795745092384939","opStatus":"SUCCESS","opTime":"43 ms","table":"partition_mv.p6_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"p6"}}
2019-12-29 08:37:11 AUDIT audit:93 - {"time":"December 29, 2019 12:37:11 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10795745061061713","opStatus":"SUCCESS","opTime":"239 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p6"}}
2019-12-29 08:37:11 AUDIT audit:72 - {"time":"December 29, 2019 12:37:11 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10795745307292282","opStatus":"START"}
2019-12-29 08:37:12 AUDIT audit:93 - {"time":"December 29, 2019 12:37:12 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10795745307292282","opStatus":"SUCCESS","opTime":"490 ms","table":"partition_mv.partitionone","extraInfo":{}}
- check partitioning for child tables with various combinations
2019-12-29 08:37:12 AUDIT audit:72 - {"time":"December 29, 2019 12:37:12 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795745803546835","opStatus":"START"}
2019-12-29 08:37:12 AUDIT audit:93 - {"time":"December 29, 2019 12:37:12 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795745803546835","opStatus":"SUCCESS","opTime":"42 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 08:37:12 AUDIT audit:72 - {"time":"December 29, 2019 12:37:12 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10795745918645788","opStatus":"START"}
2019-12-29 08:37:12 AUDIT audit:93 - {"time":"December 29, 2019 12:37:12 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10795745918645788","opStatus":"SUCCESS","opTime":"332 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 08:37:12 AUDIT audit:72 - {"time":"December 29, 2019 12:37:12 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10795746252509143","opStatus":"START"}
2019-12-29 08:37:12 AUDIT audit:93 - {"time":"December 29, 2019 12:37:12 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10795746252509143","opStatus":"SUCCESS","opTime":"3 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-29 08:37:12 AUDIT audit:72 - {"time":"December 29, 2019 12:37:12 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10795746257699777","opStatus":"START"}
2019-12-29 08:37:12 AUDIT audit:72 - {"time":"December 29, 2019 12:37:12 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795746272614066","opStatus":"START"}
2019-12-29 08:37:12 AUDIT audit:93 - {"time":"December 29, 2019 12:37:12 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795746272614066","opStatus":"SUCCESS","opTime":"42 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:37:13 AUDIT audit:72 - {"time":"December 29, 2019 12:37:13 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795746448861472","opStatus":"START"}
2019-12-29 08:37:14 AUDIT audit:93 - {"time":"December 29, 2019 12:37:14 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795746448861472","opStatus":"SUCCESS","opTime":"1402 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-29 08:37:14 AUDIT audit:93 - {"time":"December 29, 2019 12:37:14 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10795746257699777","opStatus":"SUCCESS","opTime":"1605 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-29 08:37:14 AUDIT audit:72 - {"time":"December 29, 2019 12:37:14 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10795748318201337","opStatus":"START"}
2019-12-29 08:37:15 AUDIT audit:93 - {"time":"December 29, 2019 12:37:15 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10795748318201337","opStatus":"SUCCESS","opTime":"193 ms","table":"partition_mv.partitionone","extraInfo":{}}
- test partition at last column
2019-12-29 08:37:15 AUDIT audit:72 - {"time":"December 29, 2019 12:37:15 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795748517921414","opStatus":"START"}
2019-12-29 08:37:15 AUDIT audit:93 - {"time":"December 29, 2019 12:37:15 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795748517921414","opStatus":"SUCCESS","opTime":"40 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 08:37:15 AUDIT audit:72 - {"time":"December 29, 2019 12:37:15 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10795748646106916","opStatus":"START"}
2019-12-29 08:37:15 AUDIT audit:93 - {"time":"December 29, 2019 12:37:15 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10795748646106916","opStatus":"SUCCESS","opTime":"370 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 08:37:15 AUDIT audit:72 - {"time":"December 29, 2019 12:37:15 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10795749018542190","opStatus":"START"}
2019-12-29 08:37:15 AUDIT audit:93 - {"time":"December 29, 2019 12:37:15 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10795749018542190","opStatus":"SUCCESS","opTime":"4 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-29 08:37:15 AUDIT audit:72 - {"time":"December 29, 2019 12:37:15 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10795749025297325","opStatus":"START"}
2019-12-29 08:37:15 AUDIT audit:72 - {"time":"December 29, 2019 12:37:15 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795749047262943","opStatus":"START"}
2019-12-29 08:37:15 AUDIT audit:93 - {"time":"December 29, 2019 12:37:15 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795749047262943","opStatus":"SUCCESS","opTime":"41 ms","table":"partition_mv.dm1_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"dm1"}}
2019-12-29 08:37:15 AUDIT audit:72 - {"time":"December 29, 2019 12:37:15 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795749248904732","opStatus":"START"}
2019-12-29 08:37:16 AUDIT audit:93 - {"time":"December 29, 2019 12:37:16 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795749248904732","opStatus":"SUCCESS","opTime":"815 ms","table":"partition_mv.dm1_table","extraInfo":{"SegmentId":"0","DataSize":"666.0B","IndexSize":"435.0B"}}
2019-12-29 08:37:16 AUDIT audit:93 - {"time":"December 29, 2019 12:37:16 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10795749025297325","opStatus":"SUCCESS","opTime":"1051 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-29 08:37:17 AUDIT audit:72 - {"time":"December 29, 2019 12:37:17 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10795750572145073","opStatus":"START"}
2019-12-29 08:37:17 AUDIT audit:93 - {"time":"December 29, 2019 12:37:17 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10795750572145073","opStatus":"SUCCESS","opTime":"207 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 08:37:17 AUDIT audit:72 - {"time":"December 29, 2019 12:37:17 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795750782887054","opStatus":"START"}
2019-12-29 08:37:17 AUDIT audit:93 - {"time":"December 29, 2019 12:37:17 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795750782887054","opStatus":"SUCCESS","opTime":"65 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 08:37:17 AUDIT audit:72 - {"time":"December 29, 2019 12:37:17 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10795750935457471","opStatus":"START"}
2019-12-29 08:37:17 AUDIT audit:93 - {"time":"December 29, 2019 12:37:17 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10795750935457471","opStatus":"SUCCESS","opTime":"386 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 08:37:17 AUDIT audit:72 - {"time":"December 29, 2019 12:37:17 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10795751323856138","opStatus":"START"}
2019-12-29 08:37:17 AUDIT audit:93 - {"time":"December 29, 2019 12:37:17 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10795751323856138","opStatus":"SUCCESS","opTime":"3 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-29 08:37:17 AUDIT audit:72 - {"time":"December 29, 2019 12:37:17 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10795751330459195","opStatus":"START"}
2019-12-29 08:37:17 AUDIT audit:72 - {"time":"December 29, 2019 12:37:17 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795751349383306","opStatus":"START"}
2019-12-29 08:37:17 AUDIT audit:93 - {"time":"December 29, 2019 12:37:17 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10795751349383306","opStatus":"SUCCESS","opTime":"45 ms","table":"partition_mv.dm1_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"dm1"}}
2019-12-29 08:37:18 AUDIT audit:72 - {"time":"December 29, 2019 12:37:18 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795751550515461","opStatus":"START"}
2019-12-29 08:37:19 AUDIT audit:93 - {"time":"December 29, 2019 12:37:19 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10795751550515461","opStatus":"SUCCESS","opTime":"1481 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-29 08:37:19 AUDIT audit:93 - {"time":"December 29, 2019 12:37:19 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10795751330459195","opStatus":"SUCCESS","opTime":"1710 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-29 08:37:20 AUDIT audit:72 - {"time":"December 29, 2019 12:37:20 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10795753595001819","opStatus":"START"}
2019-12-29 08:37:20 AUDIT audit:93 - {"time":"December 29, 2019 12:37:20 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10795753595001819","opStatus":"SUCCESS","opTime":"162 ms","table":"partition_mv.partitionone","extraInfo":{}}
- test partition on timeseries column
2019-12-29 08:37:20 AUDIT audit:72 - {"time":"December 29, 2019 12:37:20 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10795753761755963","opStatus":"START"}
2019-12-29 08:37:20 AUDIT audit:93 - {"time":"December 29, 2019 12:37:20 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10795753761755963","opStatus":"SUCCESS","opTime":"1 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 08:37:20 AUDIT audit:72 - {"time":"December 29, 2019 12:37:20 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10795753762798376","opStatus":"START"}
2019-12-29 08:37:20 AUDIT audit:93 - {"time":"December 29, 2019 12:37:20 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10795753762798376","opStatus":"SUCCESS","opTime":"85 ms","table":"partition_mv.droppartition","extraInfo":{}}
2019-12-29 08:37:20 AUDIT audit:72 - {"time":"December 29, 2019 12:37:20 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10795753847790177","opStatus":"START"}
2019-12-29 08:37:20 AUDIT audit:93 - {"time":"December 29, 2019 12:37:20 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10795753847790177","opStatus":"SUCCESS","opTime":"115 ms","table":"partition_mv.maintable","extraInfo":{}}
2019-12-29 08:37:20 AUDIT audit:72 - {"time":"December 29, 2019 12:37:20 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10795753962939312","opStatus":"START"}
2019-12-29 08:37:20 AUDIT audit:93 - {"time":"December 29, 2019 12:37:20 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10795753962939312","opStatus":"SUCCESS","opTime":"46 ms","table":"partition_mv.par","extraInfo":{}}
2019-12-29 08:37:20 AUDIT audit:72 - {"time":"December 29, 2019 12:37:20 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10795754009184509","opStatus":"START"}
2019-12-29 08:37:20 AUDIT audit:93 - {"time":"December 29, 2019 12:37:20 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10795754009184509","opStatus":"SUCCESS","opTime":"107 ms","table":"partition_mv.partitiontable","extraInfo":{}}
2019-12-29 08:37:20 AUDIT audit:72 - {"time":"December 29, 2019 12:37:20 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10795754116876041","opStatus":"START"}
2019-12-29 08:37:20 AUDIT audit:93 - {"time":"December 29, 2019 12:37:20 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10795754116876041","opStatus":"SUCCESS","opTime":"211 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
MVTPCDSTestCase:
- test create datamap with tpcds_1_4_testCases case_1 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_3 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_4 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_5 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_6 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_8 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_11 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_15 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_16 !!! IGNORED !!!
Run completed in 11 minutes, 28 seconds.
Total number of tests run: 232
Suites: completed 21, aborted 0
Tests: succeeded 229, failed 3, canceled 0, ignored 18, pending 0
*** 3 TESTS FAILED ***
[JENKINS] Recording test results

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

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

Changes:


------------------------------------------
[...truncated 1.16 MB...]
2019-12-29 13:39:49 AUDIT audit:72 - {"time":"December 29, 2019 5:39:49 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813902830593354","opStatus":"START"}
2019-12-29 13:39:50 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-29 13:39:50 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-29 13:39:50 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-29 13:39:50 ERROR DataTypeUtil:385 - Problem while converting data typeconfigManagement
2019-12-29 13:39:51 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-29 13:39:51 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-29 13:39:51 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-29 13:39:51 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-29 13:39:51 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-29 13:39:51 AUDIT audit:93 - {"time":"December 29, 2019 5:39:51 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813902830593354","opStatus":"SUCCESS","opTime":"1993 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 13:39:51 AUDIT audit:93 - {"time":"December 29, 2019 5:39:51 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10813901747453526","opStatus":"SUCCESS","opTime":"3082 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 13:39:51 AUDIT audit:72 - {"time":"December 29, 2019 5:39:51 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10813904836224374","opStatus":"START"}
2019-12-29 13:39:51 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:51 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:51 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:51 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:52 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:52 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:52 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:52 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:52 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:52 AUDIT audit:72 - {"time":"December 29, 2019 5:39:52 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813905895976285","opStatus":"START"}
2019-12-29 13:39:54 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-29 13:39:54 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-29 13:39:54 AUDIT audit:93 - {"time":"December 29, 2019 5:39:54 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813905895976285","opStatus":"SUCCESS","opTime":"1992 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 13:39:54 AUDIT audit:93 - {"time":"December 29, 2019 5:39:54 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10813904836224374","opStatus":"SUCCESS","opTime":"3059 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 13:39:54 AUDIT audit:72 - {"time":"December 29, 2019 5:39:54 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10813907898371538","opStatus":"START"}
2019-12-29 13:39:54 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:54 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:54 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:54 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:55 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:55 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:55 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:55 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:55 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:55 AUDIT audit:72 - {"time":"December 29, 2019 5:39:55 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813908906807221","opStatus":"START"}
2019-12-29 13:39:57 ERROR DataTypeUtil:385 - Problem while converting data typeconfigManagement
2019-12-29 13:39:57 AUDIT audit:93 - {"time":"December 29, 2019 5:39:57 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813908906807221","opStatus":"SUCCESS","opTime":"1991 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 13:39:57 AUDIT audit:93 - {"time":"December 29, 2019 5:39:57 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10813907898371538","opStatus":"SUCCESS","opTime":"3006 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 13:39:57 AUDIT audit:72 - {"time":"December 29, 2019 5:39:57 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10813910907735720","opStatus":"START"}
2019-12-29 13:39:57 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:57 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:57 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:57 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:58 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:58 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:58 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:58 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:58 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:39:58 AUDIT audit:72 - {"time":"December 29, 2019 5:39:58 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813911951321255","opStatus":"START"}
2019-12-29 13:40:00 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-29 13:40:00 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-29 13:40:00 AUDIT audit:93 - {"time":"December 29, 2019 5:40:00 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813911951321255","opStatus":"SUCCESS","opTime":"2097 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 13:40:00 AUDIT audit:93 - {"time":"December 29, 2019 5:40:00 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10813910907735720","opStatus":"SUCCESS","opTime":"3146 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 13:40:00 AUDIT audit:72 - {"time":"December 29, 2019 5:40:00 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10813914057192965","opStatus":"START"}
2019-12-29 13:40:00 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:40:00 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:40:01 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:40:01 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:40:01 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:40:01 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:40:01 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:40:01 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:40:01 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:40:01 AUDIT audit:72 - {"time":"December 29, 2019 5:40:01 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813915126653727","opStatus":"START"}
2019-12-29 13:40:03 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-29 13:40:03 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-29 13:40:03 AUDIT audit:93 - {"time":"December 29, 2019 5:40:03 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813915126653727","opStatus":"SUCCESS","opTime":"2021 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 13:40:03 AUDIT audit:93 - {"time":"December 29, 2019 5:40:03 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10813914057192965","opStatus":"SUCCESS","opTime":"3097 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 13:40:03 AUDIT audit:72 - {"time":"December 29, 2019 5:40:03 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10813917157768301","opStatus":"START"}
2019-12-29 13:40:04 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:40:04 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:40:04 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:40:04 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:40:04 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:40:04 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:40:04 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:40:04 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:40:04 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:40:04 AUDIT audit:72 - {"time":"December 29, 2019 5:40:04 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813918209911177","opStatus":"START"}
2019-12-29 13:40:06 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-29 13:40:06 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-29 13:40:06 AUDIT audit:93 - {"time":"December 29, 2019 5:40:06 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813918209911177","opStatus":"SUCCESS","opTime":"2085 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 13:40:06 AUDIT audit:93 - {"time":"December 29, 2019 5:40:06 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10813917157768301","opStatus":"SUCCESS","opTime":"3143 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 13:40:06 AUDIT audit:72 - {"time":"December 29, 2019 5:40:06 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10813920303746210","opStatus":"START"}
2019-12-29 13:40:08 AUDIT audit:72 - {"time":"December 29, 2019 5:40:08 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10813921498150456","opStatus":"START"}
2019-12-29 13:40:09 AUDIT audit:93 - {"time":"December 29, 2019 5:40:09 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10813921498150456","opStatus":"SUCCESS","opTime":"1401 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 13:40:09 AUDIT audit:93 - {"time":"December 29, 2019 5:40:09 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10813920303746210","opStatus":"SUCCESS","opTime":"2762 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 13:40:09 AUDIT audit:72 - {"time":"December 29, 2019 5:40:09 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10813923237181692","opStatus":"START"}
2019-12-29 13:40:11 AUDIT audit:93 - {"time":"December 29, 2019 5:40:11 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10813923237181692","opStatus":"SUCCESS","opTime":"1202 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
- Test data updation after compaction on Partition with mv tables
2019-12-29 13:40:11 AUDIT audit:72 - {"time":"December 29, 2019 5:40:11 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813924448580437","opStatus":"START"}
2019-12-29 13:40:11 AUDIT audit:93 - {"time":"December 29, 2019 5:40:11 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813924448580437","opStatus":"SUCCESS","opTime":"80 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:40:11 AUDIT audit:72 - {"time":"December 29, 2019 5:40:11 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10813924530069294","opStatus":"START"}
2019-12-29 13:40:11 AUDIT audit:93 - {"time":"December 29, 2019 5:40:11 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10813924530069294","opStatus":"SUCCESS","opTime":"3 ms","table":"NA","extraInfo":{"dmName":"ag"}}
2019-12-29 13:40:11 AUDIT audit:72 - {"time":"December 29, 2019 5:40:11 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10813924536682322","opStatus":"START"}
2019-12-29 13:40:11 AUDIT audit:72 - {"time":"December 29, 2019 5:40:11 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813924717638956","opStatus":"START"}
2019-12-29 13:40:11 AUDIT audit:93 - {"time":"December 29, 2019 5:40:11 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813924717638956","opStatus":"SUCCESS","opTime":"38 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:40:11 AUDIT audit:93 - {"time":"December 29, 2019 5:40:11 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10813924536682322","opStatus":"SUCCESS","opTime":"389 ms","table":"partition_mv.updatetime_8","extraInfo":{"provider":"mv","dmName":"ag"}}
2019-12-29 13:40:11 AUDIT audit:72 - {"time":"December 29, 2019 5:40:11 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10813924937449042","opStatus":"START"}
2019-12-29 13:40:11 AUDIT audit:72 - {"time":"December 29, 2019 5:40:11 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813925422090093","opStatus":"START"}
2019-12-29 13:40:14 AUDIT audit:93 - {"time":"December 29, 2019 5:40:14 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813925422090093","opStatus":"SUCCESS","opTime":"2165 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:40:14 AUDIT audit:93 - {"time":"December 29, 2019 5:40:14 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10813924937449042","opStatus":"SUCCESS","opTime":"2657 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:40:14 AUDIT audit:72 - {"time":"December 29, 2019 5:40:14 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10813927605390990","opStatus":"START"}
2019-12-29 13:40:14 AUDIT audit:72 - {"time":"December 29, 2019 5:40:14 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813927989177977","opStatus":"START"}
2019-12-29 13:40:16 AUDIT audit:93 - {"time":"December 29, 2019 5:40:16 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813927989177977","opStatus":"SUCCESS","opTime":"2082 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:40:16 AUDIT audit:93 - {"time":"December 29, 2019 5:40:16 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10813927605390990","opStatus":"SUCCESS","opTime":"2473 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:40:16 AUDIT audit:72 - {"time":"December 29, 2019 5:40:16 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10813930087070584","opStatus":"START"}
2019-12-29 13:40:17 AUDIT audit:72 - {"time":"December 29, 2019 5:40:17 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813930441105355","opStatus":"START"}
2019-12-29 13:40:19 AUDIT audit:93 - {"time":"December 29, 2019 5:40:19 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813930441105355","opStatus":"SUCCESS","opTime":"2125 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:40:19 AUDIT audit:93 - {"time":"December 29, 2019 5:40:19 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10813930087070584","opStatus":"SUCCESS","opTime":"2486 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:40:19 AUDIT audit:72 - {"time":"December 29, 2019 5:40:19 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10813932582005174","opStatus":"START"}
2019-12-29 13:40:19 AUDIT audit:72 - {"time":"December 29, 2019 5:40:19 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813932936676481","opStatus":"START"}
2019-12-29 13:40:21 AUDIT audit:93 - {"time":"December 29, 2019 5:40:21 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813932936676481","opStatus":"SUCCESS","opTime":"2023 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:40:21 AUDIT audit:93 - {"time":"December 29, 2019 5:40:21 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10813932582005174","opStatus":"SUCCESS","opTime":"2385 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:40:21 AUDIT audit:72 - {"time":"December 29, 2019 5:40:21 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10813934976031565","opStatus":"START"}
2019-12-29 13:40:21 AUDIT audit:72 - {"time":"December 29, 2019 5:40:21 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813935356547822","opStatus":"START"}
2019-12-29 13:40:24 AUDIT audit:93 - {"time":"December 29, 2019 5:40:24 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813935356547822","opStatus":"SUCCESS","opTime":"2177 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:40:24 AUDIT audit:93 - {"time":"December 29, 2019 5:40:24 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10813934976031565","opStatus":"SUCCESS","opTime":"2566 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:40:24 AUDIT audit:72 - {"time":"December 29, 2019 5:40:24 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10813937551435320","opStatus":"START"}
2019-12-29 13:40:24 AUDIT audit:72 - {"time":"December 29, 2019 5:40:24 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813937997438699","opStatus":"START"}
2019-12-29 13:40:26 AUDIT audit:93 - {"time":"December 29, 2019 5:40:26 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813937997438699","opStatus":"SUCCESS","opTime":"2082 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:40:26 AUDIT audit:93 - {"time":"December 29, 2019 5:40:26 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10813937551435320","opStatus":"SUCCESS","opTime":"2535 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:40:26 AUDIT audit:72 - {"time":"December 29, 2019 5:40:26 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10813940096925343","opStatus":"START"}
2019-12-29 13:40:27 AUDIT audit:72 - {"time":"December 29, 2019 5:40:27 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813940509533054","opStatus":"START"}
2019-12-29 13:40:29 AUDIT audit:93 - {"time":"December 29, 2019 5:40:29 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813940509533054","opStatus":"SUCCESS","opTime":"2015 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:40:29 AUDIT audit:93 - {"time":"December 29, 2019 5:40:29 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10813940096925343","opStatus":"SUCCESS","opTime":"2435 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:40:29 AUDIT audit:72 - {"time":"December 29, 2019 5:40:29 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10813942540786313","opStatus":"START"}
2019-12-29 13:40:29 AUDIT audit:72 - {"time":"December 29, 2019 5:40:29 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813942909149390","opStatus":"START"}
2019-12-29 13:40:31 AUDIT audit:93 - {"time":"December 29, 2019 5:40:31 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813942909149390","opStatus":"SUCCESS","opTime":"2103 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:40:31 AUDIT audit:93 - {"time":"December 29, 2019 5:40:31 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10813942540786313","opStatus":"SUCCESS","opTime":"2478 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:40:31 AUDIT audit:72 - {"time":"December 29, 2019 5:40:31 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10813945021137206","opStatus":"START"}
2019-12-29 13:40:31 AUDIT audit:72 - {"time":"December 29, 2019 5:40:31 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10813945156339255","opStatus":"START"}
2019-12-29 13:40:32 AUDIT audit:93 - {"time":"December 29, 2019 5:40:32 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10813945156339255","opStatus":"SUCCESS","opTime":"319 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:40:32 AUDIT audit:72 - {"time":"December 29, 2019 5:40:32 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10813945604669558","opStatus":"START"}
2019-12-29 13:40:32 AUDIT audit:93 - {"time":"December 29, 2019 5:40:32 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10813945604669558","opStatus":"SUCCESS","opTime":"27 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:40:32 AUDIT audit:93 - {"time":"December 29, 2019 5:40:32 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10813945021137206","opStatus":"SUCCESS","opTime":"642 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:40:32 AUDIT audit:72 - {"time":"December 29, 2019 5:40:32 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10813945670578442","opStatus":"START"}
2019-12-29 13:40:32 AUDIT audit:93 - {"time":"December 29, 2019 5:40:32 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10813945670578442","opStatus":"SUCCESS","opTime":"17 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:40:32 AUDIT audit:72 - {"time":"December 29, 2019 5:40:32 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10813946099929343","opStatus":"START"}
2019-12-29 13:40:32 AUDIT audit:93 - {"time":"December 29, 2019 5:40:32 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10813946099929343","opStatus":"SUCCESS","opTime":"199 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 13:40:32 AUDIT audit:72 - {"time":"December 29, 2019 5:40:32 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813946302790397","opStatus":"START"}
2019-12-29 13:40:32 AUDIT audit:93 - {"time":"December 29, 2019 5:40:32 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813946302790397","opStatus":"SUCCESS","opTime":"55 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 13:40:32 AUDIT audit:72 - {"time":"December 29, 2019 5:40:32 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10813946362034060","opStatus":"START"}
2019-12-29 13:40:33 AUDIT audit:72 - {"time":"December 29, 2019 5:40:33 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813946481769555","opStatus":"START"}
2019-12-29 13:40:33 AUDIT audit:93 - {"time":"December 29, 2019 5:40:33 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813946481769555","opStatus":"SUCCESS","opTime":"43 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:40:33 AUDIT audit:93 - {"time":"December 29, 2019 5:40:33 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10813946362034060","opStatus":"SUCCESS","opTime":"303 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p7"}}
2019-12-29 13:40:33 AUDIT audit:72 - {"time":"December 29, 2019 5:40:33 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10813946669060539","opStatus":"START"}
2019-12-29 13:40:33 AUDIT audit:72 - {"time":"December 29, 2019 5:40:33 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813946687858992","opStatus":"START"}
2019-12-29 13:40:33 AUDIT audit:93 - {"time":"December 29, 2019 5:40:33 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813946687858992","opStatus":"SUCCESS","opTime":"40 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:40:33 AUDIT audit:93 - {"time":"December 29, 2019 5:40:33 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10813946669060539","opStatus":"SUCCESS","opTime":"185 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p1"}}
2019-12-29 13:40:33 AUDIT audit:72 - {"time":"December 29, 2019 5:40:33 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10813946858057860","opStatus":"START"}
2019-12-29 13:40:33 AUDIT audit:72 - {"time":"December 29, 2019 5:40:33 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813946875403071","opStatus":"START"}
2019-12-29 13:40:33 AUDIT audit:93 - {"time":"December 29, 2019 5:40:33 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813946875403071","opStatus":"SUCCESS","opTime":"36 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:40:33 AUDIT audit:93 - {"time":"December 29, 2019 5:40:33 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10813946858057860","opStatus":"SUCCESS","opTime":"184 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p2"}}
2019-12-29 13:40:33 AUDIT audit:72 - {"time":"December 29, 2019 5:40:33 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10813947045903560","opStatus":"START"}
2019-12-29 13:40:33 AUDIT audit:72 - {"time":"December 29, 2019 5:40:33 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813947065464098","opStatus":"START"}
2019-12-29 13:40:33 AUDIT audit:93 - {"time":"December 29, 2019 5:40:33 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813947065464098","opStatus":"SUCCESS","opTime":"80 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:40:33 AUDIT audit:93 - {"time":"December 29, 2019 5:40:33 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10813947045903560","opStatus":"SUCCESS","opTime":"233 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p3"}}
2019-12-29 13:40:33 AUDIT audit:72 - {"time":"December 29, 2019 5:40:33 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10813947282692425","opStatus":"START"}
2019-12-29 13:40:33 AUDIT audit:72 - {"time":"December 29, 2019 5:40:33 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813947302425424","opStatus":"START"}
2019-12-29 13:40:33 AUDIT audit:93 - {"time":"December 29, 2019 5:40:33 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813947302425424","opStatus":"SUCCESS","opTime":"35 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:40:34 AUDIT audit:93 - {"time":"December 29, 2019 5:40:34 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10813947282692425","opStatus":"SUCCESS","opTime":"190 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p4"}}
2019-12-29 13:40:34 AUDIT audit:72 - {"time":"December 29, 2019 5:40:34 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10813947475134267","opStatus":"START"}
2019-12-29 13:40:34 AUDIT audit:72 - {"time":"December 29, 2019 5:40:34 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813947505905257","opStatus":"START"}
2019-12-29 13:40:34 AUDIT audit:93 - {"time":"December 29, 2019 5:40:34 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813947505905257","opStatus":"SUCCESS","opTime":"40 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:40:34 AUDIT audit:93 - {"time":"December 29, 2019 5:40:34 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10813947475134267","opStatus":"SUCCESS","opTime":"213 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p5"}}
2019-12-29 13:40:34 AUDIT audit:72 - {"time":"December 29, 2019 5:40:34 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10813947692506219","opStatus":"START"}
2019-12-29 13:40:34 AUDIT audit:72 - {"time":"December 29, 2019 5:40:34 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813947715913309","opStatus":"START"}
2019-12-29 13:40:34 AUDIT audit:93 - {"time":"December 29, 2019 5:40:34 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813947715913309","opStatus":"SUCCESS","opTime":"42 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:40:34 AUDIT audit:93 - {"time":"December 29, 2019 5:40:34 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10813947692506219","opStatus":"SUCCESS","opTime":"231 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p6"}}
2019-12-29 13:40:34 AUDIT audit:72 - {"time":"December 29, 2019 5:40:34 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10813947930811094","opStatus":"START"}
2019-12-29 13:40:34 AUDIT audit:93 - {"time":"December 29, 2019 5:40:34 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10813947930811094","opStatus":"SUCCESS","opTime":"484 ms","table":"partition_mv.partitionone","extraInfo":{}}
- check partitioning for child tables with various combinations
2019-12-29 13:40:34 AUDIT audit:72 - {"time":"December 29, 2019 5:40:34 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813948421147703","opStatus":"START"}
2019-12-29 13:40:35 AUDIT audit:93 - {"time":"December 29, 2019 5:40:35 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813948421147703","opStatus":"SUCCESS","opTime":"34 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 13:40:35 AUDIT audit:72 - {"time":"December 29, 2019 5:40:35 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10813948529589953","opStatus":"START"}
2019-12-29 13:40:35 AUDIT audit:93 - {"time":"December 29, 2019 5:40:35 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10813948529589953","opStatus":"SUCCESS","opTime":"329 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 13:40:35 AUDIT audit:72 - {"time":"December 29, 2019 5:40:35 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10813948860790739","opStatus":"START"}
2019-12-29 13:40:35 AUDIT audit:93 - {"time":"December 29, 2019 5:40:35 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10813948860790739","opStatus":"SUCCESS","opTime":"3 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-29 13:40:35 AUDIT audit:72 - {"time":"December 29, 2019 5:40:35 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10813948867173318","opStatus":"START"}
2019-12-29 13:40:35 AUDIT audit:72 - {"time":"December 29, 2019 5:40:35 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813948885696475","opStatus":"START"}
2019-12-29 13:40:35 AUDIT audit:93 - {"time":"December 29, 2019 5:40:35 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813948885696475","opStatus":"SUCCESS","opTime":"36 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:40:35 AUDIT audit:72 - {"time":"December 29, 2019 5:40:35 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813949057497284","opStatus":"START"}
2019-12-29 13:40:37 AUDIT audit:93 - {"time":"December 29, 2019 5:40:37 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813949057497284","opStatus":"SUCCESS","opTime":"1397 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-29 13:40:37 AUDIT audit:93 - {"time":"December 29, 2019 5:40:37 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10813948867173318","opStatus":"SUCCESS","opTime":"1597 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-29 13:40:37 AUDIT audit:72 - {"time":"December 29, 2019 5:40:37 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10813950900143506","opStatus":"START"}
2019-12-29 13:40:37 AUDIT audit:93 - {"time":"December 29, 2019 5:40:37 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10813950900143506","opStatus":"SUCCESS","opTime":"214 ms","table":"partition_mv.partitionone","extraInfo":{}}
- test partition at last column
2019-12-29 13:40:37 AUDIT audit:72 - {"time":"December 29, 2019 5:40:37 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813951122073483","opStatus":"START"}
2019-12-29 13:40:37 AUDIT audit:93 - {"time":"December 29, 2019 5:40:37 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813951122073483","opStatus":"SUCCESS","opTime":"36 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 13:40:37 AUDIT audit:72 - {"time":"December 29, 2019 5:40:37 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10813951303874804","opStatus":"START"}
2019-12-29 13:40:38 AUDIT audit:93 - {"time":"December 29, 2019 5:40:38 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10813951303874804","opStatus":"SUCCESS","opTime":"314 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 13:40:38 AUDIT audit:72 - {"time":"December 29, 2019 5:40:38 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10813951619514906","opStatus":"START"}
2019-12-29 13:40:38 AUDIT audit:93 - {"time":"December 29, 2019 5:40:38 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10813951619514906","opStatus":"SUCCESS","opTime":"3 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-29 13:40:38 AUDIT audit:72 - {"time":"December 29, 2019 5:40:38 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10813951625169073","opStatus":"START"}
2019-12-29 13:40:38 AUDIT audit:72 - {"time":"December 29, 2019 5:40:38 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813951642068092","opStatus":"START"}
2019-12-29 13:40:38 AUDIT audit:93 - {"time":"December 29, 2019 5:40:38 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813951642068092","opStatus":"SUCCESS","opTime":"31 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:40:38 AUDIT audit:72 - {"time":"December 29, 2019 5:40:38 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813951802524562","opStatus":"START"}
2019-12-29 13:40:39 AUDIT audit:93 - {"time":"December 29, 2019 5:40:39 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813951802524562","opStatus":"SUCCESS","opTime":"685 ms","table":"partition_mv.dm1_table","extraInfo":{"SegmentId":"0","DataSize":"666.0B","IndexSize":"435.0B"}}
2019-12-29 13:40:39 AUDIT audit:93 - {"time":"December 29, 2019 5:40:39 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10813951625169073","opStatus":"SUCCESS","opTime":"872 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-29 13:40:39 AUDIT audit:72 - {"time":"December 29, 2019 5:40:39 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10813952967041375","opStatus":"START"}
2019-12-29 13:40:39 AUDIT audit:93 - {"time":"December 29, 2019 5:40:39 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10813952967041375","opStatus":"SUCCESS","opTime":"192 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 13:40:39 AUDIT audit:72 - {"time":"December 29, 2019 5:40:39 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813953161630971","opStatus":"START"}
2019-12-29 13:40:39 AUDIT audit:93 - {"time":"December 29, 2019 5:40:39 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813953161630971","opStatus":"SUCCESS","opTime":"60 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 13:40:39 AUDIT audit:72 - {"time":"December 29, 2019 5:40:39 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10813953297775857","opStatus":"START"}
2019-12-29 13:40:40 AUDIT audit:93 - {"time":"December 29, 2019 5:40:40 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10813953297775857","opStatus":"SUCCESS","opTime":"357 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 13:40:40 AUDIT audit:72 - {"time":"December 29, 2019 5:40:40 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10813953656821879","opStatus":"START"}
2019-12-29 13:40:40 AUDIT audit:93 - {"time":"December 29, 2019 5:40:40 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10813953656821879","opStatus":"SUCCESS","opTime":"3 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-29 13:40:40 AUDIT audit:72 - {"time":"December 29, 2019 5:40:40 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10813953663490214","opStatus":"START"}
2019-12-29 13:40:40 AUDIT audit:72 - {"time":"December 29, 2019 5:40:40 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813953682908262","opStatus":"START"}
2019-12-29 13:40:40 AUDIT audit:93 - {"time":"December 29, 2019 5:40:40 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10813953682908262","opStatus":"SUCCESS","opTime":"41 ms","table":"partition_mv.dm1_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"dm1"}}
2019-12-29 13:40:40 AUDIT audit:72 - {"time":"December 29, 2019 5:40:40 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813953890325043","opStatus":"START"}
2019-12-29 13:40:41 AUDIT audit:93 - {"time":"December 29, 2019 5:40:41 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10813953890325043","opStatus":"SUCCESS","opTime":"1487 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-29 13:40:41 AUDIT audit:93 - {"time":"December 29, 2019 5:40:41 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10813953663490214","opStatus":"SUCCESS","opTime":"1724 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-29 13:40:42 AUDIT audit:72 - {"time":"December 29, 2019 5:40:42 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10813955912834860","opStatus":"START"}
2019-12-29 13:40:42 AUDIT audit:93 - {"time":"December 29, 2019 5:40:42 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10813955912834860","opStatus":"SUCCESS","opTime":"160 ms","table":"partition_mv.partitionone","extraInfo":{}}
- test partition on timeseries column
2019-12-29 13:40:42 AUDIT audit:72 - {"time":"December 29, 2019 5:40:42 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10813956078252239","opStatus":"START"}
2019-12-29 13:40:42 AUDIT audit:93 - {"time":"December 29, 2019 5:40:42 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10813956078252239","opStatus":"SUCCESS","opTime":"1 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:40:42 AUDIT audit:72 - {"time":"December 29, 2019 5:40:42 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10813956079365889","opStatus":"START"}
2019-12-29 13:40:42 AUDIT audit:93 - {"time":"December 29, 2019 5:40:42 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10813956079365889","opStatus":"SUCCESS","opTime":"84 ms","table":"partition_mv.droppartition","extraInfo":{}}
2019-12-29 13:40:42 AUDIT audit:72 - {"time":"December 29, 2019 5:40:42 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10813956163796214","opStatus":"START"}
2019-12-29 13:40:42 AUDIT audit:93 - {"time":"December 29, 2019 5:40:42 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10813956163796214","opStatus":"SUCCESS","opTime":"127 ms","table":"partition_mv.maintable","extraInfo":{}}
2019-12-29 13:40:42 AUDIT audit:72 - {"time":"December 29, 2019 5:40:42 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10813956291424850","opStatus":"START"}
2019-12-29 13:40:42 AUDIT audit:93 - {"time":"December 29, 2019 5:40:42 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10813956291424850","opStatus":"SUCCESS","opTime":"52 ms","table":"partition_mv.par","extraInfo":{}}
2019-12-29 13:40:42 AUDIT audit:72 - {"time":"December 29, 2019 5:40:42 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10813956343706313","opStatus":"START"}
2019-12-29 13:40:43 AUDIT audit:93 - {"time":"December 29, 2019 5:40:43 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10813956343706313","opStatus":"SUCCESS","opTime":"137 ms","table":"partition_mv.partitiontable","extraInfo":{}}
2019-12-29 13:40:43 AUDIT audit:72 - {"time":"December 29, 2019 5:40:43 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10813956481378154","opStatus":"START"}
2019-12-29 13:40:43 AUDIT audit:93 - {"time":"December 29, 2019 5:40:43 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10813956481378154","opStatus":"SUCCESS","opTime":"236 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
MVTPCDSTestCase:
- test create datamap with tpcds_1_4_testCases case_1 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_3 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_4 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_5 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_6 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_8 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_11 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_15 !!! IGNORED !!!
- test create datamap with tpcds_1_4_testCases case_16 !!! IGNORED !!!
Run completed in 11 minutes, 45 seconds.
Total number of tests run: 234
Suites: completed 21, aborted 0
Tests: succeeded 231, failed 3, canceled 0, ignored 18, pending 0
*** 3 TESTS FAILED ***
[JENKINS] Recording test results

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

Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://builds.apache.org/job/carbondata-master-spark-2.1/org.apache.carbondata$carbondata-mv-core/3935/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 13:00:30 AUDIT audit:72 - {"time":"December 29, 2019 5:00:30 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310438009425728","opStatus":"START"}
2019-12-29 13:00:33 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-29 13:00:33 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-29 13:00:33 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-29 13:00:33 ERROR DataTypeUtil:385 - Problem while converting data typeconfigManagement
2019-12-29 13:00:33 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-29 13:00:33 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-29 13:00:33 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-29 13:00:33 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-29 13:00:33 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-29 13:00:33 AUDIT audit:93 - {"time":"December 29, 2019 5:00:33 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310438009425728","opStatus":"SUCCESS","opTime":"2864 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 13:00:33 AUDIT audit:93 - {"time":"December 29, 2019 5:00:33 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5310436754880509","opStatus":"SUCCESS","opTime":"4130 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 13:00:33 AUDIT audit:72 - {"time":"December 29, 2019 5:00:33 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5310440893462200","opStatus":"START"}
2019-12-29 13:00:34 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:34 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:34 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:34 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:34 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:34 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:34 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:34 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:34 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:35 AUDIT audit:72 - {"time":"December 29, 2019 5:00:35 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310442197526932","opStatus":"START"}
2019-12-29 13:00:37 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-29 13:00:37 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-29 13:00:38 AUDIT audit:93 - {"time":"December 29, 2019 5:00:38 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310442197526932","opStatus":"SUCCESS","opTime":"3045 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 13:00:38 AUDIT audit:93 - {"time":"December 29, 2019 5:00:38 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5310440893462200","opStatus":"SUCCESS","opTime":"4360 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 13:00:38 AUDIT audit:72 - {"time":"December 29, 2019 5:00:38 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5310445258704174","opStatus":"START"}
2019-12-29 13:00:38 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:38 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:38 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:38 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:38 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:38 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:38 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:39 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:39 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:39 AUDIT audit:72 - {"time":"December 29, 2019 5:00:39 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310446514698635","opStatus":"START"}
2019-12-29 13:00:41 ERROR DataTypeUtil:385 - Problem while converting data typeconfigManagement
2019-12-29 13:00:42 AUDIT audit:93 - {"time":"December 29, 2019 5:00:42 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310446514698635","opStatus":"SUCCESS","opTime":"3028 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 13:00:42 AUDIT audit:93 - {"time":"December 29, 2019 5:00:42 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5310445258704174","opStatus":"SUCCESS","opTime":"4295 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 13:00:42 AUDIT audit:72 - {"time":"December 29, 2019 5:00:42 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5310449558920132","opStatus":"START"}
2019-12-29 13:00:42 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:42 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:43 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:43 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:43 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:43 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:43 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:43 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:43 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:43 AUDIT audit:72 - {"time":"December 29, 2019 5:00:43 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310450862614511","opStatus":"START"}
2019-12-29 13:00:46 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-29 13:00:46 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-29 13:00:46 AUDIT audit:93 - {"time":"December 29, 2019 5:00:46 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310450862614511","opStatus":"SUCCESS","opTime":"3163 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 13:00:46 AUDIT audit:93 - {"time":"December 29, 2019 5:00:46 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5310449558920132","opStatus":"SUCCESS","opTime":"4478 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 13:00:46 AUDIT audit:72 - {"time":"December 29, 2019 5:00:46 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5310454042326831","opStatus":"START"}
2019-12-29 13:00:47 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:47 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:47 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:47 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:47 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:47 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:47 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:47 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:47 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:48 AUDIT audit:72 - {"time":"December 29, 2019 5:00:48 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310455371704421","opStatus":"START"}
2019-12-29 13:00:50 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-29 13:00:50 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-29 13:00:51 AUDIT audit:93 - {"time":"December 29, 2019 5:00:51 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310455371704421","opStatus":"SUCCESS","opTime":"3062 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 13:00:51 AUDIT audit:93 - {"time":"December 29, 2019 5:00:51 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5310454042326831","opStatus":"SUCCESS","opTime":"4403 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 13:00:51 AUDIT audit:72 - {"time":"December 29, 2019 5:00:51 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5310458450360075","opStatus":"START"}
2019-12-29 13:00:51 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:51 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:51 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:52 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:52 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:52 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:52 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:52 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:52 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-29 13:00:52 AUDIT audit:72 - {"time":"December 29, 2019 5:00:52 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310459810071738","opStatus":"START"}
2019-12-29 13:00:55 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-29 13:00:55 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-29 13:00:55 AUDIT audit:93 - {"time":"December 29, 2019 5:00:55 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310459810071738","opStatus":"SUCCESS","opTime":"3166 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 13:00:55 AUDIT audit:93 - {"time":"December 29, 2019 5:00:55 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5310458450360075","opStatus":"SUCCESS","opTime":"4537 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 13:00:55 AUDIT audit:72 - {"time":"December 29, 2019 5:00:55 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5310462991675056","opStatus":"START"}
2019-12-29 13:00:57 AUDIT audit:72 - {"time":"December 29, 2019 5:00:57 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5310464281627318","opStatus":"START"}
2019-12-29 13:00:58 AUDIT audit:93 - {"time":"December 29, 2019 5:00:58 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5310464281627318","opStatus":"SUCCESS","opTime":"1559 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-29 13:00:59 AUDIT audit:93 - {"time":"December 29, 2019 5:00:59 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5310462991675056","opStatus":"SUCCESS","opTime":"3205 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-29 13:00:59 AUDIT audit:72 - {"time":"December 29, 2019 5:00:59 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5310466447458933","opStatus":"START"}
2019-12-29 13:01:04 AUDIT audit:93 - {"time":"December 29, 2019 5:01:04 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5310466447458933","opStatus":"SUCCESS","opTime":"5164 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
- Test data updation after compaction on Partition with mv tables
2019-12-29 13:01:04 AUDIT audit:72 - {"time":"December 29, 2019 5:01:04 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310471627046971","opStatus":"START"}
2019-12-29 13:01:04 AUDIT audit:93 - {"time":"December 29, 2019 5:01:04 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310471627046971","opStatus":"SUCCESS","opTime":"172 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:01:04 AUDIT audit:72 - {"time":"December 29, 2019 5:01:04 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5310471802289926","opStatus":"START"}
2019-12-29 13:01:04 AUDIT audit:93 - {"time":"December 29, 2019 5:01:04 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5310471802289926","opStatus":"SUCCESS","opTime":"6 ms","table":"NA","extraInfo":{"dmName":"ag"}}
2019-12-29 13:01:04 AUDIT audit:72 - {"time":"December 29, 2019 5:01:04 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5310471814708460","opStatus":"START"}
2019-12-29 13:01:05 AUDIT audit:72 - {"time":"December 29, 2019 5:01:05 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310472094519633","opStatus":"START"}
2019-12-29 13:01:05 AUDIT audit:93 - {"time":"December 29, 2019 5:01:05 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310472094519633","opStatus":"SUCCESS","opTime":"125 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:01:05 AUDIT audit:93 - {"time":"December 29, 2019 5:01:05 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5310471814708460","opStatus":"SUCCESS","opTime":"718 ms","table":"partition_mv.updatetime_8","extraInfo":{"provider":"mv","dmName":"ag"}}
2019-12-29 13:01:05 AUDIT audit:72 - {"time":"December 29, 2019 5:01:05 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5310472550143727","opStatus":"START"}
2019-12-29 13:01:06 AUDIT audit:72 - {"time":"December 29, 2019 5:01:06 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310473442022312","opStatus":"START"}
2019-12-29 13:01:09 AUDIT audit:93 - {"time":"December 29, 2019 5:01:09 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310473442022312","opStatus":"SUCCESS","opTime":"3587 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:01:09 AUDIT audit:93 - {"time":"December 29, 2019 5:01:09 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5310472550143727","opStatus":"SUCCESS","opTime":"4491 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:01:09 AUDIT audit:72 - {"time":"December 29, 2019 5:01:09 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5310477057545027","opStatus":"START"}
2019-12-29 13:01:10 AUDIT audit:72 - {"time":"December 29, 2019 5:01:10 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310477716201419","opStatus":"START"}
2019-12-29 13:01:14 AUDIT audit:93 - {"time":"December 29, 2019 5:01:14 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310477716201419","opStatus":"SUCCESS","opTime":"3634 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:01:14 AUDIT audit:93 - {"time":"December 29, 2019 5:01:14 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5310477057545027","opStatus":"SUCCESS","opTime":"4305 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:01:14 AUDIT audit:72 - {"time":"December 29, 2019 5:01:14 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5310481377068883","opStatus":"START"}
2019-12-29 13:01:14 AUDIT audit:72 - {"time":"December 29, 2019 5:01:14 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310481852151965","opStatus":"START"}
2019-12-29 13:01:17 AUDIT audit:93 - {"time":"December 29, 2019 5:01:17 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310481852151965","opStatus":"SUCCESS","opTime":"3207 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:01:18 AUDIT audit:93 - {"time":"December 29, 2019 5:01:18 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5310481377068883","opStatus":"SUCCESS","opTime":"3694 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:01:18 AUDIT audit:72 - {"time":"December 29, 2019 5:01:18 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5310485088600033","opStatus":"START"}
2019-12-29 13:01:18 AUDIT audit:72 - {"time":"December 29, 2019 5:01:18 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310485577905564","opStatus":"START"}
2019-12-29 13:01:21 AUDIT audit:93 - {"time":"December 29, 2019 5:01:21 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310485577905564","opStatus":"SUCCESS","opTime":"3344 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:01:21 AUDIT audit:93 - {"time":"December 29, 2019 5:01:21 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5310485088600033","opStatus":"SUCCESS","opTime":"3846 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:01:21 AUDIT audit:72 - {"time":"December 29, 2019 5:01:21 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5310488948238993","opStatus":"START"}
2019-12-29 13:01:22 AUDIT audit:72 - {"time":"December 29, 2019 5:01:22 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310489410352789","opStatus":"START"}
2019-12-29 13:01:25 AUDIT audit:93 - {"time":"December 29, 2019 5:01:25 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310489410352789","opStatus":"SUCCESS","opTime":"3144 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:01:25 AUDIT audit:93 - {"time":"December 29, 2019 5:01:25 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5310488948238993","opStatus":"SUCCESS","opTime":"3617 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:01:25 AUDIT audit:72 - {"time":"December 29, 2019 5:01:25 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5310492580824893","opStatus":"START"}
2019-12-29 13:01:26 AUDIT audit:72 - {"time":"December 29, 2019 5:01:26 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310493070973050","opStatus":"START"}
2019-12-29 13:01:29 AUDIT audit:93 - {"time":"December 29, 2019 5:01:29 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310493070973050","opStatus":"SUCCESS","opTime":"3195 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:01:29 AUDIT audit:93 - {"time":"December 29, 2019 5:01:29 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5310492580824893","opStatus":"SUCCESS","opTime":"3697 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:01:29 AUDIT audit:72 - {"time":"December 29, 2019 5:01:29 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5310496293139641","opStatus":"START"}
2019-12-29 13:01:29 AUDIT audit:72 - {"time":"December 29, 2019 5:01:29 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310497014313179","opStatus":"START"}
2019-12-29 13:01:33 AUDIT audit:93 - {"time":"December 29, 2019 5:01:33 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310497014313179","opStatus":"SUCCESS","opTime":"3285 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:01:33 AUDIT audit:93 - {"time":"December 29, 2019 5:01:33 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5310496293139641","opStatus":"SUCCESS","opTime":"4018 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:01:33 AUDIT audit:72 - {"time":"December 29, 2019 5:01:33 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5310500326220947","opStatus":"START"}
2019-12-29 13:01:33 AUDIT audit:72 - {"time":"December 29, 2019 5:01:33 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310500820241392","opStatus":"START"}
2019-12-29 13:01:37 AUDIT audit:93 - {"time":"December 29, 2019 5:01:37 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310500820241392","opStatus":"SUCCESS","opTime":"3272 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:01:37 AUDIT audit:93 - {"time":"December 29, 2019 5:01:37 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5310500326220947","opStatus":"SUCCESS","opTime":"3779 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:01:37 AUDIT audit:72 - {"time":"December 29, 2019 5:01:37 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5310504109350965","opStatus":"START"}
2019-12-29 13:01:37 AUDIT audit:72 - {"time":"December 29, 2019 5:01:37 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5310504313013879","opStatus":"START"}
2019-12-29 13:01:37 AUDIT audit:93 - {"time":"December 29, 2019 5:01:37 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5310504313013879","opStatus":"SUCCESS","opTime":"453 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:01:37 AUDIT audit:72 - {"time":"December 29, 2019 5:01:37 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5310504961227140","opStatus":"START"}
2019-12-29 13:01:38 AUDIT audit:93 - {"time":"December 29, 2019 5:01:38 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5310504961227140","opStatus":"SUCCESS","opTime":"216 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:01:38 AUDIT audit:93 - {"time":"December 29, 2019 5:01:38 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5310504109350965","opStatus":"SUCCESS","opTime":"1123 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-29 13:01:38 AUDIT audit:72 - {"time":"December 29, 2019 5:01:38 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5310505246332275","opStatus":"START"}
2019-12-29 13:01:38 AUDIT audit:93 - {"time":"December 29, 2019 5:01:38 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"5310505246332275","opStatus":"SUCCESS","opTime":"34 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:01:39 AUDIT audit:72 - {"time":"December 29, 2019 5:01:39 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5310506074990586","opStatus":"START"}
2019-12-29 13:01:39 AUDIT audit:93 - {"time":"December 29, 2019 5:01:39 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5310506074990586","opStatus":"SUCCESS","opTime":"368 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 13:01:39 AUDIT audit:72 - {"time":"December 29, 2019 5:01:39 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310506449622333","opStatus":"START"}
2019-12-29 13:01:39 AUDIT audit:93 - {"time":"December 29, 2019 5:01:39 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310506449622333","opStatus":"SUCCESS","opTime":"113 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 13:01:39 AUDIT audit:72 - {"time":"December 29, 2019 5:01:39 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5310506566606704","opStatus":"START"}
2019-12-29 13:01:39 AUDIT audit:72 - {"time":"December 29, 2019 5:01:39 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310506797668580","opStatus":"START"}
2019-12-29 13:01:39 AUDIT audit:93 - {"time":"December 29, 2019 5:01:39 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310506797668580","opStatus":"SUCCESS","opTime":"91 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:01:40 AUDIT audit:93 - {"time":"December 29, 2019 5:01:40 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5310506566606704","opStatus":"SUCCESS","opTime":"576 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p7"}}
2019-12-29 13:01:40 AUDIT audit:72 - {"time":"December 29, 2019 5:01:40 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5310507147792413","opStatus":"START"}
2019-12-29 13:01:40 AUDIT audit:72 - {"time":"December 29, 2019 5:01:40 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310507179709369","opStatus":"START"}
2019-12-29 13:01:40 AUDIT audit:93 - {"time":"December 29, 2019 5:01:40 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310507179709369","opStatus":"SUCCESS","opTime":"67 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:01:40 AUDIT audit:93 - {"time":"December 29, 2019 5:01:40 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5310507147792413","opStatus":"SUCCESS","opTime":"336 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p1"}}
2019-12-29 13:01:40 AUDIT audit:72 - {"time":"December 29, 2019 5:01:40 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5310507490157501","opStatus":"START"}
2019-12-29 13:01:40 AUDIT audit:72 - {"time":"December 29, 2019 5:01:40 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310507524515122","opStatus":"START"}
2019-12-29 13:01:40 AUDIT audit:93 - {"time":"December 29, 2019 5:01:40 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310507524515122","opStatus":"SUCCESS","opTime":"63 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:01:40 AUDIT audit:93 - {"time":"December 29, 2019 5:01:40 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5310507490157501","opStatus":"SUCCESS","opTime":"348 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p2"}}
2019-12-29 13:01:40 AUDIT audit:72 - {"time":"December 29, 2019 5:01:40 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5310507845840019","opStatus":"START"}
2019-12-29 13:01:40 AUDIT audit:72 - {"time":"December 29, 2019 5:01:40 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310507884909360","opStatus":"START"}
2019-12-29 13:01:40 AUDIT audit:93 - {"time":"December 29, 2019 5:01:40 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310507884909360","opStatus":"SUCCESS","opTime":"86 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:01:41 AUDIT audit:93 - {"time":"December 29, 2019 5:01:41 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5310507845840019","opStatus":"SUCCESS","opTime":"397 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p3"}}
2019-12-29 13:01:41 AUDIT audit:72 - {"time":"December 29, 2019 5:01:41 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5310508249567947","opStatus":"START"}
2019-12-29 13:01:41 AUDIT audit:72 - {"time":"December 29, 2019 5:01:41 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310508289710626","opStatus":"START"}
2019-12-29 13:01:41 AUDIT audit:93 - {"time":"December 29, 2019 5:01:41 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310508289710626","opStatus":"SUCCESS","opTime":"65 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:01:41 AUDIT audit:93 - {"time":"December 29, 2019 5:01:41 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5310508249567947","opStatus":"SUCCESS","opTime":"361 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p4"}}
2019-12-29 13:01:41 AUDIT audit:72 - {"time":"December 29, 2019 5:01:41 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5310508617335150","opStatus":"START"}
2019-12-29 13:01:41 AUDIT audit:72 - {"time":"December 29, 2019 5:01:41 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310508656973209","opStatus":"START"}
2019-12-29 13:01:41 AUDIT audit:93 - {"time":"December 29, 2019 5:01:41 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310508656973209","opStatus":"SUCCESS","opTime":"106 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:01:41 AUDIT audit:93 - {"time":"December 29, 2019 5:01:41 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5310508617335150","opStatus":"SUCCESS","opTime":"406 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p5"}}
2019-12-29 13:01:41 AUDIT audit:72 - {"time":"December 29, 2019 5:01:41 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5310509030310244","opStatus":"START"}
2019-12-29 13:01:42 AUDIT audit:72 - {"time":"December 29, 2019 5:01:42 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310509074549774","opStatus":"START"}
2019-12-29 13:01:42 AUDIT audit:93 - {"time":"December 29, 2019 5:01:42 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310509074549774","opStatus":"SUCCESS","opTime":"63 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:01:42 AUDIT audit:93 - {"time":"December 29, 2019 5:01:42 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5310509030310244","opStatus":"SUCCESS","opTime":"375 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p6"}}
2019-12-29 13:01:42 AUDIT audit:72 - {"time":"December 29, 2019 5:01:42 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5310509417219407","opStatus":"START"}
2019-12-29 13:01:43 AUDIT audit:93 - {"time":"December 29, 2019 5:01:43 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5310509417219407","opStatus":"SUCCESS","opTime":"1081 ms","table":"partition_mv.partitionone","extraInfo":{}}
- check partitioning for child tables with various combinations
2019-12-29 13:01:43 AUDIT audit:72 - {"time":"December 29, 2019 5:01:43 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310510508218635","opStatus":"START"}
2019-12-29 13:01:43 AUDIT audit:93 - {"time":"December 29, 2019 5:01:43 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310510508218635","opStatus":"SUCCESS","opTime":"71 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 13:01:43 AUDIT audit:72 - {"time":"December 29, 2019 5:01:43 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5310510711533883","opStatus":"START"}
2019-12-29 13:01:44 AUDIT audit:93 - {"time":"December 29, 2019 5:01:44 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5310510711533883","opStatus":"SUCCESS","opTime":"592 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 13:01:44 AUDIT audit:72 - {"time":"December 29, 2019 5:01:44 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5310511306635870","opStatus":"START"}
2019-12-29 13:01:44 AUDIT audit:93 - {"time":"December 29, 2019 5:01:44 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5310511306635870","opStatus":"SUCCESS","opTime":"5 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-29 13:01:44 AUDIT audit:72 - {"time":"December 29, 2019 5:01:44 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5310511315936840","opStatus":"START"}
2019-12-29 13:01:44 AUDIT audit:72 - {"time":"December 29, 2019 5:01:44 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310511346001155","opStatus":"START"}
2019-12-29 13:01:44 AUDIT audit:93 - {"time":"December 29, 2019 5:01:44 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310511346001155","opStatus":"SUCCESS","opTime":"67 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:01:44 AUDIT audit:72 - {"time":"December 29, 2019 5:01:44 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310511663173728","opStatus":"START"}
2019-12-29 13:01:47 AUDIT audit:93 - {"time":"December 29, 2019 5:01:47 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310511663173728","opStatus":"SUCCESS","opTime":"2479 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-29 13:01:47 AUDIT audit:93 - {"time":"December 29, 2019 5:01:47 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5310511315936840","opStatus":"SUCCESS","opTime":"2840 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-29 13:01:47 AUDIT audit:72 - {"time":"December 29, 2019 5:01:47 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5310514921362876","opStatus":"START"}
2019-12-29 13:01:48 AUDIT audit:93 - {"time":"December 29, 2019 5:01:48 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5310514921362876","opStatus":"SUCCESS","opTime":"594 ms","table":"partition_mv.partitionone","extraInfo":{}}
- test partition at last column
2019-12-29 13:01:48 AUDIT audit:72 - {"time":"December 29, 2019 5:01:48 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310515526434951","opStatus":"START"}
2019-12-29 13:01:48 AUDIT audit:93 - {"time":"December 29, 2019 5:01:48 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310515526434951","opStatus":"SUCCESS","opTime":"69 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 13:01:48 AUDIT audit:72 - {"time":"December 29, 2019 5:01:48 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5310515747732438","opStatus":"START"}
2019-12-29 13:01:49 AUDIT audit:93 - {"time":"December 29, 2019 5:01:49 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5310515747732438","opStatus":"SUCCESS","opTime":"663 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 13:01:49 AUDIT audit:72 - {"time":"December 29, 2019 5:01:49 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5310516415992069","opStatus":"START"}
2019-12-29 13:01:49 AUDIT audit:93 - {"time":"December 29, 2019 5:01:49 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5310516415992069","opStatus":"SUCCESS","opTime":"6 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-29 13:01:49 AUDIT audit:72 - {"time":"December 29, 2019 5:01:49 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5310516428765533","opStatus":"START"}
2019-12-29 13:01:49 AUDIT audit:72 - {"time":"December 29, 2019 5:01:49 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310516472073933","opStatus":"START"}
2019-12-29 13:01:49 AUDIT audit:93 - {"time":"December 29, 2019 5:01:49 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310516472073933","opStatus":"SUCCESS","opTime":"166 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:01:49 AUDIT audit:72 - {"time":"December 29, 2019 5:01:49 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310516910507900","opStatus":"START"}
2019-12-29 13:01:51 AUDIT audit:93 - {"time":"December 29, 2019 5:01:51 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310516910507900","opStatus":"SUCCESS","opTime":"1302 ms","table":"partition_mv.dm1_table","extraInfo":{"SegmentId":"0","DataSize":"666.0B","IndexSize":"435.0B"}}
2019-12-29 13:01:51 AUDIT audit:93 - {"time":"December 29, 2019 5:01:51 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5310516428765533","opStatus":"SUCCESS","opTime":"1803 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-29 13:01:51 AUDIT audit:72 - {"time":"December 29, 2019 5:01:51 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5310519043157981","opStatus":"START"}
2019-12-29 13:01:52 AUDIT audit:93 - {"time":"December 29, 2019 5:01:52 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5310519043157981","opStatus":"SUCCESS","opTime":"354 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 13:01:52 AUDIT audit:72 - {"time":"December 29, 2019 5:01:52 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310519401606409","opStatus":"START"}
2019-12-29 13:01:52 AUDIT audit:93 - {"time":"December 29, 2019 5:01:52 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310519401606409","opStatus":"SUCCESS","opTime":"102 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-29 13:01:52 AUDIT audit:72 - {"time":"December 29, 2019 5:01:52 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5310519659591949","opStatus":"START"}
2019-12-29 13:01:53 AUDIT audit:93 - {"time":"December 29, 2019 5:01:53 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"5310519659591949","opStatus":"SUCCESS","opTime":"594 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-29 13:01:53 AUDIT audit:72 - {"time":"December 29, 2019 5:01:53 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5310520255454524","opStatus":"START"}
2019-12-29 13:01:53 AUDIT audit:93 - {"time":"December 29, 2019 5:01:53 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"5310520255454524","opStatus":"SUCCESS","opTime":"5 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-29 13:01:53 AUDIT audit:72 - {"time":"December 29, 2019 5:01:53 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5310520265569587","opStatus":"START"}
2019-12-29 13:01:53 AUDIT audit:72 - {"time":"December 29, 2019 5:01:53 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310520290845428","opStatus":"START"}
2019-12-29 13:01:53 AUDIT audit:93 - {"time":"December 29, 2019 5:01:53 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"5310520290845428","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:01:53 AUDIT audit:72 - {"time":"December 29, 2019 5:01:53 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310520605168477","opStatus":"START"}
2019-12-29 13:01:55 AUDIT audit:93 - {"time":"December 29, 2019 5:01:55 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"5310520605168477","opStatus":"SUCCESS","opTime":"2458 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-29 13:01:56 AUDIT audit:93 - {"time":"December 29, 2019 5:01:56 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"5310520265569587","opStatus":"SUCCESS","opTime":"2808 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-29 13:01:56 AUDIT audit:72 - {"time":"December 29, 2019 5:01:56 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5310524065597497","opStatus":"START"}
2019-12-29 13:01:57 AUDIT audit:93 - {"time":"December 29, 2019 5:01:57 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5310524065597497","opStatus":"SUCCESS","opTime":"274 ms","table":"partition_mv.partitionone","extraInfo":{}}
- test partition on timeseries column
2019-12-29 13:01:57 AUDIT audit:72 - {"time":"December 29, 2019 5:01:57 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5310524348685611","opStatus":"START"}
2019-12-29 13:01:57 AUDIT audit:93 - {"time":"December 29, 2019 5:01:57 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5310524348685611","opStatus":"SUCCESS","opTime":"2 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-29 13:01:57 AUDIT audit:72 - {"time":"December 29, 2019 5:01:57 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5310524350687886","opStatus":"START"}
2019-12-29 13:01:57 AUDIT audit:93 - {"time":"December 29, 2019 5:01:57 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5310524350687886","opStatus":"SUCCESS","opTime":"171 ms","table":"partition_mv.droppartition","extraInfo":{}}
2019-12-29 13:01:57 AUDIT audit:72 - {"time":"December 29, 2019 5:01:57 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5310524521902263","opStatus":"START"}
2019-12-29 13:01:57 AUDIT audit:93 - {"time":"December 29, 2019 5:01:57 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5310524521902263","opStatus":"SUCCESS","opTime":"242 ms","table":"partition_mv.maintable","extraInfo":{}}
2019-12-29 13:01:57 AUDIT audit:72 - {"time":"December 29, 2019 5:01:57 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5310524764874230","opStatus":"START"}
2019-12-29 13:01:57 AUDIT audit:93 - {"time":"December 29, 2019 5:01:57 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5310524764874230","opStatus":"SUCCESS","opTime":"108 ms","table":"partition_mv.par","extraInfo":{}}
2019-12-29 13:01:57 AUDIT audit:72 - {"time":"December 29, 2019 5:01:57 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5310524874250258","opStatus":"START"}
2019-12-29 13:01:58 AUDIT audit:93 - {"time":"December 29, 2019 5:01:58 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5310524874250258","opStatus":"SUCCESS","opTime":"259 ms","table":"partition_mv.partitiontable","extraInfo":{}}
2019-12-29 13:01:58 AUDIT audit:72 - {"time":"December 29, 2019 5:01:58 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5310525133768885","opStatus":"START"}
2019-12-29 13:01:58 AUDIT audit:93 - {"time":"December 29, 2019 5:01:58 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"5310525133768885","opStatus":"SUCCESS","opTime":"653 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, 20 seconds.
Total number of tests run: 234
Suites: completed 21, aborted 0
Tests: succeeded 231, failed 3, canceled 0, ignored 18, pending 0
*** 3 TESTS FAILED ***
[JENKINS] Recording test results