See <https://builds.apache.org/job/carbondata-master-spark-2.1/org.apache.carbondata$carbondata-examples-spark2/2581/display/redirect>
------------------------------------------ [...truncated 206.22 KB...] 18/07/07 06:04:09 AUDIT CarbonTableCompactor: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Compaction request completed for table default.tablecompaction_table 18/07/07 06:04:09 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been received for table default.tablecompaction_table 18/07/07 06:04:10 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for default.tablecompaction_table 18/07/07 06:04:10 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Compaction request received for table default.tablecompaction_table +-----------------+---------+--------------------+--------------------+---------+-----------+ |SegmentSequenceId| Status| Load Start Time| Load End Time|Merged To|File Format| +-----------------+---------+--------------------+--------------------+---------+-----------+ | 5| Success|2018-07-07 06:04:...|2018-07-07 06:04:...| NA|COLUMNAR_V3| | 4| Success|2018-07-07 06:04:...|2018-07-07 06:04:...| NA|COLUMNAR_V3| | 3| Success|2018-07-07 06:04:...|2018-07-07 06:04:...| NA|COLUMNAR_V3| | 2|Compacted|2018-07-07 06:04:...|2018-07-07 06:04:...| 0.1|COLUMNAR_V3| | 1|Compacted|2018-07-07 06:04:...|2018-07-07 06:04:...| 0.1|COLUMNAR_V3| | 0.1| Success|2018-07-07 06:04:...|2018-07-07 06:04:...| NA|COLUMNAR_V3| | 0|Compacted|2018-07-07 06:04:...|2018-07-07 06:04:...| 0.1|COLUMNAR_V3| +-----------------+---------+--------------------+--------------------+---------+-----------+ 18/07/07 06:04:10 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been received for table default.tablecompaction_table 18/07/07 06:04:10 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for default.tablecompaction_table 18/07/07 06:04:10 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Compaction request received for table default.tablecompaction_table 18/07/07 06:04:10 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been received for table default.tablecompaction_table 18/07/07 06:04:10 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for default.tablecompaction_table 18/07/07 06:04:10 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Compaction request received for table default.tablecompaction_table 18/07/07 06:04:10 AUDIT CarbonTableCompactor: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Compaction request completed for table default.tablecompaction_table 18/07/07 06:04:10 AUDIT CarbonTableCompactor: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Compaction request completed for table default.tablecompaction_table +-----------------+---------+--------------------+--------------------+---------+-----------+ |SegmentSequenceId| Status| Load Start Time| Load End Time|Merged To|File Format| +-----------------+---------+--------------------+--------------------+---------+-----------+ | 7| Success|2018-07-07 06:04:...|2018-07-07 06:04:...| NA|COLUMNAR_V3| | 6| Success|2018-07-07 06:04:...|2018-07-07 06:04:...| NA|COLUMNAR_V3| | 5|Compacted|2018-07-07 06:04:...|2018-07-07 06:04:...| 3.1|COLUMNAR_V3| | 4|Compacted|2018-07-07 06:04:...|2018-07-07 06:04:...| 3.1|COLUMNAR_V3| | 3.1|Compacted|2018-07-07 06:04:...|2018-07-07 06:04:...| 0.2|COLUMNAR_V3| | 3|Compacted|2018-07-07 06:04:...|2018-07-07 06:04:...| 3.1|COLUMNAR_V3| | 2|Compacted|2018-07-07 06:04:...|2018-07-07 06:04:...| 0.1|COLUMNAR_V3| | 1|Compacted|2018-07-07 06:04:...|2018-07-07 06:04:...| 0.1|COLUMNAR_V3| | 0.2| Success|2018-07-07 06:04:...|2018-07-07 06:04:...| NA|COLUMNAR_V3| | 0.1|Compacted|2018-07-07 06:04:...|2018-07-07 06:04:...| 0.2|COLUMNAR_V3| | 0|Compacted|2018-07-07 06:04:...|2018-07-07 06:04:...| 0.1|COLUMNAR_V3| +-----------------+---------+--------------------+--------------------+---------+-----------+ 18/07/07 06:04:10 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been received for table default.tablecompaction_table 18/07/07 06:04:11 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for default.tablecompaction_table 18/07/07 06:04:11 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Compaction request received for table default.tablecompaction_table 18/07/07 06:04:11 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been received for table default.tablecompaction_table 18/07/07 06:04:11 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for default.tablecompaction_table 18/07/07 06:04:11 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Compaction request received for table default.tablecompaction_table 18/07/07 06:04:11 AUDIT CarbonAlterTableCompactionCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Compaction request received for table default.tablecompaction_table 18/07/07 06:04:11 AUDIT CarbonTableCompactor: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Compaction request completed for table default.tablecompaction_table 18/07/07 06:04:11 AUDIT CarbonStore$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]The clean files request has been received for default.tablecompaction_table 18/07/07 06:04:11 AUDIT CarbonStore$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Clean files operation is success for default.tablecompaction_table. +-----------------+-------+--------------------+--------------------+---------+-----------+ |SegmentSequenceId| Status| Load Start Time| Load End Time|Merged To|File Format| +-----------------+-------+--------------------+--------------------+---------+-----------+ | 9|Success|2018-07-07 06:04:...|2018-07-07 06:04:...| NA|COLUMNAR_V3| | 8|Success|2018-07-07 06:04:...|2018-07-07 06:04:...| NA|COLUMNAR_V3| | 0.3|Success|2018-07-07 06:04:...|2018-07-07 06:04:...| NA|COLUMNAR_V3| +-----------------+-------+--------------------+--------------------+---------+-----------+ 18/07/07 06:04:11 AUDIT CarbonDropTableCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Deleting table [tablecompaction_table] under database [default] 18/07/07 06:04:11 AUDIT CarbonDropTableCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Deleted table [tablecompaction_table] under database [default] [32m- TableLevelCompactionOptionExample[0m 18/07/07 06:04:11 AUDIT CarbonCreateTableCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Creating Table with Database name [default] and Table name [timeseriestable] 18/07/07 06:04:11 AUDIT CarbonCreateTableCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Table created with Database name [default] and Table name [timeseriestable] 18/07/07 06:04:11 AUDIT CarbonCreateTableCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Creating Table with Database name [default] and Table name [timeseriestable_agg0_hour] 18/07/07 06:04:12 AUDIT CarbonCreateTableCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Table created with Database name [default] and Table name [timeseriestable_agg0_hour] 18/07/07 06:04:12 AUDIT CarbonCreateDataMapCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]DataMap agg0_hour successfully added 18/07/07 06:04:12 AUDIT CarbonCreateTableCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Creating Table with Database name [default] and Table name [timeseriestable_agg0_day] 18/07/07 06:04:12 AUDIT CarbonCreateTableCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Table created with Database name [default] and Table name [timeseriestable_agg0_day] 18/07/07 06:04:12 AUDIT CarbonCreateDataMapCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]DataMap agg0_day successfully added 18/07/07 06:04:12 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been received for table default.timeseriestable 18/07/07 06:04:13 ERROR DataLoadExecutor: [Executor task launch worker-1][partitionID:table;queryID:20605894635810027] Data Load is partially success for table timeseriestable 18/07/07 06:04:13 AUDIT CacheProvider: [asf931.gq1.ygridcore.net][jenkins][Thread-1]The key carbon.input.segments.default.timeseriestable with value 0 added in the session param 18/07/07 06:04:13 AUDIT CacheProvider: [asf931.gq1.ygridcore.net][jenkins][Thread-1]The key validate.carbon.input.segments.default.timeseriestable with value false added in the session param 18/07/07 06:04:13 AUDIT CacheProvider: [asf931.gq1.ygridcore.net][jenkins][Thread-1]The key carbon.query.directQueryOnDataMap.enabled with value true added in the session param 18/07/07 06:04:13 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been received for table default.timeseriestable_agg0_hour 18/07/07 06:04:14 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for default.timeseriestable_agg0_hour 18/07/07 06:04:14 AUDIT CacheProvider: [asf931.gq1.ygridcore.net][jenkins][Thread-1]The key carbon.input.segments.default.timeseriestable_agg0_hour with value 0 added in the session param 18/07/07 06:04:14 AUDIT CacheProvider: [asf931.gq1.ygridcore.net][jenkins][Thread-1]The key validate.carbon.input.segments.default.timeseriestable_agg0_hour with value false added in the session param 18/07/07 06:04:14 AUDIT CacheProvider: [asf931.gq1.ygridcore.net][jenkins][Thread-1]The key carbon.query.directQueryOnDataMap.enabled with value true added in the session param 18/07/07 06:04:14 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been received for table default.timeseriestable_agg0_day 18/07/07 06:04:15 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for default.timeseriestable_agg0_day 18/07/07 06:04:15 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for default.timeseriestable 18/07/07 06:04:15 AUDIT CacheProvider: [asf931.gq1.ygridcore.net][jenkins][Thread-1]The key carbon.query.directQueryOnDataMap.enabled with value true added in the session param +--------+--------------------+ |sum(age)| UDF(mytime, hour)| +--------+--------------------+ | 68|2000-04-10 01:00:...| | 22|2000-06-26 10:00:...| | 36|2003-04-22 10:00:...| | 64|2004-08-10 11:00:...| | 4|2004-08-11 04:00:...| | 20|2006-02-26 05:00:...| | 82|2006-03-04 10:00:...| | 98|2006-09-24 09:00:...| | 116|2007-07-16 04:00:...| | 70|2009-05-07 05:00:...| | 84|2009-09-08 10:00:...| | 38|2009-10-05 09:00:...| | 82|2011-01-24 10:00:...| | 100|2013-04-15 11:00:...| | 96|2014-09-18 03:00:...| | 76|2016-02-22 06:00:...| | 38|2016-06-05 01:00:...| | 104|2016-07-05 04:00:...| | 4|2017-02-07 03:00:...| | 70|2017-04-06 07:00:...| +--------+--------------------+ only showing top 20 rows +------------------+--------------------+ | avg(age)| UDF(mytime, year)| +------------------+--------------------+ |29.845559845559844|2019-01-01 00:00:...| | 29.99526066350711|2006-01-01 00:00:...| |30.569767441860463|2010-01-01 00:00:...| | 40.0| null| |31.138339920948617|2018-01-01 00:00:...| |29.677777777777777|2017-01-01 00:00:...| |30.139737991266376|2003-01-01 00:00:...| | 31.23963133640553|2005-01-01 00:00:...| | 30.05761316872428|2014-01-01 00:00:...| | 30.31174089068826|2016-01-01 00:00:...| | 30.36178861788618|2011-01-01 00:00:...| | 28.89090909090909|2015-01-01 00:00:...| | 30.65|2009-01-01 00:00:...| |28.962962962962962|2002-01-01 00:00:...| | 28.88256227758007|2004-01-01 00:00:...| |30.852320675105485|2000-01-01 00:00:...| |31.321739130434782|2008-01-01 00:00:...| |29.382716049382715|2012-01-01 00:00:...| |29.090579710144926|2007-01-01 00:00:...| |29.301526717557252|2013-01-01 00:00:...| +------------------+--------------------+ only showing top 20 rows 18/07/07 06:04:16 AUDIT CarbonDropTableCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Deleting table [timeseriestable] under database [default] 18/07/07 06:04:16 AUDIT CarbonDropTableCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Deleting table [timeseriestable_agg0_hour] under database [default] 18/07/07 06:04:16 AUDIT CarbonDropTableCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Deleted table [timeseriestable_agg0_hour] under database [default] 18/07/07 06:04:16 AUDIT CarbonDropTableCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Deleting table [timeseriestable_agg0_day] under database [default] 18/07/07 06:04:16 AUDIT CarbonDropTableCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Deleted table [timeseriestable_agg0_day] under database [default] 18/07/07 06:04:16 AUDIT CarbonDropTableCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Deleted table [timeseriestable] under database [default] [32m- TimeSeriesPreAggregateTableExample[0m 18/07/07 06:04:17 AUDIT CarbonCreateTableCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Creating Table with Database name [default] and Table name [persontable] 18/07/07 06:04:17 AUDIT CarbonCreateTableCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Table created with Database name [default] and Table name [persontable] 18/07/07 06:04:17 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been received for table default.persontable 18/07/07 06:04:18 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for default.persontable 18/07/07 06:04:18 AUDIT CarbonCreateDataMapCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]DataMap dm successfully added +--------+ |count(1)| +--------+ | 18| +--------+ +--------+ |count(1)| +--------+ | 18| +--------+ time for query on table with lucene datamap table:0.37 time for query on table without lucene datamap table:0.454 +-----------------+-------------+ | id| name| +-----------------+-------------+ |which test1 good3|who and name1| |which test1 good3|who and name1| |which test1 good3|who and name2| |which test1 good3|who and name2| |which test1 good4|who and name2| |which test1 good4|who and name2| |which test1 good5|who and name2| |which test1 good5|who and name2| |which test1 good8|who and name0| |which test1 good8|who and name0| |which test1 good8|who and name1| |which test1 good8|who and name1| |which test1 good8|who and name1| |which test1 good8|who and name1| |which test1 good9|who and name7| |which test1 good9|who and name7| +-----------------+-------------+ +-----------------+-------------+ | id| name| +-----------------+-------------+ |which test1 good1|who and name5| |which test1 good1|who and name5| |which test1 good3|who and name1| |which test1 good3|who and name1| |which test1 good3|who and name2| |which test1 good3|who and name2| |which test1 good4|who and name2| |which test1 good4|who and name2| |which test1 good5|who and name2| |which test1 good5|who and name2| +-----------------+-------------+ 18/07/07 06:04:22 AUDIT CarbonDropTableCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Deleting table [persontable] under database [default] 18/07/07 06:04:22 AUDIT CarbonDropTableCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Deleted table [persontable] under database [default] [32m- LuceneDataMapExample[0m 18/07/07 06:04:22 AUDIT CarbonCreateTableCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Creating Table with Database name [default] and Table name [origin_table] 18/07/07 06:04:22 AUDIT CarbonCreateTableCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Table created with Database name [default] and Table name [origin_table] 18/07/07 06:04:22 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been received for table default.origin_table 18/07/07 06:04:22 ERROR DataLoadExecutor: [Executor task launch worker-1][partitionID:table;queryID:20605905683807233] Data Load is partially success for table origin_table 18/07/07 06:04:22 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for default.origin_table 18/07/07 06:04:22 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been received for table default.origin_table 18/07/07 06:04:22 ERROR DataLoadExecutor: [Executor task launch worker-1][partitionID:table;queryID:20605905909657526] Data Load is partially success for table origin_table 18/07/07 06:04:22 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for default.origin_table 18/07/07 06:04:22 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been received for table default.origin_table 18/07/07 06:04:23 ERROR DataLoadExecutor: [Executor task launch worker-1][partitionID:table;queryID:20605906123131842] Data Load is partially success for table origin_table 18/07/07 06:04:23 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for default.origin_table 18/07/07 06:04:23 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been received for table default.origin_table 18/07/07 06:04:23 ERROR DataLoadExecutor: [Executor task launch worker-1][partitionID:table;queryID:20605906365631417] Data Load is partially success for table origin_table 18/07/07 06:04:23 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for default.origin_table +--------+ |count(1)| +--------+ | 40| +--------+ 18/07/07 06:04:23 AUDIT CarbonCreateTableCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Creating Table with Database name [default] and Table name [external_table] 18/07/07 06:04:23 AUDIT CarbonCreateTableCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Table created with Database name [default] and Table name [external_table] +--------+ |count(1)| +--------+ | 40| +--------+ 18/07/07 06:04:23 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been received for table default.origin_table 18/07/07 06:04:23 ERROR DataLoadExecutor: [Executor task launch worker-1][partitionID:table;queryID:20605906869933653] Data Load is partially success for table origin_table 18/07/07 06:04:23 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for default.origin_table 18/07/07 06:04:23 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been received for table default.origin_table 18/07/07 06:04:24 ERROR DataLoadExecutor: [Executor task launch worker-1][partitionID:table;queryID:20605907107699463] Data Load is partially success for table origin_table 18/07/07 06:04:24 AUDIT CarbonDataRDDFactory$: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for default.origin_table +--------+ |count(1)| +--------+ | 60| +--------+ 18/07/07 06:04:24 AUDIT CarbonDropTableCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Deleting table [origin_table] under database [default] 18/07/07 06:04:24 AUDIT CarbonDropTableCommand: [asf931.gq1.ygridcore.net][jenkins][Thread-1]Deleted table [origin_table] under database [default] [32m- ExternalTableExample[0m [36mRun completed in 2 minutes, 23 seconds.[0m [36mTotal number of tests run: 17[0m [36mSuites: completed 2, aborted 0[0m [36mTests: succeeded 16, failed 1, canceled 0, ignored 0, pending 0[0m [31m*** 1 TEST FAILED ***[0m [JENKINS] Recording test results
