See
<https://builds.apache.org/job/carbondata-master-spark-2.2/org.apache.carbondata$carbondata-examples-spark2/234/display/redirect>
------------------------------------------
[...truncated 275.26 KB...]
|2018-02-15|18 |A42158473832|325371318 |China |Asia |88888 |
|2018-02-15|19 |A42152474834|225371319 |US |America |88888 |
|2018-02-15|20 |A42151477824|225371320 |China |Asia |88888 |
|2018-02-15|21 |A42158474137|325371321 |Japan |Asia |88888 |
|2018-02-15|22 |A42258434837|25371322 |China |Asia |88888 |
|2018-02-15|23 |A42158475838|425371323 |UK |OutSpace|88888 |
|2018-02-15|24 |A41158494839|625371324 |China |Asia |88888 |
|2018-02-15|25 |A41158494840|626381324 |Good |OutSpace|88888 |
|2018-02-15|26 |A41158494843|625378824 |NotGood|OutSpace|88888 |
+----------+---+------------+-----------+-------+--------+------+
18/03/29 21:02:40 AUDIT CarbonCreateTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Creating Table with Database name
[default] and Table name [withoutpartition]
18/03/29 21:02:40 AUDIT CarbonCreateTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Table created with Database name
[default] and Table name [withoutpartition]
18/03/29 21:02:40 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been
received for table default.withoutpartition
18/03/29 21:02:47 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for
default.withoutpartition
18/03/29 21:02:47 AUDIT CarbonCreateTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Creating Table with Database name
[default] and Table name [withpartition]
18/03/29 21:02:47 AUDIT CarbonCreateTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Table created with Database name
[default] and Table name [withpartition]
18/03/29 21:02:47 AUDIT CarbonStore$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Delete segment by Id request has
been received for default.withpartition
18/03/29 21:02:47 ERROR CarbonLockUtil: ScalaTest-main-running-RunExamples Not
able to release the table status lock
18/03/29 21:02:47 AUDIT CarbonStore$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Delete segment by date is
successful for default.withpartition.
18/03/29 21:02:47 AUDIT CarbonCreateTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Creating Table with Database name
[default] and Table name [withpartition]
18/03/29 21:02:56 STATISTIC QueryStatisticsRecorderImpl: Time taken for Carbon
Optimizer to optimize: 1
18/03/29 21:02:56 STATISTIC QueryStatisticsRecorderImpl: Print query statistic
for each task id:
+-----------------+-------+-----------------------+----------+----------------+--------------------+----------------+--------------+---------------+---------------+---------------+-----------+-------------+-----------+-----------+
|query_id |task_id|start_time
|total_time|load_blocks_time|load_dictionary_time|carbon_scan_time|carbon_IO_time|scan_blocks_num|total_blocklets|valid_blocklets|total_pages|scanned_pages|valid_pages|result_size|
+-----------------+-------+-----------------------+----------+----------------+--------------------+----------------+--------------+---------------+---------------+---------------+-----------+-------------+-----------+-----------+
|44934927814799692| 0|2018-03-29 21:02:56.736| 153ms| 1ms|
0ms| -1ms| -1ms| 1|
1| 1| 0| 32| 32| 125000|
+-----------------+-------+-----------------------+----------+----------------+--------------------+----------------+--------------+---------------+---------------+---------------+-----------+-------------+-----------+-----------+
18/03/29 21:02:56 STATISTIC QueryStatisticsRecorderImpl: Time taken for Carbon
Optimizer to optimize: 0
18/03/29 21:02:57 STATISTIC QueryStatisticsRecorderImpl: Print query statistic
for each task id:
+-----------------+-------+-----------------------+----------+----------------+--------------------+----------------+--------------+---------------+---------------+---------------+-----------+-------------+-----------+-----------+
|query_id |task_id|start_time
|total_time|load_blocks_time|load_dictionary_time|carbon_scan_time|carbon_IO_time|scan_blocks_num|total_blocklets|valid_blocklets|total_pages|scanned_pages|valid_pages|result_size|
+-----------------+-------+-----------------------+----------+----------------+--------------------+----------------+--------------+---------------+---------------+---------------+-----------+-------------+-----------+-----------+
|44934928208116633| 0|2018-03-29 21:02:57.120| 34ms| 0ms|
0ms| -1ms| -1ms| 1|
1| 1| 0| 2| 2| 62500|
+-----------------+-------+-----------------------+----------+----------------+--------------------+----------------+--------------+---------------+---------------+---------------+-----------+-------------+-----------+-----------+
18/03/29 21:02:57 STATISTIC QueryStatisticsRecorderImpl: Print query statistic
for each task id:
+-----------------+-------+-----------------------+----------+----------------+--------------------+----------------+--------------+---------------+---------------+---------------+-----------+-------------+-----------+-----------+
|query_id |task_id|start_time
|total_time|load_blocks_time|load_dictionary_time|carbon_scan_time|carbon_IO_time|scan_blocks_num|total_blocklets|valid_blocklets|total_pages|scanned_pages|valid_pages|result_size|
+-----------------+-------+-----------------------+----------+----------------+--------------------+----------------+--------------+---------------+---------------+---------------+-----------+-------------+-----------+-----------+
|44934928208116633| 1|2018-03-29 21:02:57.120| 38ms| 0ms|
0ms| -1ms| -1ms| 1|
1| 1| 0| 2| 2| 62500|
+-----------------+-------+-----------------------+----------+----------------+--------------------+----------------+--------------+---------------+---------------+---------------+-----------+-------------+-----------+-----------+
----time of without partition----:0.29
----time of with partition----:0.268
18/03/29 21:02:57 AUDIT CarbonDropTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Deleting table [partitiontable0]
under database [default]
18/03/29 21:02:57 AUDIT CarbonDropTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Deleted table [partitiontable0]
under database [default]
18/03/29 21:02:57 AUDIT CarbonDropTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Deleting table [withoutpartition]
under database [default]
18/03/29 21:02:57 AUDIT CarbonDropTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Deleted table [withoutpartition]
under database [default]
18/03/29 21:02:57 AUDIT CarbonDropTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Deleting table [withpartition]
under database [default]
18/03/29 21:02:57 AUDIT CarbonDropTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Deleted table [withpartition]
under database [default]
18/03/29 21:02:57 AUDIT CarbonDropTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Deleting table [origintable] under
database [default]
18/03/29 21:02:57 AUDIT CarbonDropTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Deleted table [origintable] under
database [default]
[32m- StandardPartitionExample[0m
18/03/29 21:02:57 AUDIT CarbonCreateTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Creating Table with Database name
[default] and Table name [tablecompaction_table]
18/03/29 21:02:57 AUDIT CarbonCreateTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Table created with Database name
[default] and Table name [tablecompaction_table]
18/03/29 21:02:57 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been
received for table default.tablecompaction_table
18/03/29 21:02:58 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for
default.tablecompaction_table
18/03/29 21:02:58 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Compaction request received for
table default.tablecompaction_table
18/03/29 21:02:58 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been
received for table default.tablecompaction_table
18/03/29 21:02:58 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for
default.tablecompaction_table
18/03/29 21:02:58 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Compaction request received for
table default.tablecompaction_table
18/03/29 21:02:58 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been
received for table default.tablecompaction_table
18/03/29 21:02:58 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for
default.tablecompaction_table
18/03/29 21:02:58 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Compaction request received for
table default.tablecompaction_table
18/03/29 21:02:58 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been
received for table default.tablecompaction_table
18/03/29 21:02:59 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for
default.tablecompaction_table
18/03/29 21:02:59 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Compaction request received for
table default.tablecompaction_table
18/03/29 21:02:59 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been
received for table default.tablecompaction_table
18/03/29 21:02:59 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for
default.tablecompaction_table
18/03/29 21:02:59 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Compaction request received for
table default.tablecompaction_table
18/03/29 21:02:59 AUDIT CarbonTableCompactor:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Compaction request completed for
table default.tablecompaction_table
18/03/29 21:02:59 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been
received for table default.tablecompaction_table
18/03/29 21:02:59 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for
default.tablecompaction_table
18/03/29 21:02:59 AUDIT CarbonDataRDDFactory$:
[asf920.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-03-29 21:02:...|2018-03-29 21:02:...|
NA|COLUMNAR_V3|
| 4| Success|2018-03-29 21:02:...|2018-03-29 21:02:...|
NA|COLUMNAR_V3|
| 3| Success|2018-03-29 21:02:...|2018-03-29 21:02:...|
NA|COLUMNAR_V3|
| 2|Compacted|2018-03-29 21:02:...|2018-03-29 21:02:...|
0.1|COLUMNAR_V3|
| 1|Compacted|2018-03-29 21:02:...|2018-03-29 21:02:...|
0.1|COLUMNAR_V3|
| 0.1| Success|2018-03-29 21:02:...|2018-03-29 21:02:...|
NA|COLUMNAR_V3|
| 0|Compacted|2018-03-29 21:02:...|2018-03-29 21:02:...|
0.1|COLUMNAR_V3|
+-----------------+---------+--------------------+--------------------+---------+-----------+
18/03/29 21:02:59 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been
received for table default.tablecompaction_table
18/03/29 21:03:00 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for
default.tablecompaction_table
18/03/29 21:03:00 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Compaction request received for
table default.tablecompaction_table
18/03/29 21:03:00 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been
received for table default.tablecompaction_table
18/03/29 21:03:00 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for
default.tablecompaction_table
18/03/29 21:03:00 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Compaction request received for
table default.tablecompaction_table
18/03/29 21:03:00 AUDIT CarbonTableCompactor:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Compaction request completed for
table default.tablecompaction_table
18/03/29 21:03:00 AUDIT CarbonTableCompactor:
[asf920.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-03-29 21:03:...|2018-03-29 21:03:...|
NA|COLUMNAR_V3|
| 6| Success|2018-03-29 21:02:...|2018-03-29 21:03:...|
NA|COLUMNAR_V3|
| 5|Compacted|2018-03-29 21:02:...|2018-03-29 21:02:...|
3.1|COLUMNAR_V3|
| 4|Compacted|2018-03-29 21:02:...|2018-03-29 21:02:...|
3.1|COLUMNAR_V3|
| 3.1|Compacted|2018-03-29 21:03:...|2018-03-29 21:03:...|
0.2|COLUMNAR_V3|
| 3|Compacted|2018-03-29 21:02:...|2018-03-29 21:02:...|
3.1|COLUMNAR_V3|
| 2|Compacted|2018-03-29 21:02:...|2018-03-29 21:02:...|
0.1|COLUMNAR_V3|
| 1|Compacted|2018-03-29 21:02:...|2018-03-29 21:02:...|
0.1|COLUMNAR_V3|
| 0.2| Success|2018-03-29 21:03:...|2018-03-29 21:03:...|
NA|COLUMNAR_V3|
| 0.1|Compacted|2018-03-29 21:02:...|2018-03-29 21:02:...|
0.2|COLUMNAR_V3|
| 0|Compacted|2018-03-29 21:02:...|2018-03-29 21:02:...|
0.1|COLUMNAR_V3|
+-----------------+---------+--------------------+--------------------+---------+-----------+
18/03/29 21:03:01 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been
received for table default.tablecompaction_table
18/03/29 21:03:01 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for
default.tablecompaction_table
18/03/29 21:03:01 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Compaction request received for
table default.tablecompaction_table
18/03/29 21:03:01 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been
received for table default.tablecompaction_table
18/03/29 21:03:01 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for
default.tablecompaction_table
18/03/29 21:03:01 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Compaction request received for
table default.tablecompaction_table
18/03/29 21:03:01 AUDIT CarbonAlterTableCompactionCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Compaction request received for
table default.tablecompaction_table
18/03/29 21:03:01 AUDIT CarbonTableCompactor:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Compaction request completed for
table default.tablecompaction_table
18/03/29 21:03:01 AUDIT CarbonStore$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]The clean files request has been
received for default.tablecompaction_table
18/03/29 21:03:01 AUDIT CarbonStore$:
[asf920.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-03-29 21:03:...|2018-03-29 21:03:...|
NA|COLUMNAR_V3|
| 8|Success|2018-03-29 21:03:...|2018-03-29 21:03:...|
NA|COLUMNAR_V3|
| 0.3|Success|2018-03-29 21:03:...|2018-03-29 21:03:...|
NA|COLUMNAR_V3|
+-----------------+-------+--------------------+--------------------+---------+-----------+
18/03/29 21:03:02 AUDIT CarbonDropTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Deleting table
[tablecompaction_table] under database [default]
18/03/29 21:03:02 AUDIT CarbonDropTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Deleted table
[tablecompaction_table] under database [default]
[32m- TableLevelCompactionOptionExample[0m
18/03/29 21:03:02 AUDIT CarbonCreateTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Creating Table with Database name
[default] and Table name [timeseriestable]
18/03/29 21:03:02 AUDIT CarbonCreateTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Table created with Database name
[default] and Table name [timeseriestable]
18/03/29 21:03:02 AUDIT CarbonCreateTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Creating Table with Database name
[default] and Table name [timeseriestable_agg0_hour]
18/03/29 21:03:02 AUDIT CarbonCreateTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Table created with Database name
[default] and Table name [timeseriestable_agg0_hour]
18/03/29 21:03:02 AUDIT CarbonCreateDataMapCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]DataMap agg0_hour successfully
added
18/03/29 21:03:02 AUDIT CarbonCreateTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Creating Table with Database name
[default] and Table name [timeseriestable_agg0_day]
18/03/29 21:03:02 AUDIT CarbonCreateTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Table created with Database name
[default] and Table name [timeseriestable_agg0_day]
18/03/29 21:03:02 AUDIT CarbonCreateDataMapCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]DataMap agg0_day successfully added
18/03/29 21:03:02 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been
received for table default.timeseriestable
18/03/29 21:03:03 AUDIT CacheProvider:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]The key
carbon.input.segments.default.timeseriestable with value 0 added in the session
param
18/03/29 21:03:03 AUDIT CacheProvider:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]The key
validate.carbon.input.segments.default.timeseriestable with value false added
in the session param
18/03/29 21:03:03 AUDIT CacheProvider:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]The key
carbon.query.directQueryOnDataMap.enabled with value true added in the session
param
18/03/29 21:03:03 AUDIT CacheProvider:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]The key
carbon.input.segments.default.timeseriestable with value 0 added in the session
param
18/03/29 21:03:03 AUDIT CacheProvider:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]The key
validate.carbon.input.segments.default.timeseriestable with value false added
in the session param
18/03/29 21:03:03 AUDIT CacheProvider:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]The key
carbon.query.directQueryOnDataMap.enabled with value true added in the session
param
18/03/29 21:03:03 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been
received for table default.timeseriestable_agg0_hour
18/03/29 21:03:03 STATISTIC QueryStatisticsRecorderImpl: Time taken for Carbon
Optimizer to optimize: 0
18/03/29 21:03:03 STATISTIC QueryStatisticsRecorderImpl: Print query statistic
for each task id:
+-----------------+-------+-----------------------+----------+----------------+--------------------+----------------+--------------+---------------+---------------+---------------+-----------+-------------+-----------+-----------+
|query_id |task_id|start_time
|total_time|load_blocks_time|load_dictionary_time|carbon_scan_time|carbon_IO_time|scan_blocks_num|total_blocklets|valid_blocklets|total_pages|scanned_pages|valid_pages|result_size|
+-----------------+-------+-----------------------+----------+----------------+--------------------+----------------+--------------+---------------+---------------+---------------+-----------+-------------+-----------+-----------+
|44934934443127144| 0|2018-03-29 21:03:03.446| 298ms| 0ms|
0ms| -1ms| -1ms| 1|
1| 1| 1| 0| 1| 10000|
+-----------------+-------+-----------------------+----------+----------------+--------------------+----------------+--------------+---------------+---------------+---------------+-----------+-------------+-----------+-----------+
18/03/29 21:03:04 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for
default.timeseriestable_agg0_hour
18/03/29 21:03:04 AUDIT CacheProvider:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]The key
carbon.input.segments.default.timeseriestable_agg0_hour with value 0 added in
the session param
18/03/29 21:03:04 AUDIT CacheProvider:
[asf920.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/03/29 21:03:04 AUDIT CacheProvider:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]The key
carbon.query.directQueryOnDataMap.enabled with value true added in the session
param
18/03/29 21:03:04 AUDIT CacheProvider:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]The key
carbon.input.segments.default.timeseriestable_agg0_hour with value 0 added in
the session param
18/03/29 21:03:04 AUDIT CacheProvider:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]The key
carbon.query.directQueryOnDataMap.enabled with value true added in the session
param
18/03/29 21:03:04 AUDIT CacheProvider:
[asf920.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/03/29 21:03:04 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load request has been
received for table default.timeseriestable_agg0_day
18/03/29 21:03:04 STATISTIC QueryStatisticsRecorderImpl: Time taken for Carbon
Optimizer to optimize: 1
18/03/29 21:03:04 STATISTIC QueryStatisticsRecorderImpl: Print query statistic
for each task id:
+-----------------+-------+-----------------------+----------+----------------+--------------------+----------------+--------------+---------------+---------------+---------------+-----------+-------------+-----------+-----------+
|query_id |task_id|start_time
|total_time|load_blocks_time|load_dictionary_time|carbon_scan_time|carbon_IO_time|scan_blocks_num|total_blocklets|valid_blocklets|total_pages|scanned_pages|valid_pages|result_size|
+-----------------+-------+-----------------------+----------+----------------+--------------------+----------------+--------------+---------------+---------------+---------------+-----------+-------------+-----------+-----------+
|44934935872742299| 0|2018-03-29 21:03:04.852| 115ms| 0ms|
0ms| -1ms| -1ms| 1|
1| 1| 1| 0| 1| 4831|
+-----------------+-------+-----------------------+----------+----------------+--------------------+----------------+--------------+---------------+---------------+---------------+-----------+-------------+-----------+-----------+
18/03/29 21:03:05 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for
default.timeseriestable_agg0_day
18/03/29 21:03:05 AUDIT CarbonDataRDDFactory$:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Data load is successful for
default.timeseriestable
18/03/29 21:03:05 AUDIT CacheProvider:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]The key
carbon.query.directQueryOnDataMap.enabled with value true added in the session
param
18/03/29 21:03:05 STATISTIC QueryStatisticsRecorderImpl: Time taken for Carbon
Optimizer to optimize: 0
18/03/29 21:03:06 STATISTIC QueryStatisticsRecorderImpl: Print query statistic
for each task id:
+-----------------+-------+-----------------------+----------+----------------+--------------------+----------------+--------------+---------------+---------------+---------------+-----------+-------------+-----------+-----------+
|query_id |task_id|start_time
|total_time|load_blocks_time|load_dictionary_time|carbon_scan_time|carbon_IO_time|scan_blocks_num|total_blocklets|valid_blocklets|total_pages|scanned_pages|valid_pages|result_size|
+-----------------+-------+-----------------------+----------+----------------+--------------------+----------------+--------------+---------------+---------------+---------------+-----------+-------------+-----------+-----------+
|44934937078865884| 0|2018-03-29 21:03:06.008| 99ms| 0ms|
0ms| -1ms| -1ms| 1|
1| 1| 1| 0| 1| 4831|
+-----------------+-------+-----------------------+----------+----------------+--------------------+----------------+--------------+---------------+---------------+---------------+-----------+-------------+-----------+-----------+
+--------+----------------------------+
|sum(age)|UDF:timeseries(mytime, hour)|
+--------+----------------------------+
| 82| 2000-11-16 11:00:00|
| 76| 2000-11-18 00:00:00|
| 18| 2001-02-20 08:00:00|
| 100| 2003-06-21 02:00:00|
| 18| 2004-09-24 10:00:00|
| 64| 2004-11-09 04:00:00|
| 102| 2008-03-13 04:00:00|
| 116| 2009-03-18 01:00:00|
| 92| 2009-11-16 07:00:00|
| 66| 2010-02-03 07:00:00|
| 44| 2010-11-19 04:00:00|
| 22| 2011-03-01 05:00:00|
| 14| 2011-09-12 10:00:00|
| 44| 2011-10-11 10:00:00|
| 70| 2011-10-15 11:00:00|
| 38| 2013-02-18 08:00:00|
| 8| 2013-06-27 10:00:00|
| 74| 2014-01-27 03:00:00|
| 10| 2015-07-26 00:00:00|
| 94| 2016-06-05 01:00:00|
+--------+----------------------------+
only showing top 20 rows
18/03/29 21:03:06 STATISTIC QueryStatisticsRecorderImpl: Time taken for Carbon
Optimizer to optimize: 1
18/03/29 21:03:06 STATISTIC QueryStatisticsRecorderImpl: Print query statistic
for each task id:
+-----------------+-------+-----------------------+----------+----------------+--------------------+----------------+--------------+---------------+---------------+---------------+-----------+-------------+-----------+-----------+
|query_id |task_id|start_time
|total_time|load_blocks_time|load_dictionary_time|carbon_scan_time|carbon_IO_time|scan_blocks_num|total_blocklets|valid_blocklets|total_pages|scanned_pages|valid_pages|result_size|
+-----------------+-------+-----------------------+----------+----------------+--------------------+----------------+--------------+---------------+---------------+---------------+-----------+-------------+-----------+-----------+
|44934937326863192| 0|2018-03-29 21:03:06.287| 86ms| 0ms|
0ms| -1ms| -1ms| 1|
1| 1| 1| 0| 1| 10000|
+-----------------+-------+-----------------------+----------+----------------+--------------------+----------------+--------------+---------------+---------------+---------------+-----------+-------------+-----------+-----------+
+------------------+----------------------------+
| avg(age)|UDF:timeseries(mytime, year)|
+------------------+----------------------------+
|29.841509433962266| 2019-01-01 00:00:00|
|28.823293172690764| 2006-01-01 00:00:00|
|30.285185185185185| 2010-01-01 00:00:00|
|28.728813559322035| 2018-01-01 00:00:00|
|31.604743083003953| 2017-01-01 00:00:00|
|30.384937238493723| 2003-01-01 00:00:00|
| 30.21031746031746| 2005-01-01 00:00:00|
|27.980582524271846| 2014-01-01 00:00:00|
|28.191056910569106| 2016-01-01 00:00:00|
|29.449152542372882| 2011-01-01 00:00:00|
|30.799180327868854| 2015-01-01 00:00:00|
|29.114942528735632| 2009-01-01 00:00:00|
|29.228782287822877| 2002-01-01 00:00:00|
| 28.08433734939759| 2004-01-01 00:00:00|
| 29.13240418118467| 2000-01-01 00:00:00|
|28.244635193133046| 2008-01-01 00:00:00|
|30.049618320610687| 2012-01-01 00:00:00|
| 29.31726907630522| 2007-01-01 00:00:00|
|29.288537549407113| 2013-01-01 00:00:00|
| 30.10460251046025| 2001-01-01 00:00:00|
+------------------+----------------------------+
18/03/29 21:03:06 AUDIT CarbonDropTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Deleting table [timeseriestable]
under database [default]
18/03/29 21:03:06 AUDIT CarbonDropTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Deleting table
[timeseriestable_agg0_hour] under database [default]
18/03/29 21:03:06 AUDIT CarbonDropTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Deleted table
[timeseriestable_agg0_hour] under database [default]
18/03/29 21:03:06 AUDIT CarbonDropTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Deleting table
[timeseriestable_agg0_day] under database [default]
18/03/29 21:03:06 AUDIT CarbonDropTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Deleted table
[timeseriestable_agg0_day] under database [default]
18/03/29 21:03:06 AUDIT CarbonDropTableCommand:
[asf920.gq1.ygridcore.net][jenkins][Thread-1]Deleted table [timeseriestable]
under database [default]
[32m- TimeSeriesPreAggregateTableExample[0m
[36mRun completed in 1 minute, 24 seconds.[0m
[36mTotal number of tests run: 15[0m
[36mSuites: completed 2, aborted 0[0m
[36mTests: succeeded 14, failed 1, canceled 0, ignored 0, pending 0[0m
[31m*** 1 TEST FAILED ***[0m
[JENKINS] Recording test results
