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/20 08:44:57 UTC
Build failed in Jenkins: carbondata-master-spark-2.3 » Apache CarbonData :: Materialized View Core #2205
See <https://builds.apache.org/job/carbondata-master-spark-2.3/org.apache.carbondata$carbondata-mv-core/2205/display/redirect>
Changes:
------------------------------------------
[...truncated 1.53 MB...]
2020-04-20 08:43:54 AUDIT audit:97 - {"time":"April 20, 2020 1:43:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844529313921622","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-20 08:43:54 AUDIT audit:74 - {"time":"April 20, 2020 1:43:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844529317671010","opStatus":"START"}
2020-04-20 08:43:54 AUDIT audit:97 - {"time":"April 20, 2020 1:43:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844529317671010","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-20 08:43:54 AUDIT audit:74 - {"time":"April 20, 2020 1:43:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844529321601268","opStatus":"START"}
2020-04-20 08:43:54 AUDIT audit:97 - {"time":"April 20, 2020 1:43:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844529321601268","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-20 08:43:54 AUDIT audit:74 - {"time":"April 20, 2020 1:43:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844529325478918","opStatus":"START"}
2020-04-20 08:43:54 AUDIT audit:97 - {"time":"April 20, 2020 1:43:54 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844529325478918","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-20 08:43:54 AUDIT audit:74 - {"time":"April 20, 2020 1:43:54 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844529337786554","opStatus":"START"}
2020-04-20 08:43:54 AUDIT audit:97 - {"time":"April 20, 2020 1:43:54 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844529337786554","opStatus":"SUCCESS","opTime":"85 ms","table":"NA","extraInfo":{}}
2020-04-20 08:43:54 AUDIT audit:74 - {"time":"April 20, 2020 1:43:54 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6844529425430111","opStatus":"START"}
2020-04-20 08:43:54 AUDIT audit:74 - {"time":"April 20, 2020 1:43:54 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844529455523883","opStatus":"START"}
2020-04-20 08:43:54 AUDIT audit:74 - {"time":"April 20, 2020 1:43:54 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844529461731434","opStatus":"START"}
2020-04-20 08:43:54 AUDIT audit:97 - {"time":"April 20, 2020 1:43:54 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844529461731434","opStatus":"SUCCESS","opTime":"53 ms","table":"NA","extraInfo":{}}
2020-04-20 08:43:54 AUDIT audit:97 - {"time":"April 20, 2020 1:43:54 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844529455523883","opStatus":"SUCCESS","opTime":"62 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-20 08:43:54 AUDIT audit:97 - {"time":"April 20, 2020 1:43:54 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6844529425430111","opStatus":"SUCCESS","opTime":"286 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-20 08:43:54 AUDIT audit:74 - {"time":"April 20, 2020 1:43:54 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6844529716609181","opStatus":"START"}
2020-04-20 08:43:54 AUDIT audit:74 - {"time":"April 20, 2020 1:43:54 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844529739720735","opStatus":"START"}
2020-04-20 08:43:54 AUDIT audit:74 - {"time":"April 20, 2020 1:43:54 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844529745463516","opStatus":"START"}
2020-04-20 08:43:55 AUDIT audit:97 - {"time":"April 20, 2020 1:43:55 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844529745463516","opStatus":"SUCCESS","opTime":"60 ms","table":"NA","extraInfo":{}}
2020-04-20 08:43:55 AUDIT audit:97 - {"time":"April 20, 2020 1:43:55 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844529739720735","opStatus":"SUCCESS","opTime":"70 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-20 08:43:55 AUDIT audit:97 - {"time":"April 20, 2020 1:43:55 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6844529716609181","opStatus":"SUCCESS","opTime":"265 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-20 08:43:55 AUDIT audit:74 - {"time":"April 20, 2020 1:43:55 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6844529986596560","opStatus":"START"}
2020-04-20 08:43:55 AUDIT audit:74 - {"time":"April 20, 2020 1:43:55 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844530010452383","opStatus":"START"}
2020-04-20 08:43:55 AUDIT audit:74 - {"time":"April 20, 2020 1:43:55 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844530016564601","opStatus":"START"}
2020-04-20 08:43:55 AUDIT audit:97 - {"time":"April 20, 2020 1:43:55 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844530016564601","opStatus":"SUCCESS","opTime":"106 ms","table":"NA","extraInfo":{}}
2020-04-20 08:43:55 AUDIT audit:97 - {"time":"April 20, 2020 1:43:55 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844530010452383","opStatus":"SUCCESS","opTime":"115 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-20 08:43:55 AUDIT audit:97 - {"time":"April 20, 2020 1:43:55 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6844529986596560","opStatus":"SUCCESS","opTime":"348 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-20 08:43:55 AUDIT audit:74 - {"time":"April 20, 2020 1:43:55 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6844530339105279","opStatus":"START"}
2020-04-20 08:43:55 AUDIT audit:74 - {"time":"April 20, 2020 1:43:55 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844530365267872","opStatus":"START"}
2020-04-20 08:43:55 AUDIT audit:74 - {"time":"April 20, 2020 1:43:55 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844530371558660","opStatus":"START"}
2020-04-20 08:43:55 AUDIT audit:97 - {"time":"April 20, 2020 1:43:55 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844530371558660","opStatus":"SUCCESS","opTime":"60 ms","table":"NA","extraInfo":{}}
2020-04-20 08:43:55 AUDIT audit:97 - {"time":"April 20, 2020 1:43:55 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844530365267872","opStatus":"SUCCESS","opTime":"68 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-20 08:43:55 AUDIT audit:97 - {"time":"April 20, 2020 1:43:55 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6844530339105279","opStatus":"SUCCESS","opTime":"296 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-20 08:43:55 AUDIT audit:74 - {"time":"April 20, 2020 1:43:55 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6844530640425758","opStatus":"START"}
2020-04-20 08:43:55 AUDIT audit:74 - {"time":"April 20, 2020 1:43:55 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844530665655748","opStatus":"START"}
2020-04-20 08:43:55 AUDIT audit:74 - {"time":"April 20, 2020 1:43:55 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844530672362242","opStatus":"START"}
2020-04-20 08:43:55 AUDIT audit:97 - {"time":"April 20, 2020 1:43:55 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844530672362242","opStatus":"SUCCESS","opTime":"59 ms","table":"NA","extraInfo":{}}
2020-04-20 08:43:55 AUDIT audit:97 - {"time":"April 20, 2020 1:43:55 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844530665655748","opStatus":"SUCCESS","opTime":"69 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-20 08:43:56 AUDIT audit:97 - {"time":"April 20, 2020 1:43:56 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6844530640425758","opStatus":"SUCCESS","opTime":"294 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-20 08:43:56 AUDIT audit:74 - {"time":"April 20, 2020 1:43:56 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6844530939523534","opStatus":"START"}
2020-04-20 08:43:56 AUDIT audit:74 - {"time":"April 20, 2020 1:43:56 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844530963761917","opStatus":"START"}
2020-04-20 08:43:56 AUDIT audit:74 - {"time":"April 20, 2020 1:43:56 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844530969672206","opStatus":"START"}
2020-04-20 08:43:56 AUDIT audit:97 - {"time":"April 20, 2020 1:43:56 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844530969672206","opStatus":"SUCCESS","opTime":"54 ms","table":"NA","extraInfo":{}}
2020-04-20 08:43:56 AUDIT audit:97 - {"time":"April 20, 2020 1:43:56 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844530963761917","opStatus":"SUCCESS","opTime":"62 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-20 08:43:56 AUDIT audit:97 - {"time":"April 20, 2020 1:43:56 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6844530939523534","opStatus":"SUCCESS","opTime":"272 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-20 08:43:56 AUDIT audit:74 - {"time":"April 20, 2020 1:43:56 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6844531216864769","opStatus":"START"}
2020-04-20 08:43:56 AUDIT audit:74 - {"time":"April 20, 2020 1:43:56 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844531246829399","opStatus":"START"}
2020-04-20 08:43:56 AUDIT audit:74 - {"time":"April 20, 2020 1:43:56 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844531253870355","opStatus":"START"}
2020-04-20 08:43:56 AUDIT audit:97 - {"time":"April 20, 2020 1:43:56 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844531253870355","opStatus":"SUCCESS","opTime":"45 ms","table":"NA","extraInfo":{}}
2020-04-20 08:43:56 AUDIT audit:97 - {"time":"April 20, 2020 1:43:56 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844531246829399","opStatus":"SUCCESS","opTime":"54 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-20 08:43:56 AUDIT audit:97 - {"time":"April 20, 2020 1:43:56 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6844531216864769","opStatus":"SUCCESS","opTime":"280 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-20 08:43:56 AUDIT audit:74 - {"time":"April 20, 2020 1:43:56 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6844531682654142","opStatus":"START"}
2020-04-20 08:43:57 AUDIT audit:97 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6844531682654142","opStatus":"SUCCESS","opTime":"679 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- check partitioning for child tables with various combinations[0m
2020-04-20 08:43:57 AUDIT audit:74 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532372528061","opStatus":"START"}
2020-04-20 08:43:57 AUDIT audit:97 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532372528061","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-20 08:43:57 AUDIT audit:74 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532376485398","opStatus":"START"}
2020-04-20 08:43:57 AUDIT audit:97 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532376485398","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-20 08:43:57 AUDIT audit:74 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532380254919","opStatus":"START"}
2020-04-20 08:43:57 AUDIT audit:97 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532380254919","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-20 08:43:57 AUDIT audit:74 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532383989653","opStatus":"START"}
2020-04-20 08:43:57 AUDIT audit:97 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532383989653","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-20 08:43:57 AUDIT audit:74 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532387729067","opStatus":"START"}
2020-04-20 08:43:57 AUDIT audit:97 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532387729067","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-20 08:43:57 AUDIT audit:74 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532391443069","opStatus":"START"}
2020-04-20 08:43:57 AUDIT audit:97 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532391443069","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-20 08:43:57 AUDIT audit:74 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532395185170","opStatus":"START"}
2020-04-20 08:43:57 AUDIT audit:97 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532395185170","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-20 08:43:57 AUDIT audit:74 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532398881850","opStatus":"START"}
2020-04-20 08:43:57 AUDIT audit:97 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532398881850","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag1"}}
2020-04-20 08:43:57 AUDIT audit:74 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532402559459","opStatus":"START"}
2020-04-20 08:43:57 AUDIT audit:97 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532402559459","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-20 08:43:57 AUDIT audit:74 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532406295183","opStatus":"START"}
2020-04-20 08:43:57 AUDIT audit:97 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532406295183","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-20 08:43:57 AUDIT audit:74 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532410290857","opStatus":"START"}
2020-04-20 08:43:57 AUDIT audit:97 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532410290857","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-20 08:43:57 AUDIT audit:74 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532414297559","opStatus":"START"}
2020-04-20 08:43:57 AUDIT audit:97 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532414297559","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-20 08:43:57 AUDIT audit:74 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844532428186308","opStatus":"START"}
2020-04-20 08:43:57 AUDIT audit:97 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844532428186308","opStatus":"SUCCESS","opTime":"79 ms","table":"NA","extraInfo":{}}
2020-04-20 08:43:57 AUDIT audit:74 - {"time":"April 20, 2020 1:43:57 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6844532603063308","opStatus":"START"}
2020-04-20 08:43:58 AUDIT audit:97 - {"time":"April 20, 2020 1:43:58 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6844532603063308","opStatus":"SUCCESS","opTime":"386 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-20 08:43:58 AUDIT audit:74 - {"time":"April 20, 2020 1:43:58 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532991124053","opStatus":"START"}
2020-04-20 08:43:58 AUDIT audit:97 - {"time":"April 20, 2020 1:43:58 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844532991124053","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-20 08:43:58 AUDIT audit:74 - {"time":"April 20, 2020 1:43:58 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6844532995820017","opStatus":"START"}
2020-04-20 08:43:58 AUDIT audit:74 - {"time":"April 20, 2020 1:43:58 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844533017872967","opStatus":"START"}
2020-04-20 08:43:58 AUDIT audit:74 - {"time":"April 20, 2020 1:43:58 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844533023725017","opStatus":"START"}
2020-04-20 08:43:58 AUDIT audit:97 - {"time":"April 20, 2020 1:43:58 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844533023725017","opStatus":"SUCCESS","opTime":"51 ms","table":"NA","extraInfo":{}}
2020-04-20 08:43:58 AUDIT audit:97 - {"time":"April 20, 2020 1:43:58 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844533017872967","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-20 08:43:58 AUDIT audit:74 - {"time":"April 20, 2020 1:43:58 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6844533282231106","opStatus":"START"}
2020-04-20 08:44:00 AUDIT audit:97 - {"time":"April 20, 2020 1:44:00 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6844533282231106","opStatus":"SUCCESS","opTime":"2174 ms","table":"partition_mv.dm1","extraInfo":{}}
2020-04-20 08:44:00 AUDIT audit:97 - {"time":"April 20, 2020 1:44:00 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6844532995820017","opStatus":"SUCCESS","opTime":"2460 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-20 08:44:01 AUDIT audit:74 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6844535978676115","opStatus":"START"}
2020-04-20 08:44:01 AUDIT audit:97 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6844535978676115","opStatus":"SUCCESS","opTime":"207 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- test partition at last column[0m
2020-04-20 08:44:01 AUDIT audit:74 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536196164065","opStatus":"START"}
2020-04-20 08:44:01 AUDIT audit:97 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536196164065","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-20 08:44:01 AUDIT audit:74 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536200101582","opStatus":"START"}
2020-04-20 08:44:01 AUDIT audit:97 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536200101582","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-20 08:44:01 AUDIT audit:74 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536203773307","opStatus":"START"}
2020-04-20 08:44:01 AUDIT audit:97 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536203773307","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-20 08:44:01 AUDIT audit:74 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536207484682","opStatus":"START"}
2020-04-20 08:44:01 AUDIT audit:97 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536207484682","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-20 08:44:01 AUDIT audit:74 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536211165065","opStatus":"START"}
2020-04-20 08:44:01 AUDIT audit:97 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536211165065","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-20 08:44:01 AUDIT audit:74 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536214914660","opStatus":"START"}
2020-04-20 08:44:01 AUDIT audit:97 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536214914660","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-20 08:44:01 AUDIT audit:74 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536218641291","opStatus":"START"}
2020-04-20 08:44:01 AUDIT audit:97 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536218641291","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-20 08:44:01 AUDIT audit:74 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536222353353","opStatus":"START"}
2020-04-20 08:44:01 AUDIT audit:97 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536222353353","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag1"}}
2020-04-20 08:44:01 AUDIT audit:74 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536226039539","opStatus":"START"}
2020-04-20 08:44:01 AUDIT audit:97 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536226039539","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-20 08:44:01 AUDIT audit:74 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536229740019","opStatus":"START"}
2020-04-20 08:44:01 AUDIT audit:97 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536229740019","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-20 08:44:01 AUDIT audit:74 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536233426820","opStatus":"START"}
2020-04-20 08:44:01 AUDIT audit:97 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536233426820","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-20 08:44:01 AUDIT audit:74 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536237130378","opStatus":"START"}
2020-04-20 08:44:01 AUDIT audit:97 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536237130378","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-20 08:44:01 AUDIT audit:74 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844536248686933","opStatus":"START"}
2020-04-20 08:44:01 AUDIT audit:97 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844536248686933","opStatus":"SUCCESS","opTime":"68 ms","table":"NA","extraInfo":{}}
2020-04-20 08:44:01 AUDIT audit:74 - {"time":"April 20, 2020 1:44:01 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6844536411400344","opStatus":"START"}
2020-04-20 08:44:02 AUDIT audit:97 - {"time":"April 20, 2020 1:44:02 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6844536411400344","opStatus":"SUCCESS","opTime":"419 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-20 08:44:02 AUDIT audit:74 - {"time":"April 20, 2020 1:44:02 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536832229491","opStatus":"START"}
2020-04-20 08:44:02 AUDIT audit:97 - {"time":"April 20, 2020 1:44:02 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844536832229491","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-20 08:44:02 AUDIT audit:74 - {"time":"April 20, 2020 1:44:02 AM PDT","username":"jenkins","opName":"DESC FORMATTED","opId":"6844536918106369","opStatus":"START"}
2020-04-20 08:44:02 ERROR CarbonUtil:2444 - Unable to unlock Table lock for table during table status updation
2020-04-20 08:44:02 AUDIT audit:97 - {"time":"April 20, 2020 1:44:02 AM PDT","username":"jenkins","opName":"DESC FORMATTED","opId":"6844536918106369","opStatus":"SUCCESS","opTime":"37 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 |Mon Apr 20 01:44:01 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 |Mon Apr 20 01:44:01 PDT 2020 | |
+-----------------------------+-----------------------------------------------------------------------------------------------------------------------+-------+
2020-04-20 08:44:02 AUDIT audit:74 - {"time":"April 20, 2020 1:44:02 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6844537002053293","opStatus":"START"}
2020-04-20 08:44:02 AUDIT audit:74 - {"time":"April 20, 2020 1:44:02 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844537028655852","opStatus":"START"}
2020-04-20 08:44:02 AUDIT audit:74 - {"time":"April 20, 2020 1:44:02 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844537034477134","opStatus":"START"}
2020-04-20 08:44:02 AUDIT audit:97 - {"time":"April 20, 2020 1:44:02 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844537034477134","opStatus":"SUCCESS","opTime":"57 ms","table":"NA","extraInfo":{}}
2020-04-20 08:44:02 AUDIT audit:97 - {"time":"April 20, 2020 1:44:02 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844537028655852","opStatus":"SUCCESS","opTime":"66 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-20 08:44:02 AUDIT audit:74 - {"time":"April 20, 2020 1:44:02 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6844537283863953","opStatus":"START"}
2020-04-20 08:44:03 AUDIT audit:97 - {"time":"April 20, 2020 1:44:03 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6844537283863953","opStatus":"SUCCESS","opTime":"835 ms","table":"partition_mv.dm1","extraInfo":{"SegmentId":"0","DataSize":"688.0B","IndexSize":"454.0B"}}
2020-04-20 08:44:03 AUDIT audit:97 - {"time":"April 20, 2020 1:44:03 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6844537002053293","opStatus":"SUCCESS","opTime":"1117 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-20 08:44:03 AUDIT audit:74 - {"time":"April 20, 2020 1:44:03 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6844538607957437","opStatus":"START"}
2020-04-20 08:44:04 AUDIT audit:97 - {"time":"April 20, 2020 1:44:04 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6844538607957437","opStatus":"SUCCESS","opTime":"191 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-20 08:44:04 AUDIT audit:74 - {"time":"April 20, 2020 1:44:04 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844538803639594","opStatus":"START"}
2020-04-20 08:44:04 AUDIT audit:97 - {"time":"April 20, 2020 1:44:04 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844538803639594","opStatus":"SUCCESS","opTime":"55 ms","table":"NA","extraInfo":{}}
2020-04-20 08:44:04 AUDIT audit:74 - {"time":"April 20, 2020 1:44:04 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6844538956368685","opStatus":"START"}
2020-04-20 08:44:04 AUDIT audit:97 - {"time":"April 20, 2020 1:44:04 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6844538956368685","opStatus":"SUCCESS","opTime":"404 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-20 08:44:04 AUDIT audit:74 - {"time":"April 20, 2020 1:44:04 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844539362597601","opStatus":"START"}
2020-04-20 08:44:04 AUDIT audit:97 - {"time":"April 20, 2020 1:44:04 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6844539362597601","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-20 08:44:04 AUDIT audit:74 - {"time":"April 20, 2020 1:44:04 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6844539368547683","opStatus":"START"}
2020-04-20 08:44:04 AUDIT audit:74 - {"time":"April 20, 2020 1:44:04 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844539392235706","opStatus":"START"}
2020-04-20 08:44:04 AUDIT audit:74 - {"time":"April 20, 2020 1:44:04 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844539398214464","opStatus":"START"}
2020-04-20 08:44:04 AUDIT audit:97 - {"time":"April 20, 2020 1:44:04 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844539398214464","opStatus":"SUCCESS","opTime":"60 ms","table":"NA","extraInfo":{}}
2020-04-20 08:44:04 AUDIT audit:97 - {"time":"April 20, 2020 1:44:04 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6844539392235706","opStatus":"SUCCESS","opTime":"68 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-20 08:44:04 AUDIT audit:74 - {"time":"April 20, 2020 1:44:04 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6844539656826049","opStatus":"START"}
2020-04-20 08:44:07 AUDIT audit:97 - {"time":"April 20, 2020 1:44:07 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6844539656826049","opStatus":"SUCCESS","opTime":"2176 ms","table":"partition_mv.dm1","extraInfo":{}}
2020-04-20 08:44:07 AUDIT audit:97 - {"time":"April 20, 2020 1:44:07 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6844539368547683","opStatus":"SUCCESS","opTime":"2464 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-20 08:44:07 AUDIT audit:74 - {"time":"April 20, 2020 1:44:07 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6844542308958775","opStatus":"START"}
2020-04-20 08:44:07 AUDIT audit:97 - {"time":"April 20, 2020 1:44:07 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6844542308958775","opStatus":"SUCCESS","opTime":"203 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- test partition on timeseries column[0m
2020-04-20 08:44:07 AUDIT audit:74 - {"time":"April 20, 2020 1:44:07 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6844542683492493","opStatus":"START"}
2020-04-20 08:44:08 AUDIT audit:97 - {"time":"April 20, 2020 1:44:08 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6844542683492493","opStatus":"SUCCESS","opTime":"116 ms","table":"partition_mv.droppartition","extraInfo":{}}
2020-04-20 08:44:08 AUDIT audit:74 - {"time":"April 20, 2020 1:44:08 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6844542799581655","opStatus":"START"}
2020-04-20 08:44:08 AUDIT audit:97 - {"time":"April 20, 2020 1:44:08 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6844542799581655","opStatus":"SUCCESS","opTime":"159 ms","table":"partition_mv.maintable","extraInfo":{}}
2020-04-20 08:44:08 AUDIT audit:74 - {"time":"April 20, 2020 1:44:08 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6844542958460225","opStatus":"START"}
2020-04-20 08:44:08 AUDIT audit:97 - {"time":"April 20, 2020 1:44:08 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6844542958460225","opStatus":"SUCCESS","opTime":"59 ms","table":"partition_mv.par","extraInfo":{}}
2020-04-20 08:44:08 AUDIT audit:74 - {"time":"April 20, 2020 1:44:08 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6844543017775055","opStatus":"START"}
2020-04-20 08:44:08 AUDIT audit:97 - {"time":"April 20, 2020 1:44:08 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6844543017775055","opStatus":"SUCCESS","opTime":"422 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, 40 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 #2208
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/2208/display/redirect>
Changes:
------------------------------------------
[...truncated 1.53 MB...]
2020-04-22 08:43:07 AUDIT audit:97 - {"time":"April 22, 2020 1:43:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693658449068269","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-22 08:43:07 AUDIT audit:74 - {"time":"April 22, 2020 1:43:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693658453237785","opStatus":"START"}
2020-04-22 08:43:07 AUDIT audit:97 - {"time":"April 22, 2020 1:43:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693658453237785","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-22 08:43:07 AUDIT audit:74 - {"time":"April 22, 2020 1:43:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693658457419789","opStatus":"START"}
2020-04-22 08:43:07 AUDIT audit:97 - {"time":"April 22, 2020 1:43:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693658457419789","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-22 08:43:07 AUDIT audit:74 - {"time":"April 22, 2020 1:43:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693658461614757","opStatus":"START"}
2020-04-22 08:43:07 AUDIT audit:97 - {"time":"April 22, 2020 1:43:07 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693658461614757","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-22 08:43:08 AUDIT audit:74 - {"time":"April 22, 2020 1:43:08 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693658475812186","opStatus":"START"}
2020-04-22 08:43:08 AUDIT audit:97 - {"time":"April 22, 2020 1:43:08 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693658475812186","opStatus":"SUCCESS","opTime":"82 ms","table":"NA","extraInfo":{}}
2020-04-22 08:43:08 AUDIT audit:74 - {"time":"April 22, 2020 1:43:08 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6693658561191875","opStatus":"START"}
2020-04-22 08:43:08 AUDIT audit:74 - {"time":"April 22, 2020 1:43:08 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693658589988521","opStatus":"START"}
2020-04-22 08:43:08 AUDIT audit:74 - {"time":"April 22, 2020 1:43:08 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693658597100576","opStatus":"START"}
2020-04-22 08:43:08 AUDIT audit:97 - {"time":"April 22, 2020 1:43:08 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693658597100576","opStatus":"SUCCESS","opTime":"62 ms","table":"NA","extraInfo":{}}
2020-04-22 08:43:08 AUDIT audit:97 - {"time":"April 22, 2020 1:43:08 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693658589988521","opStatus":"SUCCESS","opTime":"72 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-22 08:43:08 AUDIT audit:97 - {"time":"April 22, 2020 1:43:08 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6693658561191875","opStatus":"SUCCESS","opTime":"282 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-22 08:43:08 AUDIT audit:74 - {"time":"April 22, 2020 1:43:08 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6693658848757663","opStatus":"START"}
2020-04-22 08:43:08 AUDIT audit:74 - {"time":"April 22, 2020 1:43:08 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693658872166693","opStatus":"START"}
2020-04-22 08:43:08 AUDIT audit:74 - {"time":"April 22, 2020 1:43:08 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693658878607557","opStatus":"START"}
2020-04-22 08:43:08 AUDIT audit:97 - {"time":"April 22, 2020 1:43:08 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693658878607557","opStatus":"SUCCESS","opTime":"54 ms","table":"NA","extraInfo":{}}
2020-04-22 08:43:08 AUDIT audit:97 - {"time":"April 22, 2020 1:43:08 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693658872166693","opStatus":"SUCCESS","opTime":"64 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-22 08:43:08 AUDIT audit:97 - {"time":"April 22, 2020 1:43:08 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6693658848757663","opStatus":"SUCCESS","opTime":"249 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-22 08:43:08 AUDIT audit:74 - {"time":"April 22, 2020 1:43:08 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6693659102925377","opStatus":"START"}
2020-04-22 08:43:08 AUDIT audit:74 - {"time":"April 22, 2020 1:43:08 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693659127084075","opStatus":"START"}
2020-04-22 08:43:08 AUDIT audit:74 - {"time":"April 22, 2020 1:43:08 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693659133920751","opStatus":"START"}
2020-04-22 08:43:08 AUDIT audit:97 - {"time":"April 22, 2020 1:43:08 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693659133920751","opStatus":"SUCCESS","opTime":"83 ms","table":"NA","extraInfo":{}}
2020-04-22 08:43:08 AUDIT audit:97 - {"time":"April 22, 2020 1:43:08 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693659127084075","opStatus":"SUCCESS","opTime":"93 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-22 08:43:08 AUDIT audit:97 - {"time":"April 22, 2020 1:43:08 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6693659102925377","opStatus":"SUCCESS","opTime":"296 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-22 08:43:08 AUDIT audit:74 - {"time":"April 22, 2020 1:43:08 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6693659405247629","opStatus":"START"}
2020-04-22 08:43:08 AUDIT audit:74 - {"time":"April 22, 2020 1:43:08 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693659431535144","opStatus":"START"}
2020-04-22 08:43:08 AUDIT audit:74 - {"time":"April 22, 2020 1:43:08 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693659438561785","opStatus":"START"}
2020-04-22 08:43:09 AUDIT audit:97 - {"time":"April 22, 2020 1:43:09 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693659438561785","opStatus":"SUCCESS","opTime":"53 ms","table":"NA","extraInfo":{}}
2020-04-22 08:43:09 AUDIT audit:97 - {"time":"April 22, 2020 1:43:09 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693659431535144","opStatus":"SUCCESS","opTime":"63 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-22 08:43:09 AUDIT audit:97 - {"time":"April 22, 2020 1:43:09 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6693659405247629","opStatus":"SUCCESS","opTime":"273 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-22 08:43:09 AUDIT audit:74 - {"time":"April 22, 2020 1:43:09 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6693659683539482","opStatus":"START"}
2020-04-22 08:43:09 AUDIT audit:74 - {"time":"April 22, 2020 1:43:09 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693659709144481","opStatus":"START"}
2020-04-22 08:43:09 AUDIT audit:74 - {"time":"April 22, 2020 1:43:09 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693659716127539","opStatus":"START"}
2020-04-22 08:43:09 AUDIT audit:97 - {"time":"April 22, 2020 1:43:09 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693659716127539","opStatus":"SUCCESS","opTime":"60 ms","table":"NA","extraInfo":{}}
2020-04-22 08:43:09 AUDIT audit:97 - {"time":"April 22, 2020 1:43:09 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693659709144481","opStatus":"SUCCESS","opTime":"69 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-22 08:43:09 AUDIT audit:97 - {"time":"April 22, 2020 1:43:09 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6693659683539482","opStatus":"SUCCESS","opTime":"311 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-22 08:43:09 AUDIT audit:74 - {"time":"April 22, 2020 1:43:09 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6693659999922881","opStatus":"START"}
2020-04-22 08:43:09 AUDIT audit:74 - {"time":"April 22, 2020 1:43:09 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693660027137029","opStatus":"START"}
2020-04-22 08:43:09 AUDIT audit:74 - {"time":"April 22, 2020 1:43:09 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693660034142884","opStatus":"START"}
2020-04-22 08:43:09 AUDIT audit:97 - {"time":"April 22, 2020 1:43:09 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693660034142884","opStatus":"SUCCESS","opTime":"50 ms","table":"NA","extraInfo":{}}
2020-04-22 08:43:09 AUDIT audit:97 - {"time":"April 22, 2020 1:43:09 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693660027137029","opStatus":"SUCCESS","opTime":"60 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-22 08:43:09 AUDIT audit:97 - {"time":"April 22, 2020 1:43:09 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6693659999922881","opStatus":"SUCCESS","opTime":"293 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-22 08:43:09 AUDIT audit:74 - {"time":"April 22, 2020 1:43:09 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6693660299693989","opStatus":"START"}
2020-04-22 08:43:09 AUDIT audit:74 - {"time":"April 22, 2020 1:43:09 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693660329596463","opStatus":"START"}
2020-04-22 08:43:09 AUDIT audit:74 - {"time":"April 22, 2020 1:43:09 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693660337604058","opStatus":"START"}
2020-04-22 08:43:09 AUDIT audit:97 - {"time":"April 22, 2020 1:43:09 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693660337604058","opStatus":"SUCCESS","opTime":"55 ms","table":"NA","extraInfo":{}}
2020-04-22 08:43:09 AUDIT audit:97 - {"time":"April 22, 2020 1:43:09 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693660329596463","opStatus":"SUCCESS","opTime":"66 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-22 08:43:10 AUDIT audit:97 - {"time":"April 22, 2020 1:43:10 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6693660299693989","opStatus":"SUCCESS","opTime":"281 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-22 08:43:10 AUDIT audit:74 - {"time":"April 22, 2020 1:43:10 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6693660759685311","opStatus":"START"}
2020-04-22 08:43:11 AUDIT audit:97 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6693660759685311","opStatus":"SUCCESS","opTime":"805 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- check partitioning for child tables with various combinations[0m
2020-04-22 08:43:11 AUDIT audit:74 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693661578708798","opStatus":"START"}
2020-04-22 08:43:11 AUDIT audit:97 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693661578708798","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-22 08:43:11 AUDIT audit:74 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693661583226161","opStatus":"START"}
2020-04-22 08:43:11 AUDIT audit:97 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693661583226161","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-22 08:43:11 AUDIT audit:74 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693661587511133","opStatus":"START"}
2020-04-22 08:43:11 AUDIT audit:97 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693661587511133","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-22 08:43:11 AUDIT audit:74 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693661591790028","opStatus":"START"}
2020-04-22 08:43:11 AUDIT audit:97 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693661591790028","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-22 08:43:11 AUDIT audit:74 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693661596068834","opStatus":"START"}
2020-04-22 08:43:11 AUDIT audit:97 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693661596068834","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-22 08:43:11 AUDIT audit:74 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693661600335867","opStatus":"START"}
2020-04-22 08:43:11 AUDIT audit:97 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693661600335867","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-22 08:43:11 AUDIT audit:74 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693661604665411","opStatus":"START"}
2020-04-22 08:43:11 AUDIT audit:97 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693661604665411","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-22 08:43:11 AUDIT audit:74 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693661609044501","opStatus":"START"}
2020-04-22 08:43:11 AUDIT audit:97 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693661609044501","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag1"}}
2020-04-22 08:43:11 AUDIT audit:74 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693661613396798","opStatus":"START"}
2020-04-22 08:43:11 AUDIT audit:97 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693661613396798","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-22 08:43:11 AUDIT audit:74 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693661617732010","opStatus":"START"}
2020-04-22 08:43:11 AUDIT audit:97 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693661617732010","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-22 08:43:11 AUDIT audit:74 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693661622054246","opStatus":"START"}
2020-04-22 08:43:11 AUDIT audit:97 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693661622054246","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-22 08:43:11 AUDIT audit:74 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693661626357949","opStatus":"START"}
2020-04-22 08:43:11 AUDIT audit:97 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693661626357949","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-22 08:43:11 AUDIT audit:74 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693661640229964","opStatus":"START"}
2020-04-22 08:43:11 AUDIT audit:97 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693661640229964","opStatus":"SUCCESS","opTime":"87 ms","table":"NA","extraInfo":{}}
2020-04-22 08:43:11 AUDIT audit:74 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6693661814892336","opStatus":"START"}
2020-04-22 08:43:11 AUDIT audit:97 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6693661814892336","opStatus":"SUCCESS","opTime":"427 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-22 08:43:11 AUDIT audit:74 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693662244149895","opStatus":"START"}
2020-04-22 08:43:11 AUDIT audit:97 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693662244149895","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-22 08:43:11 AUDIT audit:74 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6693662249460731","opStatus":"START"}
2020-04-22 08:43:11 AUDIT audit:74 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693662272172642","opStatus":"START"}
2020-04-22 08:43:11 AUDIT audit:74 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693662278907061","opStatus":"START"}
2020-04-22 08:43:11 AUDIT audit:97 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693662278907061","opStatus":"SUCCESS","opTime":"48 ms","table":"NA","extraInfo":{}}
2020-04-22 08:43:11 AUDIT audit:97 - {"time":"April 22, 2020 1:43:11 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693662272172642","opStatus":"SUCCESS","opTime":"58 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-22 08:43:12 AUDIT audit:74 - {"time":"April 22, 2020 1:43:12 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6693662521346308","opStatus":"START"}
2020-04-22 08:43:13 AUDIT audit:97 - {"time":"April 22, 2020 1:43:13 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6693662521346308","opStatus":"SUCCESS","opTime":"1926 ms","table":"partition_mv.dm1","extraInfo":{}}
2020-04-22 08:43:13 AUDIT audit:97 - {"time":"April 22, 2020 1:43:13 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6693662249460731","opStatus":"SUCCESS","opTime":"2197 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-22 08:43:14 AUDIT audit:74 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6693665142222669","opStatus":"START"}
2020-04-22 08:43:14 AUDIT audit:97 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6693665142222669","opStatus":"SUCCESS","opTime":"203 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- test partition at last column[0m
2020-04-22 08:43:14 AUDIT audit:74 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665357393043","opStatus":"START"}
2020-04-22 08:43:14 AUDIT audit:97 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665357393043","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-22 08:43:14 AUDIT audit:74 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665361839950","opStatus":"START"}
2020-04-22 08:43:14 AUDIT audit:97 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665361839950","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-22 08:43:14 AUDIT audit:74 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665366066313","opStatus":"START"}
2020-04-22 08:43:14 AUDIT audit:97 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665366066313","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-22 08:43:14 AUDIT audit:74 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665370280907","opStatus":"START"}
2020-04-22 08:43:14 AUDIT audit:97 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665370280907","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-22 08:43:14 AUDIT audit:74 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665374471036","opStatus":"START"}
2020-04-22 08:43:14 AUDIT audit:97 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665374471036","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-22 08:43:14 AUDIT audit:74 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665378668673","opStatus":"START"}
2020-04-22 08:43:14 AUDIT audit:97 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665378668673","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-22 08:43:14 AUDIT audit:74 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665382858154","opStatus":"START"}
2020-04-22 08:43:14 AUDIT audit:97 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665382858154","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-22 08:43:14 AUDIT audit:74 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665387058609","opStatus":"START"}
2020-04-22 08:43:14 AUDIT audit:97 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665387058609","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag1"}}
2020-04-22 08:43:14 AUDIT audit:74 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665391228736","opStatus":"START"}
2020-04-22 08:43:14 AUDIT audit:97 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665391228736","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-22 08:43:14 AUDIT audit:74 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665395400391","opStatus":"START"}
2020-04-22 08:43:14 AUDIT audit:97 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665395400391","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-22 08:43:14 AUDIT audit:74 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665399591944","opStatus":"START"}
2020-04-22 08:43:14 AUDIT audit:97 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665399591944","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-22 08:43:14 AUDIT audit:74 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665403765214","opStatus":"START"}
2020-04-22 08:43:14 AUDIT audit:97 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665403765214","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-22 08:43:14 AUDIT audit:74 - {"time":"April 22, 2020 1:43:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693665417052455","opStatus":"START"}
2020-04-22 08:43:15 AUDIT audit:97 - {"time":"April 22, 2020 1:43:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693665417052455","opStatus":"SUCCESS","opTime":"60 ms","table":"NA","extraInfo":{}}
2020-04-22 08:43:15 AUDIT audit:74 - {"time":"April 22, 2020 1:43:15 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6693665567579088","opStatus":"START"}
2020-04-22 08:43:15 AUDIT audit:97 - {"time":"April 22, 2020 1:43:15 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6693665567579088","opStatus":"SUCCESS","opTime":"415 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-22 08:43:15 AUDIT audit:74 - {"time":"April 22, 2020 1:43:15 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665984994539","opStatus":"START"}
2020-04-22 08:43:15 AUDIT audit:97 - {"time":"April 22, 2020 1:43:15 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693665984994539","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-22 08:43:15 AUDIT audit:74 - {"time":"April 22, 2020 1:43:15 AM PDT","username":"jenkins","opName":"DESC FORMATTED","opId":"6693666072586393","opStatus":"START"}
2020-04-22 08:43:15 ERROR CarbonUtil:2444 - Unable to unlock Table lock for table during table status updation
2020-04-22 08:43:15 AUDIT audit:97 - {"time":"April 22, 2020 1:43:15 AM PDT","username":"jenkins","opName":"DESC FORMATTED","opId":"6693666072586393","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 |Wed Apr 22 01:43:14 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 |Wed Apr 22 01:43:15 PDT 2020 | |
+-----------------------------+-----------------------------------------------------------------------------------------------------------------------+-------+
2020-04-22 08:43:15 AUDIT audit:74 - {"time":"April 22, 2020 1:43:15 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6693666161595934","opStatus":"START"}
2020-04-22 08:43:15 AUDIT audit:74 - {"time":"April 22, 2020 1:43:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693666188404869","opStatus":"START"}
2020-04-22 08:43:15 AUDIT audit:74 - {"time":"April 22, 2020 1:43:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693666194947364","opStatus":"START"}
2020-04-22 08:43:15 AUDIT audit:97 - {"time":"April 22, 2020 1:43:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693666194947364","opStatus":"SUCCESS","opTime":"57 ms","table":"NA","extraInfo":{}}
2020-04-22 08:43:15 AUDIT audit:97 - {"time":"April 22, 2020 1:43:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693666188404869","opStatus":"SUCCESS","opTime":"66 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-22 08:43:15 AUDIT audit:74 - {"time":"April 22, 2020 1:43:15 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6693666427650677","opStatus":"START"}
2020-04-22 08:43:16 AUDIT audit:97 - {"time":"April 22, 2020 1:43:16 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6693666427650677","opStatus":"SUCCESS","opTime":"761 ms","table":"partition_mv.dm1","extraInfo":{"SegmentId":"0","DataSize":"688.0B","IndexSize":"454.0B"}}
2020-04-22 08:43:16 AUDIT audit:97 - {"time":"April 22, 2020 1:43:16 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6693666161595934","opStatus":"SUCCESS","opTime":"1025 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-22 08:43:17 AUDIT audit:74 - {"time":"April 22, 2020 1:43:17 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6693667694044514","opStatus":"START"}
2020-04-22 08:43:17 AUDIT audit:97 - {"time":"April 22, 2020 1:43:17 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6693667694044514","opStatus":"SUCCESS","opTime":"552 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-22 08:43:17 AUDIT audit:74 - {"time":"April 22, 2020 1:43:17 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693668250368400","opStatus":"START"}
2020-04-22 08:43:17 AUDIT audit:97 - {"time":"April 22, 2020 1:43:17 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693668250368400","opStatus":"SUCCESS","opTime":"52 ms","table":"NA","extraInfo":{}}
2020-04-22 08:43:17 AUDIT audit:74 - {"time":"April 22, 2020 1:43:17 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6693668369258527","opStatus":"START"}
2020-04-22 08:43:18 AUDIT audit:97 - {"time":"April 22, 2020 1:43:18 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6693668369258527","opStatus":"SUCCESS","opTime":"353 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-22 08:43:18 AUDIT audit:74 - {"time":"April 22, 2020 1:43:18 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693668723140088","opStatus":"START"}
2020-04-22 08:43:18 AUDIT audit:97 - {"time":"April 22, 2020 1:43:18 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6693668723140088","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-22 08:43:18 AUDIT audit:74 - {"time":"April 22, 2020 1:43:18 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6693668727844510","opStatus":"START"}
2020-04-22 08:43:18 AUDIT audit:74 - {"time":"April 22, 2020 1:43:18 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693668747606588","opStatus":"START"}
2020-04-22 08:43:18 AUDIT audit:74 - {"time":"April 22, 2020 1:43:18 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693668753310710","opStatus":"START"}
2020-04-22 08:43:18 AUDIT audit:97 - {"time":"April 22, 2020 1:43:18 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693668753310710","opStatus":"SUCCESS","opTime":"75 ms","table":"NA","extraInfo":{}}
2020-04-22 08:43:18 AUDIT audit:97 - {"time":"April 22, 2020 1:43:18 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6693668747606588","opStatus":"SUCCESS","opTime":"84 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-22 08:43:18 AUDIT audit:74 - {"time":"April 22, 2020 1:43:18 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6693669075379191","opStatus":"START"}
2020-04-22 08:43:20 AUDIT audit:97 - {"time":"April 22, 2020 1:43:20 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6693669075379191","opStatus":"SUCCESS","opTime":"2234 ms","table":"partition_mv.dm1","extraInfo":{}}
2020-04-22 08:43:20 AUDIT audit:97 - {"time":"April 22, 2020 1:43:20 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6693668727844510","opStatus":"SUCCESS","opTime":"2582 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-22 08:43:21 AUDIT audit:74 - {"time":"April 22, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6693671844342281","opStatus":"START"}
2020-04-22 08:43:21 AUDIT audit:97 - {"time":"April 22, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6693671844342281","opStatus":"SUCCESS","opTime":"219 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- test partition on timeseries column[0m
2020-04-22 08:43:21 AUDIT audit:74 - {"time":"April 22, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6693672212568650","opStatus":"START"}
2020-04-22 08:43:21 AUDIT audit:97 - {"time":"April 22, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6693672212568650","opStatus":"SUCCESS","opTime":"98 ms","table":"partition_mv.droppartition","extraInfo":{}}
2020-04-22 08:43:21 AUDIT audit:74 - {"time":"April 22, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6693672311301556","opStatus":"START"}
2020-04-22 08:43:21 AUDIT audit:97 - {"time":"April 22, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6693672311301556","opStatus":"SUCCESS","opTime":"150 ms","table":"partition_mv.maintable","extraInfo":{}}
2020-04-22 08:43:21 AUDIT audit:74 - {"time":"April 22, 2020 1:43:21 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6693672462041055","opStatus":"START"}
2020-04-22 08:43:22 AUDIT audit:97 - {"time":"April 22, 2020 1:43:22 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6693672462041055","opStatus":"SUCCESS","opTime":"57 ms","table":"partition_mv.par","extraInfo":{}}
2020-04-22 08:43:22 AUDIT audit:74 - {"time":"April 22, 2020 1:43:22 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6693672519127797","opStatus":"START"}
2020-04-22 08:43:22 AUDIT audit:97 - {"time":"April 22, 2020 1:43:22 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6693672519127797","opStatus":"SUCCESS","opTime":"153 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, 58 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 #2207
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/2207/display/redirect>
Changes:
------------------------------------------
[...truncated 1.53 MB...]
2020-04-21 08:38:22 AUDIT audit:97 - {"time":"April 21, 2020 1:38:22 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601440267238154","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-21 08:38:22 AUDIT audit:74 - {"time":"April 21, 2020 1:38:22 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601440271667454","opStatus":"START"}
2020-04-21 08:38:22 AUDIT audit:97 - {"time":"April 21, 2020 1:38:22 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601440271667454","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-21 08:38:22 AUDIT audit:74 - {"time":"April 21, 2020 1:38:22 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601440276109065","opStatus":"START"}
2020-04-21 08:38:22 AUDIT audit:97 - {"time":"April 21, 2020 1:38:22 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601440276109065","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-21 08:38:22 AUDIT audit:74 - {"time":"April 21, 2020 1:38:22 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601440280543753","opStatus":"START"}
2020-04-21 08:38:22 AUDIT audit:97 - {"time":"April 21, 2020 1:38:22 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601440280543753","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-21 08:38:22 AUDIT audit:74 - {"time":"April 21, 2020 1:38:22 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601440296937258","opStatus":"START"}
2020-04-21 08:38:22 AUDIT audit:97 - {"time":"April 21, 2020 1:38:22 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601440296937258","opStatus":"SUCCESS","opTime":"70 ms","table":"NA","extraInfo":{}}
2020-04-21 08:38:22 AUDIT audit:74 - {"time":"April 21, 2020 1:38:22 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6601440369736045","opStatus":"START"}
2020-04-21 08:38:22 AUDIT audit:74 - {"time":"April 21, 2020 1:38:22 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601440396044135","opStatus":"START"}
2020-04-21 08:38:22 AUDIT audit:74 - {"time":"April 21, 2020 1:38:22 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601440402857058","opStatus":"START"}
2020-04-21 08:38:22 AUDIT audit:97 - {"time":"April 21, 2020 1:38:22 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601440402857058","opStatus":"SUCCESS","opTime":"43 ms","table":"NA","extraInfo":{}}
2020-04-21 08:38:22 AUDIT audit:97 - {"time":"April 21, 2020 1:38:22 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601440396044135","opStatus":"SUCCESS","opTime":"53 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-21 08:38:22 AUDIT audit:97 - {"time":"April 21, 2020 1:38:22 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6601440369736045","opStatus":"SUCCESS","opTime":"249 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-21 08:38:22 AUDIT audit:74 - {"time":"April 21, 2020 1:38:22 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6601440623923083","opStatus":"START"}
2020-04-21 08:38:22 AUDIT audit:74 - {"time":"April 21, 2020 1:38:22 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601440645837335","opStatus":"START"}
2020-04-21 08:38:22 AUDIT audit:74 - {"time":"April 21, 2020 1:38:22 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601440652335757","opStatus":"START"}
2020-04-21 08:38:22 AUDIT audit:97 - {"time":"April 21, 2020 1:38:22 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601440652335757","opStatus":"SUCCESS","opTime":"44 ms","table":"NA","extraInfo":{}}
2020-04-21 08:38:22 AUDIT audit:97 - {"time":"April 21, 2020 1:38:22 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601440645837335","opStatus":"SUCCESS","opTime":"53 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-21 08:38:23 AUDIT audit:97 - {"time":"April 21, 2020 1:38:23 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6601440623923083","opStatus":"SUCCESS","opTime":"232 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-21 08:38:23 AUDIT audit:74 - {"time":"April 21, 2020 1:38:23 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6601440861500846","opStatus":"START"}
2020-04-21 08:38:23 AUDIT audit:74 - {"time":"April 21, 2020 1:38:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601440883998194","opStatus":"START"}
2020-04-21 08:38:23 AUDIT audit:74 - {"time":"April 21, 2020 1:38:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601440890805399","opStatus":"START"}
2020-04-21 08:38:23 AUDIT audit:97 - {"time":"April 21, 2020 1:38:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601440890805399","opStatus":"SUCCESS","opTime":"81 ms","table":"NA","extraInfo":{}}
2020-04-21 08:38:23 AUDIT audit:97 - {"time":"April 21, 2020 1:38:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601440883998194","opStatus":"SUCCESS","opTime":"91 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-21 08:38:23 AUDIT audit:97 - {"time":"April 21, 2020 1:38:23 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6601440861500846","opStatus":"SUCCESS","opTime":"273 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-21 08:38:23 AUDIT audit:74 - {"time":"April 21, 2020 1:38:23 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6601441139995486","opStatus":"START"}
2020-04-21 08:38:23 AUDIT audit:74 - {"time":"April 21, 2020 1:38:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601441164428614","opStatus":"START"}
2020-04-21 08:38:23 AUDIT audit:74 - {"time":"April 21, 2020 1:38:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601441171331558","opStatus":"START"}
2020-04-21 08:38:23 AUDIT audit:97 - {"time":"April 21, 2020 1:38:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601441171331558","opStatus":"SUCCESS","opTime":"34 ms","table":"NA","extraInfo":{}}
2020-04-21 08:38:23 AUDIT audit:97 - {"time":"April 21, 2020 1:38:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601441164428614","opStatus":"SUCCESS","opTime":"43 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-21 08:38:23 AUDIT audit:97 - {"time":"April 21, 2020 1:38:23 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6601441139995486","opStatus":"SUCCESS","opTime":"231 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-21 08:38:23 AUDIT audit:74 - {"time":"April 21, 2020 1:38:23 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6601441376265322","opStatus":"START"}
2020-04-21 08:38:23 AUDIT audit:74 - {"time":"April 21, 2020 1:38:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601441400125577","opStatus":"START"}
2020-04-21 08:38:23 AUDIT audit:74 - {"time":"April 21, 2020 1:38:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601441407129990","opStatus":"START"}
2020-04-21 08:38:23 AUDIT audit:97 - {"time":"April 21, 2020 1:38:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601441407129990","opStatus":"SUCCESS","opTime":"48 ms","table":"NA","extraInfo":{}}
2020-04-21 08:38:23 AUDIT audit:97 - {"time":"April 21, 2020 1:38:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601441400125577","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-21 08:38:23 AUDIT audit:97 - {"time":"April 21, 2020 1:38:23 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6601441376265322","opStatus":"SUCCESS","opTime":"245 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-21 08:38:23 AUDIT audit:74 - {"time":"April 21, 2020 1:38:23 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6601441626166515","opStatus":"START"}
2020-04-21 08:38:23 AUDIT audit:74 - {"time":"April 21, 2020 1:38:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601441649367571","opStatus":"START"}
2020-04-21 08:38:23 AUDIT audit:74 - {"time":"April 21, 2020 1:38:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601441655998033","opStatus":"START"}
2020-04-21 08:38:23 AUDIT audit:97 - {"time":"April 21, 2020 1:38:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601441655998033","opStatus":"SUCCESS","opTime":"33 ms","table":"NA","extraInfo":{}}
2020-04-21 08:38:23 AUDIT audit:97 - {"time":"April 21, 2020 1:38:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601441649367571","opStatus":"SUCCESS","opTime":"42 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-21 08:38:24 AUDIT audit:97 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6601441626166515","opStatus":"SUCCESS","opTime":"217 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-21 08:38:24 AUDIT audit:74 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6601441848554194","opStatus":"START"}
2020-04-21 08:38:24 AUDIT audit:74 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601441873316293","opStatus":"START"}
2020-04-21 08:38:24 AUDIT audit:74 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601441880031823","opStatus":"START"}
2020-04-21 08:38:24 AUDIT audit:97 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601441880031823","opStatus":"SUCCESS","opTime":"42 ms","table":"NA","extraInfo":{}}
2020-04-21 08:38:24 AUDIT audit:97 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601441873316293","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-21 08:38:24 AUDIT audit:97 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6601441848554194","opStatus":"SUCCESS","opTime":"232 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-21 08:38:24 AUDIT audit:74 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6601442229571651","opStatus":"START"}
2020-04-21 08:38:24 AUDIT audit:97 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6601442229571651","opStatus":"SUCCESS","opTime":"536 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- check partitioning for child tables with various combinations[0m
2020-04-21 08:38:24 AUDIT audit:74 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601442776859323","opStatus":"START"}
2020-04-21 08:38:24 AUDIT audit:97 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601442776859323","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-21 08:38:24 AUDIT audit:74 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601442781584924","opStatus":"START"}
2020-04-21 08:38:24 AUDIT audit:97 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601442781584924","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-21 08:38:24 AUDIT audit:74 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601442786077730","opStatus":"START"}
2020-04-21 08:38:24 AUDIT audit:97 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601442786077730","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-21 08:38:24 AUDIT audit:74 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601442790591693","opStatus":"START"}
2020-04-21 08:38:24 AUDIT audit:97 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601442790591693","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-21 08:38:24 AUDIT audit:74 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601442795103653","opStatus":"START"}
2020-04-21 08:38:24 AUDIT audit:97 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601442795103653","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-21 08:38:24 AUDIT audit:74 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601442799539408","opStatus":"START"}
2020-04-21 08:38:24 AUDIT audit:97 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601442799539408","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-21 08:38:24 AUDIT audit:74 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601442804064578","opStatus":"START"}
2020-04-21 08:38:24 AUDIT audit:97 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601442804064578","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-21 08:38:24 AUDIT audit:74 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601442808512275","opStatus":"START"}
2020-04-21 08:38:24 AUDIT audit:97 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601442808512275","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag1"}}
2020-04-21 08:38:24 AUDIT audit:74 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601442812960432","opStatus":"START"}
2020-04-21 08:38:24 AUDIT audit:97 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601442812960432","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-21 08:38:24 AUDIT audit:74 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601442817400991","opStatus":"START"}
2020-04-21 08:38:24 AUDIT audit:97 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601442817400991","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-21 08:38:24 AUDIT audit:74 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601442821865459","opStatus":"START"}
2020-04-21 08:38:24 AUDIT audit:97 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601442821865459","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-21 08:38:24 AUDIT audit:74 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601442826299307","opStatus":"START"}
2020-04-21 08:38:24 AUDIT audit:97 - {"time":"April 21, 2020 1:38:24 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601442826299307","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-21 08:38:25 AUDIT audit:74 - {"time":"April 21, 2020 1:38:25 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601442839935986","opStatus":"START"}
2020-04-21 08:38:25 AUDIT audit:97 - {"time":"April 21, 2020 1:38:25 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601442839935986","opStatus":"SUCCESS","opTime":"77 ms","table":"NA","extraInfo":{}}
2020-04-21 08:38:25 AUDIT audit:74 - {"time":"April 21, 2020 1:38:25 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6601442993834478","opStatus":"START"}
2020-04-21 08:38:25 AUDIT audit:97 - {"time":"April 21, 2020 1:38:25 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6601442993834478","opStatus":"SUCCESS","opTime":"378 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-21 08:38:25 AUDIT audit:74 - {"time":"April 21, 2020 1:38:25 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601443373335220","opStatus":"START"}
2020-04-21 08:38:25 AUDIT audit:97 - {"time":"April 21, 2020 1:38:25 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601443373335220","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-21 08:38:25 AUDIT audit:74 - {"time":"April 21, 2020 1:38:25 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6601443378708981","opStatus":"START"}
2020-04-21 08:38:25 AUDIT audit:74 - {"time":"April 21, 2020 1:38:25 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601443399451705","opStatus":"START"}
2020-04-21 08:38:25 AUDIT audit:74 - {"time":"April 21, 2020 1:38:25 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601443406116492","opStatus":"START"}
2020-04-21 08:38:25 AUDIT audit:97 - {"time":"April 21, 2020 1:38:25 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601443406116492","opStatus":"SUCCESS","opTime":"36 ms","table":"NA","extraInfo":{}}
2020-04-21 08:38:25 AUDIT audit:97 - {"time":"April 21, 2020 1:38:25 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601443399451705","opStatus":"SUCCESS","opTime":"45 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-21 08:38:25 AUDIT audit:74 - {"time":"April 21, 2020 1:38:25 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6601443640086145","opStatus":"START"}
2020-04-21 08:38:28 AUDIT audit:97 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6601443640086145","opStatus":"SUCCESS","opTime":"2197 ms","table":"partition_mv.dm1","extraInfo":{}}
2020-04-21 08:38:28 AUDIT audit:97 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6601443378708981","opStatus":"SUCCESS","opTime":"2458 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-21 08:38:28 AUDIT audit:74 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6601446363152449","opStatus":"START"}
2020-04-21 08:38:28 AUDIT audit:97 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6601446363152449","opStatus":"SUCCESS","opTime":"179 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- test partition at last column[0m
2020-04-21 08:38:28 AUDIT audit:74 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601446554477667","opStatus":"START"}
2020-04-21 08:38:28 AUDIT audit:97 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601446554477667","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-21 08:38:28 AUDIT audit:74 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601446559084024","opStatus":"START"}
2020-04-21 08:38:28 AUDIT audit:97 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601446559084024","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-21 08:38:28 AUDIT audit:74 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601446563532616","opStatus":"START"}
2020-04-21 08:38:28 AUDIT audit:97 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601446563532616","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-21 08:38:28 AUDIT audit:74 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601446568016809","opStatus":"START"}
2020-04-21 08:38:28 AUDIT audit:97 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601446568016809","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-21 08:38:28 AUDIT audit:74 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601446572420263","opStatus":"START"}
2020-04-21 08:38:28 AUDIT audit:97 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601446572420263","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-21 08:38:28 AUDIT audit:74 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601446576871721","opStatus":"START"}
2020-04-21 08:38:28 AUDIT audit:97 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601446576871721","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-21 08:38:28 AUDIT audit:74 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601446582509385","opStatus":"START"}
2020-04-21 08:38:28 AUDIT audit:97 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601446582509385","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-21 08:38:28 AUDIT audit:74 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601446586953084","opStatus":"START"}
2020-04-21 08:38:28 AUDIT audit:97 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601446586953084","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag1"}}
2020-04-21 08:38:28 AUDIT audit:74 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601446591541214","opStatus":"START"}
2020-04-21 08:38:28 AUDIT audit:97 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601446591541214","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-21 08:38:28 AUDIT audit:74 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601446596173123","opStatus":"START"}
2020-04-21 08:38:28 AUDIT audit:97 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601446596173123","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-21 08:38:28 AUDIT audit:74 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601446600842755","opStatus":"START"}
2020-04-21 08:38:28 AUDIT audit:97 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601446600842755","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-21 08:38:28 AUDIT audit:74 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601446605235012","opStatus":"START"}
2020-04-21 08:38:28 AUDIT audit:97 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601446605235012","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-21 08:38:28 AUDIT audit:74 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601446618735223","opStatus":"START"}
2020-04-21 08:38:28 AUDIT audit:97 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601446618735223","opStatus":"SUCCESS","opTime":"41 ms","table":"NA","extraInfo":{}}
2020-04-21 08:38:28 AUDIT audit:74 - {"time":"April 21, 2020 1:38:28 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6601446744448195","opStatus":"START"}
2020-04-21 08:38:29 AUDIT audit:97 - {"time":"April 21, 2020 1:38:29 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6601446744448195","opStatus":"SUCCESS","opTime":"382 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-21 08:38:29 AUDIT audit:74 - {"time":"April 21, 2020 1:38:29 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601447128958007","opStatus":"START"}
2020-04-21 08:38:29 AUDIT audit:97 - {"time":"April 21, 2020 1:38:29 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601447128958007","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-21 08:38:29 AUDIT audit:74 - {"time":"April 21, 2020 1:38:29 AM PDT","username":"jenkins","opName":"DESC FORMATTED","opId":"6601447209661376","opStatus":"START"}
2020-04-21 08:38:29 ERROR CarbonUtil:2444 - Unable to unlock Table lock for table during table status updation
2020-04-21 08:38:29 AUDIT audit:97 - {"time":"April 21, 2020 1:38:29 AM PDT","username":"jenkins","opName":"DESC FORMATTED","opId":"6601447209661376","opStatus":"SUCCESS","opTime":"37 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 |Tue Apr 21 01:38:28 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 |Tue Apr 21 01:38:29 PDT 2020 | |
+-----------------------------+-----------------------------------------------------------------------------------------------------------------------+-------+
2020-04-21 08:38:29 AUDIT audit:74 - {"time":"April 21, 2020 1:38:29 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6601447294060584","opStatus":"START"}
2020-04-21 08:38:29 AUDIT audit:74 - {"time":"April 21, 2020 1:38:29 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601447318357273","opStatus":"START"}
2020-04-21 08:38:29 AUDIT audit:74 - {"time":"April 21, 2020 1:38:29 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601447324915018","opStatus":"START"}
2020-04-21 08:38:29 AUDIT audit:97 - {"time":"April 21, 2020 1:38:29 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601447324915018","opStatus":"SUCCESS","opTime":"51 ms","table":"NA","extraInfo":{}}
2020-04-21 08:38:29 AUDIT audit:97 - {"time":"April 21, 2020 1:38:29 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601447318357273","opStatus":"SUCCESS","opTime":"60 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-21 08:38:29 AUDIT audit:74 - {"time":"April 21, 2020 1:38:29 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6601447541120513","opStatus":"START"}
2020-04-21 08:38:30 AUDIT audit:97 - {"time":"April 21, 2020 1:38:30 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6601447541120513","opStatus":"SUCCESS","opTime":"767 ms","table":"partition_mv.dm1","extraInfo":{"SegmentId":"0","DataSize":"688.0B","IndexSize":"454.0B"}}
2020-04-21 08:38:30 AUDIT audit:97 - {"time":"April 21, 2020 1:38:30 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6601447294060584","opStatus":"SUCCESS","opTime":"1013 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-21 08:38:31 AUDIT audit:74 - {"time":"April 21, 2020 1:38:31 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6601448838408648","opStatus":"START"}
2020-04-21 08:38:31 AUDIT audit:97 - {"time":"April 21, 2020 1:38:31 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6601448838408648","opStatus":"SUCCESS","opTime":"177 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-21 08:38:31 AUDIT audit:74 - {"time":"April 21, 2020 1:38:31 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601449019942169","opStatus":"START"}
2020-04-21 08:38:31 AUDIT audit:97 - {"time":"April 21, 2020 1:38:31 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601449019942169","opStatus":"SUCCESS","opTime":"40 ms","table":"NA","extraInfo":{}}
2020-04-21 08:38:31 AUDIT audit:74 - {"time":"April 21, 2020 1:38:31 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6601449136636766","opStatus":"START"}
2020-04-21 08:38:31 AUDIT audit:97 - {"time":"April 21, 2020 1:38:31 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6601449136636766","opStatus":"SUCCESS","opTime":"383 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-21 08:38:31 AUDIT audit:74 - {"time":"April 21, 2020 1:38:31 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601449521389191","opStatus":"START"}
2020-04-21 08:38:31 AUDIT audit:97 - {"time":"April 21, 2020 1:38:31 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6601449521389191","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-21 08:38:31 AUDIT audit:74 - {"time":"April 21, 2020 1:38:31 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6601449527072447","opStatus":"START"}
2020-04-21 08:38:31 AUDIT audit:74 - {"time":"April 21, 2020 1:38:31 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601449549049049","opStatus":"START"}
2020-04-21 08:38:31 AUDIT audit:74 - {"time":"April 21, 2020 1:38:31 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601449555754192","opStatus":"START"}
2020-04-21 08:38:31 AUDIT audit:97 - {"time":"April 21, 2020 1:38:31 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601449555754192","opStatus":"SUCCESS","opTime":"62 ms","table":"NA","extraInfo":{}}
2020-04-21 08:38:31 AUDIT audit:97 - {"time":"April 21, 2020 1:38:31 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6601449549049049","opStatus":"SUCCESS","opTime":"72 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-21 08:38:31 AUDIT audit:74 - {"time":"April 21, 2020 1:38:31 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6601449795494310","opStatus":"START"}
2020-04-21 08:38:34 AUDIT audit:97 - {"time":"April 21, 2020 1:38:34 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6601449795494310","opStatus":"SUCCESS","opTime":"2584 ms","table":"partition_mv.dm1","extraInfo":{}}
2020-04-21 08:38:34 AUDIT audit:97 - {"time":"April 21, 2020 1:38:34 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6601449527072447","opStatus":"SUCCESS","opTime":"2851 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-21 08:38:35 AUDIT audit:74 - {"time":"April 21, 2020 1:38:35 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6601452865258695","opStatus":"START"}
2020-04-21 08:38:35 AUDIT audit:97 - {"time":"April 21, 2020 1:38:35 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6601452865258695","opStatus":"SUCCESS","opTime":"195 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- test partition on timeseries column[0m
2020-04-21 08:38:35 AUDIT audit:74 - {"time":"April 21, 2020 1:38:35 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6601453214440771","opStatus":"START"}
2020-04-21 08:38:35 AUDIT audit:97 - {"time":"April 21, 2020 1:38:35 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6601453214440771","opStatus":"SUCCESS","opTime":"123 ms","table":"partition_mv.droppartition","extraInfo":{}}
2020-04-21 08:38:35 AUDIT audit:74 - {"time":"April 21, 2020 1:38:35 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6601453338006826","opStatus":"START"}
2020-04-21 08:38:35 AUDIT audit:97 - {"time":"April 21, 2020 1:38:35 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6601453338006826","opStatus":"SUCCESS","opTime":"135 ms","table":"partition_mv.maintable","extraInfo":{}}
2020-04-21 08:38:35 AUDIT audit:74 - {"time":"April 21, 2020 1:38:35 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6601453472892140","opStatus":"START"}
2020-04-21 08:38:35 AUDIT audit:97 - {"time":"April 21, 2020 1:38:35 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6601453472892140","opStatus":"SUCCESS","opTime":"133 ms","table":"partition_mv.par","extraInfo":{}}
2020-04-21 08:38:35 AUDIT audit:74 - {"time":"April 21, 2020 1:38:35 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6601453605777920","opStatus":"START"}
2020-04-21 08:38:35 AUDIT audit:97 - {"time":"April 21, 2020 1:38:35 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6601453605777920","opStatus":"SUCCESS","opTime":"185 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, 44 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 #2206
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/2206/display/redirect>
Changes:
------------------------------------------
[...truncated 1.53 MB...]
2020-04-20 09:44:36 AUDIT audit:97 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519014041647454","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-20 09:44:36 AUDIT audit:74 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519014045543553","opStatus":"START"}
2020-04-20 09:44:36 AUDIT audit:97 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519014045543553","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-20 09:44:36 AUDIT audit:74 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519014049444701","opStatus":"START"}
2020-04-20 09:44:36 AUDIT audit:97 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519014049444701","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-20 09:44:36 AUDIT audit:74 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519014053336811","opStatus":"START"}
2020-04-20 09:44:36 AUDIT audit:97 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519014053336811","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-20 09:44:36 AUDIT audit:74 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519014066013138","opStatus":"START"}
2020-04-20 09:44:36 AUDIT audit:97 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519014066013138","opStatus":"SUCCESS","opTime":"66 ms","table":"NA","extraInfo":{}}
2020-04-20 09:44:36 AUDIT audit:74 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6519014135004479","opStatus":"START"}
2020-04-20 09:44:36 AUDIT audit:74 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519014165734229","opStatus":"START"}
2020-04-20 09:44:36 AUDIT audit:74 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519014173127598","opStatus":"START"}
2020-04-20 09:44:36 AUDIT audit:97 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519014173127598","opStatus":"SUCCESS","opTime":"47 ms","table":"NA","extraInfo":{}}
2020-04-20 09:44:36 AUDIT audit:97 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519014165734229","opStatus":"SUCCESS","opTime":"57 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-20 09:44:36 AUDIT audit:97 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6519014135004479","opStatus":"SUCCESS","opTime":"258 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-20 09:44:36 AUDIT audit:74 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6519014398081828","opStatus":"START"}
2020-04-20 09:44:36 AUDIT audit:74 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519014419143933","opStatus":"START"}
2020-04-20 09:44:36 AUDIT audit:74 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519014424939954","opStatus":"START"}
2020-04-20 09:44:36 AUDIT audit:97 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519014424939954","opStatus":"SUCCESS","opTime":"45 ms","table":"NA","extraInfo":{}}
2020-04-20 09:44:36 AUDIT audit:97 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519014419143933","opStatus":"SUCCESS","opTime":"54 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-20 09:44:36 AUDIT audit:97 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6519014398081828","opStatus":"SUCCESS","opTime":"229 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-20 09:44:36 AUDIT audit:74 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6519014631506172","opStatus":"START"}
2020-04-20 09:44:36 AUDIT audit:74 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519014653331120","opStatus":"START"}
2020-04-20 09:44:36 AUDIT audit:74 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519014659444918","opStatus":"START"}
2020-04-20 09:44:36 AUDIT audit:97 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519014659444918","opStatus":"SUCCESS","opTime":"73 ms","table":"NA","extraInfo":{}}
2020-04-20 09:44:36 AUDIT audit:97 - {"time":"April 20, 2020 2:44:36 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519014653331120","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-20 09:44:37 AUDIT audit:97 - {"time":"April 20, 2020 2:44:37 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6519014631506172","opStatus":"SUCCESS","opTime":"263 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-20 09:44:37 AUDIT audit:74 - {"time":"April 20, 2020 2:44:37 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6519014899770081","opStatus":"START"}
2020-04-20 09:44:37 AUDIT audit:74 - {"time":"April 20, 2020 2:44:37 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519014923570161","opStatus":"START"}
2020-04-20 09:44:37 AUDIT audit:74 - {"time":"April 20, 2020 2:44:37 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519014929825812","opStatus":"START"}
2020-04-20 09:44:37 AUDIT audit:97 - {"time":"April 20, 2020 2:44:37 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519014929825812","opStatus":"SUCCESS","opTime":"36 ms","table":"NA","extraInfo":{}}
2020-04-20 09:44:37 AUDIT audit:97 - {"time":"April 20, 2020 2:44:37 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519014923570161","opStatus":"SUCCESS","opTime":"45 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-20 09:44:37 AUDIT audit:97 - {"time":"April 20, 2020 2:44:37 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6519014899770081","opStatus":"SUCCESS","opTime":"258 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-20 09:44:37 AUDIT audit:74 - {"time":"April 20, 2020 2:44:37 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6519015162765001","opStatus":"START"}
2020-04-20 09:44:37 AUDIT audit:74 - {"time":"April 20, 2020 2:44:37 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519015190907473","opStatus":"START"}
2020-04-20 09:44:37 AUDIT audit:74 - {"time":"April 20, 2020 2:44:37 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519015198104223","opStatus":"START"}
2020-04-20 09:44:37 AUDIT audit:97 - {"time":"April 20, 2020 2:44:37 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519015198104223","opStatus":"SUCCESS","opTime":"43 ms","table":"NA","extraInfo":{}}
2020-04-20 09:44:37 AUDIT audit:97 - {"time":"April 20, 2020 2:44:37 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519015190907473","opStatus":"SUCCESS","opTime":"53 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-20 09:44:37 AUDIT audit:97 - {"time":"April 20, 2020 2:44:37 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6519015162765001","opStatus":"SUCCESS","opTime":"293 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-20 09:44:37 AUDIT audit:74 - {"time":"April 20, 2020 2:44:37 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6519015461285526","opStatus":"START"}
2020-04-20 09:44:37 AUDIT audit:74 - {"time":"April 20, 2020 2:44:37 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519015488149010","opStatus":"START"}
2020-04-20 09:44:37 AUDIT audit:74 - {"time":"April 20, 2020 2:44:37 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519015494945025","opStatus":"START"}
2020-04-20 09:44:37 AUDIT audit:97 - {"time":"April 20, 2020 2:44:37 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519015494945025","opStatus":"SUCCESS","opTime":"38 ms","table":"NA","extraInfo":{}}
2020-04-20 09:44:37 AUDIT audit:97 - {"time":"April 20, 2020 2:44:37 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519015488149010","opStatus":"SUCCESS","opTime":"48 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-20 09:44:37 AUDIT audit:97 - {"time":"April 20, 2020 2:44:37 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6519015461285526","opStatus":"SUCCESS","opTime":"278 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-20 09:44:37 AUDIT audit:74 - {"time":"April 20, 2020 2:44:37 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6519015745106436","opStatus":"START"}
2020-04-20 09:44:37 AUDIT audit:74 - {"time":"April 20, 2020 2:44:37 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519015773717457","opStatus":"START"}
2020-04-20 09:44:37 AUDIT audit:74 - {"time":"April 20, 2020 2:44:37 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519015780581853","opStatus":"START"}
2020-04-20 09:44:37 AUDIT audit:97 - {"time":"April 20, 2020 2:44:37 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519015780581853","opStatus":"SUCCESS","opTime":"44 ms","table":"NA","extraInfo":{}}
2020-04-20 09:44:37 AUDIT audit:97 - {"time":"April 20, 2020 2:44:37 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519015773717457","opStatus":"SUCCESS","opTime":"54 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-20 09:44:38 AUDIT audit:97 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6519015745106436","opStatus":"SUCCESS","opTime":"250 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-20 09:44:38 AUDIT audit:74 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6519016148217878","opStatus":"START"}
2020-04-20 09:44:38 AUDIT audit:97 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6519016148217878","opStatus":"SUCCESS","opTime":"554 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- check partitioning for child tables with various combinations[0m
2020-04-20 09:44:38 AUDIT audit:74 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519016713699724","opStatus":"START"}
2020-04-20 09:44:38 AUDIT audit:97 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519016713699724","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-20 09:44:38 AUDIT audit:74 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519016717842621","opStatus":"START"}
2020-04-20 09:44:38 AUDIT audit:97 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519016717842621","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-20 09:44:38 AUDIT audit:74 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519016721812389","opStatus":"START"}
2020-04-20 09:44:38 AUDIT audit:97 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519016721812389","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-20 09:44:38 AUDIT audit:74 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519016725738603","opStatus":"START"}
2020-04-20 09:44:38 AUDIT audit:97 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519016725738603","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-20 09:44:38 AUDIT audit:74 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519016729637248","opStatus":"START"}
2020-04-20 09:44:38 AUDIT audit:97 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519016729637248","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-20 09:44:38 AUDIT audit:74 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519016733589843","opStatus":"START"}
2020-04-20 09:44:38 AUDIT audit:97 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519016733589843","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-20 09:44:38 AUDIT audit:74 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519016737587627","opStatus":"START"}
2020-04-20 09:44:38 AUDIT audit:97 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519016737587627","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-20 09:44:38 AUDIT audit:74 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519016741584686","opStatus":"START"}
2020-04-20 09:44:38 AUDIT audit:97 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519016741584686","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag1"}}
2020-04-20 09:44:38 AUDIT audit:74 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519016745587645","opStatus":"START"}
2020-04-20 09:44:38 AUDIT audit:97 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519016745587645","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-20 09:44:38 AUDIT audit:74 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519016749583463","opStatus":"START"}
2020-04-20 09:44:38 AUDIT audit:97 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519016749583463","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-20 09:44:38 AUDIT audit:74 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519016753625983","opStatus":"START"}
2020-04-20 09:44:38 AUDIT audit:97 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519016753625983","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-20 09:44:38 AUDIT audit:74 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519016757588761","opStatus":"START"}
2020-04-20 09:44:38 AUDIT audit:97 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519016757588761","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-20 09:44:38 AUDIT audit:74 - {"time":"April 20, 2020 2:44:38 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519016769787213","opStatus":"START"}
2020-04-20 09:44:39 AUDIT audit:97 - {"time":"April 20, 2020 2:44:39 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519016769787213","opStatus":"SUCCESS","opTime":"73 ms","table":"NA","extraInfo":{}}
2020-04-20 09:44:39 AUDIT audit:74 - {"time":"April 20, 2020 2:44:39 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6519016930883638","opStatus":"START"}
2020-04-20 09:44:39 AUDIT audit:97 - {"time":"April 20, 2020 2:44:39 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6519016930883638","opStatus":"SUCCESS","opTime":"365 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-20 09:44:39 AUDIT audit:74 - {"time":"April 20, 2020 2:44:39 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519017298671381","opStatus":"START"}
2020-04-20 09:44:39 AUDIT audit:97 - {"time":"April 20, 2020 2:44:39 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519017298671381","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-20 09:44:39 AUDIT audit:74 - {"time":"April 20, 2020 2:44:39 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6519017303480920","opStatus":"START"}
2020-04-20 09:44:39 AUDIT audit:74 - {"time":"April 20, 2020 2:44:39 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519017324258203","opStatus":"START"}
2020-04-20 09:44:39 AUDIT audit:74 - {"time":"April 20, 2020 2:44:39 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519017330207111","opStatus":"START"}
2020-04-20 09:44:39 AUDIT audit:97 - {"time":"April 20, 2020 2:44:39 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519017330207111","opStatus":"SUCCESS","opTime":"38 ms","table":"NA","extraInfo":{}}
2020-04-20 09:44:39 AUDIT audit:97 - {"time":"April 20, 2020 2:44:39 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519017324258203","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-20 09:44:39 AUDIT audit:74 - {"time":"April 20, 2020 2:44:39 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6519017611990388","opStatus":"START"}
2020-04-20 09:44:41 AUDIT audit:97 - {"time":"April 20, 2020 2:44:41 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6519017611990388","opStatus":"SUCCESS","opTime":"1959 ms","table":"partition_mv.dm1","extraInfo":{}}
2020-04-20 09:44:41 AUDIT audit:97 - {"time":"April 20, 2020 2:44:41 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6519017303480920","opStatus":"SUCCESS","opTime":"2266 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-20 09:44:42 AUDIT audit:74 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6519020167966364","opStatus":"START"}
2020-04-20 09:44:42 AUDIT audit:97 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6519020167966364","opStatus":"SUCCESS","opTime":"237 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- test partition at last column[0m
2020-04-20 09:44:42 AUDIT audit:74 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519020416239607","opStatus":"START"}
2020-04-20 09:44:42 AUDIT audit:97 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519020416239607","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p1"}}
2020-04-20 09:44:42 AUDIT audit:74 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519020420792847","opStatus":"START"}
2020-04-20 09:44:42 AUDIT audit:97 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519020420792847","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p2"}}
2020-04-20 09:44:42 AUDIT audit:74 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519020424698870","opStatus":"START"}
2020-04-20 09:44:42 AUDIT audit:97 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519020424698870","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p3"}}
2020-04-20 09:44:42 AUDIT audit:74 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519020428615340","opStatus":"START"}
2020-04-20 09:44:42 AUDIT audit:97 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519020428615340","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p4"}}
2020-04-20 09:44:42 AUDIT audit:74 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519020432548683","opStatus":"START"}
2020-04-20 09:44:42 AUDIT audit:97 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519020432548683","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"p5"}}
2020-04-20 09:44:42 AUDIT audit:74 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519020436427773","opStatus":"START"}
2020-04-20 09:44:42 AUDIT audit:97 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519020436427773","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p6"}}
2020-04-20 09:44:42 AUDIT audit:74 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519020440384382","opStatus":"START"}
2020-04-20 09:44:42 AUDIT audit:97 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519020440384382","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"p7"}}
2020-04-20 09:44:42 AUDIT audit:74 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519020444301879","opStatus":"START"}
2020-04-20 09:44:42 AUDIT audit:97 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519020444301879","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag1"}}
2020-04-20 09:44:42 AUDIT audit:74 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519020448180817","opStatus":"START"}
2020-04-20 09:44:42 AUDIT audit:97 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519020448180817","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag2"}}
2020-04-20 09:44:42 AUDIT audit:74 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519020452062452","opStatus":"START"}
2020-04-20 09:44:42 AUDIT audit:97 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519020452062452","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"ag3"}}
2020-04-20 09:44:42 AUDIT audit:74 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519020455918487","opStatus":"START"}
2020-04-20 09:44:42 AUDIT audit:97 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519020455918487","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag4"}}
2020-04-20 09:44:42 AUDIT audit:74 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519020459808779","opStatus":"START"}
2020-04-20 09:44:42 AUDIT audit:97 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519020459808779","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"ag5"}}
2020-04-20 09:44:42 AUDIT audit:74 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519020471935224","opStatus":"START"}
2020-04-20 09:44:42 AUDIT audit:97 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519020471935224","opStatus":"SUCCESS","opTime":"42 ms","table":"NA","extraInfo":{}}
2020-04-20 09:44:42 AUDIT audit:74 - {"time":"April 20, 2020 2:44:42 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6519020615453090","opStatus":"START"}
2020-04-20 09:44:43 AUDIT audit:97 - {"time":"April 20, 2020 2:44:43 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6519020615453090","opStatus":"SUCCESS","opTime":"394 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-20 09:44:43 AUDIT audit:74 - {"time":"April 20, 2020 2:44:43 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519021011254382","opStatus":"START"}
2020-04-20 09:44:43 AUDIT audit:97 - {"time":"April 20, 2020 2:44:43 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519021011254382","opStatus":"SUCCESS","opTime":"1 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-20 09:44:43 AUDIT audit:74 - {"time":"April 20, 2020 2:44:43 AM PDT","username":"jenkins","opName":"DESC FORMATTED","opId":"6519021085565194","opStatus":"START"}
2020-04-20 09:44:43 ERROR CarbonUtil:2444 - Unable to unlock Table lock for table during table status updation
2020-04-20 09:44:43 AUDIT audit:97 - {"time":"April 20, 2020 2:44:43 AM PDT","username":"jenkins","opName":"DESC FORMATTED","opId":"6519021085565194","opStatus":"SUCCESS","opTime":"33 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 |Mon Apr 20 02:44:42 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 |Mon Apr 20 02:44:43 PDT 2020 | |
+-----------------------------+-----------------------------------------------------------------------------------------------------------------------+-------+
2020-04-20 09:44:43 AUDIT audit:74 - {"time":"April 20, 2020 2:44:43 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6519021164603592","opStatus":"START"}
2020-04-20 09:44:43 AUDIT audit:74 - {"time":"April 20, 2020 2:44:43 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519021188959092","opStatus":"START"}
2020-04-20 09:44:43 AUDIT audit:74 - {"time":"April 20, 2020 2:44:43 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519021194814393","opStatus":"START"}
2020-04-20 09:44:43 AUDIT audit:97 - {"time":"April 20, 2020 2:44:43 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519021194814393","opStatus":"SUCCESS","opTime":"36 ms","table":"NA","extraInfo":{}}
2020-04-20 09:44:43 AUDIT audit:97 - {"time":"April 20, 2020 2:44:43 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519021188959092","opStatus":"SUCCESS","opTime":"45 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-20 09:44:43 AUDIT audit:74 - {"time":"April 20, 2020 2:44:43 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6519021424569606","opStatus":"START"}
2020-04-20 09:44:44 AUDIT audit:97 - {"time":"April 20, 2020 2:44:44 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6519021424569606","opStatus":"SUCCESS","opTime":"730 ms","table":"partition_mv.dm1","extraInfo":{"SegmentId":"0","DataSize":"688.0B","IndexSize":"454.0B"}}
2020-04-20 09:44:44 AUDIT audit:97 - {"time":"April 20, 2020 2:44:44 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6519021164603592","opStatus":"SUCCESS","opTime":"989 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-20 09:44:44 AUDIT audit:74 - {"time":"April 20, 2020 2:44:44 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6519022666996367","opStatus":"START"}
2020-04-20 09:44:45 AUDIT audit:97 - {"time":"April 20, 2020 2:44:45 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6519022666996367","opStatus":"SUCCESS","opTime":"233 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-20 09:44:45 AUDIT audit:74 - {"time":"April 20, 2020 2:44:45 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519022905622484","opStatus":"START"}
2020-04-20 09:44:45 AUDIT audit:97 - {"time":"April 20, 2020 2:44:45 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519022905622484","opStatus":"SUCCESS","opTime":"43 ms","table":"NA","extraInfo":{}}
2020-04-20 09:44:45 AUDIT audit:74 - {"time":"April 20, 2020 2:44:45 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6519023031804344","opStatus":"START"}
2020-04-20 09:44:45 AUDIT audit:97 - {"time":"April 20, 2020 2:44:45 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6519023031804344","opStatus":"SUCCESS","opTime":"353 ms","table":"partition_mv.partitionone","extraInfo":{}}
2020-04-20 09:44:45 AUDIT audit:74 - {"time":"April 20, 2020 2:44:45 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519023386757964","opStatus":"START"}
2020-04-20 09:44:45 AUDIT audit:97 - {"time":"April 20, 2020 2:44:45 AM PDT","username":"jenkins","opName":"DROP MATERIALIZED VIEW","opId":"6519023386757964","opStatus":"SUCCESS","opTime":"0 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-20 09:44:45 AUDIT audit:74 - {"time":"April 20, 2020 2:44:45 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6519023391888791","opStatus":"START"}
2020-04-20 09:44:45 AUDIT audit:74 - {"time":"April 20, 2020 2:44:45 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519023412774964","opStatus":"START"}
2020-04-20 09:44:45 AUDIT audit:74 - {"time":"April 20, 2020 2:44:45 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519023418770211","opStatus":"START"}
2020-04-20 09:44:45 AUDIT audit:97 - {"time":"April 20, 2020 2:44:45 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519023418770211","opStatus":"SUCCESS","opTime":"59 ms","table":"NA","extraInfo":{}}
2020-04-20 09:44:45 AUDIT audit:97 - {"time":"April 20, 2020 2:44:45 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"6519023412774964","opStatus":"SUCCESS","opTime":"68 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-20 09:44:45 AUDIT audit:74 - {"time":"April 20, 2020 2:44:45 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6519023677131513","opStatus":"START"}
2020-04-20 09:44:47 AUDIT audit:97 - {"time":"April 20, 2020 2:44:47 AM PDT","username":"jenkins","opName":"INSERT INTO","opId":"6519023677131513","opStatus":"SUCCESS","opTime":"2125 ms","table":"partition_mv.dm1","extraInfo":{}}
2020-04-20 09:44:47 AUDIT audit:97 - {"time":"April 20, 2020 2:44:47 AM PDT","username":"jenkins","opName":"CREATE MATERIALIZED VIEW","opId":"6519023391888791","opStatus":"SUCCESS","opTime":"2409 ms","table":"NA","extraInfo":{"mvName":"dm1"}}
2020-04-20 09:44:48 AUDIT audit:74 - {"time":"April 20, 2020 2:44:48 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6519026249681124","opStatus":"START"}
2020-04-20 09:44:48 AUDIT audit:97 - {"time":"April 20, 2020 2:44:48 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6519026249681124","opStatus":"SUCCESS","opTime":"179 ms","table":"partition_mv.partitionone","extraInfo":{}}
[32m- test partition on timeseries column[0m
2020-04-20 09:44:48 AUDIT audit:74 - {"time":"April 20, 2020 2:44:48 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6519026591260850","opStatus":"START"}
2020-04-20 09:44:48 AUDIT audit:97 - {"time":"April 20, 2020 2:44:48 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6519026591260850","opStatus":"SUCCESS","opTime":"139 ms","table":"partition_mv.droppartition","extraInfo":{}}
2020-04-20 09:44:48 AUDIT audit:74 - {"time":"April 20, 2020 2:44:48 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6519026731045185","opStatus":"START"}
2020-04-20 09:44:49 AUDIT audit:97 - {"time":"April 20, 2020 2:44:49 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6519026731045185","opStatus":"SUCCESS","opTime":"172 ms","table":"partition_mv.maintable","extraInfo":{}}
2020-04-20 09:44:49 AUDIT audit:74 - {"time":"April 20, 2020 2:44:49 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6519026903086891","opStatus":"START"}
2020-04-20 09:44:49 AUDIT audit:97 - {"time":"April 20, 2020 2:44:49 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6519026903086891","opStatus":"SUCCESS","opTime":"92 ms","table":"partition_mv.par","extraInfo":{}}
2020-04-20 09:44:49 AUDIT audit:74 - {"time":"April 20, 2020 2:44:49 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6519026994958048","opStatus":"START"}
2020-04-20 09:44:49 AUDIT audit:97 - {"time":"April 20, 2020 2:44:49 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"6519026994958048","opStatus":"SUCCESS","opTime":"152 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 19 minutes, 39 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