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/19 09:55:43 UTC

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

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

Changes:


------------------------------------------
[...truncated 1.14 MB...]
2019-12-19 09:53:54 AUDIT audit:72 - {"time":"December 19, 2019 1:53:54 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144645976772958","opStatus":"START"}
2019-12-19 09:53:56 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-19 09:53:56 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-19 09:53:56 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-19 09:53:56 ERROR DataTypeUtil:385 - Problem while converting data typeconfigManagement
2019-12-19 09:53:56 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-19 09:53:56 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-19 09:53:56 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-19 09:53:56 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-19 09:53:56 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-19 09:53:57 AUDIT audit:93 - {"time":"December 19, 2019 1:53:57 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144645976772958","opStatus":"SUCCESS","opTime":"2040 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-19 09:53:57 AUDIT audit:93 - {"time":"December 19, 2019 1:53:57 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9144644982526968","opStatus":"SUCCESS","opTime":"3042 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-19 09:53:57 AUDIT audit:72 - {"time":"December 19, 2019 1:53:57 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9144648029140041","opStatus":"START"}
2019-12-19 09:53:57 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:53:57 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:53:57 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:53:57 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:53:57 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:53:57 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:53:57 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:53:57 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:53:57 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:53:58 AUDIT audit:72 - {"time":"December 19, 2019 1:53:58 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144649140623438","opStatus":"START"}
2019-12-19 09:53:59 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-19 09:53:59 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-19 09:54:00 AUDIT audit:93 - {"time":"December 19, 2019 1:54:00 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144649140623438","opStatus":"SUCCESS","opTime":"1947 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-19 09:54:00 AUDIT audit:93 - {"time":"December 19, 2019 1:54:00 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9144648029140041","opStatus":"SUCCESS","opTime":"3065 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-19 09:54:00 AUDIT audit:72 - {"time":"December 19, 2019 1:54:00 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9144651096882660","opStatus":"START"}
2019-12-19 09:54:00 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:00 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:00 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:00 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:00 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:00 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:00 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:00 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:00 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:01 AUDIT audit:72 - {"time":"December 19, 2019 1:54:01 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144652173489183","opStatus":"START"}
2019-12-19 09:54:02 ERROR DataTypeUtil:385 - Problem while converting data typeconfigManagement
2019-12-19 09:54:03 AUDIT audit:93 - {"time":"December 19, 2019 1:54:03 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144652173489183","opStatus":"SUCCESS","opTime":"2139 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-19 09:54:03 AUDIT audit:93 - {"time":"December 19, 2019 1:54:03 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9144651096882660","opStatus":"SUCCESS","opTime":"3221 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-19 09:54:03 AUDIT audit:72 - {"time":"December 19, 2019 1:54:03 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9144654321469752","opStatus":"START"}
2019-12-19 09:54:03 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:03 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:03 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:03 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:03 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:03 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:04 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:04 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:04 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:04 AUDIT audit:72 - {"time":"December 19, 2019 1:54:04 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144655411672139","opStatus":"START"}
2019-12-19 09:54:05 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-19 09:54:06 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-19 09:54:06 AUDIT audit:93 - {"time":"December 19, 2019 1:54:06 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144655411672139","opStatus":"SUCCESS","opTime":"1959 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-19 09:54:06 AUDIT audit:93 - {"time":"December 19, 2019 1:54:06 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9144654321469752","opStatus":"SUCCESS","opTime":"3055 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-19 09:54:06 AUDIT audit:72 - {"time":"December 19, 2019 1:54:06 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9144657379697999","opStatus":"START"}
2019-12-19 09:54:06 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:06 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:06 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:06 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:06 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:07 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:07 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:07 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:07 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:07 AUDIT audit:72 - {"time":"December 19, 2019 1:54:07 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144658591011792","opStatus":"START"}
2019-12-19 09:54:09 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-19 09:54:09 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-19 09:54:09 AUDIT audit:93 - {"time":"December 19, 2019 1:54:09 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144658591011792","opStatus":"SUCCESS","opTime":"1954 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-19 09:54:09 AUDIT audit:93 - {"time":"December 19, 2019 1:54:09 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9144657379697999","opStatus":"SUCCESS","opTime":"3172 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-19 09:54:09 AUDIT audit:72 - {"time":"December 19, 2019 1:54:09 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9144660555091187","opStatus":"START"}
2019-12-19 09:54:09 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:09 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:10 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:10 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:10 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:10 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:10 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:10 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:10 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-19 09:54:10 AUDIT audit:72 - {"time":"December 19, 2019 1:54:10 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144661678645197","opStatus":"START"}
2019-12-19 09:54:12 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-19 09:54:12 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-19 09:54:13 AUDIT audit:93 - {"time":"December 19, 2019 1:54:13 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144661678645197","opStatus":"SUCCESS","opTime":"2417 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-19 09:54:13 AUDIT audit:93 - {"time":"December 19, 2019 1:54:13 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"9144660555091187","opStatus":"SUCCESS","opTime":"3552 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-19 09:54:13 AUDIT audit:72 - {"time":"December 19, 2019 1:54:13 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9144664110246285","opStatus":"START"}
2019-12-19 09:54:14 AUDIT audit:72 - {"time":"December 19, 2019 1:54:14 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9144665400514150","opStatus":"START"}
2019-12-19 09:54:15 AUDIT audit:93 - {"time":"December 19, 2019 1:54:15 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9144665400514150","opStatus":"SUCCESS","opTime":"1389 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-19 09:54:15 AUDIT audit:93 - {"time":"December 19, 2019 1:54:15 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9144664110246285","opStatus":"SUCCESS","opTime":"2841 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-19 09:54:16 AUDIT audit:72 - {"time":"December 19, 2019 1:54:16 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9144667114133541","opStatus":"START"}
2019-12-19 09:54:20 AUDIT audit:93 - {"time":"December 19, 2019 1:54:20 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9144667114133541","opStatus":"SUCCESS","opTime":"4715 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
- Test data updation after compaction on Partition with mv tables
2019-12-19 09:54:20 AUDIT audit:72 - {"time":"December 19, 2019 1:54:20 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144671836579039","opStatus":"START"}
2019-12-19 09:54:20 AUDIT audit:93 - {"time":"December 19, 2019 1:54:20 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144671836579039","opStatus":"SUCCESS","opTime":"138 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-19 09:54:20 AUDIT audit:72 - {"time":"December 19, 2019 1:54:20 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"9144671977217348","opStatus":"START"}
2019-12-19 09:54:20 AUDIT audit:93 - {"time":"December 19, 2019 1:54:20 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"9144671977217348","opStatus":"SUCCESS","opTime":"5 ms","table":"NA","extraInfo":{"dmName":"ag"}}
2019-12-19 09:54:20 AUDIT audit:72 - {"time":"December 19, 2019 1:54:20 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9144671987226882","opStatus":"START"}
2019-12-19 09:54:21 AUDIT audit:72 - {"time":"December 19, 2019 1:54:21 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144672126641372","opStatus":"START"}
2019-12-19 09:54:21 AUDIT audit:93 - {"time":"December 19, 2019 1:54:21 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144672126641372","opStatus":"SUCCESS","opTime":"108 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-19 09:54:21 AUDIT audit:93 - {"time":"December 19, 2019 1:54:21 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9144671987226882","opStatus":"SUCCESS","opTime":"413 ms","table":"partition_mv.updatetime_8","extraInfo":{"provider":"mv","dmName":"ag"}}
2019-12-19 09:54:21 AUDIT audit:72 - {"time":"December 19, 2019 1:54:21 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9144672409814450","opStatus":"START"}
2019-12-19 09:54:21 AUDIT audit:72 - {"time":"December 19, 2019 1:54:21 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144672975465984","opStatus":"START"}
2019-12-19 09:54:24 AUDIT audit:93 - {"time":"December 19, 2019 1:54:24 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144672975465984","opStatus":"SUCCESS","opTime":"2461 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-19 09:54:24 AUDIT audit:93 - {"time":"December 19, 2019 1:54:24 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9144672409814450","opStatus":"SUCCESS","opTime":"3029 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-19 09:54:24 AUDIT audit:72 - {"time":"December 19, 2019 1:54:24 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9144675448309464","opStatus":"START"}
2019-12-19 09:54:24 AUDIT audit:72 - {"time":"December 19, 2019 1:54:24 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144675861463218","opStatus":"START"}
2019-12-19 09:54:26 AUDIT audit:93 - {"time":"December 19, 2019 1:54:26 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144675861463218","opStatus":"SUCCESS","opTime":"2058 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-19 09:54:26 AUDIT audit:93 - {"time":"December 19, 2019 1:54:26 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9144675448309464","opStatus":"SUCCESS","opTime":"2475 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-19 09:54:26 AUDIT audit:72 - {"time":"December 19, 2019 1:54:26 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9144677931955145","opStatus":"START"}
2019-12-19 09:54:27 AUDIT audit:72 - {"time":"December 19, 2019 1:54:27 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144678262402637","opStatus":"START"}
2019-12-19 09:54:29 AUDIT audit:93 - {"time":"December 19, 2019 1:54:29 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144678262402637","opStatus":"SUCCESS","opTime":"2037 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-19 09:54:29 AUDIT audit:93 - {"time":"December 19, 2019 1:54:29 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9144677931955145","opStatus":"SUCCESS","opTime":"2371 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-19 09:54:29 AUDIT audit:72 - {"time":"December 19, 2019 1:54:29 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9144680312324864","opStatus":"START"}
2019-12-19 09:54:29 AUDIT audit:72 - {"time":"December 19, 2019 1:54:29 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144680798880485","opStatus":"START"}
2019-12-19 09:54:31 AUDIT audit:93 - {"time":"December 19, 2019 1:54:31 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144680798880485","opStatus":"SUCCESS","opTime":"1979 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-19 09:54:31 AUDIT audit:93 - {"time":"December 19, 2019 1:54:31 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9144680312324864","opStatus":"SUCCESS","opTime":"2469 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-19 09:54:31 AUDIT audit:72 - {"time":"December 19, 2019 1:54:31 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9144682792686315","opStatus":"START"}
2019-12-19 09:54:32 AUDIT audit:72 - {"time":"December 19, 2019 1:54:32 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144683127153700","opStatus":"START"}
2019-12-19 09:54:34 AUDIT audit:93 - {"time":"December 19, 2019 1:54:34 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144683127153700","opStatus":"SUCCESS","opTime":"2004 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-19 09:54:34 AUDIT audit:93 - {"time":"December 19, 2019 1:54:34 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9144682792686315","opStatus":"SUCCESS","opTime":"2342 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-19 09:54:34 AUDIT audit:72 - {"time":"December 19, 2019 1:54:34 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9144685144319494","opStatus":"START"}
2019-12-19 09:54:34 AUDIT audit:72 - {"time":"December 19, 2019 1:54:34 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144685490291581","opStatus":"START"}
2019-12-19 09:54:36 AUDIT audit:93 - {"time":"December 19, 2019 1:54:36 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144685490291581","opStatus":"SUCCESS","opTime":"2132 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-19 09:54:36 AUDIT audit:93 - {"time":"December 19, 2019 1:54:36 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9144685144319494","opStatus":"SUCCESS","opTime":"2481 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-19 09:54:36 AUDIT audit:72 - {"time":"December 19, 2019 1:54:36 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9144687635203792","opStatus":"START"}
2019-12-19 09:54:37 AUDIT audit:72 - {"time":"December 19, 2019 1:54:37 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144688027934916","opStatus":"START"}
2019-12-19 09:54:39 AUDIT audit:93 - {"time":"December 19, 2019 1:54:39 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144688027934916","opStatus":"SUCCESS","opTime":"2287 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-19 09:54:39 AUDIT audit:93 - {"time":"December 19, 2019 1:54:39 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9144687635203792","opStatus":"SUCCESS","opTime":"2684 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-19 09:54:39 AUDIT audit:72 - {"time":"December 19, 2019 1:54:39 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9144690326748521","opStatus":"START"}
2019-12-19 09:54:39 AUDIT audit:72 - {"time":"December 19, 2019 1:54:39 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144690660639182","opStatus":"START"}
2019-12-19 09:54:41 AUDIT audit:93 - {"time":"December 19, 2019 1:54:41 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144690660639182","opStatus":"SUCCESS","opTime":"1988 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-19 09:54:41 AUDIT audit:93 - {"time":"December 19, 2019 1:54:41 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9144690326748521","opStatus":"SUCCESS","opTime":"2325 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-19 09:54:41 AUDIT audit:72 - {"time":"December 19, 2019 1:54:41 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9144692653266774","opStatus":"START"}
2019-12-19 09:54:41 AUDIT audit:72 - {"time":"December 19, 2019 1:54:41 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9144692771926911","opStatus":"START"}
2019-12-19 09:54:42 AUDIT audit:93 - {"time":"December 19, 2019 1:54:42 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9144692771926911","opStatus":"SUCCESS","opTime":"304 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-19 09:54:42 AUDIT audit:72 - {"time":"December 19, 2019 1:54:42 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9144693209955515","opStatus":"START"}
2019-12-19 09:54:42 AUDIT audit:93 - {"time":"December 19, 2019 1:54:42 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9144693209955515","opStatus":"SUCCESS","opTime":"21 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-19 09:54:42 AUDIT audit:93 - {"time":"December 19, 2019 1:54:42 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9144692653266774","opStatus":"SUCCESS","opTime":"735 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-19 09:54:42 AUDIT audit:72 - {"time":"December 19, 2019 1:54:42 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9144693396394000","opStatus":"START"}
2019-12-19 09:54:42 AUDIT audit:93 - {"time":"December 19, 2019 1:54:42 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"9144693396394000","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-19 09:54:42 AUDIT audit:72 - {"time":"December 19, 2019 1:54:42 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9144693881110249","opStatus":"START"}
2019-12-19 09:54:43 AUDIT audit:93 - {"time":"December 19, 2019 1:54:43 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9144693881110249","opStatus":"SUCCESS","opTime":"335 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-19 09:54:43 AUDIT audit:72 - {"time":"December 19, 2019 1:54:43 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144694219197808","opStatus":"START"}
2019-12-19 09:54:43 AUDIT audit:93 - {"time":"December 19, 2019 1:54:43 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144694219197808","opStatus":"SUCCESS","opTime":"85 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-19 09:54:43 AUDIT audit:72 - {"time":"December 19, 2019 1:54:43 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9144694308734011","opStatus":"START"}
2019-12-19 09:54:43 AUDIT audit:72 - {"time":"December 19, 2019 1:54:43 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144694451556931","opStatus":"START"}
2019-12-19 09:54:43 AUDIT audit:93 - {"time":"December 19, 2019 1:54:43 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144694451556931","opStatus":"SUCCESS","opTime":"53 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-19 09:54:43 AUDIT audit:93 - {"time":"December 19, 2019 1:54:43 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9144694308734011","opStatus":"SUCCESS","opTime":"352 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p7"}}
2019-12-19 09:54:43 AUDIT audit:72 - {"time":"December 19, 2019 1:54:43 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9144694664750688","opStatus":"START"}
2019-12-19 09:54:43 AUDIT audit:72 - {"time":"December 19, 2019 1:54:43 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144694682572361","opStatus":"START"}
2019-12-19 09:54:43 AUDIT audit:93 - {"time":"December 19, 2019 1:54:43 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144694682572361","opStatus":"SUCCESS","opTime":"73 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-19 09:54:43 AUDIT audit:93 - {"time":"December 19, 2019 1:54:43 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9144694664750688","opStatus":"SUCCESS","opTime":"244 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p1"}}
2019-12-19 09:54:43 AUDIT audit:72 - {"time":"December 19, 2019 1:54:43 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9144694912403657","opStatus":"START"}
2019-12-19 09:54:43 AUDIT audit:72 - {"time":"December 19, 2019 1:54:43 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144694933140600","opStatus":"START"}
2019-12-19 09:54:43 AUDIT audit:93 - {"time":"December 19, 2019 1:54:43 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144694933140600","opStatus":"SUCCESS","opTime":"56 ms","table":"partition_mv.p2_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"p2"}}
2019-12-19 09:54:44 AUDIT audit:93 - {"time":"December 19, 2019 1:54:44 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9144694912403657","opStatus":"SUCCESS","opTime":"243 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p2"}}
2019-12-19 09:54:44 AUDIT audit:72 - {"time":"December 19, 2019 1:54:44 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9144695159417880","opStatus":"START"}
2019-12-19 09:54:44 AUDIT audit:72 - {"time":"December 19, 2019 1:54:44 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144695183638492","opStatus":"START"}
2019-12-19 09:54:44 AUDIT audit:93 - {"time":"December 19, 2019 1:54:44 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144695183638492","opStatus":"SUCCESS","opTime":"592 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-19 09:54:44 AUDIT audit:93 - {"time":"December 19, 2019 1:54:44 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9144695159417880","opStatus":"SUCCESS","opTime":"755 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p3"}}
2019-12-19 09:54:44 AUDIT audit:72 - {"time":"December 19, 2019 1:54:44 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9144695917934648","opStatus":"START"}
2019-12-19 09:54:44 AUDIT audit:72 - {"time":"December 19, 2019 1:54:44 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144695940410273","opStatus":"START"}
2019-12-19 09:54:45 AUDIT audit:93 - {"time":"December 19, 2019 1:54:45 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144695940410273","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-19 09:54:45 AUDIT audit:93 - {"time":"December 19, 2019 1:54:45 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9144695917934648","opStatus":"SUCCESS","opTime":"224 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p4"}}
2019-12-19 09:54:45 AUDIT audit:72 - {"time":"December 19, 2019 1:54:45 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9144696145464294","opStatus":"START"}
2019-12-19 09:54:45 AUDIT audit:72 - {"time":"December 19, 2019 1:54:45 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144696164224474","opStatus":"START"}
2019-12-19 09:54:45 AUDIT audit:93 - {"time":"December 19, 2019 1:54:45 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144696164224474","opStatus":"SUCCESS","opTime":"58 ms","table":"partition_mv.p5_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"p5"}}
2019-12-19 09:54:45 AUDIT audit:93 - {"time":"December 19, 2019 1:54:45 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9144696145464294","opStatus":"SUCCESS","opTime":"205 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p5"}}
2019-12-19 09:54:45 AUDIT audit:72 - {"time":"December 19, 2019 1:54:45 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9144696353999427","opStatus":"START"}
2019-12-19 09:54:45 AUDIT audit:72 - {"time":"December 19, 2019 1:54:45 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144696375293595","opStatus":"START"}
2019-12-19 09:54:45 AUDIT audit:93 - {"time":"December 19, 2019 1:54:45 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144696375293595","opStatus":"SUCCESS","opTime":"81 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-19 09:54:45 AUDIT audit:93 - {"time":"December 19, 2019 1:54:45 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9144696353999427","opStatus":"SUCCESS","opTime":"241 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p6"}}
2019-12-19 09:54:45 AUDIT audit:72 - {"time":"December 19, 2019 1:54:45 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9144696601947185","opStatus":"START"}
2019-12-19 09:54:46 AUDIT audit:93 - {"time":"December 19, 2019 1:54:46 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9144696601947185","opStatus":"SUCCESS","opTime":"747 ms","table":"partition_mv.partitionone","extraInfo":{}}
- check partitioning for child tables with various combinations
2019-12-19 09:54:46 AUDIT audit:72 - {"time":"December 19, 2019 1:54:46 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144697354482365","opStatus":"START"}
2019-12-19 09:54:46 AUDIT audit:93 - {"time":"December 19, 2019 1:54:46 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144697354482365","opStatus":"SUCCESS","opTime":"59 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-19 09:54:46 AUDIT audit:72 - {"time":"December 19, 2019 1:54:46 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9144697485670103","opStatus":"START"}
2019-12-19 09:54:46 AUDIT audit:93 - {"time":"December 19, 2019 1:54:46 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9144697485670103","opStatus":"SUCCESS","opTime":"369 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-19 09:54:46 AUDIT audit:72 - {"time":"December 19, 2019 1:54:46 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"9144697856301068","opStatus":"START"}
2019-12-19 09:54:46 AUDIT audit:93 - {"time":"December 19, 2019 1:54:46 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"9144697856301068","opStatus":"SUCCESS","opTime":"3 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-19 09:54:46 AUDIT audit:72 - {"time":"December 19, 2019 1:54:46 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9144697861695198","opStatus":"START"}
2019-12-19 09:54:46 AUDIT audit:72 - {"time":"December 19, 2019 1:54:46 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144697875978285","opStatus":"START"}
2019-12-19 09:54:46 AUDIT audit:93 - {"time":"December 19, 2019 1:54:46 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144697875978285","opStatus":"SUCCESS","opTime":"63 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-19 09:54:47 AUDIT audit:72 - {"time":"December 19, 2019 1:54:47 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144698095232523","opStatus":"START"}
2019-12-19 09:54:48 AUDIT audit:93 - {"time":"December 19, 2019 1:54:48 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144698095232523","opStatus":"SUCCESS","opTime":"1547 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-19 09:54:48 AUDIT audit:93 - {"time":"December 19, 2019 1:54:48 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9144697861695198","opStatus":"SUCCESS","opTime":"1789 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-19 09:54:49 AUDIT audit:72 - {"time":"December 19, 2019 1:54:49 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9144700055754342","opStatus":"START"}
2019-12-19 09:54:49 AUDIT audit:93 - {"time":"December 19, 2019 1:54:49 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9144700055754342","opStatus":"SUCCESS","opTime":"230 ms","table":"partition_mv.partitionone","extraInfo":{}}
- test partition at last column
2019-12-19 09:54:49 AUDIT audit:72 - {"time":"December 19, 2019 1:54:49 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144700291326393","opStatus":"START"}
2019-12-19 09:54:49 AUDIT audit:93 - {"time":"December 19, 2019 1:54:49 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144700291326393","opStatus":"SUCCESS","opTime":"55 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-19 09:54:49 AUDIT audit:72 - {"time":"December 19, 2019 1:54:49 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9144700426014031","opStatus":"START"}
2019-12-19 09:54:49 AUDIT audit:93 - {"time":"December 19, 2019 1:54:49 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9144700426014031","opStatus":"SUCCESS","opTime":"393 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-19 09:54:49 AUDIT audit:72 - {"time":"December 19, 2019 1:54:49 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"9144700820500303","opStatus":"START"}
2019-12-19 09:54:49 AUDIT audit:93 - {"time":"December 19, 2019 1:54:49 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"9144700820500303","opStatus":"SUCCESS","opTime":"3 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-19 09:54:49 AUDIT audit:72 - {"time":"December 19, 2019 1:54:49 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9144700827129848","opStatus":"START"}
2019-12-19 09:54:49 AUDIT audit:72 - {"time":"December 19, 2019 1:54:49 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144700846793109","opStatus":"START"}
2019-12-19 09:54:49 AUDIT audit:93 - {"time":"December 19, 2019 1:54:49 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144700846793109","opStatus":"SUCCESS","opTime":"59 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-19 09:54:50 AUDIT audit:72 - {"time":"December 19, 2019 1:54:50 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144701061052786","opStatus":"START"}
2019-12-19 09:54:50 AUDIT audit:93 - {"time":"December 19, 2019 1:54:50 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144701061052786","opStatus":"SUCCESS","opTime":"733 ms","table":"partition_mv.dm1_table","extraInfo":{"SegmentId":"0","DataSize":"666.0B","IndexSize":"435.0B"}}
2019-12-19 09:54:50 AUDIT audit:93 - {"time":"December 19, 2019 1:54:50 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9144700827129848","opStatus":"SUCCESS","opTime":"976 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-19 09:54:51 AUDIT audit:72 - {"time":"December 19, 2019 1:54:51 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9144702270464688","opStatus":"START"}
2019-12-19 09:54:51 AUDIT audit:93 - {"time":"December 19, 2019 1:54:51 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9144702270464688","opStatus":"SUCCESS","opTime":"201 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-19 09:54:51 AUDIT audit:72 - {"time":"December 19, 2019 1:54:51 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144702474080867","opStatus":"START"}
2019-12-19 09:54:51 AUDIT audit:93 - {"time":"December 19, 2019 1:54:51 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144702474080867","opStatus":"SUCCESS","opTime":"97 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-19 09:54:51 AUDIT audit:72 - {"time":"December 19, 2019 1:54:51 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9144702644193706","opStatus":"START"}
2019-12-19 09:54:52 AUDIT audit:93 - {"time":"December 19, 2019 1:54:52 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"9144702644193706","opStatus":"SUCCESS","opTime":"365 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-19 09:54:52 AUDIT audit:72 - {"time":"December 19, 2019 1:54:52 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"9144703010226483","opStatus":"START"}
2019-12-19 09:54:52 AUDIT audit:93 - {"time":"December 19, 2019 1:54:52 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"9144703010226483","opStatus":"SUCCESS","opTime":"3 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-19 09:54:52 AUDIT audit:72 - {"time":"December 19, 2019 1:54:52 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9144703016463818","opStatus":"START"}
2019-12-19 09:54:52 AUDIT audit:72 - {"time":"December 19, 2019 1:54:52 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144703033176601","opStatus":"START"}
2019-12-19 09:54:52 AUDIT audit:93 - {"time":"December 19, 2019 1:54:52 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"9144703033176601","opStatus":"SUCCESS","opTime":"56 ms","table":"partition_mv.dm1_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"dm1"}}
2019-12-19 09:54:52 AUDIT audit:72 - {"time":"December 19, 2019 1:54:52 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144703244158861","opStatus":"START"}
2019-12-19 09:54:53 AUDIT audit:93 - {"time":"December 19, 2019 1:54:53 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"9144703244158861","opStatus":"SUCCESS","opTime":"1566 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-19 09:54:53 AUDIT audit:93 - {"time":"December 19, 2019 1:54:53 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"9144703016463818","opStatus":"SUCCESS","opTime":"1805 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-19 09:54:54 AUDIT audit:72 - {"time":"December 19, 2019 1:54:54 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9144705360786098","opStatus":"START"}
2019-12-19 09:54:54 AUDIT audit:93 - {"time":"December 19, 2019 1:54:54 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9144705360786098","opStatus":"SUCCESS","opTime":"574 ms","table":"partition_mv.partitionone","extraInfo":{}}
- test partition on timeseries column
2019-12-19 09:54:54 AUDIT audit:72 - {"time":"December 19, 2019 1:54:54 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9144705941648122","opStatus":"START"}
2019-12-19 09:54:54 AUDIT audit:93 - {"time":"December 19, 2019 1:54:54 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9144705941648122","opStatus":"SUCCESS","opTime":"1 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-19 09:54:54 AUDIT audit:72 - {"time":"December 19, 2019 1:54:54 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9144705943188047","opStatus":"START"}
2019-12-19 09:54:55 AUDIT audit:93 - {"time":"December 19, 2019 1:54:55 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9144705943188047","opStatus":"SUCCESS","opTime":"119 ms","table":"partition_mv.droppartition","extraInfo":{}}
2019-12-19 09:54:55 AUDIT audit:72 - {"time":"December 19, 2019 1:54:55 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9144706062018788","opStatus":"START"}
2019-12-19 09:54:55 AUDIT audit:93 - {"time":"December 19, 2019 1:54:55 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9144706062018788","opStatus":"SUCCESS","opTime":"164 ms","table":"partition_mv.maintable","extraInfo":{}}
2019-12-19 09:54:55 AUDIT audit:72 - {"time":"December 19, 2019 1:54:55 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9144706225908682","opStatus":"START"}
2019-12-19 09:54:55 AUDIT audit:93 - {"time":"December 19, 2019 1:54:55 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9144706225908682","opStatus":"SUCCESS","opTime":"74 ms","table":"partition_mv.par","extraInfo":{}}
2019-12-19 09:54:55 AUDIT audit:72 - {"time":"December 19, 2019 1:54:55 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9144706300030017","opStatus":"START"}
2019-12-19 09:54:55 AUDIT audit:93 - {"time":"December 19, 2019 1:54:55 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9144706300030017","opStatus":"SUCCESS","opTime":"154 ms","table":"partition_mv.partitiontable","extraInfo":{}}
2019-12-19 09:54:55 AUDIT audit:72 - {"time":"December 19, 2019 1:54:55 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9144706454489338","opStatus":"START"}
2019-12-19 09:54:55 AUDIT audit:93 - {"time":"December 19, 2019 1:54:55 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"9144706454489338","opStatus":"SUCCESS","opTime":"326 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 13 minutes, 8 seconds.
Total number of tests run: 224
Suites: completed 21, aborted 0
Tests: succeeded 222, failed 2, canceled 0, ignored 27, pending 0
*** 2 TESTS FAILED ***
[JENKINS] Recording test results

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

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

Changes:


------------------------------------------
[...truncated 1.14 MB...]
2019-12-20 09:42:14 AUDIT audit:72 - {"time":"December 20, 2019 1:42:14 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022048287104711","opStatus":"START"}
2019-12-20 09:42:16 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-20 09:42:16 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-20 09:42:16 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-20 09:42:16 ERROR DataTypeUtil:385 - Problem while converting data typeconfigManagement
2019-12-20 09:42:16 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-20 09:42:16 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-20 09:42:16 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-20 09:42:16 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-20 09:42:16 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-20 09:42:16 AUDIT audit:93 - {"time":"December 20, 2019 1:42:16 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022048287104711","opStatus":"SUCCESS","opTime":"2018 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-20 09:42:16 AUDIT audit:93 - {"time":"December 20, 2019 1:42:16 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10022047284927856","opStatus":"SUCCESS","opTime":"3026 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-20 09:42:16 AUDIT audit:72 - {"time":"December 20, 2019 1:42:16 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10022050316683914","opStatus":"START"}
2019-12-20 09:42:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:17 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:17 AUDIT audit:72 - {"time":"December 20, 2019 1:42:17 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022051383337399","opStatus":"START"}
2019-12-20 09:42:19 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-20 09:42:19 ERROR DataTypeUtil:385 - Problem while converting data typeLearning
2019-12-20 09:42:19 AUDIT audit:93 - {"time":"December 20, 2019 1:42:19 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022051383337399","opStatus":"SUCCESS","opTime":"2005 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-20 09:42:19 AUDIT audit:93 - {"time":"December 20, 2019 1:42:19 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10022050316683914","opStatus":"SUCCESS","opTime":"3077 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-20 09:42:19 AUDIT audit:72 - {"time":"December 20, 2019 1:42:19 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10022053397609394","opStatus":"START"}
2019-12-20 09:42:20 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:20 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:20 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:20 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:20 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:20 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:20 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:20 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:20 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:20 AUDIT audit:72 - {"time":"December 20, 2019 1:42:20 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022054370236995","opStatus":"START"}
2019-12-20 09:42:22 ERROR DataTypeUtil:385 - Problem while converting data typeconfigManagement
2019-12-20 09:42:23 AUDIT audit:93 - {"time":"December 20, 2019 1:42:23 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022054370236995","opStatus":"SUCCESS","opTime":"2060 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-20 09:42:23 AUDIT audit:93 - {"time":"December 20, 2019 1:42:23 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10022053397609394","opStatus":"SUCCESS","opTime":"3035 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-20 09:42:23 AUDIT audit:72 - {"time":"December 20, 2019 1:42:23 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10022056436714964","opStatus":"START"}
2019-12-20 09:42:23 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:23 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:23 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:23 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:23 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:23 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:23 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:23 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:23 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:23 AUDIT audit:72 - {"time":"December 20, 2019 1:42:23 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022057408829698","opStatus":"START"}
2019-12-20 09:42:25 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-20 09:42:25 ERROR DataTypeUtil:385 - Problem while converting data typenetwork
2019-12-20 09:42:25 AUDIT audit:93 - {"time":"December 20, 2019 1:42:25 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022057408829698","opStatus":"SUCCESS","opTime":"1927 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-20 09:42:25 AUDIT audit:93 - {"time":"December 20, 2019 1:42:25 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10022056436714964","opStatus":"SUCCESS","opTime":"2902 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-20 09:42:25 AUDIT audit:72 - {"time":"December 20, 2019 1:42:25 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10022059341837065","opStatus":"START"}
2019-12-20 09:42:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:26 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:27 AUDIT audit:72 - {"time":"December 20, 2019 1:42:27 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022060669788963","opStatus":"START"}
2019-12-20 09:42:28 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-20 09:42:28 ERROR DataTypeUtil:385 - Problem while converting data typeprotocol
2019-12-20 09:42:29 AUDIT audit:93 - {"time":"December 20, 2019 1:42:29 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022060669788963","opStatus":"SUCCESS","opTime":"1913 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-20 09:42:29 AUDIT audit:93 - {"time":"December 20, 2019 1:42:29 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10022059341837065","opStatus":"SUCCESS","opTime":"3244 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-20 09:42:29 AUDIT audit:72 - {"time":"December 20, 2019 1:42:29 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10022062589359013","opStatus":"START"}
2019-12-20 09:42:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:29 ERROR GlobalSortHelper$:38 - Data Load is partially success for table partitionallcompaction
2019-12-20 09:42:30 AUDIT audit:72 - {"time":"December 20, 2019 1:42:30 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022063594308251","opStatus":"START"}
2019-12-20 09:42:31 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-20 09:42:31 ERROR DataTypeUtil:385 - Problem while converting data typesecurity
2019-12-20 09:42:32 AUDIT audit:93 - {"time":"December 20, 2019 1:42:32 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022063594308251","opStatus":"SUCCESS","opTime":"1971 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-20 09:42:32 AUDIT audit:93 - {"time":"December 20, 2019 1:42:32 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10022062589359013","opStatus":"SUCCESS","opTime":"2979 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-20 09:42:32 AUDIT audit:72 - {"time":"December 20, 2019 1:42:32 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10022065570328037","opStatus":"START"}
2019-12-20 09:42:33 AUDIT audit:72 - {"time":"December 20, 2019 1:42:33 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10022066897888432","opStatus":"START"}
2019-12-20 09:42:34 AUDIT audit:93 - {"time":"December 20, 2019 1:42:34 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10022066897888432","opStatus":"SUCCESS","opTime":"1318 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-20 09:42:34 AUDIT audit:93 - {"time":"December 20, 2019 1:42:34 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10022065570328037","opStatus":"SUCCESS","opTime":"2809 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-20 09:42:35 AUDIT audit:72 - {"time":"December 20, 2019 1:42:35 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10022068535912252","opStatus":"START"}
2019-12-20 09:42:36 AUDIT audit:93 - {"time":"December 20, 2019 1:42:36 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10022068535912252","opStatus":"SUCCESS","opTime":"1077 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
- Test data updation after compaction on Partition with mv tables
2019-12-20 09:42:36 AUDIT audit:72 - {"time":"December 20, 2019 1:42:36 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022069621365870","opStatus":"START"}
2019-12-20 09:42:36 AUDIT audit:93 - {"time":"December 20, 2019 1:42:36 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022069621365870","opStatus":"SUCCESS","opTime":"69 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-20 09:42:36 AUDIT audit:72 - {"time":"December 20, 2019 1:42:36 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10022069693224615","opStatus":"START"}
2019-12-20 09:42:36 AUDIT audit:93 - {"time":"December 20, 2019 1:42:36 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10022069693224615","opStatus":"SUCCESS","opTime":"4 ms","table":"NA","extraInfo":{"dmName":"ag"}}
2019-12-20 09:42:36 AUDIT audit:72 - {"time":"December 20, 2019 1:42:36 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10022069701203370","opStatus":"START"}
2019-12-20 09:42:36 AUDIT audit:72 - {"time":"December 20, 2019 1:42:36 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022069856796104","opStatus":"START"}
2019-12-20 09:42:36 AUDIT audit:93 - {"time":"December 20, 2019 1:42:36 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022069856796104","opStatus":"SUCCESS","opTime":"91 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-20 09:42:36 AUDIT audit:93 - {"time":"December 20, 2019 1:42:36 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10022069701203370","opStatus":"SUCCESS","opTime":"396 ms","table":"partition_mv.updatetime_8","extraInfo":{"provider":"mv","dmName":"ag"}}
2019-12-20 09:42:36 AUDIT audit:72 - {"time":"December 20, 2019 1:42:36 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10022070106394255","opStatus":"START"}
2019-12-20 09:42:37 AUDIT audit:72 - {"time":"December 20, 2019 1:42:37 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022070601667952","opStatus":"START"}
2019-12-20 09:42:39 AUDIT audit:93 - {"time":"December 20, 2019 1:42:39 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022070601667952","opStatus":"SUCCESS","opTime":"2275 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-20 09:42:39 AUDIT audit:93 - {"time":"December 20, 2019 1:42:39 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10022070106394255","opStatus":"SUCCESS","opTime":"2780 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-20 09:42:39 AUDIT audit:72 - {"time":"December 20, 2019 1:42:39 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10022072895705552","opStatus":"START"}
2019-12-20 09:42:39 AUDIT audit:72 - {"time":"December 20, 2019 1:42:39 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022073314855923","opStatus":"START"}
2019-12-20 09:42:42 AUDIT audit:93 - {"time":"December 20, 2019 1:42:42 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022073314855923","opStatus":"SUCCESS","opTime":"2128 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-20 09:42:42 AUDIT audit:93 - {"time":"December 20, 2019 1:42:42 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10022072895705552","opStatus":"SUCCESS","opTime":"2555 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-20 09:42:42 AUDIT audit:72 - {"time":"December 20, 2019 1:42:42 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10022075467341583","opStatus":"START"}
2019-12-20 09:42:42 AUDIT audit:72 - {"time":"December 20, 2019 1:42:42 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022075853718698","opStatus":"START"}
2019-12-20 09:42:44 AUDIT audit:93 - {"time":"December 20, 2019 1:42:44 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022075853718698","opStatus":"SUCCESS","opTime":"2052 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-20 09:42:44 AUDIT audit:93 - {"time":"December 20, 2019 1:42:44 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10022075467341583","opStatus":"SUCCESS","opTime":"2451 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-20 09:42:44 AUDIT audit:72 - {"time":"December 20, 2019 1:42:44 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10022077932329567","opStatus":"START"}
2019-12-20 09:42:45 AUDIT audit:72 - {"time":"December 20, 2019 1:42:45 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022078426273779","opStatus":"START"}
2019-12-20 09:42:46 AUDIT audit:93 - {"time":"December 20, 2019 1:42:46 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022078426273779","opStatus":"SUCCESS","opTime":"1998 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-20 09:42:47 AUDIT audit:93 - {"time":"December 20, 2019 1:42:47 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10022077932329567","opStatus":"SUCCESS","opTime":"2498 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-20 09:42:47 AUDIT audit:72 - {"time":"December 20, 2019 1:42:47 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10022080440084683","opStatus":"START"}
2019-12-20 09:42:47 AUDIT audit:72 - {"time":"December 20, 2019 1:42:47 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022080797900752","opStatus":"START"}
2019-12-20 09:42:49 AUDIT audit:93 - {"time":"December 20, 2019 1:42:49 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022080797900752","opStatus":"SUCCESS","opTime":"1988 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-20 09:42:49 AUDIT audit:93 - {"time":"December 20, 2019 1:42:49 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10022080440084683","opStatus":"SUCCESS","opTime":"2353 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-20 09:42:49 AUDIT audit:72 - {"time":"December 20, 2019 1:42:49 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10022082802574818","opStatus":"START"}
2019-12-20 09:42:49 AUDIT audit:72 - {"time":"December 20, 2019 1:42:49 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022083178813092","opStatus":"START"}
2019-12-20 09:42:51 AUDIT audit:93 - {"time":"December 20, 2019 1:42:51 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022083178813092","opStatus":"SUCCESS","opTime":"2132 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-20 09:42:51 AUDIT audit:93 - {"time":"December 20, 2019 1:42:51 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10022082802574818","opStatus":"SUCCESS","opTime":"2516 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-20 09:42:51 AUDIT audit:72 - {"time":"December 20, 2019 1:42:51 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10022085327649883","opStatus":"START"}
2019-12-20 09:42:52 AUDIT audit:72 - {"time":"December 20, 2019 1:42:52 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022085718281561","opStatus":"START"}
2019-12-20 09:42:54 AUDIT audit:93 - {"time":"December 20, 2019 1:42:54 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022085718281561","opStatus":"SUCCESS","opTime":"2082 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-20 09:42:54 AUDIT audit:93 - {"time":"December 20, 2019 1:42:54 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10022085327649883","opStatus":"SUCCESS","opTime":"2480 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-20 09:42:54 AUDIT audit:72 - {"time":"December 20, 2019 1:42:54 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10022087817189689","opStatus":"START"}
2019-12-20 09:42:54 AUDIT audit:72 - {"time":"December 20, 2019 1:42:54 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022088196471444","opStatus":"START"}
2019-12-20 09:42:56 AUDIT audit:93 - {"time":"December 20, 2019 1:42:56 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022088196471444","opStatus":"SUCCESS","opTime":"2002 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-20 09:42:56 AUDIT audit:93 - {"time":"December 20, 2019 1:42:56 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10022087817189689","opStatus":"SUCCESS","opTime":"2389 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-20 09:42:56 AUDIT audit:72 - {"time":"December 20, 2019 1:42:56 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10022090209164402","opStatus":"START"}
2019-12-20 09:42:56 AUDIT audit:72 - {"time":"December 20, 2019 1:42:56 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10022090345691993","opStatus":"START"}
2019-12-20 09:42:57 AUDIT audit:93 - {"time":"December 20, 2019 1:42:57 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10022090345691993","opStatus":"SUCCESS","opTime":"412 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-20 09:42:57 AUDIT audit:72 - {"time":"December 20, 2019 1:42:57 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10022091047958509","opStatus":"START"}
2019-12-20 09:42:57 AUDIT audit:93 - {"time":"December 20, 2019 1:42:57 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10022091047958509","opStatus":"SUCCESS","opTime":"24 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-20 09:42:57 AUDIT audit:93 - {"time":"December 20, 2019 1:42:57 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10022090209164402","opStatus":"SUCCESS","opTime":"908 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-20 09:42:57 AUDIT audit:72 - {"time":"December 20, 2019 1:42:57 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10022091125256088","opStatus":"START"}
2019-12-20 09:42:57 AUDIT audit:93 - {"time":"December 20, 2019 1:42:57 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10022091125256088","opStatus":"SUCCESS","opTime":"20 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
- Test data updation in Aggregate query after compaction on Partitioned table with mv table
2019-12-20 09:42:58 AUDIT audit:72 - {"time":"December 20, 2019 1:42:58 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10022091608138287","opStatus":"START"}
2019-12-20 09:42:58 AUDIT audit:93 - {"time":"December 20, 2019 1:42:58 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10022091608138287","opStatus":"SUCCESS","opTime":"213 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-20 09:42:58 AUDIT audit:72 - {"time":"December 20, 2019 1:42:58 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022091825887401","opStatus":"START"}
2019-12-20 09:42:58 AUDIT audit:93 - {"time":"December 20, 2019 1:42:58 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022091825887401","opStatus":"SUCCESS","opTime":"84 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-20 09:42:58 AUDIT audit:72 - {"time":"December 20, 2019 1:42:58 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10022091914322852","opStatus":"START"}
2019-12-20 09:42:58 AUDIT audit:72 - {"time":"December 20, 2019 1:42:58 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022092057812550","opStatus":"START"}
2019-12-20 09:42:58 AUDIT audit:93 - {"time":"December 20, 2019 1:42:58 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022092057812550","opStatus":"SUCCESS","opTime":"42 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-20 09:42:58 AUDIT audit:93 - {"time":"December 20, 2019 1:42:58 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10022091914322852","opStatus":"SUCCESS","opTime":"342 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p7"}}
2019-12-20 09:42:58 AUDIT audit:72 - {"time":"December 20, 2019 1:42:58 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10022092261870618","opStatus":"START"}
2019-12-20 09:42:58 AUDIT audit:72 - {"time":"December 20, 2019 1:42:58 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022092285729820","opStatus":"START"}
2019-12-20 09:42:58 AUDIT audit:93 - {"time":"December 20, 2019 1:42:58 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022092285729820","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-20 09:42:59 AUDIT audit:93 - {"time":"December 20, 2019 1:42:59 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10022092261870618","opStatus":"SUCCESS","opTime":"226 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p1"}}
2019-12-20 09:42:59 AUDIT audit:72 - {"time":"December 20, 2019 1:42:59 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10022092492254289","opStatus":"START"}
2019-12-20 09:42:59 AUDIT audit:72 - {"time":"December 20, 2019 1:42:59 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022092513972118","opStatus":"START"}
2019-12-20 09:42:59 AUDIT audit:93 - {"time":"December 20, 2019 1:42:59 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022092513972118","opStatus":"SUCCESS","opTime":"49 ms","table":"partition_mv.p2_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"p2"}}
2019-12-20 09:42:59 AUDIT audit:93 - {"time":"December 20, 2019 1:42:59 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10022092492254289","opStatus":"SUCCESS","opTime":"230 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p2"}}
2019-12-20 09:42:59 AUDIT audit:72 - {"time":"December 20, 2019 1:42:59 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10022092726649827","opStatus":"START"}
2019-12-20 09:42:59 AUDIT audit:72 - {"time":"December 20, 2019 1:42:59 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022092749408429","opStatus":"START"}
2019-12-20 09:42:59 AUDIT audit:93 - {"time":"December 20, 2019 1:42:59 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022092749408429","opStatus":"SUCCESS","opTime":"46 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-20 09:42:59 AUDIT audit:93 - {"time":"December 20, 2019 1:42:59 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10022092726649827","opStatus":"SUCCESS","opTime":"231 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p3"}}
2019-12-20 09:42:59 AUDIT audit:72 - {"time":"December 20, 2019 1:42:59 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10022092961991040","opStatus":"START"}
2019-12-20 09:42:59 AUDIT audit:72 - {"time":"December 20, 2019 1:42:59 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022092986186021","opStatus":"START"}
2019-12-20 09:42:59 AUDIT audit:93 - {"time":"December 20, 2019 1:42:59 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022092986186021","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-20 09:42:59 AUDIT audit:93 - {"time":"December 20, 2019 1:42:59 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10022092961991040","opStatus":"SUCCESS","opTime":"229 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p4"}}
2019-12-20 09:42:59 AUDIT audit:72 - {"time":"December 20, 2019 1:42:59 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10022093195285837","opStatus":"START"}
2019-12-20 09:42:59 AUDIT audit:72 - {"time":"December 20, 2019 1:42:59 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022093218582261","opStatus":"START"}
2019-12-20 09:42:59 AUDIT audit:93 - {"time":"December 20, 2019 1:42:59 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022093218582261","opStatus":"SUCCESS","opTime":"44 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-20 09:42:59 AUDIT audit:93 - {"time":"December 20, 2019 1:42:59 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10022093195285837","opStatus":"SUCCESS","opTime":"228 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p5"}}
2019-12-20 09:43:00 AUDIT audit:72 - {"time":"December 20, 2019 1:43:00 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10022093427046348","opStatus":"START"}
2019-12-20 09:43:00 AUDIT audit:72 - {"time":"December 20, 2019 1:43:00 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022093452724822","opStatus":"START"}
2019-12-20 09:43:00 AUDIT audit:93 - {"time":"December 20, 2019 1:43:00 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022093452724822","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-20 09:43:00 AUDIT audit:93 - {"time":"December 20, 2019 1:43:00 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10022093427046348","opStatus":"SUCCESS","opTime":"232 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p6"}}
2019-12-20 09:43:00 AUDIT audit:72 - {"time":"December 20, 2019 1:43:00 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10022093667177985","opStatus":"START"}
2019-12-20 09:43:00 AUDIT audit:93 - {"time":"December 20, 2019 1:43:00 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10022093667177985","opStatus":"SUCCESS","opTime":"499 ms","table":"partition_mv.partitionone","extraInfo":{}}
- check partitioning for child tables with various combinations
2019-12-20 09:43:00 AUDIT audit:72 - {"time":"December 20, 2019 1:43:00 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022094172182986","opStatus":"START"}
2019-12-20 09:43:00 AUDIT audit:93 - {"time":"December 20, 2019 1:43:00 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022094172182986","opStatus":"SUCCESS","opTime":"45 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-20 09:43:00 AUDIT audit:72 - {"time":"December 20, 2019 1:43:00 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10022094309093532","opStatus":"START"}
2019-12-20 09:43:01 AUDIT audit:93 - {"time":"December 20, 2019 1:43:01 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10022094309093532","opStatus":"SUCCESS","opTime":"346 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-20 09:43:01 AUDIT audit:72 - {"time":"December 20, 2019 1:43:01 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10022094657309073","opStatus":"START"}
2019-12-20 09:43:01 AUDIT audit:93 - {"time":"December 20, 2019 1:43:01 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10022094657309073","opStatus":"SUCCESS","opTime":"3 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-20 09:43:01 AUDIT audit:72 - {"time":"December 20, 2019 1:43:01 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10022094663338706","opStatus":"START"}
2019-12-20 09:43:01 AUDIT audit:72 - {"time":"December 20, 2019 1:43:01 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022094681365263","opStatus":"START"}
2019-12-20 09:43:01 AUDIT audit:93 - {"time":"December 20, 2019 1:43:01 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022094681365263","opStatus":"SUCCESS","opTime":"44 ms","table":"partition_mv.dm1_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"dm1"}}
2019-12-20 09:43:01 AUDIT audit:72 - {"time":"December 20, 2019 1:43:01 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022094901288894","opStatus":"START"}
2019-12-20 09:43:03 AUDIT audit:93 - {"time":"December 20, 2019 1:43:03 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022094901288894","opStatus":"SUCCESS","opTime":"1663 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-20 09:43:03 AUDIT audit:93 - {"time":"December 20, 2019 1:43:03 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10022094663338706","opStatus":"SUCCESS","opTime":"1912 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-20 09:43:03 AUDIT audit:72 - {"time":"December 20, 2019 1:43:03 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10022097050670226","opStatus":"START"}
2019-12-20 09:43:03 AUDIT audit:93 - {"time":"December 20, 2019 1:43:03 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10022097050670226","opStatus":"SUCCESS","opTime":"204 ms","table":"partition_mv.partitionone","extraInfo":{}}
- test partition at last column
2019-12-20 09:43:03 AUDIT audit:72 - {"time":"December 20, 2019 1:43:03 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022097261865599","opStatus":"START"}
2019-12-20 09:43:03 AUDIT audit:93 - {"time":"December 20, 2019 1:43:03 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022097261865599","opStatus":"SUCCESS","opTime":"48 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-20 09:43:03 AUDIT audit:72 - {"time":"December 20, 2019 1:43:03 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10022097406064538","opStatus":"START"}
2019-12-20 09:43:04 AUDIT audit:93 - {"time":"December 20, 2019 1:43:04 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10022097406064538","opStatus":"SUCCESS","opTime":"390 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-20 09:43:04 AUDIT audit:72 - {"time":"December 20, 2019 1:43:04 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10022097797616236","opStatus":"START"}
2019-12-20 09:43:04 AUDIT audit:93 - {"time":"December 20, 2019 1:43:04 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10022097797616236","opStatus":"SUCCESS","opTime":"3 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-20 09:43:04 AUDIT audit:72 - {"time":"December 20, 2019 1:43:04 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10022097804640379","opStatus":"START"}
2019-12-20 09:43:04 AUDIT audit:72 - {"time":"December 20, 2019 1:43:04 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022097825654106","opStatus":"START"}
2019-12-20 09:43:04 AUDIT audit:93 - {"time":"December 20, 2019 1:43:04 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022097825654106","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-20 09:43:04 AUDIT audit:72 - {"time":"December 20, 2019 1:43:04 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022098036648653","opStatus":"START"}
2019-12-20 09:43:05 AUDIT audit:93 - {"time":"December 20, 2019 1:43:05 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022098036648653","opStatus":"SUCCESS","opTime":"741 ms","table":"partition_mv.dm1_table","extraInfo":{"SegmentId":"0","DataSize":"666.0B","IndexSize":"435.0B"}}
2019-12-20 09:43:05 AUDIT audit:93 - {"time":"December 20, 2019 1:43:05 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10022097804640379","opStatus":"SUCCESS","opTime":"986 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-20 09:43:05 AUDIT audit:72 - {"time":"December 20, 2019 1:43:05 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10022099305862589","opStatus":"START"}
2019-12-20 09:43:06 AUDIT audit:93 - {"time":"December 20, 2019 1:43:06 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10022099305862589","opStatus":"SUCCESS","opTime":"227 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-20 09:43:06 AUDIT audit:72 - {"time":"December 20, 2019 1:43:06 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022099535253527","opStatus":"START"}
2019-12-20 09:43:06 AUDIT audit:93 - {"time":"December 20, 2019 1:43:06 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022099535253527","opStatus":"SUCCESS","opTime":"77 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-20 09:43:06 AUDIT audit:72 - {"time":"December 20, 2019 1:43:06 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10022099706406488","opStatus":"START"}
2019-12-20 09:43:06 AUDIT audit:93 - {"time":"December 20, 2019 1:43:06 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10022099706406488","opStatus":"SUCCESS","opTime":"392 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-20 09:43:06 AUDIT audit:72 - {"time":"December 20, 2019 1:43:06 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10022100100543564","opStatus":"START"}
2019-12-20 09:43:06 AUDIT audit:93 - {"time":"December 20, 2019 1:43:06 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10022100100543564","opStatus":"SUCCESS","opTime":"4 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-20 09:43:06 AUDIT audit:72 - {"time":"December 20, 2019 1:43:06 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10022100107404167","opStatus":"START"}
2019-12-20 09:43:06 AUDIT audit:72 - {"time":"December 20, 2019 1:43:06 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022100126186091","opStatus":"START"}
2019-12-20 09:43:06 AUDIT audit:93 - {"time":"December 20, 2019 1:43:06 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10022100126186091","opStatus":"SUCCESS","opTime":"47 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-20 09:43:06 AUDIT audit:72 - {"time":"December 20, 2019 1:43:06 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022100341047433","opStatus":"START"}
2019-12-20 09:43:08 AUDIT audit:93 - {"time":"December 20, 2019 1:43:08 AM PST","username":"jenkins","opName":"LOAD DATA","opId":"10022100341047433","opStatus":"SUCCESS","opTime":"1571 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-20 09:43:08 AUDIT audit:93 - {"time":"December 20, 2019 1:43:08 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10022100107404167","opStatus":"SUCCESS","opTime":"1816 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
2019-12-20 09:43:09 AUDIT audit:72 - {"time":"December 20, 2019 1:43:09 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10022102465089356","opStatus":"START"}
2019-12-20 09:43:09 AUDIT audit:93 - {"time":"December 20, 2019 1:43:09 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10022102465089356","opStatus":"SUCCESS","opTime":"194 ms","table":"partition_mv.partitionone","extraInfo":{}}
- test partition on timeseries column
2019-12-20 09:43:09 AUDIT audit:72 - {"time":"December 20, 2019 1:43:09 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10022102666027459","opStatus":"START"}
2019-12-20 09:43:09 AUDIT audit:93 - {"time":"December 20, 2019 1:43:09 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10022102666027459","opStatus":"SUCCESS","opTime":"1 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-20 09:43:09 AUDIT audit:72 - {"time":"December 20, 2019 1:43:09 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10022102667216733","opStatus":"START"}
2019-12-20 09:43:09 AUDIT audit:93 - {"time":"December 20, 2019 1:43:09 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10022102667216733","opStatus":"SUCCESS","opTime":"100 ms","table":"partition_mv.droppartition","extraInfo":{}}
2019-12-20 09:43:09 AUDIT audit:72 - {"time":"December 20, 2019 1:43:09 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10022102768273631","opStatus":"START"}
2019-12-20 09:43:09 AUDIT audit:93 - {"time":"December 20, 2019 1:43:09 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10022102768273631","opStatus":"SUCCESS","opTime":"236 ms","table":"partition_mv.maintable","extraInfo":{}}
2019-12-20 09:43:09 AUDIT audit:72 - {"time":"December 20, 2019 1:43:09 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10022103004796894","opStatus":"START"}
2019-12-20 09:43:09 AUDIT audit:93 - {"time":"December 20, 2019 1:43:09 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10022103004796894","opStatus":"SUCCESS","opTime":"55 ms","table":"partition_mv.par","extraInfo":{}}
2019-12-20 09:43:09 AUDIT audit:72 - {"time":"December 20, 2019 1:43:09 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10022103059642539","opStatus":"START"}
2019-12-20 09:43:09 AUDIT audit:93 - {"time":"December 20, 2019 1:43:09 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10022103059642539","opStatus":"SUCCESS","opTime":"126 ms","table":"partition_mv.partitiontable","extraInfo":{}}
2019-12-20 09:43:09 AUDIT audit:72 - {"time":"December 20, 2019 1:43:09 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10022103186289387","opStatus":"START"}
2019-12-20 09:43:10 AUDIT audit:93 - {"time":"December 20, 2019 1:43:10 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10022103186289387","opStatus":"SUCCESS","opTime":"251 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, 26 seconds.
Total number of tests run: 224
Suites: completed 21, aborted 0
Tests: succeeded 222, failed 2, canceled 0, ignored 27, pending 0
*** 2 TESTS FAILED ***
[JENKINS] Recording test results