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 2020/04/24 07:43:19 UTC
Build failed in Jenkins: carbondata-master-spark-2.3 » Apache CarbonData :: Materialized View Core #2211
See <https://builds.apache.org/job/carbondata-master-spark-2.3/org.apache.carbondata$carbondata-mv-core/2211/display/redirect>
Changes:
------------------------------------------
[...truncated 1.54 MB...]
2020-04-24 07:42:14 AUDIT audit:97 - {"time":"April 24, 2020 12:42:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857272411220443","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-24 07:42:14 AUDIT audit:74 - {"time":"April 24, 2020 12:42:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857272415914964","opStatus":"START"}
2020-04-24 07:42:14 AUDIT audit:97 - {"time":"April 24, 2020 12:42:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857272415914964","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-24 07:42:14 AUDIT audit:74 - {"time":"April 24, 2020 12:42:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857272420703655","opStatus":"START"}
2020-04-24 07:42:14 AUDIT audit:97 - {"time":"April 24, 2020 12:42:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857272420703655","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-24 07:42:14 AUDIT audit:74 - {"time":"April 24, 2020 12:42:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857272425457032","opStatus":"START"}
2020-04-24 07:42:14 AUDIT audit:97 - {"time":"April 24, 2020 12:42:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857272425457032","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-24 07:42:14 AUDIT audit:74 - {"time":"April 24, 2020 12:42:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857272440411615","opStatus":"START"}
2020-04-24 07:42:14 AUDIT audit:97 - {"time":"April 24, 2020 12:42:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857272440411615","opStatus":"SUCCESS","opTime":"73 ms","table":"NA","extraInfo":{}}
2020-04-24 07:42:14 AUDIT audit:74 - {"time":"April 24, 2020 12:42:14 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6857272516419995","opStatus":"START"}
2020-04-24 07:42:14 AUDIT audit:74 - {"time":"April 24, 2020 12:42:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857272550759358","opStatus":"START"}
2020-04-24 07:42:14 AUDIT audit:74 - {"time":"April 24, 2020 12:42:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857272560487587","opStatus":"START"}
2020-04-24 07:42:14 AUDIT audit:97 - {"time":"April 24, 2020 12:42:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857272560487587","opStatus":"SUCCESS","opTime":"41 ms","table":"NA","extraInfo":{}}
2020-04-24 07:42:14 AUDIT audit:97 - {"time":"April 24, 2020 12:42:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857272550759358","opStatus":"SUCCESS","opTime":"54 ms","table":"partition_mv.p7","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 07:42:14 AUDIT audit:97 - {"time":"April 24, 2020 12:42:14 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6857272516419995","opStatus":"SUCCESS","opTime":"252 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-24 07:42:14 AUDIT audit:74 - {"time":"April 24, 2020 12:42:14 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6857272774954931","opStatus":"START"}
2020-04-24 07:42:14 AUDIT audit:74 - {"time":"April 24, 2020 12:42:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857272798040609","opStatus":"START"}
2020-04-24 07:42:14 AUDIT audit:74 - {"time":"April 24, 2020 12:42:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857272804817032","opStatus":"START"}
2020-04-24 07:42:15 AUDIT audit:97 - {"time":"April 24, 2020 12:42:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857272804817032","opStatus":"SUCCESS","opTime":"32 ms","table":"NA","extraInfo":{}}
2020-04-24 07:42:15 AUDIT audit:97 - {"time":"April 24, 2020 12:42:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857272798040609","opStatus":"SUCCESS","opTime":"42 ms","table":"partition_mv.p1","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 07:42:15 AUDIT audit:97 - {"time":"April 24, 2020 12:42:15 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6857272774954931","opStatus":"SUCCESS","opTime":"222 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-24 07:42:15 AUDIT audit:74 - {"time":"April 24, 2020 12:42:15 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6857273002057237","opStatus":"START"}
2020-04-24 07:42:15 AUDIT audit:74 - {"time":"April 24, 2020 12:42:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857273024945128","opStatus":"START"}
2020-04-24 07:42:15 AUDIT audit:74 - {"time":"April 24, 2020 12:42:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857273032858382","opStatus":"START"}
2020-04-24 07:42:15 AUDIT audit:97 - {"time":"April 24, 2020 12:42:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857273032858382","opStatus":"SUCCESS","opTime":"71 ms","table":"NA","extraInfo":{}}
2020-04-24 07:42:15 AUDIT audit:97 - {"time":"April 24, 2020 12:42:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857273024945128","opStatus":"SUCCESS","opTime":"82 ms","table":"partition_mv.p2","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 07:42:15 AUDIT audit:97 - {"time":"April 24, 2020 12:42:15 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6857273002057237","opStatus":"SUCCESS","opTime":"280 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-24 07:42:15 AUDIT audit:74 - {"time":"April 24, 2020 12:42:15 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6857273287396025","opStatus":"START"}
2020-04-24 07:42:15 AUDIT audit:74 - {"time":"April 24, 2020 12:42:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857273312236827","opStatus":"START"}
2020-04-24 07:42:15 AUDIT audit:74 - {"time":"April 24, 2020 12:42:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857273319243831","opStatus":"START"}
2020-04-24 07:42:15 AUDIT audit:97 - {"time":"April 24, 2020 12:42:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857273319243831","opStatus":"SUCCESS","opTime":"44 ms","table":"NA","extraInfo":{}}
2020-04-24 07:42:15 AUDIT audit:97 - {"time":"April 24, 2020 12:42:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857273312236827","opStatus":"SUCCESS","opTime":"53 ms","table":"partition_mv.p3","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 07:42:15 AUDIT audit:97 - {"time":"April 24, 2020 12:42:15 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6857273287396025","opStatus":"SUCCESS","opTime":"257 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-24 07:42:15 AUDIT audit:74 - {"time":"April 24, 2020 12:42:15 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6857273549543270","opStatus":"START"}
2020-04-24 07:42:15 AUDIT audit:74 - {"time":"April 24, 2020 12:42:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857273574085428","opStatus":"START"}
2020-04-24 07:42:15 AUDIT audit:74 - {"time":"April 24, 2020 12:42:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857273581137241","opStatus":"START"}
2020-04-24 07:42:15 AUDIT audit:97 - {"time":"April 24, 2020 12:42:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857273581137241","opStatus":"SUCCESS","opTime":"48 ms","table":"NA","extraInfo":{}}
2020-04-24 07:42:15 AUDIT audit:97 - {"time":"April 24, 2020 12:42:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857273574085428","opStatus":"SUCCESS","opTime":"58 ms","table":"partition_mv.p4","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 07:42:15 AUDIT audit:97 - {"time":"April 24, 2020 12:42:15 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6857273549543270","opStatus":"SUCCESS","opTime":"267 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-24 07:42:15 AUDIT audit:74 - {"time":"April 24, 2020 12:42:15 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6857273823144417","opStatus":"START"}
2020-04-24 07:42:16 AUDIT audit:74 - {"time":"April 24, 2020 12:42:16 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857273848531171","opStatus":"START"}
2020-04-24 07:42:16 AUDIT audit:74 - {"time":"April 24, 2020 12:42:16 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857273855345581","opStatus":"START"}
2020-04-24 07:42:16 AUDIT audit:97 - {"time":"April 24, 2020 12:42:16 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857273855345581","opStatus":"SUCCESS","opTime":"45 ms","table":"NA","extraInfo":{}}
2020-04-24 07:42:16 AUDIT audit:97 - {"time":"April 24, 2020 12:42:16 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857273848531171","opStatus":"SUCCESS","opTime":"53 ms","table":"partition_mv.p5","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 07:42:16 AUDIT audit:97 - {"time":"April 24, 2020 12:42:16 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6857273823144417","opStatus":"SUCCESS","opTime":"237 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-24 07:42:16 AUDIT audit:74 - {"time":"April 24, 2020 12:42:16 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6857274066478325","opStatus":"START"}
2020-04-24 07:42:16 AUDIT audit:74 - {"time":"April 24, 2020 12:42:16 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857274092642616","opStatus":"START"}
2020-04-24 07:42:16 AUDIT audit:74 - {"time":"April 24, 2020 12:42:16 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857274099565074","opStatus":"START"}
2020-04-24 07:42:16 AUDIT audit:97 - {"time":"April 24, 2020 12:42:16 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857274099565074","opStatus":"SUCCESS","opTime":"33 ms","table":"NA","extraInfo":{}}
2020-04-24 07:42:16 AUDIT audit:97 - {"time":"April 24, 2020 12:42:16 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857274092642616","opStatus":"SUCCESS","opTime":"43 ms","table":"partition_mv.p6","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 07:42:16 AUDIT audit:97 - {"time":"April 24, 2020 12:42:16 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6857274066478325","opStatus":"SUCCESS","opTime":"234 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-24 07:42:16 AUDIT audit:74 - {"time":"April 24, 2020 12:42:16 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6857274457212087","opStatus":"START"}
2020-04-24 07:42:17 AUDIT audit:97 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6857274457212087","opStatus":"SUCCESS","opTime":"525 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- check partitioning for child tables with various combinations[0m
2020-04-24 07:42:17 AUDIT audit:74 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857274996577379","opStatus":"START"}
2020-04-24 07:42:17 AUDIT audit:97 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857274996577379","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-24 07:42:17 AUDIT audit:74 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857275001328477","opStatus":"START"}
2020-04-24 07:42:17 AUDIT audit:97 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857275001328477","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-24 07:42:17 AUDIT audit:74 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857275005873375","opStatus":"START"}
2020-04-24 07:42:17 AUDIT audit:97 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857275005873375","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-24 07:42:17 AUDIT audit:74 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857275010424053","opStatus":"START"}
2020-04-24 07:42:17 AUDIT audit:97 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857275010424053","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-24 07:42:17 AUDIT audit:74 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857275014989937","opStatus":"START"}
2020-04-24 07:42:17 AUDIT audit:97 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857275014989937","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-24 07:42:17 AUDIT audit:74 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857275019574616","opStatus":"START"}
2020-04-24 07:42:17 AUDIT audit:97 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857275019574616","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-24 07:42:17 AUDIT audit:74 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857275024224588","opStatus":"START"}
2020-04-24 07:42:17 AUDIT audit:97 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857275024224588","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-24 07:42:17 AUDIT audit:74 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857275028932317","opStatus":"START"}
2020-04-24 07:42:17 AUDIT audit:97 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857275028932317","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag1"}}
2020-04-24 07:42:17 AUDIT audit:74 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857275033496284","opStatus":"START"}
2020-04-24 07:42:17 AUDIT audit:97 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857275033496284","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-24 07:42:17 AUDIT audit:74 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857275038015954","opStatus":"START"}
2020-04-24 07:42:17 AUDIT audit:97 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857275038015954","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-24 07:42:17 AUDIT audit:74 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857275042607470","opStatus":"START"}
2020-04-24 07:42:17 AUDIT audit:97 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857275042607470","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-24 07:42:17 AUDIT audit:74 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857275047116703","opStatus":"START"}
2020-04-24 07:42:17 AUDIT audit:97 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857275047116703","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-24 07:42:17 AUDIT audit:74 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857275060966373","opStatus":"START"}
2020-04-24 07:42:17 AUDIT audit:97 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857275060966373","opStatus":"SUCCESS","opTime":"65 ms","table":"NA","extraInfo":{}}
2020-04-24 07:42:17 AUDIT audit:74 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6857275207790281","opStatus":"START"}
2020-04-24 07:42:17 AUDIT audit:97 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6857275207790281","opStatus":"SUCCESS","opTime":"364 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-24 07:42:17 AUDIT audit:74 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857275573805062","opStatus":"START"}
2020-04-24 07:42:17 AUDIT audit:97 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857275573805062","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-24 07:42:17 AUDIT audit:74 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6857275579237790","opStatus":"START"}
2020-04-24 07:42:17 AUDIT audit:74 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857275600536341","opStatus":"START"}
2020-04-24 07:42:17 AUDIT audit:74 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857275607196146","opStatus":"START"}
2020-04-24 07:42:17 AUDIT audit:97 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857275607196146","opStatus":"SUCCESS","opTime":"35 ms","table":"NA","extraInfo":{}}
2020-04-24 07:42:17 AUDIT audit:97 - {"time":"April 24, 2020 12:42:17 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857275600536341","opStatus":"SUCCESS","opTime":"44 ms","table":"partition_mv.dm1","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 07:42:18 AUDIT audit:74 - {"time":"April 24, 2020 12:42:18 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6857275837554741","opStatus":"START"}
2020-04-24 07:42:20 AUDIT audit:97 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6857275837554741","opStatus":"SUCCESS","opTime":"2011 ms","table":"partition_mv.dm1","extraInfo":{}}
2020-04-24 07:42:20 AUDIT audit:97 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6857275579237790","opStatus":"SUCCESS","opTime":"2268 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-24 07:42:20 AUDIT audit:74 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6857278388994012","opStatus":"START"}
2020-04-24 07:42:20 AUDIT audit:97 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6857278388994012","opStatus":"SUCCESS","opTime":"179 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- test partition at last column[0m
2020-04-24 07:42:20 AUDIT audit:74 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857278580182994","opStatus":"START"}
2020-04-24 07:42:20 AUDIT audit:97 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857278580182994","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-24 07:42:20 AUDIT audit:74 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857278584952264","opStatus":"START"}
2020-04-24 07:42:20 AUDIT audit:97 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857278584952264","opStatus":"SUCCESS","opTime":"92 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-24 07:42:20 AUDIT audit:74 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857278682099950","opStatus":"START"}
2020-04-24 07:42:20 AUDIT audit:97 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857278682099950","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-24 07:42:20 AUDIT audit:74 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857278687416410","opStatus":"START"}
2020-04-24 07:42:20 AUDIT audit:97 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857278687416410","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-24 07:42:20 AUDIT audit:74 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857278692336632","opStatus":"START"}
2020-04-24 07:42:20 AUDIT audit:97 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857278692336632","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-24 07:42:20 AUDIT audit:74 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857278697236916","opStatus":"START"}
2020-04-24 07:42:20 AUDIT audit:97 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857278697236916","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-24 07:42:20 AUDIT audit:74 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857278702061767","opStatus":"START"}
2020-04-24 07:42:20 AUDIT audit:97 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857278702061767","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-24 07:42:20 AUDIT audit:74 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857278706855051","opStatus":"START"}
2020-04-24 07:42:20 AUDIT audit:97 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857278706855051","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag1"}}
2020-04-24 07:42:20 AUDIT audit:74 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857278711720945","opStatus":"START"}
2020-04-24 07:42:20 AUDIT audit:97 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857278711720945","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-24 07:42:20 AUDIT audit:74 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857278716585791","opStatus":"START"}
2020-04-24 07:42:20 AUDIT audit:97 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857278716585791","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-24 07:42:20 AUDIT audit:74 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857278721459077","opStatus":"START"}
2020-04-24 07:42:20 AUDIT audit:97 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857278721459077","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-24 07:42:20 AUDIT audit:74 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857278726852159","opStatus":"START"}
2020-04-24 07:42:20 AUDIT audit:97 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857278726852159","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-24 07:42:20 AUDIT audit:74 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857278742534533","opStatus":"START"}
2020-04-24 07:42:20 AUDIT audit:97 - {"time":"April 24, 2020 12:42:20 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857278742534533","opStatus":"SUCCESS","opTime":"38 ms","table":"NA","extraInfo":{}}
2020-04-24 07:42:21 AUDIT audit:74 - {"time":"April 24, 2020 12:42:21 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6857278865739858","opStatus":"START"}
2020-04-24 07:42:21 AUDIT audit:97 - {"time":"April 24, 2020 12:42:21 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6857278865739858","opStatus":"SUCCESS","opTime":"369 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-24 07:42:21 AUDIT audit:74 - {"time":"April 24, 2020 12:42:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857279236471918","opStatus":"START"}
2020-04-24 07:42:21 AUDIT audit:97 - {"time":"April 24, 2020 12:42:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857279236471918","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-24 07:42:21 AUDIT audit:74 - {"time":"April 24, 2020 12:42:21 AM PDT","username":"jenkins","opName":"DESC FORMATTED","opId":"6857279324837871","opStatus":"START"}
2020-04-24 07:42:21 ERROR CarbonUtil:2444 - Unable to unlock Table lock for table during table status updation
2020-04-24 07:42:21 AUDIT audit:97 - {"time":"April 24, 2020 12:42:21 AM PDT","username":"jenkins","opName":"DESC FORMATTED","opId":"6857279324837871","opStatus":"SUCCESS","opTime":"38 ms","table":"partition_mv.partitionone","extraInfo":{}}
+-----------------------------+-----------------------------------------------------------------------------------------------------------------------+-------+
|col_name |data_type |comment|
+-----------------------------+-----------------------------------------------------------------------------------------------------------------------+-------+
|a |int |null |
|b |int |null |
|c |timestamp |null |
|d |timestamp |null |
| | | |
|## Detailed Table Information| | |
|Database |partition_mv | |
|Table |partitionone | |
|Owner |jenkins | |
|Created |Fri Apr 24 00:42:20 PDT 2020 | |
|Location |<https://builds.apache.org/job/carbondata-master-spark-2.3/org.apache.carbondata$carbondata-mv-core/ws/target/warehouse/partition_mv.db/partitionone|> |
|External |false | |
|Transactional |true | |
|Streaming |false | |
|Table Block Size |1024 MB | |
|Table Blocklet Size |64 MB | |
|Comment | | |
|Bad Record Path | | |
|Min Input Per Node Per Load |0.0B | |
| | | |
|## Index Information | | |
|Sort Scope |NO_SORT | |
|Sort Columns | | |
|Inverted Index Columns | | |
|Cached Min/Max Index Columns |All columns | |
|Min/Max Index Cache Level |BLOCK | |
|Table page size in mb | | |
| | | |
|## Encoding Information | | |
|Local Dictionary Enabled |true | |
|Local Dictionary Threshold |10000 | |
|Local Dictionary Include | | |
| | | |
|## Compaction Information | | |
|MAJOR_COMPACTION_SIZE |1024 | |
|AUTO_LOAD_MERGE |false | |
|COMPACTION_LEVEL_THRESHOLD |4,3 | |
|COMPACTION_PRESERVE_SEGMENTS |0 | |
|ALLOWED_COMPACTION_DAYS |0 | |
| | | |
|## Partition Information | | |
|Partition Type |NATIVE_HIVE | |
|Partition Columns |c:TIMESTAMP, d:TIMESTAMP | |
|Number of Partitions |1 | |
| | | |
|## Dynamic Information | | |
|Table Data Size |1.10KB | |
|Table Index Size |705.0B | |
|Last Update |Fri Apr 24 00:42:21 PDT 2020 | |
+-----------------------------+-----------------------------------------------------------------------------------------------------------------------+-------+
2020-04-24 07:42:21 AUDIT audit:74 - {"time":"April 24, 2020 12:42:21 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6857279409713811","opStatus":"START"}
2020-04-24 07:42:21 AUDIT audit:74 - {"time":"April 24, 2020 12:42:21 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857279434200592","opStatus":"START"}
2020-04-24 07:42:21 AUDIT audit:74 - {"time":"April 24, 2020 12:42:21 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857279440837498","opStatus":"START"}
2020-04-24 07:42:21 AUDIT audit:97 - {"time":"April 24, 2020 12:42:21 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857279440837498","opStatus":"SUCCESS","opTime":"30 ms","table":"NA","extraInfo":{}}
2020-04-24 07:42:21 AUDIT audit:97 - {"time":"April 24, 2020 12:42:21 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857279434200592","opStatus":"SUCCESS","opTime":"39 ms","table":"partition_mv.dm1","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 07:42:21 AUDIT audit:74 - {"time":"April 24, 2020 12:42:21 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6857279631913620","opStatus":"START"}
2020-04-24 07:42:22 AUDIT audit:97 - {"time":"April 24, 2020 12:42:22 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6857279631913620","opStatus":"SUCCESS","opTime":"764 ms","table":"partition_mv.dm1","extraInfo":{"SegmentId":"0","DataSize":"688.0B","IndexSize":"454.0B"}}
2020-04-24 07:42:22 AUDIT audit:97 - {"time":"April 24, 2020 12:42:22 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6857279409713811","opStatus":"SUCCESS","opTime":"985 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-24 07:42:23 AUDIT audit:74 - {"time":"April 24, 2020 12:42:23 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6857280915632400","opStatus":"START"}
2020-04-24 07:42:23 AUDIT audit:97 - {"time":"April 24, 2020 12:42:23 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6857280915632400","opStatus":"SUCCESS","opTime":"176 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-24 07:42:23 AUDIT audit:74 - {"time":"April 24, 2020 12:42:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857281097825604","opStatus":"START"}
2020-04-24 07:42:23 AUDIT audit:97 - {"time":"April 24, 2020 12:42:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857281097825604","opStatus":"SUCCESS","opTime":"40 ms","table":"NA","extraInfo":{}}
2020-04-24 07:42:23 AUDIT audit:74 - {"time":"April 24, 2020 12:42:23 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6857281215055520","opStatus":"START"}
2020-04-24 07:42:23 AUDIT audit:97 - {"time":"April 24, 2020 12:42:23 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6857281215055520","opStatus":"SUCCESS","opTime":"345 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-24 07:42:23 AUDIT audit:74 - {"time":"April 24, 2020 12:42:23 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857281561351944","opStatus":"START"}
2020-04-24 07:42:23 AUDIT audit:97 - {"time":"April 24, 2020 12:42:23 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6857281561351944","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-24 07:42:23 AUDIT audit:74 - {"time":"April 24, 2020 12:42:23 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6857281567128371","opStatus":"START"}
2020-04-24 07:42:23 AUDIT audit:74 - {"time":"April 24, 2020 12:42:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857281589036937","opStatus":"START"}
2020-04-24 07:42:23 AUDIT audit:74 - {"time":"April 24, 2020 12:42:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857281595813052","opStatus":"START"}
2020-04-24 07:42:23 AUDIT audit:97 - {"time":"April 24, 2020 12:42:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857281595813052","opStatus":"SUCCESS","opTime":"76 ms","table":"NA","extraInfo":{}}
2020-04-24 07:42:23 AUDIT audit:97 - {"time":"April 24, 2020 12:42:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6857281589036937","opStatus":"SUCCESS","opTime":"86 ms","table":"partition_mv.dm1","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 07:42:24 AUDIT audit:74 - {"time":"April 24, 2020 12:42:24 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6857281833827984","opStatus":"START"}
2020-04-24 07:42:25 AUDIT audit:97 - {"time":"April 24, 2020 12:42:25 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6857281833827984","opStatus":"SUCCESS","opTime":"1977 ms","table":"partition_mv.dm1","extraInfo":{}}
2020-04-24 07:42:25 AUDIT audit:97 - {"time":"April 24, 2020 12:42:25 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6857281567128371","opStatus":"SUCCESS","opTime":"2242 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-24 07:42:26 AUDIT audit:74 - {"time":"April 24, 2020 12:42:26 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6857284280327209","opStatus":"START"}
2020-04-24 07:42:26 AUDIT audit:97 - {"time":"April 24, 2020 12:42:26 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6857284280327209","opStatus":"SUCCESS","opTime":"192 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- test partition on timeseries column[0m
2020-04-24 07:42:26 AUDIT audit:74 - {"time":"April 24, 2020 12:42:26 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6857284620594362","opStatus":"START"}
2020-04-24 07:42:26 AUDIT audit:97 - {"time":"April 24, 2020 12:42:26 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6857284620594362","opStatus":"SUCCESS","opTime":"91 ms","table":"partition_mv.droppartition","extraInfo":{}}
2020-04-24 07:42:26 AUDIT audit:74 - {"time":"April 24, 2020 12:42:26 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6857284712011684","opStatus":"START"}
2020-04-24 07:42:27 AUDIT audit:97 - {"time":"April 24, 2020 12:42:27 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6857284712011684","opStatus":"SUCCESS","opTime":"137 ms","table":"partition_mv.maintable","extraInfo":{}}
2020-04-24 07:42:27 AUDIT audit:74 - {"time":"April 24, 2020 12:42:27 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6857284848428593","opStatus":"START"}
2020-04-24 07:42:27 AUDIT audit:97 - {"time":"April 24, 2020 12:42:27 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6857284848428593","opStatus":"SUCCESS","opTime":"113 ms","table":"partition_mv.par","extraInfo":{}}
2020-04-24 07:42:27 AUDIT audit:74 - {"time":"April 24, 2020 12:42:27 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6857284961825877","opStatus":"START"}
2020-04-24 07:42:27 AUDIT audit:97 - {"time":"April 24, 2020 12:42:27 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6857284961825877","opStatus":"SUCCESS","opTime":"156 ms","table":"partition_mv.partitiontable","extraInfo":{}}
[32mMVTPCDSTestCase:[0m
[33m- test create materialized view with tpcds_1_4_testCases case_1 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_3 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_4 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_5 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_6 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_8 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_11 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_15 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_16 !!! IGNORED !!![0m
[32mIsSPJGHSuite:[0m
[32m- project only[0m
[32m- groupby-project[0m
[32m- groupby-project-filter[0m
[32m- groupby-project-filter-join[0m
[32mLogicalToModularPlanSuite:[0m
[32m- select only[0m
[32m- select-project-groupby grouping without aggregate function[0m
[32m- select-project with filter[0m
[32m- join[0m
[32m- left outer join[0m
[32m- right outer join[0m
[33m- joins: conjunctive predicates #1 with alias !!! IGNORED !!![0m
[33m- joins: conjunctive predicates #2 with alias !!! IGNORED !!![0m
[33m- SPJGH query !!! IGNORED !!![0m
[33m- non-SPJGH query !!! IGNORED !!![0m
[36mRun completed in 17 minutes, 50 seconds.[0m
[36mTotal number of tests run: 268[0m
[36mSuites: completed 28, aborted 0[0m
[36mTests: succeeded 266, failed 2, canceled 0, ignored 25, pending 0[0m
[31m*** 2 TESTS FAILED ***[0m
[JENKINS] Recording test results
Build failed in Jenkins: carbondata-master-spark-2.3 » Apache CarbonData :: Materialized View Core #2215
Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://builds.apache.org/job/carbondata-master-spark-2.3/org.apache.carbondata$carbondata-mv-core/2215/display/redirect>
Changes:
------------------------------------------
[...truncated 1.53 MB...]
2020-04-26 08:43:13 AUDIT audit:97 - {"time":"April 26, 2020 1:43:13 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039264187981187","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-26 08:43:13 AUDIT audit:74 - {"time":"April 26, 2020 1:43:13 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039264192271566","opStatus":"START"}
2020-04-26 08:43:13 AUDIT audit:97 - {"time":"April 26, 2020 1:43:13 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039264192271566","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-26 08:43:13 AUDIT audit:74 - {"time":"April 26, 2020 1:43:13 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039264196579616","opStatus":"START"}
2020-04-26 08:43:13 AUDIT audit:97 - {"time":"April 26, 2020 1:43:13 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039264196579616","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-26 08:43:13 AUDIT audit:74 - {"time":"April 26, 2020 1:43:13 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039264200828317","opStatus":"START"}
2020-04-26 08:43:13 AUDIT audit:97 - {"time":"April 26, 2020 1:43:13 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039264200828317","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-26 08:43:13 AUDIT audit:74 - {"time":"April 26, 2020 1:43:13 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039264214791184","opStatus":"START"}
2020-04-26 08:43:13 AUDIT audit:97 - {"time":"April 26, 2020 1:43:13 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039264214791184","opStatus":"SUCCESS","opTime":"81 ms","table":"NA","extraInfo":{}}
2020-04-26 08:43:13 AUDIT audit:74 - {"time":"April 26, 2020 1:43:13 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"7039264298949198","opStatus":"START"}
2020-04-26 08:43:13 AUDIT audit:74 - {"time":"April 26, 2020 1:43:13 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039264328491742","opStatus":"START"}
2020-04-26 08:43:13 AUDIT audit:74 - {"time":"April 26, 2020 1:43:13 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039264335650999","opStatus":"START"}
2020-04-26 08:43:13 AUDIT audit:97 - {"time":"April 26, 2020 1:43:13 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039264335650999","opStatus":"SUCCESS","opTime":"43 ms","table":"NA","extraInfo":{}}
2020-04-26 08:43:13 AUDIT audit:97 - {"time":"April 26, 2020 1:43:13 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039264328491742","opStatus":"SUCCESS","opTime":"54 ms","table":"partition_mv.p7","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-26 08:43:14 AUDIT audit:97 - {"time":"April 26, 2020 1:43:14 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"7039264298949198","opStatus":"SUCCESS","opTime":"325 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-26 08:43:14 AUDIT audit:74 - {"time":"April 26, 2020 1:43:14 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"7039264630549986","opStatus":"START"}
2020-04-26 08:43:14 AUDIT audit:74 - {"time":"April 26, 2020 1:43:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039264660566081","opStatus":"START"}
2020-04-26 08:43:14 AUDIT audit:74 - {"time":"April 26, 2020 1:43:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039264667856759","opStatus":"START"}
2020-04-26 08:43:14 AUDIT audit:97 - {"time":"April 26, 2020 1:43:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039264667856759","opStatus":"SUCCESS","opTime":"53 ms","table":"NA","extraInfo":{}}
2020-04-26 08:43:14 AUDIT audit:97 - {"time":"April 26, 2020 1:43:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039264660566081","opStatus":"SUCCESS","opTime":"63 ms","table":"partition_mv.p1","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-26 08:43:14 AUDIT audit:97 - {"time":"April 26, 2020 1:43:14 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"7039264630549986","opStatus":"SUCCESS","opTime":"258 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-26 08:43:14 AUDIT audit:74 - {"time":"April 26, 2020 1:43:14 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"7039264894235225","opStatus":"START"}
2020-04-26 08:43:14 AUDIT audit:74 - {"time":"April 26, 2020 1:43:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039264918065428","opStatus":"START"}
2020-04-26 08:43:14 AUDIT audit:74 - {"time":"April 26, 2020 1:43:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039264924820147","opStatus":"START"}
2020-04-26 08:43:14 AUDIT audit:97 - {"time":"April 26, 2020 1:43:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039264924820147","opStatus":"SUCCESS","opTime":"71 ms","table":"NA","extraInfo":{}}
2020-04-26 08:43:14 AUDIT audit:97 - {"time":"April 26, 2020 1:43:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039264918065428","opStatus":"SUCCESS","opTime":"81 ms","table":"partition_mv.p2","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-26 08:43:14 AUDIT audit:97 - {"time":"April 26, 2020 1:43:14 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"7039264894235225","opStatus":"SUCCESS","opTime":"314 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-26 08:43:14 AUDIT audit:74 - {"time":"April 26, 2020 1:43:14 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"7039265215169851","opStatus":"START"}
2020-04-26 08:43:14 AUDIT audit:74 - {"time":"April 26, 2020 1:43:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039265245451624","opStatus":"START"}
2020-04-26 08:43:14 AUDIT audit:74 - {"time":"April 26, 2020 1:43:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039265253751682","opStatus":"START"}
2020-04-26 08:43:14 AUDIT audit:97 - {"time":"April 26, 2020 1:43:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039265253751682","opStatus":"SUCCESS","opTime":"51 ms","table":"NA","extraInfo":{}}
2020-04-26 08:43:14 AUDIT audit:97 - {"time":"April 26, 2020 1:43:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039265245451624","opStatus":"SUCCESS","opTime":"62 ms","table":"partition_mv.p3","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-26 08:43:15 AUDIT audit:97 - {"time":"April 26, 2020 1:43:15 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"7039265215169851","opStatus":"SUCCESS","opTime":"285 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-26 08:43:15 AUDIT audit:74 - {"time":"April 26, 2020 1:43:15 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"7039265507206868","opStatus":"START"}
2020-04-26 08:43:15 AUDIT audit:74 - {"time":"April 26, 2020 1:43:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039265532559600","opStatus":"START"}
2020-04-26 08:43:15 AUDIT audit:74 - {"time":"April 26, 2020 1:43:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039265539403801","opStatus":"START"}
2020-04-26 08:43:15 AUDIT audit:97 - {"time":"April 26, 2020 1:43:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039265539403801","opStatus":"SUCCESS","opTime":"57 ms","table":"NA","extraInfo":{}}
2020-04-26 08:43:15 AUDIT audit:97 - {"time":"April 26, 2020 1:43:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039265532559600","opStatus":"SUCCESS","opTime":"67 ms","table":"partition_mv.p4","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-26 08:43:15 AUDIT audit:97 - {"time":"April 26, 2020 1:43:15 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"7039265507206868","opStatus":"SUCCESS","opTime":"311 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-26 08:43:15 AUDIT audit:74 - {"time":"April 26, 2020 1:43:15 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"7039265823778450","opStatus":"START"}
2020-04-26 08:43:15 AUDIT audit:74 - {"time":"April 26, 2020 1:43:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039265850546447","opStatus":"START"}
2020-04-26 08:43:15 AUDIT audit:74 - {"time":"April 26, 2020 1:43:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039265857452129","opStatus":"START"}
2020-04-26 08:43:15 AUDIT audit:97 - {"time":"April 26, 2020 1:43:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039265857452129","opStatus":"SUCCESS","opTime":"38 ms","table":"NA","extraInfo":{}}
2020-04-26 08:43:15 AUDIT audit:97 - {"time":"April 26, 2020 1:43:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039265850546447","opStatus":"SUCCESS","opTime":"49 ms","table":"partition_mv.p5","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-26 08:43:15 AUDIT audit:97 - {"time":"April 26, 2020 1:43:15 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"7039265823778450","opStatus":"SUCCESS","opTime":"263 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-26 08:43:15 AUDIT audit:74 - {"time":"April 26, 2020 1:43:15 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"7039266093452976","opStatus":"START"}
2020-04-26 08:43:15 AUDIT audit:74 - {"time":"April 26, 2020 1:43:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039266123352595","opStatus":"START"}
2020-04-26 08:43:15 AUDIT audit:74 - {"time":"April 26, 2020 1:43:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039266130746832","opStatus":"START"}
2020-04-26 08:43:15 AUDIT audit:97 - {"time":"April 26, 2020 1:43:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039266130746832","opStatus":"SUCCESS","opTime":"41 ms","table":"NA","extraInfo":{}}
2020-04-26 08:43:15 AUDIT audit:97 - {"time":"April 26, 2020 1:43:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039266123352595","opStatus":"SUCCESS","opTime":"51 ms","table":"partition_mv.p6","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-26 08:43:15 AUDIT audit:97 - {"time":"April 26, 2020 1:43:15 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"7039266093452976","opStatus":"SUCCESS","opTime":"280 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-26 08:43:16 AUDIT audit:74 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"7039266571739493","opStatus":"START"}
2020-04-26 08:43:16 AUDIT audit:97 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"7039266571739493","opStatus":"SUCCESS","opTime":"569 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- check partitioning for child tables with various combinations[0m
2020-04-26 08:43:16 AUDIT audit:74 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267153310648","opStatus":"START"}
2020-04-26 08:43:16 AUDIT audit:97 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267153310648","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-26 08:43:16 AUDIT audit:74 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267157851335","opStatus":"START"}
2020-04-26 08:43:16 AUDIT audit:97 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267157851335","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-26 08:43:16 AUDIT audit:74 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267162102380","opStatus":"START"}
2020-04-26 08:43:16 AUDIT audit:97 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267162102380","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-26 08:43:16 AUDIT audit:74 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267166322223","opStatus":"START"}
2020-04-26 08:43:16 AUDIT audit:97 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267166322223","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-26 08:43:16 AUDIT audit:74 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267170498064","opStatus":"START"}
2020-04-26 08:43:16 AUDIT audit:97 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267170498064","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-26 08:43:16 AUDIT audit:74 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267174730191","opStatus":"START"}
2020-04-26 08:43:16 AUDIT audit:97 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267174730191","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-26 08:43:16 AUDIT audit:74 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267179133588","opStatus":"START"}
2020-04-26 08:43:16 AUDIT audit:97 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267179133588","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-26 08:43:16 AUDIT audit:74 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267183505287","opStatus":"START"}
2020-04-26 08:43:16 AUDIT audit:97 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267183505287","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag1"}}
2020-04-26 08:43:16 AUDIT audit:74 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267187843712","opStatus":"START"}
2020-04-26 08:43:16 AUDIT audit:97 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267187843712","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-26 08:43:16 AUDIT audit:74 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267192047584","opStatus":"START"}
2020-04-26 08:43:16 AUDIT audit:97 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267192047584","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-26 08:43:16 AUDIT audit:74 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267196628306","opStatus":"START"}
2020-04-26 08:43:16 AUDIT audit:97 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267196628306","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-26 08:43:16 AUDIT audit:74 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267200978408","opStatus":"START"}
2020-04-26 08:43:16 AUDIT audit:97 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267200978408","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-26 08:43:16 AUDIT audit:74 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039267214481833","opStatus":"START"}
2020-04-26 08:43:16 AUDIT audit:97 - {"time":"April 26, 2020 1:43:16 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039267214481833","opStatus":"SUCCESS","opTime":"83 ms","table":"NA","extraInfo":{}}
2020-04-26 08:43:17 AUDIT audit:74 - {"time":"April 26, 2020 1:43:17 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"7039267535933982","opStatus":"START"}
2020-04-26 08:43:17 AUDIT audit:97 - {"time":"April 26, 2020 1:43:17 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"7039267535933982","opStatus":"SUCCESS","opTime":"429 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-26 08:43:17 AUDIT audit:74 - {"time":"April 26, 2020 1:43:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267967252655","opStatus":"START"}
2020-04-26 08:43:17 AUDIT audit:97 - {"time":"April 26, 2020 1:43:17 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039267967252655","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-26 08:43:17 AUDIT audit:74 - {"time":"April 26, 2020 1:43:17 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"7039267974250660","opStatus":"START"}
2020-04-26 08:43:17 AUDIT audit:74 - {"time":"April 26, 2020 1:43:17 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039267999555554","opStatus":"START"}
2020-04-26 08:43:17 AUDIT audit:74 - {"time":"April 26, 2020 1:43:17 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039268007573128","opStatus":"START"}
2020-04-26 08:43:17 AUDIT audit:97 - {"time":"April 26, 2020 1:43:17 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039268007573128","opStatus":"SUCCESS","opTime":"47 ms","table":"NA","extraInfo":{}}
2020-04-26 08:43:17 AUDIT audit:97 - {"time":"April 26, 2020 1:43:17 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039267999555554","opStatus":"SUCCESS","opTime":"59 ms","table":"partition_mv.dm1","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-26 08:43:17 AUDIT audit:74 - {"time":"April 26, 2020 1:43:17 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"7039268300354818","opStatus":"START"}
2020-04-26 08:43:20 AUDIT audit:97 - {"time":"April 26, 2020 1:43:20 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"7039268300354818","opStatus":"SUCCESS","opTime":"2396 ms","table":"partition_mv.dm1","extraInfo":{}}
2020-04-26 08:43:20 AUDIT audit:97 - {"time":"April 26, 2020 1:43:20 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"7039267974250660","opStatus":"SUCCESS","opTime":"2720 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-26 08:43:20 AUDIT audit:74 - {"time":"April 26, 2020 1:43:20 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"7039271297141637","opStatus":"START"}
2020-04-26 08:43:21 AUDIT audit:97 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"7039271297141637","opStatus":"SUCCESS","opTime":"211 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- test partition at last column[0m
2020-04-26 08:43:21 AUDIT audit:74 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039271520780518","opStatus":"START"}
2020-04-26 08:43:21 AUDIT audit:97 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039271520780518","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-26 08:43:21 AUDIT audit:74 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039271525619162","opStatus":"START"}
2020-04-26 08:43:21 AUDIT audit:97 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039271525619162","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-26 08:43:21 AUDIT audit:74 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039271530250068","opStatus":"START"}
2020-04-26 08:43:21 AUDIT audit:97 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039271530250068","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-26 08:43:21 AUDIT audit:74 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039271534892498","opStatus":"START"}
2020-04-26 08:43:21 AUDIT audit:97 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039271534892498","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-26 08:43:21 AUDIT audit:74 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039271539387475","opStatus":"START"}
2020-04-26 08:43:21 AUDIT audit:97 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039271539387475","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-26 08:43:21 AUDIT audit:74 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039271544159637","opStatus":"START"}
2020-04-26 08:43:21 AUDIT audit:97 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039271544159637","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-26 08:43:21 AUDIT audit:74 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039271548766276","opStatus":"START"}
2020-04-26 08:43:21 AUDIT audit:97 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039271548766276","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-26 08:43:21 AUDIT audit:74 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039271553341723","opStatus":"START"}
2020-04-26 08:43:21 AUDIT audit:97 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039271553341723","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag1"}}
2020-04-26 08:43:21 AUDIT audit:74 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039271557720606","opStatus":"START"}
2020-04-26 08:43:21 AUDIT audit:97 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039271557720606","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-26 08:43:21 AUDIT audit:74 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039271562158890","opStatus":"START"}
2020-04-26 08:43:21 AUDIT audit:97 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039271562158890","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-26 08:43:21 AUDIT audit:74 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039271566432614","opStatus":"START"}
2020-04-26 08:43:21 AUDIT audit:97 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039271566432614","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-26 08:43:21 AUDIT audit:74 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039271570779512","opStatus":"START"}
2020-04-26 08:43:21 AUDIT audit:97 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039271570779512","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-26 08:43:21 AUDIT audit:74 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039271584026325","opStatus":"START"}
2020-04-26 08:43:21 AUDIT audit:97 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039271584026325","opStatus":"SUCCESS","opTime":"46 ms","table":"NA","extraInfo":{}}
2020-04-26 08:43:21 AUDIT audit:74 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"7039271718057881","opStatus":"START"}
2020-04-26 08:43:21 AUDIT audit:97 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"7039271718057881","opStatus":"SUCCESS","opTime":"445 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-26 08:43:21 AUDIT audit:74 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039272164109779","opStatus":"START"}
2020-04-26 08:43:21 AUDIT audit:97 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039272164109779","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-26 08:43:21 AUDIT audit:74 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DESC FORMATTED","opId":"7039272247366419","opStatus":"START"}
2020-04-26 08:43:21 ERROR CarbonUtil:2444 - Unable to unlock Table lock for table during table status updation
2020-04-26 08:43:21 AUDIT audit:97 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DESC FORMATTED","opId":"7039272247366419","opStatus":"SUCCESS","opTime":"38 ms","table":"partition_mv.partitionone","extraInfo":{}}
+-----------------------------+-----------------------------------------------------------------------------------------------------------------------+-------+
|col_name |data_type |comment|
+-----------------------------+-----------------------------------------------------------------------------------------------------------------------+-------+
|a |int |null |
|b |int |null |
|c |timestamp |null |
|d |timestamp |null |
| | | |
|## Detailed Table Information| | |
|Database |partition_mv | |
|Table |partitionone | |
|Owner |jenkins | |
|Created |Sun Apr 26 01:43:21 PDT 2020 | |
|Location |<https://builds.apache.org/job/carbondata-master-spark-2.3/org.apache.carbondata$carbondata-mv-core/ws/target/warehouse/partition_mv.db/partitionone|> |
|External |false | |
|Transactional |true | |
|Streaming |false | |
|Table Block Size |1024 MB | |
|Table Blocklet Size |64 MB | |
|Comment | | |
|Bad Record Path | | |
|Min Input Per Node Per Load |0.0B | |
| | | |
|## Index Information | | |
|Sort Scope |NO_SORT | |
|Sort Columns | | |
|Inverted Index Columns | | |
|Cached Min/Max Index Columns |All columns | |
|Min/Max Index Cache Level |BLOCK | |
|Table page size in mb | | |
| | | |
|## Encoding Information | | |
|Local Dictionary Enabled |true | |
|Local Dictionary Threshold |10000 | |
|Local Dictionary Include | | |
| | | |
|## Compaction Information | | |
|MAJOR_COMPACTION_SIZE |1024 | |
|AUTO_LOAD_MERGE |false | |
|COMPACTION_LEVEL_THRESHOLD |4,3 | |
|COMPACTION_PRESERVE_SEGMENTS |0 | |
|ALLOWED_COMPACTION_DAYS |0 | |
| | | |
|## Partition Information | | |
|Partition Type |NATIVE_HIVE | |
|Partition Columns |c:TIMESTAMP, d:TIMESTAMP | |
|Number of Partitions |1 | |
| | | |
|## Dynamic Information | | |
|Table Data Size |1.10KB | |
|Table Index Size |705.0B | |
|Last Update |Sun Apr 26 01:43:21 PDT 2020 | |
+-----------------------------+-----------------------------------------------------------------------------------------------------------------------+-------+
2020-04-26 08:43:21 AUDIT audit:74 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"7039272333707042","opStatus":"START"}
2020-04-26 08:43:21 AUDIT audit:74 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039272360337601","opStatus":"START"}
2020-04-26 08:43:21 AUDIT audit:74 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039272366752740","opStatus":"START"}
2020-04-26 08:43:21 AUDIT audit:97 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039272366752740","opStatus":"SUCCESS","opTime":"46 ms","table":"NA","extraInfo":{}}
2020-04-26 08:43:21 AUDIT audit:97 - {"time":"April 26, 2020 1:43:21 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039272360337601","opStatus":"SUCCESS","opTime":"55 ms","table":"partition_mv.dm1","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-26 08:43:22 AUDIT audit:74 - {"time":"April 26, 2020 1:43:22 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"7039272609928750","opStatus":"START"}
2020-04-26 08:43:23 AUDIT audit:97 - {"time":"April 26, 2020 1:43:23 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"7039272609928750","opStatus":"SUCCESS","opTime":"887 ms","table":"partition_mv.dm1","extraInfo":{"SegmentId":"0","DataSize":"688.0B","IndexSize":"454.0B"}}
2020-04-26 08:43:23 AUDIT audit:97 - {"time":"April 26, 2020 1:43:23 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"7039272333707042","opStatus":"SUCCESS","opTime":"1162 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-26 08:43:23 AUDIT audit:74 - {"time":"April 26, 2020 1:43:23 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"7039274043277328","opStatus":"START"}
2020-04-26 08:43:23 AUDIT audit:97 - {"time":"April 26, 2020 1:43:23 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"7039274043277328","opStatus":"SUCCESS","opTime":"180 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-26 08:43:23 AUDIT audit:74 - {"time":"April 26, 2020 1:43:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039274230186235","opStatus":"START"}
2020-04-26 08:43:23 AUDIT audit:97 - {"time":"April 26, 2020 1:43:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039274230186235","opStatus":"SUCCESS","opTime":"50 ms","table":"NA","extraInfo":{}}
2020-04-26 08:43:23 AUDIT audit:74 - {"time":"April 26, 2020 1:43:23 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"7039274366743105","opStatus":"START"}
2020-04-26 08:43:24 AUDIT audit:97 - {"time":"April 26, 2020 1:43:24 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"7039274366743105","opStatus":"SUCCESS","opTime":"387 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-26 08:43:24 AUDIT audit:74 - {"time":"April 26, 2020 1:43:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039274755800617","opStatus":"START"}
2020-04-26 08:43:24 AUDIT audit:97 - {"time":"April 26, 2020 1:43:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"7039274755800617","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-26 08:43:24 AUDIT audit:74 - {"time":"April 26, 2020 1:43:24 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"7039274761489996","opStatus":"START"}
2020-04-26 08:43:24 AUDIT audit:74 - {"time":"April 26, 2020 1:43:24 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039274788956204","opStatus":"START"}
2020-04-26 08:43:24 AUDIT audit:74 - {"time":"April 26, 2020 1:43:24 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039274795667245","opStatus":"START"}
2020-04-26 08:43:24 AUDIT audit:97 - {"time":"April 26, 2020 1:43:24 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039274795667245","opStatus":"SUCCESS","opTime":"84 ms","table":"NA","extraInfo":{}}
2020-04-26 08:43:24 AUDIT audit:97 - {"time":"April 26, 2020 1:43:24 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"7039274788956204","opStatus":"SUCCESS","opTime":"94 ms","table":"partition_mv.dm1","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-26 08:43:24 AUDIT audit:74 - {"time":"April 26, 2020 1:43:24 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"7039275062937535","opStatus":"START"}
2020-04-26 08:43:26 AUDIT audit:97 - {"time":"April 26, 2020 1:43:26 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"7039275062937535","opStatus":"SUCCESS","opTime":"2358 ms","table":"partition_mv.dm1","extraInfo":{}}
2020-04-26 08:43:26 AUDIT audit:97 - {"time":"April 26, 2020 1:43:26 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"7039274761489996","opStatus":"SUCCESS","opTime":"2659 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-26 08:43:27 AUDIT audit:74 - {"time":"April 26, 2020 1:43:27 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"7039277928481792","opStatus":"START"}
2020-04-26 08:43:27 AUDIT audit:97 - {"time":"April 26, 2020 1:43:27 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"7039277928481792","opStatus":"SUCCESS","opTime":"203 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- test partition on timeseries column[0m
2020-04-26 08:43:27 AUDIT audit:74 - {"time":"April 26, 2020 1:43:27 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"7039278281760690","opStatus":"START"}
2020-04-26 08:43:27 AUDIT audit:97 - {"time":"April 26, 2020 1:43:27 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"7039278281760690","opStatus":"SUCCESS","opTime":"98 ms","table":"partition_mv.droppartition","extraInfo":{}}
2020-04-26 08:43:27 AUDIT audit:74 - {"time":"April 26, 2020 1:43:27 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"7039278380022621","opStatus":"START"}
2020-04-26 08:43:28 AUDIT audit:97 - {"time":"April 26, 2020 1:43:28 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"7039278380022621","opStatus":"SUCCESS","opTime":"152 ms","table":"partition_mv.maintable","extraInfo":{}}
2020-04-26 08:43:28 AUDIT audit:74 - {"time":"April 26, 2020 1:43:28 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"7039278531991661","opStatus":"START"}
2020-04-26 08:43:28 AUDIT audit:97 - {"time":"April 26, 2020 1:43:28 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"7039278531991661","opStatus":"SUCCESS","opTime":"332 ms","table":"partition_mv.par","extraInfo":{}}
2020-04-26 08:43:28 AUDIT audit:74 - {"time":"April 26, 2020 1:43:28 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"7039278864097952","opStatus":"START"}
2020-04-26 08:43:28 AUDIT audit:97 - {"time":"April 26, 2020 1:43:28 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"7039278864097952","opStatus":"SUCCESS","opTime":"285 ms","table":"partition_mv.partitiontable","extraInfo":{}}
[32mMVTPCDSTestCase:[0m
[33m- test create materialized view with tpcds_1_4_testCases case_1 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_3 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_4 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_5 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_6 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_8 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_11 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_15 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_16 !!! IGNORED !!![0m
[32mIsSPJGHSuite:[0m
[32m- project only[0m
[32m- groupby-project[0m
[32m- groupby-project-filter[0m
[32m- groupby-project-filter-join[0m
[32mLogicalToModularPlanSuite:[0m
[32m- select only[0m
[32m- select-project-groupby grouping without aggregate function[0m
[32m- select-project with filter[0m
[32m- join[0m
[32m- left outer join[0m
[32m- right outer join[0m
[33m- joins: conjunctive predicates #1 with alias !!! IGNORED !!![0m
[33m- joins: conjunctive predicates #2 with alias !!! IGNORED !!![0m
[33m- SPJGH query !!! IGNORED !!![0m
[33m- non-SPJGH query !!! IGNORED !!![0m
[36mRun completed in 15 minutes, 31 seconds.[0m
[36mTotal number of tests run: 268[0m
[36mSuites: completed 28, aborted 0[0m
[36mTests: succeeded 266, failed 2, canceled 0, ignored 25, pending 0[0m
[31m*** 2 TESTS FAILED ***[0m
[JENKINS] Recording test results
Build failed in Jenkins: carbondata-master-spark-2.3 » Apache CarbonData :: Materialized View Core #2214
Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://builds.apache.org/job/carbondata-master-spark-2.3/org.apache.carbondata$carbondata-mv-core/2214/display/redirect>
Changes:
------------------------------------------
[...truncated 1.53 MB...]
2020-04-25 08:36:51 AUDIT audit:97 - {"time":"April 25, 2020 1:36:51 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946949379402881","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-25 08:36:51 AUDIT audit:74 - {"time":"April 25, 2020 1:36:51 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946949383703846","opStatus":"START"}
2020-04-25 08:36:51 AUDIT audit:97 - {"time":"April 25, 2020 1:36:51 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946949383703846","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-25 08:36:51 AUDIT audit:74 - {"time":"April 25, 2020 1:36:51 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946949388026751","opStatus":"START"}
2020-04-25 08:36:51 AUDIT audit:97 - {"time":"April 25, 2020 1:36:51 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946949388026751","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-25 08:36:51 AUDIT audit:74 - {"time":"April 25, 2020 1:36:51 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946949392330652","opStatus":"START"}
2020-04-25 08:36:51 AUDIT audit:97 - {"time":"April 25, 2020 1:36:51 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946949392330652","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-25 08:36:51 AUDIT audit:74 - {"time":"April 25, 2020 1:36:51 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946949406488906","opStatus":"START"}
2020-04-25 08:36:51 AUDIT audit:97 - {"time":"April 25, 2020 1:36:51 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946949406488906","opStatus":"SUCCESS","opTime":"70 ms","table":"NA","extraInfo":{}}
2020-04-25 08:36:51 AUDIT audit:74 - {"time":"April 25, 2020 1:36:51 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6946949478795704","opStatus":"START"}
2020-04-25 08:36:51 AUDIT audit:74 - {"time":"April 25, 2020 1:36:51 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946949505558341","opStatus":"START"}
2020-04-25 08:36:51 AUDIT audit:74 - {"time":"April 25, 2020 1:36:51 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946949512364081","opStatus":"START"}
2020-04-25 08:36:51 AUDIT audit:97 - {"time":"April 25, 2020 1:36:51 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946949512364081","opStatus":"SUCCESS","opTime":"41 ms","table":"NA","extraInfo":{}}
2020-04-25 08:36:51 AUDIT audit:97 - {"time":"April 25, 2020 1:36:51 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946949505558341","opStatus":"SUCCESS","opTime":"50 ms","table":"partition_mv.p7","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-25 08:36:51 AUDIT audit:97 - {"time":"April 25, 2020 1:36:51 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6946949478795704","opStatus":"SUCCESS","opTime":"240 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-25 08:36:51 AUDIT audit:74 - {"time":"April 25, 2020 1:36:51 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6946949724020126","opStatus":"START"}
2020-04-25 08:36:51 AUDIT audit:74 - {"time":"April 25, 2020 1:36:51 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946949745869916","opStatus":"START"}
2020-04-25 08:36:51 AUDIT audit:74 - {"time":"April 25, 2020 1:36:51 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946949752127510","opStatus":"START"}
2020-04-25 08:36:51 AUDIT audit:97 - {"time":"April 25, 2020 1:36:51 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946949752127510","opStatus":"SUCCESS","opTime":"35 ms","table":"NA","extraInfo":{}}
2020-04-25 08:36:51 AUDIT audit:97 - {"time":"April 25, 2020 1:36:51 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946949745869916","opStatus":"SUCCESS","opTime":"43 ms","table":"partition_mv.p1","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-25 08:36:52 AUDIT audit:97 - {"time":"April 25, 2020 1:36:52 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6946949724020126","opStatus":"SUCCESS","opTime":"226 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-25 08:36:52 AUDIT audit:74 - {"time":"April 25, 2020 1:36:52 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6946949955407882","opStatus":"START"}
2020-04-25 08:36:52 AUDIT audit:74 - {"time":"April 25, 2020 1:36:52 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946949977972960","opStatus":"START"}
2020-04-25 08:36:52 AUDIT audit:74 - {"time":"April 25, 2020 1:36:52 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946949984553803","opStatus":"START"}
2020-04-25 08:36:52 AUDIT audit:97 - {"time":"April 25, 2020 1:36:52 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946949984553803","opStatus":"SUCCESS","opTime":"70 ms","table":"NA","extraInfo":{}}
2020-04-25 08:36:52 AUDIT audit:97 - {"time":"April 25, 2020 1:36:52 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946949977972960","opStatus":"SUCCESS","opTime":"79 ms","table":"partition_mv.p2","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-25 08:36:52 AUDIT audit:97 - {"time":"April 25, 2020 1:36:52 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6946949955407882","opStatus":"SUCCESS","opTime":"289 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-25 08:36:52 AUDIT audit:74 - {"time":"April 25, 2020 1:36:52 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6946950249420402","opStatus":"START"}
2020-04-25 08:36:52 AUDIT audit:74 - {"time":"April 25, 2020 1:36:52 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946950277957359","opStatus":"START"}
2020-04-25 08:36:52 AUDIT audit:74 - {"time":"April 25, 2020 1:36:52 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946950284716388","opStatus":"START"}
2020-04-25 08:36:52 AUDIT audit:97 - {"time":"April 25, 2020 1:36:52 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946950284716388","opStatus":"SUCCESS","opTime":"50 ms","table":"NA","extraInfo":{}}
2020-04-25 08:36:52 AUDIT audit:97 - {"time":"April 25, 2020 1:36:52 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946950277957359","opStatus":"SUCCESS","opTime":"60 ms","table":"partition_mv.p3","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-25 08:36:52 AUDIT audit:97 - {"time":"April 25, 2020 1:36:52 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6946950249420402","opStatus":"SUCCESS","opTime":"256 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-25 08:36:52 AUDIT audit:74 - {"time":"April 25, 2020 1:36:52 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6946950510659406","opStatus":"START"}
2020-04-25 08:36:52 AUDIT audit:74 - {"time":"April 25, 2020 1:36:52 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946950539264151","opStatus":"START"}
2020-04-25 08:36:52 AUDIT audit:74 - {"time":"April 25, 2020 1:36:52 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946950547077788","opStatus":"START"}
2020-04-25 08:36:52 AUDIT audit:97 - {"time":"April 25, 2020 1:36:52 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946950547077788","opStatus":"SUCCESS","opTime":"40 ms","table":"NA","extraInfo":{}}
2020-04-25 08:36:52 AUDIT audit:97 - {"time":"April 25, 2020 1:36:52 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946950539264151","opStatus":"SUCCESS","opTime":"50 ms","table":"partition_mv.p4","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-25 08:36:52 AUDIT audit:97 - {"time":"April 25, 2020 1:36:52 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6946950510659406","opStatus":"SUCCESS","opTime":"241 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-25 08:36:52 AUDIT audit:74 - {"time":"April 25, 2020 1:36:52 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6946950757412800","opStatus":"START"}
2020-04-25 08:36:52 AUDIT audit:74 - {"time":"April 25, 2020 1:36:52 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946950780562863","opStatus":"START"}
2020-04-25 08:36:52 AUDIT audit:74 - {"time":"April 25, 2020 1:36:52 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946950786965044","opStatus":"START"}
2020-04-25 08:36:52 AUDIT audit:97 - {"time":"April 25, 2020 1:36:52 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946950786965044","opStatus":"SUCCESS","opTime":"34 ms","table":"NA","extraInfo":{}}
2020-04-25 08:36:52 AUDIT audit:97 - {"time":"April 25, 2020 1:36:52 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946950780562863","opStatus":"SUCCESS","opTime":"43 ms","table":"partition_mv.p5","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-25 08:36:53 AUDIT audit:97 - {"time":"April 25, 2020 1:36:53 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6946950757412800","opStatus":"SUCCESS","opTime":"235 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-25 08:36:53 AUDIT audit:74 - {"time":"April 25, 2020 1:36:53 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6946950997179919","opStatus":"START"}
2020-04-25 08:36:53 AUDIT audit:74 - {"time":"April 25, 2020 1:36:53 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946951022460560","opStatus":"START"}
2020-04-25 08:36:53 AUDIT audit:74 - {"time":"April 25, 2020 1:36:53 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946951029034568","opStatus":"START"}
2020-04-25 08:36:53 AUDIT audit:97 - {"time":"April 25, 2020 1:36:53 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946951029034568","opStatus":"SUCCESS","opTime":"46 ms","table":"NA","extraInfo":{}}
2020-04-25 08:36:53 AUDIT audit:97 - {"time":"April 25, 2020 1:36:53 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946951022460560","opStatus":"SUCCESS","opTime":"55 ms","table":"partition_mv.p6","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-25 08:36:53 AUDIT audit:97 - {"time":"April 25, 2020 1:36:53 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6946950997179919","opStatus":"SUCCESS","opTime":"249 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-25 08:36:53 AUDIT audit:74 - {"time":"April 25, 2020 1:36:53 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6946951414362677","opStatus":"START"}
2020-04-25 08:36:54 AUDIT audit:97 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6946951414362677","opStatus":"SUCCESS","opTime":"537 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- check partitioning for child tables with various combinations[0m
2020-04-25 08:36:54 AUDIT audit:74 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946951962785007","opStatus":"START"}
2020-04-25 08:36:54 AUDIT audit:97 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946951962785007","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-25 08:36:54 AUDIT audit:74 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946951967312318","opStatus":"START"}
2020-04-25 08:36:54 AUDIT audit:97 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946951967312318","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-25 08:36:54 AUDIT audit:74 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946951971615262","opStatus":"START"}
2020-04-25 08:36:54 AUDIT audit:97 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946951971615262","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-25 08:36:54 AUDIT audit:74 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946951975940233","opStatus":"START"}
2020-04-25 08:36:54 AUDIT audit:97 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946951975940233","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-25 08:36:54 AUDIT audit:74 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946951980274363","opStatus":"START"}
2020-04-25 08:36:54 AUDIT audit:97 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946951980274363","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-25 08:36:54 AUDIT audit:74 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946951984551227","opStatus":"START"}
2020-04-25 08:36:54 AUDIT audit:97 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946951984551227","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-25 08:36:54 AUDIT audit:74 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946951988963619","opStatus":"START"}
2020-04-25 08:36:54 AUDIT audit:97 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946951988963619","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-25 08:36:54 AUDIT audit:74 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946951993246288","opStatus":"START"}
2020-04-25 08:36:54 AUDIT audit:97 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946951993246288","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag1"}}
2020-04-25 08:36:54 AUDIT audit:74 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946951997501368","opStatus":"START"}
2020-04-25 08:36:54 AUDIT audit:97 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946951997501368","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-25 08:36:54 AUDIT audit:74 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946952001786966","opStatus":"START"}
2020-04-25 08:36:54 AUDIT audit:97 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946952001786966","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-25 08:36:54 AUDIT audit:74 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946952006073380","opStatus":"START"}
2020-04-25 08:36:54 AUDIT audit:97 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946952006073380","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-25 08:36:54 AUDIT audit:74 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946952010326299","opStatus":"START"}
2020-04-25 08:36:54 AUDIT audit:97 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946952010326299","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-25 08:36:54 AUDIT audit:74 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946952023429191","opStatus":"START"}
2020-04-25 08:36:54 AUDIT audit:97 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946952023429191","opStatus":"SUCCESS","opTime":"62 ms","table":"NA","extraInfo":{}}
2020-04-25 08:36:54 AUDIT audit:74 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6946952175419470","opStatus":"START"}
2020-04-25 08:36:54 AUDIT audit:97 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6946952175419470","opStatus":"SUCCESS","opTime":"380 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-25 08:36:54 AUDIT audit:74 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946952557835415","opStatus":"START"}
2020-04-25 08:36:54 AUDIT audit:97 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946952557835415","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-25 08:36:54 AUDIT audit:74 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6946952563028240","opStatus":"START"}
2020-04-25 08:36:54 AUDIT audit:74 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946952583635321","opStatus":"START"}
2020-04-25 08:36:54 AUDIT audit:74 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946952589960684","opStatus":"START"}
2020-04-25 08:36:54 AUDIT audit:97 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946952589960684","opStatus":"SUCCESS","opTime":"37 ms","table":"NA","extraInfo":{}}
2020-04-25 08:36:54 AUDIT audit:97 - {"time":"April 25, 2020 1:36:54 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946952583635321","opStatus":"SUCCESS","opTime":"46 ms","table":"partition_mv.dm1","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-25 08:36:55 AUDIT audit:74 - {"time":"April 25, 2020 1:36:55 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6946952836919119","opStatus":"START"}
2020-04-25 08:36:57 AUDIT audit:97 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6946952836919119","opStatus":"SUCCESS","opTime":"2099 ms","table":"partition_mv.dm1","extraInfo":{}}
2020-04-25 08:36:57 AUDIT audit:97 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6946952563028240","opStatus":"SUCCESS","opTime":"2372 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-25 08:36:57 AUDIT audit:74 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6946955485262208","opStatus":"START"}
2020-04-25 08:36:57 AUDIT audit:97 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6946955485262208","opStatus":"SUCCESS","opTime":"184 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- test partition at last column[0m
2020-04-25 08:36:57 AUDIT audit:74 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946955680817144","opStatus":"START"}
2020-04-25 08:36:57 AUDIT audit:97 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946955680817144","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-25 08:36:57 AUDIT audit:74 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946955685296462","opStatus":"START"}
2020-04-25 08:36:57 AUDIT audit:97 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946955685296462","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-25 08:36:57 AUDIT audit:74 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946955689594518","opStatus":"START"}
2020-04-25 08:36:57 AUDIT audit:97 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946955689594518","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-25 08:36:57 AUDIT audit:74 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946955693866416","opStatus":"START"}
2020-04-25 08:36:57 AUDIT audit:97 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946955693866416","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-25 08:36:57 AUDIT audit:74 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946955698135267","opStatus":"START"}
2020-04-25 08:36:57 AUDIT audit:97 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946955698135267","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-25 08:36:57 AUDIT audit:74 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946955702426958","opStatus":"START"}
2020-04-25 08:36:57 AUDIT audit:97 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946955702426958","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-25 08:36:57 AUDIT audit:74 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946955706753589","opStatus":"START"}
2020-04-25 08:36:57 AUDIT audit:97 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946955706753589","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-25 08:36:57 AUDIT audit:74 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946955711034484","opStatus":"START"}
2020-04-25 08:36:57 AUDIT audit:97 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946955711034484","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag1"}}
2020-04-25 08:36:57 AUDIT audit:74 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946955715345513","opStatus":"START"}
2020-04-25 08:36:57 AUDIT audit:97 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946955715345513","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-25 08:36:57 AUDIT audit:74 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946955719622594","opStatus":"START"}
2020-04-25 08:36:57 AUDIT audit:97 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946955719622594","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-25 08:36:57 AUDIT audit:74 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946955723921003","opStatus":"START"}
2020-04-25 08:36:57 AUDIT audit:97 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946955723921003","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-25 08:36:57 AUDIT audit:74 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946955728189838","opStatus":"START"}
2020-04-25 08:36:57 AUDIT audit:97 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946955728189838","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-25 08:36:57 AUDIT audit:74 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946955741793224","opStatus":"START"}
2020-04-25 08:36:57 AUDIT audit:97 - {"time":"April 25, 2020 1:36:57 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946955741793224","opStatus":"SUCCESS","opTime":"41 ms","table":"NA","extraInfo":{}}
2020-04-25 08:36:58 AUDIT audit:74 - {"time":"April 25, 2020 1:36:58 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6946955871622340","opStatus":"START"}
2020-04-25 08:36:58 AUDIT audit:97 - {"time":"April 25, 2020 1:36:58 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6946955871622340","opStatus":"SUCCESS","opTime":"395 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-25 08:36:58 AUDIT audit:74 - {"time":"April 25, 2020 1:36:58 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946956268431954","opStatus":"START"}
2020-04-25 08:36:58 AUDIT audit:97 - {"time":"April 25, 2020 1:36:58 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946956268431954","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-25 08:36:58 AUDIT audit:74 - {"time":"April 25, 2020 1:36:58 AM PDT","username":"jenkins","opName":"DESC FORMATTED","opId":"6946956347807236","opStatus":"START"}
2020-04-25 08:36:58 ERROR CarbonUtil:2444 - Unable to unlock Table lock for table during table status updation
2020-04-25 08:36:58 AUDIT audit:97 - {"time":"April 25, 2020 1:36:58 AM PDT","username":"jenkins","opName":"DESC FORMATTED","opId":"6946956347807236","opStatus":"SUCCESS","opTime":"34 ms","table":"partition_mv.partitionone","extraInfo":{}}
+-----------------------------+-----------------------------------------------------------------------------------------------------------------------+-------+
|col_name |data_type |comment|
+-----------------------------+-----------------------------------------------------------------------------------------------------------------------+-------+
|a |int |null |
|b |int |null |
|c |timestamp |null |
|d |timestamp |null |
| | | |
|## Detailed Table Information| | |
|Database |partition_mv | |
|Table |partitionone | |
|Owner |jenkins | |
|Created |Sat Apr 25 01:36:57 PDT 2020 | |
|Location |<https://builds.apache.org/job/carbondata-master-spark-2.3/org.apache.carbondata$carbondata-mv-core/ws/target/warehouse/partition_mv.db/partitionone|> |
|External |false | |
|Transactional |true | |
|Streaming |false | |
|Table Block Size |1024 MB | |
|Table Blocklet Size |64 MB | |
|Comment | | |
|Bad Record Path | | |
|Min Input Per Node Per Load |0.0B | |
| | | |
|## Index Information | | |
|Sort Scope |NO_SORT | |
|Sort Columns | | |
|Inverted Index Columns | | |
|Cached Min/Max Index Columns |All columns | |
|Min/Max Index Cache Level |BLOCK | |
|Table page size in mb | | |
| | | |
|## Encoding Information | | |
|Local Dictionary Enabled |true | |
|Local Dictionary Threshold |10000 | |
|Local Dictionary Include | | |
| | | |
|## Compaction Information | | |
|MAJOR_COMPACTION_SIZE |1024 | |
|AUTO_LOAD_MERGE |false | |
|COMPACTION_LEVEL_THRESHOLD |4,3 | |
|COMPACTION_PRESERVE_SEGMENTS |0 | |
|ALLOWED_COMPACTION_DAYS |0 | |
| | | |
|## Partition Information | | |
|Partition Type |NATIVE_HIVE | |
|Partition Columns |c:TIMESTAMP, d:TIMESTAMP | |
|Number of Partitions |1 | |
| | | |
|## Dynamic Information | | |
|Table Data Size |1.10KB | |
|Table Index Size |705.0B | |
|Last Update |Sat Apr 25 01:36:58 PDT 2020 | |
+-----------------------------+-----------------------------------------------------------------------------------------------------------------------+-------+
2020-04-25 08:36:58 AUDIT audit:74 - {"time":"April 25, 2020 1:36:58 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6946956428904373","opStatus":"START"}
2020-04-25 08:36:58 AUDIT audit:74 - {"time":"April 25, 2020 1:36:58 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946956454162476","opStatus":"START"}
2020-04-25 08:36:58 AUDIT audit:74 - {"time":"April 25, 2020 1:36:58 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946956460930841","opStatus":"START"}
2020-04-25 08:36:58 AUDIT audit:97 - {"time":"April 25, 2020 1:36:58 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946956460930841","opStatus":"SUCCESS","opTime":"35 ms","table":"NA","extraInfo":{}}
2020-04-25 08:36:58 AUDIT audit:97 - {"time":"April 25, 2020 1:36:58 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946956454162476","opStatus":"SUCCESS","opTime":"44 ms","table":"partition_mv.dm1","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-25 08:36:58 AUDIT audit:74 - {"time":"April 25, 2020 1:36:58 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6946956655828036","opStatus":"START"}
2020-04-25 08:36:59 AUDIT audit:97 - {"time":"April 25, 2020 1:36:59 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6946956655828036","opStatus":"SUCCESS","opTime":"824 ms","table":"partition_mv.dm1","extraInfo":{"SegmentId":"0","DataSize":"688.0B","IndexSize":"454.0B"}}
2020-04-25 08:36:59 AUDIT audit:97 - {"time":"April 25, 2020 1:36:59 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6946956428904373","opStatus":"SUCCESS","opTime":"1049 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-25 08:37:00 AUDIT audit:74 - {"time":"April 25, 2020 1:37:00 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6946957979202982","opStatus":"START"}
2020-04-25 08:37:00 AUDIT audit:97 - {"time":"April 25, 2020 1:37:00 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6946957979202982","opStatus":"SUCCESS","opTime":"162 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-25 08:37:00 AUDIT audit:74 - {"time":"April 25, 2020 1:37:00 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946958146457865","opStatus":"START"}
2020-04-25 08:37:00 AUDIT audit:97 - {"time":"April 25, 2020 1:37:00 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946958146457865","opStatus":"SUCCESS","opTime":"42 ms","table":"NA","extraInfo":{}}
2020-04-25 08:37:00 AUDIT audit:74 - {"time":"April 25, 2020 1:37:00 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6946958273717751","opStatus":"START"}
2020-04-25 08:37:00 AUDIT audit:97 - {"time":"April 25, 2020 1:37:00 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6946958273717751","opStatus":"SUCCESS","opTime":"368 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-25 08:37:00 AUDIT audit:74 - {"time":"April 25, 2020 1:37:00 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946958643781479","opStatus":"START"}
2020-04-25 08:37:00 AUDIT audit:97 - {"time":"April 25, 2020 1:37:00 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6946958643781479","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-25 08:37:00 AUDIT audit:74 - {"time":"April 25, 2020 1:37:00 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6946958649415363","opStatus":"START"}
2020-04-25 08:37:00 AUDIT audit:74 - {"time":"April 25, 2020 1:37:00 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946958671057804","opStatus":"START"}
2020-04-25 08:37:00 AUDIT audit:74 - {"time":"April 25, 2020 1:37:00 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946958677514018","opStatus":"START"}
2020-04-25 08:37:00 AUDIT audit:97 - {"time":"April 25, 2020 1:37:00 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946958677514018","opStatus":"SUCCESS","opTime":"52 ms","table":"NA","extraInfo":{}}
2020-04-25 08:37:00 AUDIT audit:97 - {"time":"April 25, 2020 1:37:00 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6946958671057804","opStatus":"SUCCESS","opTime":"61 ms","table":"partition_mv.dm1","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-25 08:37:01 AUDIT audit:74 - {"time":"April 25, 2020 1:37:01 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6946958907110718","opStatus":"START"}
2020-04-25 08:37:03 AUDIT audit:97 - {"time":"April 25, 2020 1:37:03 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6946958907110718","opStatus":"SUCCESS","opTime":"2087 ms","table":"partition_mv.dm1","extraInfo":{}}
2020-04-25 08:37:03 AUDIT audit:97 - {"time":"April 25, 2020 1:37:03 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6946958649415363","opStatus":"SUCCESS","opTime":"2343 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-25 08:37:03 AUDIT audit:74 - {"time":"April 25, 2020 1:37:03 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6946961483130577","opStatus":"START"}
2020-04-25 08:37:03 AUDIT audit:97 - {"time":"April 25, 2020 1:37:03 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6946961483130577","opStatus":"SUCCESS","opTime":"199 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- test partition on timeseries column[0m
2020-04-25 08:37:03 AUDIT audit:74 - {"time":"April 25, 2020 1:37:03 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6946961827880840","opStatus":"START"}
2020-04-25 08:37:04 AUDIT audit:97 - {"time":"April 25, 2020 1:37:04 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6946961827880840","opStatus":"SUCCESS","opTime":"92 ms","table":"partition_mv.droppartition","extraInfo":{}}
2020-04-25 08:37:04 AUDIT audit:74 - {"time":"April 25, 2020 1:37:04 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6946961919503424","opStatus":"START"}
2020-04-25 08:37:04 AUDIT audit:97 - {"time":"April 25, 2020 1:37:04 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6946961919503424","opStatus":"SUCCESS","opTime":"177 ms","table":"partition_mv.maintable","extraInfo":{}}
2020-04-25 08:37:04 AUDIT audit:74 - {"time":"April 25, 2020 1:37:04 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6946962096974855","opStatus":"START"}
2020-04-25 08:37:04 AUDIT audit:97 - {"time":"April 25, 2020 1:37:04 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6946962096974855","opStatus":"SUCCESS","opTime":"101 ms","table":"partition_mv.par","extraInfo":{}}
2020-04-25 08:37:04 AUDIT audit:74 - {"time":"April 25, 2020 1:37:04 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6946962198249070","opStatus":"START"}
2020-04-25 08:37:04 AUDIT audit:97 - {"time":"April 25, 2020 1:37:04 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6946962198249070","opStatus":"SUCCESS","opTime":"105 ms","table":"partition_mv.partitiontable","extraInfo":{}}
[32mMVTPCDSTestCase:[0m
[33m- test create materialized view with tpcds_1_4_testCases case_1 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_3 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_4 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_5 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_6 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_8 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_11 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_15 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_16 !!! IGNORED !!![0m
[32mIsSPJGHSuite:[0m
[32m- project only[0m
[32m- groupby-project[0m
[32m- groupby-project-filter[0m
[32m- groupby-project-filter-join[0m
[32mLogicalToModularPlanSuite:[0m
[32m- select only[0m
[32m- select-project-groupby grouping without aggregate function[0m
[32m- select-project with filter[0m
[32m- join[0m
[32m- left outer join[0m
[32m- right outer join[0m
[33m- joins: conjunctive predicates #1 with alias !!! IGNORED !!![0m
[33m- joins: conjunctive predicates #2 with alias !!! IGNORED !!![0m
[33m- SPJGH query !!! IGNORED !!![0m
[33m- non-SPJGH query !!! IGNORED !!![0m
[36mRun completed in 14 minutes, 43 seconds.[0m
[36mTotal number of tests run: 268[0m
[36mSuites: completed 28, aborted 0[0m
[36mTests: succeeded 266, failed 2, canceled 0, ignored 25, pending 0[0m
[31m*** 2 TESTS FAILED ***[0m
[JENKINS] Recording test results
Build failed in Jenkins: carbondata-master-spark-2.3 » Apache CarbonData :: Materialized View Core #2213
Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://builds.apache.org/job/carbondata-master-spark-2.3/org.apache.carbondata$carbondata-mv-core/2213/display/redirect>
Changes:
------------------------------------------
[...truncated 1.53 MB...]
2020-04-24 09:34:05 AUDIT audit:97 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863983092072656","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-24 09:34:05 AUDIT audit:74 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863983096504862","opStatus":"START"}
2020-04-24 09:34:05 AUDIT audit:97 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863983096504862","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-24 09:34:05 AUDIT audit:74 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863983100917314","opStatus":"START"}
2020-04-24 09:34:05 AUDIT audit:97 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863983100917314","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-24 09:34:05 AUDIT audit:74 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863983105324043","opStatus":"START"}
2020-04-24 09:34:05 AUDIT audit:97 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863983105324043","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-24 09:34:05 AUDIT audit:74 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863983121507364","opStatus":"START"}
2020-04-24 09:34:05 AUDIT audit:97 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863983121507364","opStatus":"SUCCESS","opTime":"71 ms","table":"NA","extraInfo":{}}
2020-04-24 09:34:05 AUDIT audit:74 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6863983195050687","opStatus":"START"}
2020-04-24 09:34:05 AUDIT audit:74 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863983223390876","opStatus":"START"}
2020-04-24 09:34:05 AUDIT audit:74 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863983230332876","opStatus":"START"}
2020-04-24 09:34:05 AUDIT audit:97 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863983230332876","opStatus":"SUCCESS","opTime":"40 ms","table":"NA","extraInfo":{}}
2020-04-24 09:34:05 AUDIT audit:97 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863983223390876","opStatus":"SUCCESS","opTime":"49 ms","table":"partition_mv.p7","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 09:34:05 AUDIT audit:97 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6863983195050687","opStatus":"SUCCESS","opTime":"247 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-24 09:34:05 AUDIT audit:74 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6863983447076150","opStatus":"START"}
2020-04-24 09:34:05 AUDIT audit:74 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863983469208299","opStatus":"START"}
2020-04-24 09:34:05 AUDIT audit:74 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863983475536635","opStatus":"START"}
2020-04-24 09:34:05 AUDIT audit:97 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863983475536635","opStatus":"SUCCESS","opTime":"37 ms","table":"NA","extraInfo":{}}
2020-04-24 09:34:05 AUDIT audit:97 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863983469208299","opStatus":"SUCCESS","opTime":"44 ms","table":"partition_mv.p1","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 09:34:05 AUDIT audit:97 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6863983447076150","opStatus":"SUCCESS","opTime":"227 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-24 09:34:05 AUDIT audit:74 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6863983679867208","opStatus":"START"}
2020-04-24 09:34:05 AUDIT audit:74 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863983702940280","opStatus":"START"}
2020-04-24 09:34:05 AUDIT audit:74 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863983709585056","opStatus":"START"}
2020-04-24 09:34:05 AUDIT audit:97 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863983709585056","opStatus":"SUCCESS","opTime":"69 ms","table":"NA","extraInfo":{}}
2020-04-24 09:34:05 AUDIT audit:97 - {"time":"April 24, 2020 2:34:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863983702940280","opStatus":"SUCCESS","opTime":"79 ms","table":"partition_mv.p2","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 09:34:06 AUDIT audit:97 - {"time":"April 24, 2020 2:34:06 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6863983679867208","opStatus":"SUCCESS","opTime":"270 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-24 09:34:06 AUDIT audit:74 - {"time":"April 24, 2020 2:34:06 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6863983955657728","opStatus":"START"}
2020-04-24 09:34:06 AUDIT audit:74 - {"time":"April 24, 2020 2:34:06 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863983980575951","opStatus":"START"}
2020-04-24 09:34:06 AUDIT audit:74 - {"time":"April 24, 2020 2:34:06 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863983987408073","opStatus":"START"}
2020-04-24 09:34:06 AUDIT audit:97 - {"time":"April 24, 2020 2:34:06 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863983987408073","opStatus":"SUCCESS","opTime":"42 ms","table":"NA","extraInfo":{}}
2020-04-24 09:34:06 AUDIT audit:97 - {"time":"April 24, 2020 2:34:06 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863983980575951","opStatus":"SUCCESS","opTime":"50 ms","table":"partition_mv.p3","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 09:34:06 AUDIT audit:97 - {"time":"April 24, 2020 2:34:06 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6863983955657728","opStatus":"SUCCESS","opTime":"239 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-24 09:34:06 AUDIT audit:74 - {"time":"April 24, 2020 2:34:06 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6863984200756025","opStatus":"START"}
2020-04-24 09:34:06 AUDIT audit:74 - {"time":"April 24, 2020 2:34:06 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863984228461918","opStatus":"START"}
2020-04-24 09:34:06 AUDIT audit:74 - {"time":"April 24, 2020 2:34:06 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863984235340959","opStatus":"START"}
2020-04-24 09:34:06 AUDIT audit:97 - {"time":"April 24, 2020 2:34:06 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863984235340959","opStatus":"SUCCESS","opTime":"41 ms","table":"NA","extraInfo":{}}
2020-04-24 09:34:06 AUDIT audit:97 - {"time":"April 24, 2020 2:34:06 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863984228461918","opStatus":"SUCCESS","opTime":"50 ms","table":"partition_mv.p4","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 09:34:06 AUDIT audit:97 - {"time":"April 24, 2020 2:34:06 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6863984200756025","opStatus":"SUCCESS","opTime":"243 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-24 09:34:06 AUDIT audit:74 - {"time":"April 24, 2020 2:34:06 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6863984449913366","opStatus":"START"}
2020-04-24 09:34:06 AUDIT audit:74 - {"time":"April 24, 2020 2:34:06 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863984473890388","opStatus":"START"}
2020-04-24 09:34:06 AUDIT audit:74 - {"time":"April 24, 2020 2:34:06 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863984480524321","opStatus":"START"}
2020-04-24 09:34:06 AUDIT audit:97 - {"time":"April 24, 2020 2:34:06 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863984480524321","opStatus":"SUCCESS","opTime":"41 ms","table":"NA","extraInfo":{}}
2020-04-24 09:34:06 AUDIT audit:97 - {"time":"April 24, 2020 2:34:06 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863984473890388","opStatus":"SUCCESS","opTime":"50 ms","table":"partition_mv.p5","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 09:34:06 AUDIT audit:97 - {"time":"April 24, 2020 2:34:06 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6863984449913366","opStatus":"SUCCESS","opTime":"230 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-24 09:34:06 AUDIT audit:74 - {"time":"April 24, 2020 2:34:06 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6863984686075131","opStatus":"START"}
2020-04-24 09:34:06 AUDIT audit:74 - {"time":"April 24, 2020 2:34:06 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863984711374720","opStatus":"START"}
2020-04-24 09:34:06 AUDIT audit:74 - {"time":"April 24, 2020 2:34:06 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863984718106074","opStatus":"START"}
2020-04-24 09:34:06 AUDIT audit:97 - {"time":"April 24, 2020 2:34:06 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863984718106074","opStatus":"SUCCESS","opTime":"42 ms","table":"NA","extraInfo":{}}
2020-04-24 09:34:06 AUDIT audit:97 - {"time":"April 24, 2020 2:34:06 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863984711374720","opStatus":"SUCCESS","opTime":"51 ms","table":"partition_mv.p6","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 09:34:07 AUDIT audit:97 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6863984686075131","opStatus":"SUCCESS","opTime":"293 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-24 09:34:07 AUDIT audit:74 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6863985144109099","opStatus":"START"}
2020-04-24 09:34:07 AUDIT audit:97 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6863985144109099","opStatus":"SUCCESS","opTime":"526 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- check partitioning for child tables with various combinations[0m
2020-04-24 09:34:07 AUDIT audit:74 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863985682179292","opStatus":"START"}
2020-04-24 09:34:07 AUDIT audit:97 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863985682179292","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-24 09:34:07 AUDIT audit:74 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863985686810901","opStatus":"START"}
2020-04-24 09:34:07 AUDIT audit:97 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863985686810901","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-24 09:34:07 AUDIT audit:74 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863985691241214","opStatus":"START"}
2020-04-24 09:34:07 AUDIT audit:97 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863985691241214","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-24 09:34:07 AUDIT audit:74 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863985695690271","opStatus":"START"}
2020-04-24 09:34:07 AUDIT audit:97 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863985695690271","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-24 09:34:07 AUDIT audit:74 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863985700207617","opStatus":"START"}
2020-04-24 09:34:07 AUDIT audit:97 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863985700207617","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-24 09:34:07 AUDIT audit:74 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863985704638774","opStatus":"START"}
2020-04-24 09:34:07 AUDIT audit:97 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863985704638774","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-24 09:34:07 AUDIT audit:74 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863985709130094","opStatus":"START"}
2020-04-24 09:34:07 AUDIT audit:97 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863985709130094","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-24 09:34:07 AUDIT audit:74 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863985713582122","opStatus":"START"}
2020-04-24 09:34:07 AUDIT audit:97 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863985713582122","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag1"}}
2020-04-24 09:34:07 AUDIT audit:74 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863985718046155","opStatus":"START"}
2020-04-24 09:34:07 AUDIT audit:97 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863985718046155","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-24 09:34:07 AUDIT audit:74 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863985722490272","opStatus":"START"}
2020-04-24 09:34:07 AUDIT audit:97 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863985722490272","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-24 09:34:07 AUDIT audit:74 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863985726925667","opStatus":"START"}
2020-04-24 09:34:07 AUDIT audit:97 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863985726925667","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-24 09:34:07 AUDIT audit:74 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863985731381080","opStatus":"START"}
2020-04-24 09:34:07 AUDIT audit:97 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863985731381080","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-24 09:34:07 AUDIT audit:74 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863985744886858","opStatus":"START"}
2020-04-24 09:34:07 AUDIT audit:97 - {"time":"April 24, 2020 2:34:07 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863985744886858","opStatus":"SUCCESS","opTime":"60 ms","table":"NA","extraInfo":{}}
2020-04-24 09:34:08 AUDIT audit:74 - {"time":"April 24, 2020 2:34:08 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6863985896936514","opStatus":"START"}
2020-04-24 09:34:08 AUDIT audit:97 - {"time":"April 24, 2020 2:34:08 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6863985896936514","opStatus":"SUCCESS","opTime":"379 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-24 09:34:08 AUDIT audit:74 - {"time":"April 24, 2020 2:34:08 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863986277280352","opStatus":"START"}
2020-04-24 09:34:08 AUDIT audit:97 - {"time":"April 24, 2020 2:34:08 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863986277280352","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-24 09:34:08 AUDIT audit:74 - {"time":"April 24, 2020 2:34:08 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6863986282638318","opStatus":"START"}
2020-04-24 09:34:08 AUDIT audit:74 - {"time":"April 24, 2020 2:34:08 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863986304377604","opStatus":"START"}
2020-04-24 09:34:08 AUDIT audit:74 - {"time":"April 24, 2020 2:34:08 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863986310869482","opStatus":"START"}
2020-04-24 09:34:08 AUDIT audit:97 - {"time":"April 24, 2020 2:34:08 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863986310869482","opStatus":"SUCCESS","opTime":"35 ms","table":"NA","extraInfo":{}}
2020-04-24 09:34:08 AUDIT audit:97 - {"time":"April 24, 2020 2:34:08 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863986304377604","opStatus":"SUCCESS","opTime":"44 ms","table":"partition_mv.dm1","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 09:34:08 AUDIT audit:74 - {"time":"April 24, 2020 2:34:08 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6863986541286940","opStatus":"START"}
2020-04-24 09:34:10 AUDIT audit:97 - {"time":"April 24, 2020 2:34:10 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6863986541286940","opStatus":"SUCCESS","opTime":"2217 ms","table":"partition_mv.dm1","extraInfo":{}}
2020-04-24 09:34:10 AUDIT audit:97 - {"time":"April 24, 2020 2:34:10 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6863986282638318","opStatus":"SUCCESS","opTime":"2476 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-24 09:34:11 AUDIT audit:74 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6863989271915191","opStatus":"START"}
2020-04-24 09:34:11 AUDIT audit:97 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6863989271915191","opStatus":"SUCCESS","opTime":"191 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- test partition at last column[0m
2020-04-24 09:34:11 AUDIT audit:74 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863989475095416","opStatus":"START"}
2020-04-24 09:34:11 AUDIT audit:97 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863989475095416","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-24 09:34:11 AUDIT audit:74 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863989479805946","opStatus":"START"}
2020-04-24 09:34:11 AUDIT audit:97 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863989479805946","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-24 09:34:11 AUDIT audit:74 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863989484290401","opStatus":"START"}
2020-04-24 09:34:11 AUDIT audit:97 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863989484290401","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-24 09:34:11 AUDIT audit:74 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863989488801284","opStatus":"START"}
2020-04-24 09:34:11 AUDIT audit:97 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863989488801284","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-24 09:34:11 AUDIT audit:74 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863989493280569","opStatus":"START"}
2020-04-24 09:34:11 AUDIT audit:97 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863989493280569","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-24 09:34:11 AUDIT audit:74 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863989497760322","opStatus":"START"}
2020-04-24 09:34:11 AUDIT audit:97 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863989497760322","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-24 09:34:11 AUDIT audit:74 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863989502210668","opStatus":"START"}
2020-04-24 09:34:11 AUDIT audit:97 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863989502210668","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-24 09:34:11 AUDIT audit:74 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863989506660713","opStatus":"START"}
2020-04-24 09:34:11 AUDIT audit:97 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863989506660713","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag1"}}
2020-04-24 09:34:11 AUDIT audit:74 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863989511097145","opStatus":"START"}
2020-04-24 09:34:11 AUDIT audit:97 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863989511097145","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-24 09:34:11 AUDIT audit:74 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863989515552894","opStatus":"START"}
2020-04-24 09:34:11 AUDIT audit:97 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863989515552894","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-24 09:34:11 AUDIT audit:74 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863989519974504","opStatus":"START"}
2020-04-24 09:34:11 AUDIT audit:97 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863989519974504","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-24 09:34:11 AUDIT audit:74 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863989524483878","opStatus":"START"}
2020-04-24 09:34:11 AUDIT audit:97 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863989524483878","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-24 09:34:11 AUDIT audit:74 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863989538046356","opStatus":"START"}
2020-04-24 09:34:11 AUDIT audit:97 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863989538046356","opStatus":"SUCCESS","opTime":"34 ms","table":"NA","extraInfo":{}}
2020-04-24 09:34:11 AUDIT audit:74 - {"time":"April 24, 2020 2:34:11 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6863989648786634","opStatus":"START"}
2020-04-24 09:34:12 AUDIT audit:97 - {"time":"April 24, 2020 2:34:12 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6863989648786634","opStatus":"SUCCESS","opTime":"411 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-24 09:34:12 AUDIT audit:74 - {"time":"April 24, 2020 2:34:12 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863990061208694","opStatus":"START"}
2020-04-24 09:34:12 AUDIT audit:97 - {"time":"April 24, 2020 2:34:12 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863990061208694","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-24 09:34:12 AUDIT audit:74 - {"time":"April 24, 2020 2:34:12 AM PDT","username":"jenkins","opName":"DESC FORMATTED","opId":"6863990141422010","opStatus":"START"}
2020-04-24 09:34:12 ERROR CarbonUtil:2444 - Unable to unlock Table lock for table during table status updation
2020-04-24 09:34:12 AUDIT audit:97 - {"time":"April 24, 2020 2:34:12 AM PDT","username":"jenkins","opName":"DESC FORMATTED","opId":"6863990141422010","opStatus":"SUCCESS","opTime":"34 ms","table":"partition_mv.partitionone","extraInfo":{}}
+-----------------------------+-----------------------------------------------------------------------------------------------------------------------+-------+
|col_name |data_type |comment|
+-----------------------------+-----------------------------------------------------------------------------------------------------------------------+-------+
|a |int |null |
|b |int |null |
|c |timestamp |null |
|d |timestamp |null |
| | | |
|## Detailed Table Information| | |
|Database |partition_mv | |
|Table |partitionone | |
|Owner |jenkins | |
|Created |Fri Apr 24 02:34:11 PDT 2020 | |
|Location |<https://builds.apache.org/job/carbondata-master-spark-2.3/org.apache.carbondata$carbondata-mv-core/ws/target/warehouse/partition_mv.db/partitionone|> |
|External |false | |
|Transactional |true | |
|Streaming |false | |
|Table Block Size |1024 MB | |
|Table Blocklet Size |64 MB | |
|Comment | | |
|Bad Record Path | | |
|Min Input Per Node Per Load |0.0B | |
| | | |
|## Index Information | | |
|Sort Scope |NO_SORT | |
|Sort Columns | | |
|Inverted Index Columns | | |
|Cached Min/Max Index Columns |All columns | |
|Min/Max Index Cache Level |BLOCK | |
|Table page size in mb | | |
| | | |
|## Encoding Information | | |
|Local Dictionary Enabled |true | |
|Local Dictionary Threshold |10000 | |
|Local Dictionary Include | | |
| | | |
|## Compaction Information | | |
|MAJOR_COMPACTION_SIZE |1024 | |
|AUTO_LOAD_MERGE |false | |
|COMPACTION_LEVEL_THRESHOLD |4,3 | |
|COMPACTION_PRESERVE_SEGMENTS |0 | |
|ALLOWED_COMPACTION_DAYS |0 | |
| | | |
|## Partition Information | | |
|Partition Type |NATIVE_HIVE | |
|Partition Columns |c:TIMESTAMP, d:TIMESTAMP | |
|Number of Partitions |1 | |
| | | |
|## Dynamic Information | | |
|Table Data Size |1.10KB | |
|Table Index Size |705.0B | |
|Last Update |Fri Apr 24 02:34:12 PDT 2020 | |
+-----------------------------+-----------------------------------------------------------------------------------------------------------------------+-------+
2020-04-24 09:34:12 AUDIT audit:74 - {"time":"April 24, 2020 2:34:12 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6863990221899224","opStatus":"START"}
2020-04-24 09:34:12 AUDIT audit:74 - {"time":"April 24, 2020 2:34:12 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863990246304618","opStatus":"START"}
2020-04-24 09:34:12 AUDIT audit:74 - {"time":"April 24, 2020 2:34:12 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863990252720593","opStatus":"START"}
2020-04-24 09:34:12 AUDIT audit:97 - {"time":"April 24, 2020 2:34:12 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863990252720593","opStatus":"SUCCESS","opTime":"35 ms","table":"NA","extraInfo":{}}
2020-04-24 09:34:12 AUDIT audit:97 - {"time":"April 24, 2020 2:34:12 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863990246304618","opStatus":"SUCCESS","opTime":"44 ms","table":"partition_mv.dm1","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 09:34:12 AUDIT audit:74 - {"time":"April 24, 2020 2:34:12 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6863990458705983","opStatus":"START"}
2020-04-24 09:34:13 AUDIT audit:97 - {"time":"April 24, 2020 2:34:13 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6863990458705983","opStatus":"SUCCESS","opTime":"809 ms","table":"partition_mv.dm1","extraInfo":{"SegmentId":"0","DataSize":"688.0B","IndexSize":"454.0B"}}
2020-04-24 09:34:13 AUDIT audit:97 - {"time":"April 24, 2020 2:34:13 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6863990221899224","opStatus":"SUCCESS","opTime":"1044 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-24 09:34:13 AUDIT audit:74 - {"time":"April 24, 2020 2:34:13 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6863991789078394","opStatus":"START"}
2020-04-24 09:34:14 AUDIT audit:97 - {"time":"April 24, 2020 2:34:14 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6863991789078394","opStatus":"SUCCESS","opTime":"168 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-24 09:34:14 AUDIT audit:74 - {"time":"April 24, 2020 2:34:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863991962722202","opStatus":"START"}
2020-04-24 09:34:14 AUDIT audit:97 - {"time":"April 24, 2020 2:34:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863991962722202","opStatus":"SUCCESS","opTime":"39 ms","table":"NA","extraInfo":{}}
2020-04-24 09:34:14 AUDIT audit:74 - {"time":"April 24, 2020 2:34:14 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6863992080831207","opStatus":"START"}
2020-04-24 09:34:14 AUDIT audit:97 - {"time":"April 24, 2020 2:34:14 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6863992080831207","opStatus":"SUCCESS","opTime":"387 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-24 09:34:14 AUDIT audit:74 - {"time":"April 24, 2020 2:34:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863992469256314","opStatus":"START"}
2020-04-24 09:34:14 AUDIT audit:97 - {"time":"April 24, 2020 2:34:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6863992469256314","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-24 09:34:14 AUDIT audit:74 - {"time":"April 24, 2020 2:34:14 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6863992474922113","opStatus":"START"}
2020-04-24 09:34:14 AUDIT audit:74 - {"time":"April 24, 2020 2:34:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863992496836033","opStatus":"START"}
2020-04-24 09:34:14 AUDIT audit:74 - {"time":"April 24, 2020 2:34:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863992503420714","opStatus":"START"}
2020-04-24 09:34:14 AUDIT audit:97 - {"time":"April 24, 2020 2:34:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863992503420714","opStatus":"SUCCESS","opTime":"52 ms","table":"NA","extraInfo":{}}
2020-04-24 09:34:14 AUDIT audit:97 - {"time":"April 24, 2020 2:34:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6863992496836033","opStatus":"SUCCESS","opTime":"61 ms","table":"partition_mv.dm1","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 09:34:14 AUDIT audit:74 - {"time":"April 24, 2020 2:34:14 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6863992724037336","opStatus":"START"}
2020-04-24 09:34:16 AUDIT audit:97 - {"time":"April 24, 2020 2:34:16 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6863992724037336","opStatus":"SUCCESS","opTime":"2063 ms","table":"partition_mv.dm1","extraInfo":{}}
2020-04-24 09:34:16 AUDIT audit:97 - {"time":"April 24, 2020 2:34:16 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6863992474922113","opStatus":"SUCCESS","opTime":"2310 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-24 09:34:17 AUDIT audit:74 - {"time":"April 24, 2020 2:34:17 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6863995281293973","opStatus":"START"}
2020-04-24 09:34:17 AUDIT audit:97 - {"time":"April 24, 2020 2:34:17 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6863995281293973","opStatus":"SUCCESS","opTime":"188 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- test partition on timeseries column[0m
2020-04-24 09:34:17 AUDIT audit:74 - {"time":"April 24, 2020 2:34:17 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6863995607527700","opStatus":"START"}
2020-04-24 09:34:17 AUDIT audit:97 - {"time":"April 24, 2020 2:34:17 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6863995607527700","opStatus":"SUCCESS","opTime":"93 ms","table":"partition_mv.droppartition","extraInfo":{}}
2020-04-24 09:34:17 AUDIT audit:74 - {"time":"April 24, 2020 2:34:17 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6863995701030237","opStatus":"START"}
2020-04-24 09:34:18 AUDIT audit:97 - {"time":"April 24, 2020 2:34:18 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6863995701030237","opStatus":"SUCCESS","opTime":"153 ms","table":"partition_mv.maintable","extraInfo":{}}
2020-04-24 09:34:18 AUDIT audit:74 - {"time":"April 24, 2020 2:34:18 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6863995853960883","opStatus":"START"}
2020-04-24 09:34:18 AUDIT audit:97 - {"time":"April 24, 2020 2:34:18 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6863995853960883","opStatus":"SUCCESS","opTime":"99 ms","table":"partition_mv.par","extraInfo":{}}
2020-04-24 09:34:18 AUDIT audit:74 - {"time":"April 24, 2020 2:34:18 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6863995952999640","opStatus":"START"}
2020-04-24 09:34:18 AUDIT audit:97 - {"time":"April 24, 2020 2:34:18 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6863995952999640","opStatus":"SUCCESS","opTime":"120 ms","table":"partition_mv.partitiontable","extraInfo":{}}
[32mMVTPCDSTestCase:[0m
[33m- test create materialized view with tpcds_1_4_testCases case_1 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_3 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_4 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_5 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_6 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_8 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_11 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_15 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_16 !!! IGNORED !!![0m
[32mIsSPJGHSuite:[0m
[32m- project only[0m
[32m- groupby-project[0m
[32m- groupby-project-filter[0m
[32m- groupby-project-filter-join[0m
[32mLogicalToModularPlanSuite:[0m
[32m- select only[0m
[32m- select-project-groupby grouping without aggregate function[0m
[32m- select-project with filter[0m
[32m- join[0m
[32m- left outer join[0m
[32m- right outer join[0m
[33m- joins: conjunctive predicates #1 with alias !!! IGNORED !!![0m
[33m- joins: conjunctive predicates #2 with alias !!! IGNORED !!![0m
[33m- SPJGH query !!! IGNORED !!![0m
[33m- non-SPJGH query !!! IGNORED !!![0m
[36mRun completed in 14 minutes, 37 seconds.[0m
[36mTotal number of tests run: 268[0m
[36mSuites: completed 28, aborted 0[0m
[36mTests: succeeded 266, failed 2, canceled 0, ignored 25, pending 0[0m
[31m*** 2 TESTS FAILED ***[0m
[JENKINS] Recording test results
Build failed in Jenkins: carbondata-master-spark-2.3 » Apache CarbonData :: Materialized View Core #2212
Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://builds.apache.org/job/carbondata-master-spark-2.3/org.apache.carbondata$carbondata-mv-core/2212/display/redirect>
Changes:
------------------------------------------
[...truncated 1.53 MB...]
2020-04-24 08:40:32 AUDIT audit:97 - {"time":"April 24, 2020 1:40:32 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866303436771976","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-24 08:40:32 AUDIT audit:74 - {"time":"April 24, 2020 1:40:32 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866303440636893","opStatus":"START"}
2020-04-24 08:40:32 AUDIT audit:97 - {"time":"April 24, 2020 1:40:32 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866303440636893","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-24 08:40:32 AUDIT audit:74 - {"time":"April 24, 2020 1:40:32 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866303444512593","opStatus":"START"}
2020-04-24 08:40:32 AUDIT audit:97 - {"time":"April 24, 2020 1:40:32 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866303444512593","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-24 08:40:32 AUDIT audit:74 - {"time":"April 24, 2020 1:40:32 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866303448365032","opStatus":"START"}
2020-04-24 08:40:32 AUDIT audit:97 - {"time":"April 24, 2020 1:40:32 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866303448365032","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-24 08:40:32 AUDIT audit:74 - {"time":"April 24, 2020 1:40:32 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866303461501542","opStatus":"START"}
2020-04-24 08:40:33 AUDIT audit:97 - {"time":"April 24, 2020 1:40:33 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866303461501542","opStatus":"SUCCESS","opTime":"143 ms","table":"NA","extraInfo":{}}
2020-04-24 08:40:33 AUDIT audit:74 - {"time":"April 24, 2020 1:40:33 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6866303607213033","opStatus":"START"}
2020-04-24 08:40:33 AUDIT audit:74 - {"time":"April 24, 2020 1:40:33 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866303640806386","opStatus":"START"}
2020-04-24 08:40:33 AUDIT audit:74 - {"time":"April 24, 2020 1:40:33 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866303648705631","opStatus":"START"}
2020-04-24 08:40:33 AUDIT audit:97 - {"time":"April 24, 2020 1:40:33 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866303648705631","opStatus":"SUCCESS","opTime":"63 ms","table":"NA","extraInfo":{}}
2020-04-24 08:40:33 AUDIT audit:97 - {"time":"April 24, 2020 1:40:33 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866303640806386","opStatus":"SUCCESS","opTime":"74 ms","table":"partition_mv.p7","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 08:40:33 AUDIT audit:97 - {"time":"April 24, 2020 1:40:33 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6866303607213033","opStatus":"SUCCESS","opTime":"312 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-24 08:40:33 AUDIT audit:74 - {"time":"April 24, 2020 1:40:33 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6866303924605819","opStatus":"START"}
2020-04-24 08:40:33 AUDIT audit:74 - {"time":"April 24, 2020 1:40:33 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866303948861524","opStatus":"START"}
2020-04-24 08:40:33 AUDIT audit:74 - {"time":"April 24, 2020 1:40:33 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866303954957842","opStatus":"START"}
2020-04-24 08:40:33 AUDIT audit:97 - {"time":"April 24, 2020 1:40:33 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866303954957842","opStatus":"SUCCESS","opTime":"57 ms","table":"NA","extraInfo":{}}
2020-04-24 08:40:33 AUDIT audit:97 - {"time":"April 24, 2020 1:40:33 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866303948861524","opStatus":"SUCCESS","opTime":"66 ms","table":"partition_mv.p1","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 08:40:33 AUDIT audit:97 - {"time":"April 24, 2020 1:40:33 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6866303924605819","opStatus":"SUCCESS","opTime":"270 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-24 08:40:33 AUDIT audit:74 - {"time":"April 24, 2020 1:40:33 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6866304200125228","opStatus":"START"}
2020-04-24 08:40:33 AUDIT audit:74 - {"time":"April 24, 2020 1:40:33 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866304225083305","opStatus":"START"}
2020-04-24 08:40:33 AUDIT audit:74 - {"time":"April 24, 2020 1:40:33 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866304231489818","opStatus":"START"}
2020-04-24 08:40:33 AUDIT audit:97 - {"time":"April 24, 2020 1:40:33 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866304231489818","opStatus":"SUCCESS","opTime":"121 ms","table":"NA","extraInfo":{}}
2020-04-24 08:40:33 AUDIT audit:97 - {"time":"April 24, 2020 1:40:33 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866304225083305","opStatus":"SUCCESS","opTime":"131 ms","table":"partition_mv.p2","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 08:40:34 AUDIT audit:97 - {"time":"April 24, 2020 1:40:34 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6866304200125228","opStatus":"SUCCESS","opTime":"399 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-24 08:40:34 AUDIT audit:74 - {"time":"April 24, 2020 1:40:34 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6866304603630038","opStatus":"START"}
2020-04-24 08:40:34 AUDIT audit:74 - {"time":"April 24, 2020 1:40:34 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866304631427779","opStatus":"START"}
2020-04-24 08:40:34 AUDIT audit:74 - {"time":"April 24, 2020 1:40:34 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866304638206900","opStatus":"START"}
2020-04-24 08:40:34 AUDIT audit:97 - {"time":"April 24, 2020 1:40:34 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866304638206900","opStatus":"SUCCESS","opTime":"57 ms","table":"NA","extraInfo":{}}
2020-04-24 08:40:34 AUDIT audit:97 - {"time":"April 24, 2020 1:40:34 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866304631427779","opStatus":"SUCCESS","opTime":"67 ms","table":"partition_mv.p3","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 08:40:34 AUDIT audit:97 - {"time":"April 24, 2020 1:40:34 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6866304603630038","opStatus":"SUCCESS","opTime":"353 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-24 08:40:34 AUDIT audit:74 - {"time":"April 24, 2020 1:40:34 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6866304961997431","opStatus":"START"}
2020-04-24 08:40:34 AUDIT audit:74 - {"time":"April 24, 2020 1:40:34 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866304991298439","opStatus":"START"}
2020-04-24 08:40:34 AUDIT audit:74 - {"time":"April 24, 2020 1:40:34 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866304998458503","opStatus":"START"}
2020-04-24 08:40:34 AUDIT audit:97 - {"time":"April 24, 2020 1:40:34 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866304998458503","opStatus":"SUCCESS","opTime":"55 ms","table":"NA","extraInfo":{}}
2020-04-24 08:40:34 AUDIT audit:97 - {"time":"April 24, 2020 1:40:34 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866304991298439","opStatus":"SUCCESS","opTime":"65 ms","table":"partition_mv.p4","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 08:40:34 AUDIT audit:97 - {"time":"April 24, 2020 1:40:34 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6866304961997431","opStatus":"SUCCESS","opTime":"487 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-24 08:40:34 AUDIT audit:74 - {"time":"April 24, 2020 1:40:34 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6866305453575546","opStatus":"START"}
2020-04-24 08:40:35 AUDIT audit:74 - {"time":"April 24, 2020 1:40:35 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866305479855376","opStatus":"START"}
2020-04-24 08:40:35 AUDIT audit:74 - {"time":"April 24, 2020 1:40:35 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866305485849107","opStatus":"START"}
2020-04-24 08:40:35 AUDIT audit:97 - {"time":"April 24, 2020 1:40:35 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866305485849107","opStatus":"SUCCESS","opTime":"50 ms","table":"NA","extraInfo":{}}
2020-04-24 08:40:35 AUDIT audit:97 - {"time":"April 24, 2020 1:40:35 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866305479855376","opStatus":"SUCCESS","opTime":"59 ms","table":"partition_mv.p5","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 08:40:35 AUDIT audit:97 - {"time":"April 24, 2020 1:40:35 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6866305453575546","opStatus":"SUCCESS","opTime":"298 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-24 08:40:35 AUDIT audit:74 - {"time":"April 24, 2020 1:40:35 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6866305757529176","opStatus":"START"}
2020-04-24 08:40:35 AUDIT audit:74 - {"time":"April 24, 2020 1:40:35 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866305785743940","opStatus":"START"}
2020-04-24 08:40:35 AUDIT audit:74 - {"time":"April 24, 2020 1:40:35 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866305792334034","opStatus":"START"}
2020-04-24 08:40:35 AUDIT audit:97 - {"time":"April 24, 2020 1:40:35 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866305792334034","opStatus":"SUCCESS","opTime":"52 ms","table":"NA","extraInfo":{}}
2020-04-24 08:40:35 AUDIT audit:97 - {"time":"April 24, 2020 1:40:35 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866305785743940","opStatus":"SUCCESS","opTime":"61 ms","table":"partition_mv.p6","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 08:40:35 AUDIT audit:97 - {"time":"April 24, 2020 1:40:35 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6866305757529176","opStatus":"SUCCESS","opTime":"309 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-24 08:40:35 AUDIT audit:74 - {"time":"April 24, 2020 1:40:35 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6866306257931680","opStatus":"START"}
2020-04-24 08:40:36 AUDIT audit:97 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6866306257931680","opStatus":"SUCCESS","opTime":"625 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- check partitioning for child tables with various combinations[0m
2020-04-24 08:40:36 AUDIT audit:74 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866306892583197","opStatus":"START"}
2020-04-24 08:40:36 AUDIT audit:97 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866306892583197","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-24 08:40:36 AUDIT audit:74 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866306896040820","opStatus":"START"}
2020-04-24 08:40:36 AUDIT audit:97 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866306896040820","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-24 08:40:36 AUDIT audit:74 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866306899183760","opStatus":"START"}
2020-04-24 08:40:36 AUDIT audit:97 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866306899183760","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-24 08:40:36 AUDIT audit:74 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866306902361699","opStatus":"START"}
2020-04-24 08:40:36 AUDIT audit:97 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866306902361699","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-24 08:40:36 AUDIT audit:74 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866306905563056","opStatus":"START"}
2020-04-24 08:40:36 AUDIT audit:97 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866306905563056","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-24 08:40:36 AUDIT audit:74 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866306908756677","opStatus":"START"}
2020-04-24 08:40:36 AUDIT audit:97 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866306908756677","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-24 08:40:36 AUDIT audit:74 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866306911999634","opStatus":"START"}
2020-04-24 08:40:36 AUDIT audit:97 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866306911999634","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-24 08:40:36 AUDIT audit:74 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866306915312275","opStatus":"START"}
2020-04-24 08:40:36 AUDIT audit:97 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866306915312275","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag1"}}
2020-04-24 08:40:36 AUDIT audit:74 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866306918577070","opStatus":"START"}
2020-04-24 08:40:36 AUDIT audit:97 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866306918577070","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-24 08:40:36 AUDIT audit:74 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866306921902463","opStatus":"START"}
2020-04-24 08:40:36 AUDIT audit:97 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866306921902463","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-24 08:40:36 AUDIT audit:74 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866306925222347","opStatus":"START"}
2020-04-24 08:40:36 AUDIT audit:97 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866306925222347","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-24 08:40:36 AUDIT audit:74 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866306928502817","opStatus":"START"}
2020-04-24 08:40:36 AUDIT audit:97 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866306928502817","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-24 08:40:36 AUDIT audit:74 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866306939062361","opStatus":"START"}
2020-04-24 08:40:36 AUDIT audit:97 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866306939062361","opStatus":"SUCCESS","opTime":"198 ms","table":"NA","extraInfo":{}}
2020-04-24 08:40:36 AUDIT audit:74 - {"time":"April 24, 2020 1:40:36 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6866307242133851","opStatus":"START"}
2020-04-24 08:40:37 AUDIT audit:97 - {"time":"April 24, 2020 1:40:37 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6866307242133851","opStatus":"SUCCESS","opTime":"379 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-24 08:40:37 AUDIT audit:74 - {"time":"April 24, 2020 1:40:37 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866307623258590","opStatus":"START"}
2020-04-24 08:40:37 AUDIT audit:97 - {"time":"April 24, 2020 1:40:37 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866307623258590","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-24 08:40:37 AUDIT audit:74 - {"time":"April 24, 2020 1:40:37 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6866307627850995","opStatus":"START"}
2020-04-24 08:40:37 AUDIT audit:74 - {"time":"April 24, 2020 1:40:37 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866307650125727","opStatus":"START"}
2020-04-24 08:40:37 AUDIT audit:74 - {"time":"April 24, 2020 1:40:37 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866307655888115","opStatus":"START"}
2020-04-24 08:40:37 AUDIT audit:97 - {"time":"April 24, 2020 1:40:37 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866307655888115","opStatus":"SUCCESS","opTime":"56 ms","table":"NA","extraInfo":{}}
2020-04-24 08:40:37 AUDIT audit:97 - {"time":"April 24, 2020 1:40:37 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866307650125727","opStatus":"SUCCESS","opTime":"65 ms","table":"partition_mv.dm1","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 08:40:37 AUDIT audit:74 - {"time":"April 24, 2020 1:40:37 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6866307910961970","opStatus":"START"}
2020-04-24 08:40:39 AUDIT audit:97 - {"time":"April 24, 2020 1:40:39 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6866307910961970","opStatus":"SUCCESS","opTime":"2048 ms","table":"partition_mv.dm1","extraInfo":{}}
2020-04-24 08:40:39 AUDIT audit:97 - {"time":"April 24, 2020 1:40:39 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6866307627850995","opStatus":"SUCCESS","opTime":"2330 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-24 08:40:39 AUDIT audit:74 - {"time":"April 24, 2020 1:40:39 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6866310440469619","opStatus":"START"}
2020-04-24 08:40:40 AUDIT audit:97 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6866310440469619","opStatus":"SUCCESS","opTime":"206 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- test partition at last column[0m
2020-04-24 08:40:40 AUDIT audit:74 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866310659735404","opStatus":"START"}
2020-04-24 08:40:40 AUDIT audit:97 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866310659735404","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-24 08:40:40 AUDIT audit:74 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866310664067350","opStatus":"START"}
2020-04-24 08:40:40 AUDIT audit:97 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866310664067350","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-24 08:40:40 AUDIT audit:74 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866310668064811","opStatus":"START"}
2020-04-24 08:40:40 AUDIT audit:97 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866310668064811","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-24 08:40:40 AUDIT audit:74 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866310671991321","opStatus":"START"}
2020-04-24 08:40:40 AUDIT audit:97 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866310671991321","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-24 08:40:40 AUDIT audit:74 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866310675919691","opStatus":"START"}
2020-04-24 08:40:40 AUDIT audit:97 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866310675919691","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-24 08:40:40 AUDIT audit:74 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866310679817479","opStatus":"START"}
2020-04-24 08:40:40 AUDIT audit:97 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866310679817479","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-24 08:40:40 AUDIT audit:74 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866310683707509","opStatus":"START"}
2020-04-24 08:40:40 AUDIT audit:97 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866310683707509","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-24 08:40:40 AUDIT audit:74 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866310687487498","opStatus":"START"}
2020-04-24 08:40:40 AUDIT audit:97 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866310687487498","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag1"}}
2020-04-24 08:40:40 AUDIT audit:74 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866310691416040","opStatus":"START"}
2020-04-24 08:40:40 AUDIT audit:97 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866310691416040","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-24 08:40:40 AUDIT audit:74 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866310695242835","opStatus":"START"}
2020-04-24 08:40:40 AUDIT audit:97 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866310695242835","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-24 08:40:40 AUDIT audit:74 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866310699157261","opStatus":"START"}
2020-04-24 08:40:40 AUDIT audit:97 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866310699157261","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-24 08:40:40 AUDIT audit:74 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866310703055209","opStatus":"START"}
2020-04-24 08:40:40 AUDIT audit:97 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866310703055209","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-24 08:40:40 AUDIT audit:74 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866310716468201","opStatus":"START"}
2020-04-24 08:40:40 AUDIT audit:97 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866310716468201","opStatus":"SUCCESS","opTime":"63 ms","table":"NA","extraInfo":{}}
2020-04-24 08:40:40 AUDIT audit:74 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6866310884531003","opStatus":"START"}
2020-04-24 08:40:40 AUDIT audit:97 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6866310884531003","opStatus":"SUCCESS","opTime":"416 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-24 08:40:40 AUDIT audit:74 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866311302954628","opStatus":"START"}
2020-04-24 08:40:40 AUDIT audit:97 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866311302954628","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-24 08:40:40 AUDIT audit:74 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DESC FORMATTED","opId":"6866311395285081","opStatus":"START"}
2020-04-24 08:40:40 ERROR CarbonUtil:2444 - Unable to unlock Table lock for table during table status updation
2020-04-24 08:40:40 AUDIT audit:97 - {"time":"April 24, 2020 1:40:40 AM PDT","username":"jenkins","opName":"DESC FORMATTED","opId":"6866311395285081","opStatus":"SUCCESS","opTime":"49 ms","table":"partition_mv.partitionone","extraInfo":{}}
+-----------------------------+-----------------------------------------------------------------------------------------------------------------------+-------+
|col_name |data_type |comment|
+-----------------------------+-----------------------------------------------------------------------------------------------------------------------+-------+
|a |int |null |
|b |int |null |
|c |timestamp |null |
|d |timestamp |null |
| | | |
|## Detailed Table Information| | |
|Database |partition_mv | |
|Table |partitionone | |
|Owner |jenkins | |
|Created |Fri Apr 24 01:40:40 PDT 2020 | |
|Location |<https://builds.apache.org/job/carbondata-master-spark-2.3/org.apache.carbondata$carbondata-mv-core/ws/target/warehouse/partition_mv.db/partitionone|> |
|External |false | |
|Transactional |true | |
|Streaming |false | |
|Table Block Size |1024 MB | |
|Table Blocklet Size |64 MB | |
|Comment | | |
|Bad Record Path | | |
|Min Input Per Node Per Load |0.0B | |
| | | |
|## Index Information | | |
|Sort Scope |NO_SORT | |
|Sort Columns | | |
|Inverted Index Columns | | |
|Cached Min/Max Index Columns |All columns | |
|Min/Max Index Cache Level |BLOCK | |
|Table page size in mb | | |
| | | |
|## Encoding Information | | |
|Local Dictionary Enabled |true | |
|Local Dictionary Threshold |10000 | |
|Local Dictionary Include | | |
| | | |
|## Compaction Information | | |
|MAJOR_COMPACTION_SIZE |1024 | |
|AUTO_LOAD_MERGE |false | |
|COMPACTION_LEVEL_THRESHOLD |4,3 | |
|COMPACTION_PRESERVE_SEGMENTS |0 | |
|ALLOWED_COMPACTION_DAYS |0 | |
| | | |
|## Partition Information | | |
|Partition Type |NATIVE_HIVE | |
|Partition Columns |c:TIMESTAMP, d:TIMESTAMP | |
|Number of Partitions |1 | |
| | | |
|## Dynamic Information | | |
|Table Data Size |1.10KB | |
|Table Index Size |705.0B | |
|Last Update |Fri Apr 24 01:40:40 PDT 2020 | |
+-----------------------------+-----------------------------------------------------------------------------------------------------------------------+-------+
2020-04-24 08:40:41 AUDIT audit:74 - {"time":"April 24, 2020 1:40:41 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6866311496548155","opStatus":"START"}
2020-04-24 08:40:41 AUDIT audit:74 - {"time":"April 24, 2020 1:40:41 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866311526353061","opStatus":"START"}
2020-04-24 08:40:41 AUDIT audit:74 - {"time":"April 24, 2020 1:40:41 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866311533142045","opStatus":"START"}
2020-04-24 08:40:41 AUDIT audit:97 - {"time":"April 24, 2020 1:40:41 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866311533142045","opStatus":"SUCCESS","opTime":"54 ms","table":"NA","extraInfo":{}}
2020-04-24 08:40:41 AUDIT audit:97 - {"time":"April 24, 2020 1:40:41 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866311526353061","opStatus":"SUCCESS","opTime":"64 ms","table":"partition_mv.dm1","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 08:40:41 AUDIT audit:74 - {"time":"April 24, 2020 1:40:41 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6866311851097958","opStatus":"START"}
2020-04-24 08:40:42 AUDIT audit:97 - {"time":"April 24, 2020 1:40:42 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6866311851097958","opStatus":"SUCCESS","opTime":"886 ms","table":"partition_mv.dm1","extraInfo":{"SegmentId":"0","DataSize":"688.0B","IndexSize":"454.0B"}}
2020-04-24 08:40:42 AUDIT audit:97 - {"time":"April 24, 2020 1:40:42 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6866311496548155","opStatus":"SUCCESS","opTime":"1240 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-24 08:40:42 AUDIT audit:74 - {"time":"April 24, 2020 1:40:42 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6866313279470599","opStatus":"START"}
2020-04-24 08:40:42 AUDIT audit:97 - {"time":"April 24, 2020 1:40:42 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6866313279470599","opStatus":"SUCCESS","opTime":"180 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-24 08:40:42 AUDIT audit:74 - {"time":"April 24, 2020 1:40:42 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866313464887509","opStatus":"START"}
2020-04-24 08:40:43 AUDIT audit:97 - {"time":"April 24, 2020 1:40:43 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866313464887509","opStatus":"SUCCESS","opTime":"55 ms","table":"NA","extraInfo":{}}
2020-04-24 08:40:43 AUDIT audit:74 - {"time":"April 24, 2020 1:40:43 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6866313628700331","opStatus":"START"}
2020-04-24 08:40:43 AUDIT audit:97 - {"time":"April 24, 2020 1:40:43 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6866313628700331","opStatus":"SUCCESS","opTime":"397 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-24 08:40:43 AUDIT audit:74 - {"time":"April 24, 2020 1:40:43 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866314027882723","opStatus":"START"}
2020-04-24 08:40:43 AUDIT audit:97 - {"time":"April 24, 2020 1:40:43 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6866314027882723","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-24 08:40:43 AUDIT audit:74 - {"time":"April 24, 2020 1:40:43 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6866314033057733","opStatus":"START"}
2020-04-24 08:40:43 AUDIT audit:74 - {"time":"April 24, 2020 1:40:43 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866314057104094","opStatus":"START"}
2020-04-24 08:40:43 AUDIT audit:74 - {"time":"April 24, 2020 1:40:43 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866314066824771","opStatus":"START"}
2020-04-24 08:40:43 AUDIT audit:97 - {"time":"April 24, 2020 1:40:43 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866314066824771","opStatus":"SUCCESS","opTime":"78 ms","table":"NA","extraInfo":{}}
2020-04-24 08:40:43 AUDIT audit:97 - {"time":"April 24, 2020 1:40:43 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6866314057104094","opStatus":"SUCCESS","opTime":"92 ms","table":"partition_mv.dm1","extraInfo":{"local_dictionary_threshold":"10000","bad_record_path":"","table_blocksize":"1024","local_dictionary_enable":"true","flat_folder":"false","external":"false","sort_columns":"","comment":"","carbon.column.compressor":"snappy","mv_related_tables":"partitionone"}}
2020-04-24 08:40:43 AUDIT audit:74 - {"time":"April 24, 2020 1:40:43 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6866314351262335","opStatus":"START"}
2020-04-24 08:40:46 AUDIT audit:97 - {"time":"April 24, 2020 1:40:46 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6866314351262335","opStatus":"SUCCESS","opTime":"2359 ms","table":"partition_mv.dm1","extraInfo":{}}
2020-04-24 08:40:46 AUDIT audit:97 - {"time":"April 24, 2020 1:40:46 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6866314033057733","opStatus":"SUCCESS","opTime":"2678 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-24 08:40:46 AUDIT audit:74 - {"time":"April 24, 2020 1:40:46 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6866317244846817","opStatus":"START"}
2020-04-24 08:40:47 AUDIT audit:97 - {"time":"April 24, 2020 1:40:47 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6866317244846817","opStatus":"SUCCESS","opTime":"297 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- test partition on timeseries column[0m
2020-04-24 08:40:47 AUDIT audit:74 - {"time":"April 24, 2020 1:40:47 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6866317780402959","opStatus":"START"}
2020-04-24 08:40:47 AUDIT audit:97 - {"time":"April 24, 2020 1:40:47 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6866317780402959","opStatus":"SUCCESS","opTime":"164 ms","table":"partition_mv.droppartition","extraInfo":{}}
2020-04-24 08:40:47 AUDIT audit:74 - {"time":"April 24, 2020 1:40:47 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6866317944652787","opStatus":"START"}
2020-04-24 08:40:47 AUDIT audit:97 - {"time":"April 24, 2020 1:40:47 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6866317944652787","opStatus":"SUCCESS","opTime":"210 ms","table":"partition_mv.maintable","extraInfo":{}}
2020-04-24 08:40:47 AUDIT audit:74 - {"time":"April 24, 2020 1:40:47 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6866318155027178","opStatus":"START"}
2020-04-24 08:40:47 AUDIT audit:97 - {"time":"April 24, 2020 1:40:47 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6866318155027178","opStatus":"SUCCESS","opTime":"105 ms","table":"partition_mv.par","extraInfo":{}}
2020-04-24 08:40:47 AUDIT audit:74 - {"time":"April 24, 2020 1:40:47 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6866318259922166","opStatus":"START"}
2020-04-24 08:40:47 AUDIT audit:97 - {"time":"April 24, 2020 1:40:47 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6866318259922166","opStatus":"SUCCESS","opTime":"179 ms","table":"partition_mv.partitiontable","extraInfo":{}}
[32mMVTPCDSTestCase:[0m
[33m- test create materialized view with tpcds_1_4_testCases case_1 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_3 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_4 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_5 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_6 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_8 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_11 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_15 !!! IGNORED !!![0m
[33m- test create materialized view with tpcds_1_4_testCases case_16 !!! IGNORED !!![0m
[32mIsSPJGHSuite:[0m
[32m- project only[0m
[32m- groupby-project[0m
[32m- groupby-project-filter[0m
[32m- groupby-project-filter-join[0m
[32mLogicalToModularPlanSuite:[0m
[32m- select only[0m
[32m- select-project-groupby grouping without aggregate function[0m
[32m- select-project with filter[0m
[32m- join[0m
[32m- left outer join[0m
[32m- right outer join[0m
[33m- joins: conjunctive predicates #1 with alias !!! IGNORED !!![0m
[33m- joins: conjunctive predicates #2 with alias !!! IGNORED !!![0m
[33m- SPJGH query !!! IGNORED !!![0m
[33m- non-SPJGH query !!! IGNORED !!![0m
[36mRun completed in 16 minutes, 22 seconds.[0m
[36mTotal number of tests run: 268[0m
[36mSuites: completed 28, aborted 0[0m
[36mTests: succeeded 266, failed 2, canceled 0, ignored 25, pending 0[0m
[31m*** 2 TESTS FAILED ***[0m
[JENKINS] Recording test results