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/30 11:39:16 UTC
Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Materialized View Core #3941
See <https://builds.apache.org/job/carbondata-master-spark-2.1/org.apache.carbondata$carbondata-mv-core/3941/display/redirect?page=changes>
Changes:
[QiangCai] [CARBONATA-3605] Remove global dictionary feature
------------------------------------------
[...truncated 1.14 MB...]
2019-12-30 11:35:49 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:49 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:49 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:49 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:50 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:50 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:50 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:50 ERROR GlobalSortHelper$:45 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:50 AUDIT audit:93 - {"time":"December 30, 2019 3:35:50 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10892862735201245","opStatus":"SUCCESS","opTime":"1022 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-30 11:35:50 AUDIT audit:72 - {"time":"December 30, 2019 3:35:50 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10892863759961330","opStatus":"START"}
2019-12-30 11:35:50 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:50 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:50 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:50 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:50 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:51 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:51 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:51 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:51 ERROR GlobalSortHelper$:45 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:51 AUDIT audit:93 - {"time":"December 30, 2019 3:35:51 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10892863759961330","opStatus":"SUCCESS","opTime":"949 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-30 11:35:51 AUDIT audit:72 - {"time":"December 30, 2019 3:35:51 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10892864712355148","opStatus":"START"}
2019-12-30 11:35:51 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:51 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:51 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:51 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:51 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:51 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:52 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:52 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:52 ERROR GlobalSortHelper$:45 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:52 AUDIT audit:93 - {"time":"December 30, 2019 3:35:52 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10892864712355148","opStatus":"SUCCESS","opTime":"944 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-30 11:35:52 AUDIT audit:72 - {"time":"December 30, 2019 3:35:52 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10892865659643777","opStatus":"START"}
2019-12-30 11:35:52 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:52 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:52 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:52 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:52 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:52 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:53 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:53 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:53 ERROR GlobalSortHelper$:45 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:35:53 AUDIT audit:93 - {"time":"December 30, 2019 3:35:53 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10892865659643777","opStatus":"SUCCESS","opTime":"984 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-30 11:35:53 AUDIT audit:72 - {"time":"December 30, 2019 3:35:53 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10892866646735501","opStatus":"START"}
2019-12-30 11:35:53 AUDIT audit:93 - {"time":"December 30, 2019 3:35:53 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10892866646735501","opStatus":"SUCCESS","opTime":"57 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
[31m- Test data updation after compaction on Partition with mv tables *** FAILED ***[0m
[31m Results do not match for query:[0m
[31m == Parsed Logical Plan ==[0m
[31m 'Project [unresolvedalias('count('empno), None)][0m
[31m +- 'Filter ('empno = 14)[0m
[31m +- 'UnresolvedRelation `partitionallcompaction`[0m
[31m == Analyzed Logical Plan ==[0m
[31m count(empno): bigint[0m
[31m Aggregate [count(empno#47656) AS count(empno)#48279L][0m
[31m +- Filter (empno#47656 = 14)[0m
[31m +- SubqueryAlias partitionallcompaction[0m
[31m +- Relation[empno#47656,empname#47657,designation#47658,workgroupcategory#47659,workgroupcategoryname#47660,deptno#47661,projectjoindate#47662,projectenddate#47663,attendance#47664,utilization#47665,salary#47666,deptname#47667,doj#47668,projectcode#47669] CarbonDatasourceHadoopRelation[0m
[31m == Optimized Logical Plan ==[0m
[31m CarbonDictionaryCatalystDecoder [partition_mv_partitionallcompaction], ExcludeProfile(ArrayBuffer()), CarbonAliasDecoderRelation(), true[0m
[31m +- Aggregate [count(empno#47656) AS count(empno)#48279L][0m
[31m +- Project [empno#47656][0m
[31m +- Filter (isnotnull(empno#47656) && (empno#47656 = 14))[0m
[31m +- Relation[empno#47656,empname#47657,designation#47658,workgroupcategory#47659,workgroupcategoryname#47660,deptno#47661,projectjoindate#47662,projectenddate#47663,attendance#47664,utilization#47665,salary#47666,deptname#47667,doj#47668,projectcode#47669] CarbonDatasourceHadoopRelation[0m
[31m == Physical Plan ==[0m
[31m *HashAggregate(keys=[], functions=[count(empno#47656)], output=[count(empno)#48279L])[0m
[31m +- Exchange SinglePartition[0m
[31m +- *HashAggregate(keys=[], functions=[partial_count(empno#47656)], output=[count#48286L])[0m
[31m +- *Filter (isnotnull(empno#47656) && (empno#47656 = 14))[0m
[31m +- *FileScan carbondata partition_mv.partitionallcompaction[empno#47656] PushedFilters: [IsNotNull(empno), EqualTo(empno,14)], ReadSchema: struct<empno:int>[0m
[31m == Results ==[0m
[31m !== Correct Answer - 1 == == Spark Answer - 1 ==[0m
[31m ![5] [0] (QueryTest.scala:90)[0m
2019-12-30 11:35:53 AUDIT audit:72 - {"time":"December 30, 2019 3:35:53 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892866806791713","opStatus":"START"}
2019-12-30 11:35:53 AUDIT audit:93 - {"time":"December 30, 2019 3:35:53 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892866806791713","opStatus":"SUCCESS","opTime":"54 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-30 11:35:53 AUDIT audit:72 - {"time":"December 30, 2019 3:35:53 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10892866863036107","opStatus":"START"}
2019-12-30 11:35:53 AUDIT audit:93 - {"time":"December 30, 2019 3:35:53 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10892866863036107","opStatus":"SUCCESS","opTime":"4 ms","table":"NA","extraInfo":{"dmName":"ag"}}
2019-12-30 11:35:53 AUDIT audit:72 - {"time":"December 30, 2019 3:35:53 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892866870829890","opStatus":"START"}
2019-12-30 11:35:53 AUDIT audit:72 - {"time":"December 30, 2019 3:35:53 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892867014384778","opStatus":"START"}
2019-12-30 11:35:53 AUDIT audit:93 - {"time":"December 30, 2019 3:35:53 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892867014384778","opStatus":"SUCCESS","opTime":"44 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-30 11:35:53 AUDIT audit:93 - {"time":"December 30, 2019 3:35:53 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892866870829890","opStatus":"SUCCESS","opTime":"344 ms","table":"partition_mv.updatetime_8","extraInfo":{"provider":"mv","dmName":"ag"}}
2019-12-30 11:35:53 AUDIT audit:72 - {"time":"December 30, 2019 3:35:53 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892867224509127","opStatus":"START"}
2019-12-30 11:35:54 AUDIT audit:93 - {"time":"December 30, 2019 3:35:54 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892867224509127","opStatus":"SUCCESS","opTime":"394 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-30 11:35:54 AUDIT audit:72 - {"time":"December 30, 2019 3:35:54 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892867626534565","opStatus":"START"}
2019-12-30 11:35:54 AUDIT audit:93 - {"time":"December 30, 2019 3:35:54 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892867626534565","opStatus":"SUCCESS","opTime":"315 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-30 11:35:54 AUDIT audit:72 - {"time":"December 30, 2019 3:35:54 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892867950213321","opStatus":"START"}
2019-12-30 11:35:54 AUDIT audit:93 - {"time":"December 30, 2019 3:35:54 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892867950213321","opStatus":"SUCCESS","opTime":"281 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-30 11:35:54 AUDIT audit:72 - {"time":"December 30, 2019 3:35:54 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892868240094683","opStatus":"START"}
2019-12-30 11:35:55 AUDIT audit:93 - {"time":"December 30, 2019 3:35:55 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892868240094683","opStatus":"SUCCESS","opTime":"271 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-30 11:35:55 AUDIT audit:72 - {"time":"December 30, 2019 3:35:55 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892868520026968","opStatus":"START"}
2019-12-30 11:35:55 AUDIT audit:93 - {"time":"December 30, 2019 3:35:55 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892868520026968","opStatus":"SUCCESS","opTime":"263 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-30 11:35:55 AUDIT audit:72 - {"time":"December 30, 2019 3:35:55 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892868792342132","opStatus":"START"}
2019-12-30 11:35:55 AUDIT audit:93 - {"time":"December 30, 2019 3:35:55 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892868792342132","opStatus":"SUCCESS","opTime":"274 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-30 11:35:55 AUDIT audit:72 - {"time":"December 30, 2019 3:35:55 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892869076115423","opStatus":"START"}
2019-12-30 11:35:56 AUDIT audit:93 - {"time":"December 30, 2019 3:35:56 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892869076115423","opStatus":"SUCCESS","opTime":"384 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-30 11:35:56 AUDIT audit:72 - {"time":"December 30, 2019 3:35:56 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892869468644513","opStatus":"START"}
2019-12-30 11:35:56 AUDIT audit:93 - {"time":"December 30, 2019 3:35:56 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892869468644513","opStatus":"SUCCESS","opTime":"282 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-30 11:35:56 AUDIT audit:72 - {"time":"December 30, 2019 3:35:56 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10892869752721579","opStatus":"START"}
2019-12-30 11:35:56 AUDIT audit:93 - {"time":"December 30, 2019 3:35:56 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10892869752721579","opStatus":"SUCCESS","opTime":"21 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-30 11:35:56 AUDIT audit:72 - {"time":"December 30, 2019 3:35:56 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10892869780659303","opStatus":"START"}
2019-12-30 11:35:56 AUDIT audit:93 - {"time":"December 30, 2019 3:35:56 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10892869780659303","opStatus":"SUCCESS","opTime":"21 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
[31m- Test data updation in Aggregate query after compaction on Partitioned table with mv table *** FAILED ***[0m
[31m Results do not match for query:[0m
[31m == Parsed Logical Plan ==[0m
[31m 'Aggregate ['imex], [unresolvedalias('sum('hs_len), None)][0m
[31m +- 'UnresolvedRelation `updatetime_8`[0m
[31m == Analyzed Logical Plan ==[0m
[31m sum(hs_len): bigint[0m
[31m Aggregate [updatetime_8_imex#48382], [sum(sum_hs_len#48381L) AS sum(hs_len)#48876L][0m
[31m +- SubqueryAlias ag_table[0m
[31m +- Relation[sum_hs_len#48381L,updatetime_8_imex#48382] CarbonDatasourceHadoopRelation[0m
[31m == Optimized Logical Plan ==[0m
[31m CarbonDictionaryCatalystDecoder [partition_mv_ag_table], ExcludeProfile(ArrayBuffer()), CarbonAliasDecoderRelation(), true[0m
[31m +- Aggregate [updatetime_8_imex#48382], [sum(sum_hs_len#48381L) AS sum(hs_len)#48876L][0m
[31m +- Relation[sum_hs_len#48381L,updatetime_8_imex#48382] CarbonDatasourceHadoopRelation[0m
[31m == Physical Plan ==[0m
[31m *HashAggregate(keys=[updatetime_8_imex#48382], functions=[sum(sum_hs_len#48381L)], output=[sum(hs_len)#48876L])[0m
[31m +- Exchange hashpartitioning(updatetime_8_imex#48382, 200)[0m
[31m +- *HashAggregate(keys=[updatetime_8_imex#48382], functions=[partial_sum(sum_hs_len#48381L)], output=[updatetime_8_imex#48382, sum#48890L])[0m
[31m +- *FileScan carbondata partition_mv.ag_table[sum_hs_len#48381L,updatetime_8_imex#48382] ReadSchema: struct<sum_hs_len:bigint,updatetime_8_imex:smallint>[0m
[31m == Results ==[0m
[31m !== Correct Answer - 3 == == Spark Answer - 0 ==[0m
[31m ![40] [0m
[31m ![42] [0m
[31m ![83] (QueryTest.scala:90)[0m
2019-12-30 11:35:56 AUDIT audit:72 - {"time":"December 30, 2019 3:35:56 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892870226072813","opStatus":"START"}
2019-12-30 11:35:57 AUDIT audit:93 - {"time":"December 30, 2019 3:35:57 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892870226072813","opStatus":"SUCCESS","opTime":"314 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-30 11:35:57 AUDIT audit:72 - {"time":"December 30, 2019 3:35:57 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892870544045109","opStatus":"START"}
2019-12-30 11:35:57 AUDIT audit:93 - {"time":"December 30, 2019 3:35:57 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892870544045109","opStatus":"SUCCESS","opTime":"63 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-30 11:35:57 AUDIT audit:72 - {"time":"December 30, 2019 3:35:57 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892870610976919","opStatus":"START"}
2019-12-30 11:35:57 AUDIT audit:72 - {"time":"December 30, 2019 3:35:57 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892870752069440","opStatus":"START"}
2019-12-30 11:35:57 AUDIT audit:93 - {"time":"December 30, 2019 3:35:57 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892870752069440","opStatus":"SUCCESS","opTime":"41 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-30 11:35:57 AUDIT audit:93 - {"time":"December 30, 2019 3:35:57 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892870610976919","opStatus":"SUCCESS","opTime":"334 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p7"}}
2019-12-30 11:35:57 AUDIT audit:72 - {"time":"December 30, 2019 3:35:57 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892870949106149","opStatus":"START"}
2019-12-30 11:35:57 AUDIT audit:72 - {"time":"December 30, 2019 3:35:57 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892870967992998","opStatus":"START"}
2019-12-30 11:35:57 AUDIT audit:93 - {"time":"December 30, 2019 3:35:57 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892870967992998","opStatus":"SUCCESS","opTime":"40 ms","table":"partition_mv.p1_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"p1"}}
2019-12-30 11:35:57 AUDIT audit:93 - {"time":"December 30, 2019 3:35:57 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892870949106149","opStatus":"SUCCESS","opTime":"215 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p1"}}
2019-12-30 11:35:57 AUDIT audit:72 - {"time":"December 30, 2019 3:35:57 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892871168165119","opStatus":"START"}
2019-12-30 11:35:57 AUDIT audit:72 - {"time":"December 30, 2019 3:35:57 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892871190038235","opStatus":"START"}
2019-12-30 11:35:57 AUDIT audit:93 - {"time":"December 30, 2019 3:35:57 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892871190038235","opStatus":"SUCCESS","opTime":"39 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-30 11:35:57 AUDIT audit:93 - {"time":"December 30, 2019 3:35:57 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892871168165119","opStatus":"SUCCESS","opTime":"223 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p2"}}
2019-12-30 11:35:57 AUDIT audit:72 - {"time":"December 30, 2019 3:35:57 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892871395781953","opStatus":"START"}
2019-12-30 11:35:57 AUDIT audit:72 - {"time":"December 30, 2019 3:35:57 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892871420531637","opStatus":"START"}
2019-12-30 11:35:58 AUDIT audit:93 - {"time":"December 30, 2019 3:35:58 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892871420531637","opStatus":"SUCCESS","opTime":"41 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-30 11:35:58 AUDIT audit:93 - {"time":"December 30, 2019 3:35:58 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892871395781953","opStatus":"SUCCESS","opTime":"227 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p3"}}
2019-12-30 11:35:58 AUDIT audit:72 - {"time":"December 30, 2019 3:35:58 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892871626924137","opStatus":"START"}
2019-12-30 11:35:58 AUDIT audit:72 - {"time":"December 30, 2019 3:35:58 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892871652103727","opStatus":"START"}
2019-12-30 11:35:58 AUDIT audit:93 - {"time":"December 30, 2019 3:35:58 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892871652103727","opStatus":"SUCCESS","opTime":"43 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-30 11:35:58 AUDIT audit:93 - {"time":"December 30, 2019 3:35:58 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892871626924137","opStatus":"SUCCESS","opTime":"234 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p4"}}
2019-12-30 11:35:58 AUDIT audit:72 - {"time":"December 30, 2019 3:35:58 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892871864509368","opStatus":"START"}
2019-12-30 11:35:58 AUDIT audit:72 - {"time":"December 30, 2019 3:35:58 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892871888439320","opStatus":"START"}
2019-12-30 11:35:58 AUDIT audit:93 - {"time":"December 30, 2019 3:35:58 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892871888439320","opStatus":"SUCCESS","opTime":"40 ms","table":"partition_mv.p5_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"p5"}}
2019-12-30 11:35:58 AUDIT audit:93 - {"time":"December 30, 2019 3:35:58 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892871864509368","opStatus":"SUCCESS","opTime":"247 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p5"}}
2019-12-30 11:35:58 AUDIT audit:72 - {"time":"December 30, 2019 3:35:58 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892872115016123","opStatus":"START"}
2019-12-30 11:35:58 AUDIT audit:72 - {"time":"December 30, 2019 3:35:58 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892872141715186","opStatus":"START"}
2019-12-30 11:35:58 AUDIT audit:93 - {"time":"December 30, 2019 3:35:58 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892872141715186","opStatus":"SUCCESS","opTime":"43 ms","table":"partition_mv.p6_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"p6"}}
2019-12-30 11:35:58 AUDIT audit:93 - {"time":"December 30, 2019 3:35:58 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892872115016123","opStatus":"SUCCESS","opTime":"295 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p6"}}
2019-12-30 11:35:58 AUDIT audit:72 - {"time":"December 30, 2019 3:35:58 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892872417456411","opStatus":"START"}
2019-12-30 11:35:59 AUDIT audit:93 - {"time":"December 30, 2019 3:35:59 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892872417456411","opStatus":"SUCCESS","opTime":"615 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- check partitioning for child tables with various combinations[0m
2019-12-30 11:35:59 AUDIT audit:72 - {"time":"December 30, 2019 3:35:59 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892873039296175","opStatus":"START"}
2019-12-30 11:35:59 AUDIT audit:93 - {"time":"December 30, 2019 3:35:59 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892873039296175","opStatus":"SUCCESS","opTime":"40 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-30 11:35:59 AUDIT audit:72 - {"time":"December 30, 2019 3:35:59 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892873166642354","opStatus":"START"}
2019-12-30 11:36:00 AUDIT audit:93 - {"time":"December 30, 2019 3:36:00 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892873166642354","opStatus":"SUCCESS","opTime":"290 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-30 11:36:00 AUDIT audit:72 - {"time":"December 30, 2019 3:36:00 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10892873459006324","opStatus":"START"}
2019-12-30 11:36:00 AUDIT audit:93 - {"time":"December 30, 2019 3:36:00 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10892873459006324","opStatus":"SUCCESS","opTime":"4 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-30 11:36:00 AUDIT audit:72 - {"time":"December 30, 2019 3:36:00 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892873466419074","opStatus":"START"}
2019-12-30 11:36:00 AUDIT audit:72 - {"time":"December 30, 2019 3:36:00 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892873485370357","opStatus":"START"}
2019-12-30 11:36:00 AUDIT audit:93 - {"time":"December 30, 2019 3:36:00 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892873485370357","opStatus":"SUCCESS","opTime":"42 ms","table":"partition_mv.dm1_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"dm1"}}
2019-12-30 11:36:00 AUDIT audit:93 - {"time":"December 30, 2019 3:36:00 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892873466419074","opStatus":"SUCCESS","opTime":"217 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
[31m- test partition at last column *** FAILED ***[0m
[31m Results do not match for query:[0m
[31m == Parsed Logical Plan ==[0m
[31m 'Aggregate ['c], ['c, unresolvedalias('sum('b), None)][0m
[31m +- 'UnresolvedRelation `partitionone`[0m
[31m == Analyzed Logical Plan ==[0m
[31m c: int, sum(b): bigint[0m
[31m Aggregate [partitionone_c#49375], [partitionone_c#49375 AS c#49380, sum(sum_b#49376L) AS sum(b)#49381L][0m
[31m +- SubqueryAlias dm1_table[0m
[31m +- Relation[partitionone_c#49375,sum_b#49376L] CarbonDatasourceHadoopRelation[0m
[31m == Optimized Logical Plan ==[0m
[31m CarbonDictionaryCatalystDecoder [partition_mv_dm1_table], ExcludeProfile(ArrayBuffer()), CarbonAliasDecoderRelation(), true[0m
[31m +- Aggregate [partitionone_c#49375], [partitionone_c#49375 AS c#49380, sum(sum_b#49376L) AS sum(b)#49381L][0m
[31m +- Relation[partitionone_c#49375,sum_b#49376L] CarbonDatasourceHadoopRelation[0m
[31m == Physical Plan ==[0m
[31m *HashAggregate(keys=[partitionone_c#49375], functions=[sum(sum_b#49376L)], output=[c#49380, sum(b)#49381L])[0m
[31m +- Exchange hashpartitioning(partitionone_c#49375, 200)[0m
[31m +- *HashAggregate(keys=[partitionone_c#49375], functions=[partial_sum(sum_b#49376L)], output=[partitionone_c#49375, sum#49398L])[0m
[31m +- *FileScan carbondata partition_mv.dm1_table[partitionone_c#49375,sum_b#49376L] ReadSchema: struct<partitionone_c:int,sum_b:bigint>[0m
[31m == Results ==[0m
[31m !== Correct Answer - 1 == == Spark Answer - 0 ==[0m
[31m ![3,2] (QueryTest.scala:90)[0m
2019-12-30 11:36:00 AUDIT audit:72 - {"time":"December 30, 2019 3:36:00 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892874100188015","opStatus":"START"}
2019-12-30 11:36:00 AUDIT audit:93 - {"time":"December 30, 2019 3:36:00 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892874100188015","opStatus":"SUCCESS","opTime":"234 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-30 11:36:00 AUDIT audit:72 - {"time":"December 30, 2019 3:36:00 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892874337763735","opStatus":"START"}
2019-12-30 11:36:00 AUDIT audit:93 - {"time":"December 30, 2019 3:36:00 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892874337763735","opStatus":"SUCCESS","opTime":"40 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-30 11:36:01 AUDIT audit:72 - {"time":"December 30, 2019 3:36:01 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892874468616719","opStatus":"START"}
2019-12-30 11:36:01 AUDIT audit:93 - {"time":"December 30, 2019 3:36:01 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892874468616719","opStatus":"SUCCESS","opTime":"339 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-30 11:36:01 AUDIT audit:72 - {"time":"December 30, 2019 3:36:01 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10892874809473547","opStatus":"START"}
2019-12-30 11:36:01 AUDIT audit:93 - {"time":"December 30, 2019 3:36:01 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10892874809473547","opStatus":"SUCCESS","opTime":"5 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-30 11:36:01 AUDIT audit:72 - {"time":"December 30, 2019 3:36:01 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892874817755331","opStatus":"START"}
2019-12-30 11:36:01 AUDIT audit:72 - {"time":"December 30, 2019 3:36:01 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892874839638505","opStatus":"START"}
2019-12-30 11:36:01 AUDIT audit:93 - {"time":"December 30, 2019 3:36:01 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892874839638505","opStatus":"SUCCESS","opTime":"51 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-30 11:36:01 AUDIT audit:93 - {"time":"December 30, 2019 3:36:01 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892874817755331","opStatus":"SUCCESS","opTime":"243 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"dm1"}}
[31m- test partition on timeseries column *** FAILED ***[0m
[31m 0 did not equal 1 (TestPartitionWithMV.scala:695)[0m
2019-12-30 11:36:02 AUDIT audit:72 - {"time":"December 30, 2019 3:36:02 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892875567142529","opStatus":"START"}
2019-12-30 11:36:02 AUDIT audit:93 - {"time":"December 30, 2019 3:36:02 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892875567142529","opStatus":"SUCCESS","opTime":"2 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-30 11:36:02 AUDIT audit:72 - {"time":"December 30, 2019 3:36:02 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892875568824138","opStatus":"START"}
2019-12-30 11:36:02 AUDIT audit:93 - {"time":"December 30, 2019 3:36:02 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892875568824138","opStatus":"SUCCESS","opTime":"1 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-30 11:36:02 AUDIT audit:72 - {"time":"December 30, 2019 3:36:02 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892875569819267","opStatus":"START"}
2019-12-30 11:36:02 AUDIT audit:93 - {"time":"December 30, 2019 3:36:02 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892875569819267","opStatus":"SUCCESS","opTime":"119 ms","table":"partition_mv.droppartition","extraInfo":{}}
2019-12-30 11:36:02 AUDIT audit:72 - {"time":"December 30, 2019 3:36:02 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892875689472516","opStatus":"START"}
2019-12-30 11:36:02 AUDIT audit:93 - {"time":"December 30, 2019 3:36:02 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892875689472516","opStatus":"SUCCESS","opTime":"161 ms","table":"partition_mv.maintable","extraInfo":{}}
2019-12-30 11:36:02 AUDIT audit:72 - {"time":"December 30, 2019 3:36:02 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892875851284563","opStatus":"START"}
2019-12-30 11:36:02 AUDIT audit:93 - {"time":"December 30, 2019 3:36:02 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892875851284563","opStatus":"SUCCESS","opTime":"55 ms","table":"partition_mv.par","extraInfo":{}}
2019-12-30 11:36:02 AUDIT audit:72 - {"time":"December 30, 2019 3:36:02 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892875907432548","opStatus":"START"}
2019-12-30 11:36:02 AUDIT audit:93 - {"time":"December 30, 2019 3:36:02 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892875907432548","opStatus":"SUCCESS","opTime":"389 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-30 11:36:02 AUDIT audit:72 - {"time":"December 30, 2019 3:36:02 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892876297518944","opStatus":"START"}
2019-12-30 11:36:03 AUDIT audit:93 - {"time":"December 30, 2019 3:36:03 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892876297518944","opStatus":"SUCCESS","opTime":"209 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-30 11:36:03 AUDIT audit:72 - {"time":"December 30, 2019 3:36:03 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892876506906227","opStatus":"START"}
2019-12-30 11:36:03 AUDIT audit:93 - {"time":"December 30, 2019 3:36:03 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892876506906227","opStatus":"SUCCESS","opTime":"150 ms","table":"partition_mv.partitiontable","extraInfo":{}}
2019-12-30 11:36:03 AUDIT audit:72 - {"time":"December 30, 2019 3:36:03 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892876657478715","opStatus":"START"}
2019-12-30 11:36:03 AUDIT audit:93 - {"time":"December 30, 2019 3:36:03 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892876657478715","opStatus":"SUCCESS","opTime":"1 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-30 11:36:03 AUDIT audit:72 - {"time":"December 30, 2019 3:36:03 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892876658706839","opStatus":"START"}
2019-12-30 11:36:03 AUDIT audit:93 - {"time":"December 30, 2019 3:36:03 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892876658706839","opStatus":"SUCCESS","opTime":"207 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
[32mMVTPCDSTestCase:[0m
[33m- test create datamap with tpcds_1_4_testCases case_1 !!! IGNORED !!![0m
[33m- test create datamap with tpcds_1_4_testCases case_3 !!! IGNORED !!![0m
[33m- test create datamap with tpcds_1_4_testCases case_4 !!! IGNORED !!![0m
[33m- test create datamap with tpcds_1_4_testCases case_5 !!! IGNORED !!![0m
[33m- test create datamap with tpcds_1_4_testCases case_6 !!! IGNORED !!![0m
[33m- test create datamap with tpcds_1_4_testCases case_8 !!! IGNORED !!![0m
[33m- test create datamap with tpcds_1_4_testCases case_11 !!! IGNORED !!![0m
[33m- test create datamap with tpcds_1_4_testCases case_15 !!! IGNORED !!![0m
[33m- test create datamap with tpcds_1_4_testCases case_16 !!! IGNORED !!![0m
[36mRun completed in 8 minutes, 39 seconds.[0m
[36mTotal number of tests run: 233[0m
[36mSuites: completed 21, aborted 0[0m
[36mTests: succeeded 213, failed 20, canceled 0, ignored 18, pending 0[0m
[31m*** 20 TESTS FAILED ***[0m
[JENKINS] Recording test results