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:29 UTC
Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Materialized View Core #3940

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

Changes:

[QiangCai] [CARBONATA-3605] Remove global dictionary feature


------------------------------------------
[...truncated 1.15 MB...]
2019-12-30 11:36:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:17 ERROR GlobalSortHelper$:45 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:17 AUDIT audit:93 - {"time":"December 30, 2019 3:36:17 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10892890389529349","opStatus":"SUCCESS","opTime":"928 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-30 11:36:17 AUDIT audit:72 - {"time":"December 30, 2019 3:36:17 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10892891320819696","opStatus":"START"}
2019-12-30 11:36:18 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:18 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:18 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:18 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:18 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:18 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:18 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:18 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:18 ERROR GlobalSortHelper$:45 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:18 AUDIT audit:93 - {"time":"December 30, 2019 3:36:18 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10892891320819696","opStatus":"SUCCESS","opTime":"975 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-30 11:36:18 AUDIT audit:72 - {"time":"December 30, 2019 3:36:18 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10892892299049520","opStatus":"START"}
2019-12-30 11:36:19 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:19 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:19 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:19 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:19 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:19 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:19 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:19 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:19 ERROR GlobalSortHelper$:45 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:19 AUDIT audit:93 - {"time":"December 30, 2019 3:36:19 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10892892299049520","opStatus":"SUCCESS","opTime":"1019 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-30 11:36:19 AUDIT audit:72 - {"time":"December 30, 2019 3:36:19 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10892893320922064","opStatus":"START"}
2019-12-30 11:36:20 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:20 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:20 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:20 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:20 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:20 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:20 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:20 ERROR DataLoadExecutor:55 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:20 ERROR GlobalSortHelper$:45 - Data Load is partially success for table partitionallcompaction
2019-12-30 11:36:20 AUDIT audit:93 - {"time":"December 30, 2019 3:36:20 AM PST","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"10892893320922064","opStatus":"SUCCESS","opTime":"1010 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-30 11:36:20 AUDIT audit:72 - {"time":"December 30, 2019 3:36:20 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10892894334213435","opStatus":"START"}
2019-12-30 11:36:20 AUDIT audit:93 - {"time":"December 30, 2019 3:36:20 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10892894334213435","opStatus":"SUCCESS","opTime":"60 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:36:21 AUDIT audit:72 - {"time":"December 30, 2019 3:36:21 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892894509170980","opStatus":"START"}
2019-12-30 11:36:21 AUDIT audit:93 - {"time":"December 30, 2019 3:36:21 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892894509170980","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-30 11:36:21 AUDIT audit:72 - {"time":"December 30, 2019 3:36:21 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10892894580025709","opStatus":"START"}
2019-12-30 11:36:21 AUDIT audit:93 - {"time":"December 30, 2019 3:36:21 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10892894580025709","opStatus":"SUCCESS","opTime":"4 ms","table":"NA","extraInfo":{"dmName":"ag"}}
2019-12-30 11:36:21 AUDIT audit:72 - {"time":"December 30, 2019 3:36:21 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892894587527062","opStatus":"START"}
2019-12-30 11:36:21 AUDIT audit:72 - {"time":"December 30, 2019 3:36:21 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892894727634126","opStatus":"START"}
2019-12-30 11:36:21 AUDIT audit:93 - {"time":"December 30, 2019 3:36:21 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892894727634126","opStatus":"SUCCESS","opTime":"49 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:36:21 AUDIT audit:93 - {"time":"December 30, 2019 3:36:21 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892894587527062","opStatus":"SUCCESS","opTime":"349 ms","table":"partition_mv.updatetime_8","extraInfo":{"provider":"mv","dmName":"ag"}}
2019-12-30 11:36:21 AUDIT audit:72 - {"time":"December 30, 2019 3:36:21 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892894946241120","opStatus":"START"}
2019-12-30 11:36:21 AUDIT audit:93 - {"time":"December 30, 2019 3:36:21 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892894946241120","opStatus":"SUCCESS","opTime":"424 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-30 11:36:21 AUDIT audit:72 - {"time":"December 30, 2019 3:36:21 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892895379616233","opStatus":"START"}
2019-12-30 11:36:22 AUDIT audit:93 - {"time":"December 30, 2019 3:36:22 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892895379616233","opStatus":"SUCCESS","opTime":"342 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-30 11:36:22 AUDIT audit:72 - {"time":"December 30, 2019 3:36:22 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892895729530356","opStatus":"START"}
2019-12-30 11:36:22 AUDIT audit:93 - {"time":"December 30, 2019 3:36:22 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892895729530356","opStatus":"SUCCESS","opTime":"282 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-30 11:36:22 AUDIT audit:72 - {"time":"December 30, 2019 3:36:22 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892896019863051","opStatus":"START"}
2019-12-30 11:36:22 AUDIT audit:93 - {"time":"December 30, 2019 3:36:22 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892896019863051","opStatus":"SUCCESS","opTime":"276 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-30 11:36:22 AUDIT audit:72 - {"time":"December 30, 2019 3:36:22 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892896304072086","opStatus":"START"}
2019-12-30 11:36:23 AUDIT audit:93 - {"time":"December 30, 2019 3:36:23 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892896304072086","opStatus":"SUCCESS","opTime":"266 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-30 11:36:23 AUDIT audit:72 - {"time":"December 30, 2019 3:36:23 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892896578514163","opStatus":"START"}
2019-12-30 11:36:23 AUDIT audit:93 - {"time":"December 30, 2019 3:36:23 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892896578514163","opStatus":"SUCCESS","opTime":"267 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-30 11:36:23 AUDIT audit:72 - {"time":"December 30, 2019 3:36:23 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892896854445441","opStatus":"START"}
2019-12-30 11:36:23 AUDIT audit:93 - {"time":"December 30, 2019 3:36:23 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892896854445441","opStatus":"SUCCESS","opTime":"313 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-30 11:36:23 AUDIT audit:72 - {"time":"December 30, 2019 3:36:23 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892897175785808","opStatus":"START"}
2019-12-30 11:36:24 AUDIT audit:93 - {"time":"December 30, 2019 3:36:24 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892897175785808","opStatus":"SUCCESS","opTime":"283 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-30 11:36:24 AUDIT audit:72 - {"time":"December 30, 2019 3:36:24 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10892897460335796","opStatus":"START"}
2019-12-30 11:36:24 AUDIT audit:93 - {"time":"December 30, 2019 3:36:24 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10892897460335796","opStatus":"SUCCESS","opTime":"21 ms","table":"partition_mv.updatetime_8","extraInfo":{}}
2019-12-30 11:36:24 AUDIT audit:72 - {"time":"December 30, 2019 3:36:24 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10892897487818368","opStatus":"START"}
2019-12-30 11:36:24 AUDIT audit:93 - {"time":"December 30, 2019 3:36:24 AM PST","username":"jenkins","opName":"ALTER TABLE COMPACTION MINOR","opId":"10892897487818368","opStatus":"SUCCESS","opTime":"20 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:36:24 AUDIT audit:72 - {"time":"December 30, 2019 3:36:24 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892898026383366","opStatus":"START"}
2019-12-30 11:36:24 AUDIT audit:93 - {"time":"December 30, 2019 3:36:24 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892898026383366","opStatus":"SUCCESS","opTime":"327 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-30 11:36:24 AUDIT audit:72 - {"time":"December 30, 2019 3:36:24 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892898357238180","opStatus":"START"}
2019-12-30 11:36:24 AUDIT audit:93 - {"time":"December 30, 2019 3:36:24 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892898357238180","opStatus":"SUCCESS","opTime":"59 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-30 11:36:24 AUDIT audit:72 - {"time":"December 30, 2019 3:36:24 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892898420456485","opStatus":"START"}
2019-12-30 11:36:25 AUDIT audit:72 - {"time":"December 30, 2019 3:36:25 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892898563137454","opStatus":"START"}
2019-12-30 11:36:25 AUDIT audit:93 - {"time":"December 30, 2019 3:36:25 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892898563137454","opStatus":"SUCCESS","opTime":"48 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:36:25 AUDIT audit:93 - {"time":"December 30, 2019 3:36:25 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892898420456485","opStatus":"SUCCESS","opTime":"360 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p7"}}
2019-12-30 11:36:25 AUDIT audit:72 - {"time":"December 30, 2019 3:36:25 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892898783471574","opStatus":"START"}
2019-12-30 11:36:25 AUDIT audit:72 - {"time":"December 30, 2019 3:36:25 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892898802643428","opStatus":"START"}
2019-12-30 11:36:25 AUDIT audit:93 - {"time":"December 30, 2019 3:36:25 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892898802643428","opStatus":"SUCCESS","opTime":"44 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:36:25 AUDIT audit:93 - {"time":"December 30, 2019 3:36:25 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892898783471574","opStatus":"SUCCESS","opTime":"214 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p1"}}
2019-12-30 11:36:25 AUDIT audit:72 - {"time":"December 30, 2019 3:36:25 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892899000791311","opStatus":"START"}
2019-12-30 11:36:25 AUDIT audit:72 - {"time":"December 30, 2019 3:36:25 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892899021166813","opStatus":"START"}
2019-12-30 11:36:25 AUDIT audit:93 - {"time":"December 30, 2019 3:36:25 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892899021166813","opStatus":"SUCCESS","opTime":"43 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:36:25 AUDIT audit:93 - {"time":"December 30, 2019 3:36:25 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892899000791311","opStatus":"SUCCESS","opTime":"218 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p2"}}
2019-12-30 11:36:25 AUDIT audit:72 - {"time":"December 30, 2019 3:36:25 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892899222916110","opStatus":"START"}
2019-12-30 11:36:25 AUDIT audit:72 - {"time":"December 30, 2019 3:36:25 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892899245986633","opStatus":"START"}
2019-12-30 11:36:25 AUDIT audit:93 - {"time":"December 30, 2019 3:36:25 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892899245986633","opStatus":"SUCCESS","opTime":"47 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:36:26 AUDIT audit:93 - {"time":"December 30, 2019 3:36:26 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892899222916110","opStatus":"SUCCESS","opTime":"227 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p3"}}
2019-12-30 11:36:26 AUDIT audit:72 - {"time":"December 30, 2019 3:36:26 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892899454639545","opStatus":"START"}
2019-12-30 11:36:26 AUDIT audit:72 - {"time":"December 30, 2019 3:36:26 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892899478942982","opStatus":"START"}
2019-12-30 11:36:26 AUDIT audit:93 - {"time":"December 30, 2019 3:36:26 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892899478942982","opStatus":"SUCCESS","opTime":"45 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:36:26 AUDIT audit:93 - {"time":"December 30, 2019 3:36:26 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892899454639545","opStatus":"SUCCESS","opTime":"230 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p4"}}
2019-12-30 11:36:26 AUDIT audit:72 - {"time":"December 30, 2019 3:36:26 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892899688473437","opStatus":"START"}
2019-12-30 11:36:26 AUDIT audit:72 - {"time":"December 30, 2019 3:36:26 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892899711942007","opStatus":"START"}
2019-12-30 11:36:26 AUDIT audit:93 - {"time":"December 30, 2019 3:36:26 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892899711942007","opStatus":"SUCCESS","opTime":"97 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:36:26 AUDIT audit:93 - {"time":"December 30, 2019 3:36:26 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892899688473437","opStatus":"SUCCESS","opTime":"298 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p5"}}
2019-12-30 11:36:26 AUDIT audit:72 - {"time":"December 30, 2019 3:36:26 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892899990596060","opStatus":"START"}
2019-12-30 11:36:26 AUDIT audit:72 - {"time":"December 30, 2019 3:36:26 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892900016330664","opStatus":"START"}
2019-12-30 11:36:26 AUDIT audit:93 - {"time":"December 30, 2019 3:36:26 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892900016330664","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:36:26 AUDIT audit:93 - {"time":"December 30, 2019 3:36:26 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892899990596060","opStatus":"SUCCESS","opTime":"245 ms","table":"partition_mv.partitionone","extraInfo":{"provider":"mv","dmName":"p6"}}
2019-12-30 11:36:26 AUDIT audit:72 - {"time":"December 30, 2019 3:36:26 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892900247797695","opStatus":"START"}
2019-12-30 11:36:27 AUDIT audit:93 - {"time":"December 30, 2019 3:36:27 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892900247797695","opStatus":"SUCCESS","opTime":"637 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- check partitioning for child tables with various combinations[0m
2019-12-30 11:36:27 AUDIT audit:72 - {"time":"December 30, 2019 3:36:27 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892900889667623","opStatus":"START"}
2019-12-30 11:36:27 AUDIT audit:93 - {"time":"December 30, 2019 3:36:27 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892900889667623","opStatus":"SUCCESS","opTime":"68 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-30 11:36:27 AUDIT audit:72 - {"time":"December 30, 2019 3:36:27 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892901035083745","opStatus":"START"}
2019-12-30 11:36:27 AUDIT audit:93 - {"time":"December 30, 2019 3:36:27 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892901035083745","opStatus":"SUCCESS","opTime":"267 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-30 11:36:27 AUDIT audit:72 - {"time":"December 30, 2019 3:36:27 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10892901303348335","opStatus":"START"}
2019-12-30 11:36:27 AUDIT audit:93 - {"time":"December 30, 2019 3:36:27 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10892901303348335","opStatus":"SUCCESS","opTime":"4 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-30 11:36:27 AUDIT audit:72 - {"time":"December 30, 2019 3:36:27 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892901309885161","opStatus":"START"}
2019-12-30 11:36:27 AUDIT audit:72 - {"time":"December 30, 2019 3:36:27 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892901325395523","opStatus":"START"}
2019-12-30 11:36:27 AUDIT audit:93 - {"time":"December 30, 2019 3:36:27 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892901325395523","opStatus":"SUCCESS","opTime":"41 ms","table":"partition_mv.dm1_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"dm1"}}
2019-12-30 11:36:28 AUDIT audit:93 - {"time":"December 30, 2019 3:36:28 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892901309885161","opStatus":"SUCCESS","opTime":"216 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:28 AUDIT audit:72 - {"time":"December 30, 2019 3:36:28 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892901956993791","opStatus":"START"}
2019-12-30 11:36:28 AUDIT audit:93 - {"time":"December 30, 2019 3:36:28 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892901956993791","opStatus":"SUCCESS","opTime":"219 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-30 11:36:28 AUDIT audit:72 - {"time":"December 30, 2019 3:36:28 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892902178188578","opStatus":"START"}
2019-12-30 11:36:28 AUDIT audit:93 - {"time":"December 30, 2019 3:36:28 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892902178188578","opStatus":"SUCCESS","opTime":"54 ms","table":"partition_mv.partitionone","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-12-30 11:36:28 AUDIT audit:72 - {"time":"December 30, 2019 3:36:28 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892902327167460","opStatus":"START"}
2019-12-30 11:36:29 AUDIT audit:93 - {"time":"December 30, 2019 3:36:29 AM PST","username":"jenkins","opName":"INSERT INTO","opId":"10892902327167460","opStatus":"SUCCESS","opTime":"364 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-30 11:36:29 AUDIT audit:72 - {"time":"December 30, 2019 3:36:29 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10892902693828831","opStatus":"START"}
2019-12-30 11:36:29 AUDIT audit:93 - {"time":"December 30, 2019 3:36:29 AM PST","username":"jenkins","opName":"DROP DATAMAP","opId":"10892902693828831","opStatus":"SUCCESS","opTime":"4 ms","table":"NA","extraInfo":{"dmName":"dm1"}}
2019-12-30 11:36:29 AUDIT audit:72 - {"time":"December 30, 2019 3:36:29 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892902701996036","opStatus":"START"}
2019-12-30 11:36:29 AUDIT audit:72 - {"time":"December 30, 2019 3:36:29 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892902722999072","opStatus":"START"}
2019-12-30 11:36:29 AUDIT audit:93 - {"time":"December 30, 2019 3:36:29 AM PST","username":"jenkins","opName":"CREATE TABLE","opId":"10892902722999072","opStatus":"SUCCESS","opTime":"50 ms","table":"partition_mv.dm1_table","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","parent_tables":"partitionone","sort_columns":"","comment":"","_internal.deferred.rebuild":"false","carbon.column.compressor":"snappy","datamap_name":"dm1"}}
2019-12-30 11:36:29 AUDIT audit:93 - {"time":"December 30, 2019 3:36:29 AM PST","username":"jenkins","opName":"CREATE DATAMAP","opId":"10892902701996036","opStatus":"SUCCESS","opTime":"225 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:30 AUDIT audit:72 - {"time":"December 30, 2019 3:36:30 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892903451781882","opStatus":"START"}
2019-12-30 11:36:30 AUDIT audit:93 - {"time":"December 30, 2019 3:36:30 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892903451781882","opStatus":"SUCCESS","opTime":"2 ms","table":"partition_mv.ag_table","extraInfo":{}}
2019-12-30 11:36:30 AUDIT audit:72 - {"time":"December 30, 2019 3:36:30 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892903454049222","opStatus":"START"}
2019-12-30 11:36:30 AUDIT audit:93 - {"time":"December 30, 2019 3:36:30 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892903454049222","opStatus":"SUCCESS","opTime":"2 ms","table":"partition_mv.dm1_table","extraInfo":{}}
2019-12-30 11:36:30 AUDIT audit:72 - {"time":"December 30, 2019 3:36:30 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892903455742658","opStatus":"START"}
2019-12-30 11:36:30 AUDIT audit:93 - {"time":"December 30, 2019 3:36:30 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892903455742658","opStatus":"SUCCESS","opTime":"119 ms","table":"partition_mv.droppartition","extraInfo":{}}
2019-12-30 11:36:30 AUDIT audit:72 - {"time":"December 30, 2019 3:36:30 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892903575173321","opStatus":"START"}
2019-12-30 11:36:30 AUDIT audit:93 - {"time":"December 30, 2019 3:36:30 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892903575173321","opStatus":"SUCCESS","opTime":"139 ms","table":"partition_mv.maintable","extraInfo":{}}
2019-12-30 11:36:30 AUDIT audit:72 - {"time":"December 30, 2019 3:36:30 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892903714529665","opStatus":"START"}
2019-12-30 11:36:30 AUDIT audit:93 - {"time":"December 30, 2019 3:36:30 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892903714529665","opStatus":"SUCCESS","opTime":"55 ms","table":"partition_mv.par","extraInfo":{}}
2019-12-30 11:36:30 AUDIT audit:72 - {"time":"December 30, 2019 3:36:30 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892903769722268","opStatus":"START"}
2019-12-30 11:36:30 AUDIT audit:93 - {"time":"December 30, 2019 3:36:30 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892903769722268","opStatus":"SUCCESS","opTime":"388 ms","table":"partition_mv.partitionallcompaction","extraInfo":{}}
2019-12-30 11:36:30 AUDIT audit:72 - {"time":"December 30, 2019 3:36:30 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892904157671227","opStatus":"START"}
2019-12-30 11:36:30 AUDIT audit:93 - {"time":"December 30, 2019 3:36:30 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892904157671227","opStatus":"SUCCESS","opTime":"184 ms","table":"partition_mv.partitionone","extraInfo":{}}
2019-12-30 11:36:30 AUDIT audit:72 - {"time":"December 30, 2019 3:36:30 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892904342397585","opStatus":"START"}
2019-12-30 11:36:31 AUDIT audit:93 - {"time":"December 30, 2019 3:36:31 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892904342397585","opStatus":"SUCCESS","opTime":"208 ms","table":"partition_mv.partitiontable","extraInfo":{}}
2019-12-30 11:36:31 AUDIT audit:72 - {"time":"December 30, 2019 3:36:31 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892904550701702","opStatus":"START"}
2019-12-30 11:36:31 AUDIT audit:93 - {"time":"December 30, 2019 3:36:31 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892904550701702","opStatus":"SUCCESS","opTime":"1 ms","table":"partition_mv.sensor_1_table","extraInfo":{}}
2019-12-30 11:36:31 AUDIT audit:72 - {"time":"December 30, 2019 3:36:31 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892904551803833","opStatus":"START"}
2019-12-30 11:36:31 AUDIT audit:93 - {"time":"December 30, 2019 3:36:31 AM PST","username":"jenkins","opName":"DROP TABLE","opId":"10892904551803833","opStatus":"SUCCESS","opTime":"220 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, 42 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