| -- This file is automatically generated. You should know what you did if you want to edit this |
| -- !check_inserted_data -- |
| 10001 \N \N \N \N \N \N 2023-05-01 |
| 10001 \N \N \N \N \N \N 2023-05-01 |
| 10001 \N \N \N \N \N \N 2023-05-01 |
| 10001 false 11 11.0 11.11 11.1000 aaa 2023-05-01 |
| 10001 false 11 11.0 11.11 11.1000 aaa 2023-05-01 |
| 10001 false 11 11.0 11.11 11.1000 aaa 2023-05-01 |
| 10001 false 11 11.0 11.11 11.1000 aaa 2023-05-01 |
| 10001 false 11 11.0 11.11 11.1000 aaa 2023-05-01 |
| 10001 false 11 11.0 11.11 11.1000 aaa 2023-05-01 |
| 10001 false 11 11.0 11.11 11.1000 aaa 2023-05-01 |
| 10002 \N \N \N \N \N \N 2023-05-02 |
| 10002 \N \N \N \N \N \N 2023-05-02 |
| 10002 \N \N \N \N \N \N 2023-05-02 |
| 10002 true 22 22.0 22.22 22.2000 bbb 2023-05-02 |
| 10002 true 22 22.0 22.22 22.2000 bbb 2023-05-02 |
| 10002 true 22 22.0 22.22 22.2000 bbb 2023-05-02 |
| 10002 true 22 22.0 22.22 22.2000 bbb 2023-05-02 |
| 10002 true 22 22.0 22.22 22.2000 bbb 2023-05-02 |
| 10002 true 22 22.0 22.22 22.2000 bbb 2023-05-02 |
| 10002 true 22 22.0 22.22 22.2000 bbb 2023-05-02 |
| 10003 \N \N \N \N \N \N 2023-05-03 |
| 10003 \N \N \N \N \N \N 2023-05-03 |
| 10003 \N \N \N \N \N \N 2023-05-03 |
| 10003 false 33 33.0 33.33 33.3000 ccc 2023-05-03 |
| 10003 false 33 33.0 33.33 33.3000 ccc 2023-05-03 |
| 10003 false 33 33.0 33.33 33.3000 ccc 2023-05-03 |
| 10003 false 33 33.0 33.33 33.3000 ccc 2023-05-03 |
| 10003 false 33 33.0 33.33 33.3000 ccc 2023-05-03 |
| 10003 false 33 33.0 33.33 33.3000 ccc 2023-05-03 |
| 10003 false 33 33.0 33.33 33.3000 ccc 2023-05-03 |
| 10004 \N \N \N \N \N \N 2023-05-04 |
| 10004 \N \N \N \N \N \N 2023-05-04 |
| 10004 \N \N \N \N \N \N 2023-05-04 |
| 10004 true 44 44.0 44.44 44.4000 ddd 2023-05-04 |
| 10004 true 44 44.0 44.44 44.4000 ddd 2023-05-04 |
| 10004 true 44 44.0 44.44 44.4000 ddd 2023-05-04 |
| 10004 true 44 44.0 44.44 44.4000 ddd 2023-05-04 |
| 10004 true 44 44.0 44.44 44.4000 ddd 2023-05-04 |
| 10004 true 44 44.0 44.44 44.4000 ddd 2023-05-04 |
| 10004 true 44 44.0 44.44 44.4000 ddd 2023-05-04 |
| 10005 \N \N \N \N \N \N 2023-05-05 |
| 10005 \N \N \N \N \N \N 2023-05-05 |
| 10005 \N \N \N \N \N \N 2023-05-05 |
| 10005 false 55 55.0 55.55 55.5000 eee 2023-05-05 |
| 10005 false 55 55.0 55.55 55.5000 eee 2023-05-05 |
| 10005 false 55 55.0 55.55 55.5000 eee 2023-05-05 |
| 10005 false 55 55.0 55.55 55.5000 eee 2023-05-05 |
| 10005 false 55 55.0 55.55 55.5000 eee 2023-05-05 |
| 10005 false 55 55.0 55.55 55.5000 eee 2023-05-05 |
| 10005 false 55 55.0 55.55 55.5000 eee 2023-05-05 |
| |
| -- !check_analysis_job_in_test_1_1 -- |
| test_analyze_tbl_p1 MANUAL HISTOGRAM FULL FULL ONCE FINISHED 0 0 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 MANUAL INDEX FULL FULL ONCE FINISHED 0 0 0 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_boolean MANUAL COLUMN FULL FULL ONCE FINISHED 0 0 0 0 {"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_boolean MANUAL HISTOGRAM FULL FULL ONCE FINISHED 0 0 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_datev2 MANUAL COLUMN FULL FULL ONCE FINISHED 0 0 0 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_datev2 MANUAL HISTOGRAM FULL FULL ONCE FINISHED 0 0 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_decimal MANUAL COLUMN FULL FULL ONCE FINISHED 0 0 0 0 {"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_decimal MANUAL HISTOGRAM FULL FULL ONCE FINISHED 0 0 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_double MANUAL COLUMN FULL FULL ONCE FINISHED 0 0 0 0 {"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_double MANUAL HISTOGRAM FULL FULL ONCE FINISHED 0 0 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_float MANUAL COLUMN FULL FULL ONCE FINISHED 0 0 0 0 {"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_float MANUAL HISTOGRAM FULL FULL ONCE FINISHED 0 0 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_id MANUAL COLUMN FULL FULL ONCE FINISHED 0 0 0 0 {"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_id MANUAL HISTOGRAM FULL FULL ONCE FINISHED 0 0 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_int MANUAL COLUMN FULL FULL ONCE FINISHED 0 0 0 0 {"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_int MANUAL HISTOGRAM FULL FULL ONCE FINISHED 0 0 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_varchar MANUAL COLUMN FULL FULL ONCE FINISHED 0 0 0 0 {"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_varchar MANUAL HISTOGRAM FULL FULL ONCE FINISHED 0 0 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| |
| -- !check_column_stats_in_test_1_1 -- |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 1 1 10 |
| c_boolean 10 1 3 1 1 10 |
| c_boolean 50 2 15 0 1 50 |
| c_datev2 10 1 0 2023-05-01 2023-05-01 40 |
| c_datev2 10 1 0 2023-05-02 2023-05-02 40 |
| c_datev2 10 1 0 2023-05-03 2023-05-03 40 |
| c_datev2 10 1 0 2023-05-04 2023-05-04 40 |
| c_datev2 10 1 0 2023-05-05 2023-05-05 40 |
| c_datev2 50 5 0 2023-05-01 2023-05-05 200 |
| c_decimal 10 1 3 11.100000000 11.100000000 160 |
| c_decimal 10 1 3 22.200000000 22.200000000 160 |
| c_decimal 10 1 3 33.300000000 33.300000000 160 |
| c_decimal 10 1 3 44.400000000 44.400000000 160 |
| c_decimal 10 1 3 55.500000000 55.500000000 160 |
| c_decimal 50 5 15 11.100000000 55.500000000 800 |
| c_double 10 1 3 11.11 11.11 80 |
| c_double 10 1 3 22.22 22.22 80 |
| c_double 10 1 3 33.33 33.33 80 |
| c_double 10 1 3 44.44 44.44 80 |
| c_double 10 1 3 55.55 55.55 80 |
| c_double 50 5 15 11.11 55.55 400 |
| c_float 10 1 3 11 11 40 |
| c_float 10 1 3 22 22 40 |
| c_float 10 1 3 33 33 40 |
| c_float 10 1 3 44 44 40 |
| c_float 10 1 3 55 55 40 |
| c_float 50 5 15 11 55 200 |
| c_id 10 1 0 10001 10001 160 |
| c_id 10 1 0 10002 10002 160 |
| c_id 10 1 0 10003 10003 160 |
| c_id 10 1 0 10004 10004 160 |
| c_id 10 1 0 10005 10005 160 |
| c_id 50 5 0 10001 10005 800 |
| c_int 10 1 3 11 11 40 |
| c_int 10 1 3 22 22 40 |
| c_int 10 1 3 33 33 40 |
| c_int 10 1 3 44 44 40 |
| c_int 10 1 3 55 55 40 |
| c_int 50 5 15 11 55 200 |
| c_varchar 10 1 3 aaa aaa 21 |
| c_varchar 10 1 3 bbb bbb 21 |
| c_varchar 10 1 3 ccc ccc 21 |
| c_varchar 10 1 3 ddd ddd 21 |
| c_varchar 10 1 3 eee eee 21 |
| c_varchar 50 5 15 aaa eee 105 |
| |
| -- !check_histogram_stats_in_test_1_1 -- |
| c_boolean 0.0 {"num_buckets":2,"buckets":[{"lower":"0","upper":"0","ndv":1,"count":21,"pre_sum":0},{"lower":"1","upper":"1","ndv":1,"count":14,"pre_sum":21}]} |
| c_datev2 0.0 {"num_buckets":5,"buckets":[{"lower":"2023-05-01","upper":"2023-05-01","ndv":1,"count":10,"pre_sum":0},{"lower":"2023-05-02","upper":"2023-05-02","ndv":1,"count":10,"pre_sum":10},{"lower":"2023-05-03","upper":"2023-05-03","ndv":1,"count":10,"pre_sum":20},{"lower":"2023-05-04","upper":"2023-05-04","ndv":1,"count":10,"pre_sum":30},{"lower":"2023-05-05","upper":"2023-05-05","ndv":1,"count":10,"pre_sum":40}]} |
| c_decimal 0.0 {"num_buckets":5,"buckets":[{"lower":"11.100000000","upper":"11.100000000","ndv":1,"count":7,"pre_sum":0},{"lower":"22.200000000","upper":"22.200000000","ndv":1,"count":7,"pre_sum":7},{"lower":"33.300000000","upper":"33.300000000","ndv":1,"count":7,"pre_sum":14},{"lower":"44.400000000","upper":"44.400000000","ndv":1,"count":7,"pre_sum":21},{"lower":"55.500000000","upper":"55.500000000","ndv":1,"count":7,"pre_sum":28}]} |
| c_double 0.0 {"num_buckets":5,"buckets":[{"lower":"11.11","upper":"11.11","ndv":1,"count":7,"pre_sum":0},{"lower":"22.22","upper":"22.22","ndv":1,"count":7,"pre_sum":7},{"lower":"33.33","upper":"33.33","ndv":1,"count":7,"pre_sum":14},{"lower":"44.44","upper":"44.44","ndv":1,"count":7,"pre_sum":21},{"lower":"55.55","upper":"55.55","ndv":1,"count":7,"pre_sum":28}]} |
| c_float 0.0 {"num_buckets":5,"buckets":[{"lower":"11","upper":"11","ndv":1,"count":7,"pre_sum":0},{"lower":"22","upper":"22","ndv":1,"count":7,"pre_sum":7},{"lower":"33","upper":"33","ndv":1,"count":7,"pre_sum":14},{"lower":"44","upper":"44","ndv":1,"count":7,"pre_sum":21},{"lower":"55","upper":"55","ndv":1,"count":7,"pre_sum":28}]} |
| c_id 0.0 {"num_buckets":5,"buckets":[{"lower":"10001","upper":"10001","ndv":1,"count":10,"pre_sum":0},{"lower":"10002","upper":"10002","ndv":1,"count":10,"pre_sum":10},{"lower":"10003","upper":"10003","ndv":1,"count":10,"pre_sum":20},{"lower":"10004","upper":"10004","ndv":1,"count":10,"pre_sum":30},{"lower":"10005","upper":"10005","ndv":1,"count":10,"pre_sum":40}]} |
| c_int 0.0 {"num_buckets":5,"buckets":[{"lower":"11","upper":"11","ndv":1,"count":7,"pre_sum":0},{"lower":"22","upper":"22","ndv":1,"count":7,"pre_sum":7},{"lower":"33","upper":"33","ndv":1,"count":7,"pre_sum":14},{"lower":"44","upper":"44","ndv":1,"count":7,"pre_sum":21},{"lower":"55","upper":"55","ndv":1,"count":7,"pre_sum":28}]} |
| c_varchar 0.0 {"num_buckets":5,"buckets":[{"lower":"aaa","upper":"aaa","ndv":1,"count":7,"pre_sum":0},{"lower":"bbb","upper":"bbb","ndv":1,"count":7,"pre_sum":7},{"lower":"ccc","upper":"ccc","ndv":1,"count":7,"pre_sum":14},{"lower":"ddd","upper":"ddd","ndv":1,"count":7,"pre_sum":21},{"lower":"eee","upper":"eee","ndv":1,"count":7,"pre_sum":28}]} |
| |
| -- !check_analysis_job_in_test_1_2 -- |
| |
| -- !check_column_stats_in_test_1_2 -- |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 1 1 10 |
| c_boolean 10 1 3 1 1 10 |
| c_boolean 50 2 15 0 1 50 |
| c_datev2 10 1 0 2023-05-01 2023-05-01 40 |
| c_datev2 10 1 0 2023-05-02 2023-05-02 40 |
| c_datev2 10 1 0 2023-05-03 2023-05-03 40 |
| c_datev2 10 1 0 2023-05-04 2023-05-04 40 |
| c_datev2 10 1 0 2023-05-05 2023-05-05 40 |
| c_datev2 50 5 0 2023-05-01 2023-05-05 200 |
| c_decimal 10 1 3 11.100000000 11.100000000 160 |
| c_decimal 10 1 3 22.200000000 22.200000000 160 |
| c_decimal 10 1 3 33.300000000 33.300000000 160 |
| c_decimal 10 1 3 44.400000000 44.400000000 160 |
| c_decimal 10 1 3 55.500000000 55.500000000 160 |
| c_decimal 50 5 15 11.100000000 55.500000000 800 |
| c_double 10 1 3 11.11 11.11 80 |
| c_double 10 1 3 22.22 22.22 80 |
| c_double 10 1 3 33.33 33.33 80 |
| c_double 10 1 3 44.44 44.44 80 |
| c_double 10 1 3 55.55 55.55 80 |
| c_double 50 5 15 11.11 55.55 400 |
| c_float 10 1 3 11 11 40 |
| c_float 10 1 3 22 22 40 |
| c_float 10 1 3 33 33 40 |
| c_float 10 1 3 44 44 40 |
| c_float 10 1 3 55 55 40 |
| c_float 50 5 15 11 55 200 |
| c_id 10 1 0 10001 10001 160 |
| c_id 10 1 0 10002 10002 160 |
| c_id 10 1 0 10003 10003 160 |
| c_id 10 1 0 10004 10004 160 |
| c_id 10 1 0 10005 10005 160 |
| c_id 50 5 0 10001 10005 800 |
| c_int 10 1 3 11 11 40 |
| c_int 10 1 3 22 22 40 |
| c_int 10 1 3 33 33 40 |
| c_int 10 1 3 44 44 40 |
| c_int 10 1 3 55 55 40 |
| c_int 50 5 15 11 55 200 |
| c_varchar 10 1 3 aaa aaa 21 |
| c_varchar 10 1 3 bbb bbb 21 |
| c_varchar 10 1 3 ccc ccc 21 |
| c_varchar 10 1 3 ddd ddd 21 |
| c_varchar 10 1 3 eee eee 21 |
| c_varchar 50 5 15 aaa eee 105 |
| |
| -- !check_histogram_stats_in_test_1_2 -- |
| c_boolean 0.0 {"num_buckets":2,"buckets":[{"lower":"0","upper":"0","ndv":1,"count":21,"pre_sum":0},{"lower":"1","upper":"1","ndv":1,"count":14,"pre_sum":21}]} |
| c_datev2 0.0 {"num_buckets":5,"buckets":[{"lower":"2023-05-01","upper":"2023-05-01","ndv":1,"count":10,"pre_sum":0},{"lower":"2023-05-02","upper":"2023-05-02","ndv":1,"count":10,"pre_sum":10},{"lower":"2023-05-03","upper":"2023-05-03","ndv":1,"count":10,"pre_sum":20},{"lower":"2023-05-04","upper":"2023-05-04","ndv":1,"count":10,"pre_sum":30},{"lower":"2023-05-05","upper":"2023-05-05","ndv":1,"count":10,"pre_sum":40}]} |
| c_decimal 0.0 {"num_buckets":5,"buckets":[{"lower":"11.100000000","upper":"11.100000000","ndv":1,"count":7,"pre_sum":0},{"lower":"22.200000000","upper":"22.200000000","ndv":1,"count":7,"pre_sum":7},{"lower":"33.300000000","upper":"33.300000000","ndv":1,"count":7,"pre_sum":14},{"lower":"44.400000000","upper":"44.400000000","ndv":1,"count":7,"pre_sum":21},{"lower":"55.500000000","upper":"55.500000000","ndv":1,"count":7,"pre_sum":28}]} |
| c_double 0.0 {"num_buckets":5,"buckets":[{"lower":"11.11","upper":"11.11","ndv":1,"count":7,"pre_sum":0},{"lower":"22.22","upper":"22.22","ndv":1,"count":7,"pre_sum":7},{"lower":"33.33","upper":"33.33","ndv":1,"count":7,"pre_sum":14},{"lower":"44.44","upper":"44.44","ndv":1,"count":7,"pre_sum":21},{"lower":"55.55","upper":"55.55","ndv":1,"count":7,"pre_sum":28}]} |
| c_float 0.0 {"num_buckets":5,"buckets":[{"lower":"11","upper":"11","ndv":1,"count":7,"pre_sum":0},{"lower":"22","upper":"22","ndv":1,"count":7,"pre_sum":7},{"lower":"33","upper":"33","ndv":1,"count":7,"pre_sum":14},{"lower":"44","upper":"44","ndv":1,"count":7,"pre_sum":21},{"lower":"55","upper":"55","ndv":1,"count":7,"pre_sum":28}]} |
| c_id 0.0 {"num_buckets":5,"buckets":[{"lower":"10001","upper":"10001","ndv":1,"count":10,"pre_sum":0},{"lower":"10002","upper":"10002","ndv":1,"count":10,"pre_sum":10},{"lower":"10003","upper":"10003","ndv":1,"count":10,"pre_sum":20},{"lower":"10004","upper":"10004","ndv":1,"count":10,"pre_sum":30},{"lower":"10005","upper":"10005","ndv":1,"count":10,"pre_sum":40}]} |
| c_int 0.0 {"num_buckets":5,"buckets":[{"lower":"11","upper":"11","ndv":1,"count":7,"pre_sum":0},{"lower":"22","upper":"22","ndv":1,"count":7,"pre_sum":7},{"lower":"33","upper":"33","ndv":1,"count":7,"pre_sum":14},{"lower":"44","upper":"44","ndv":1,"count":7,"pre_sum":21},{"lower":"55","upper":"55","ndv":1,"count":7,"pre_sum":28}]} |
| c_varchar 0.0 {"num_buckets":5,"buckets":[{"lower":"aaa","upper":"aaa","ndv":1,"count":7,"pre_sum":0},{"lower":"bbb","upper":"bbb","ndv":1,"count":7,"pre_sum":7},{"lower":"ccc","upper":"ccc","ndv":1,"count":7,"pre_sum":14},{"lower":"ddd","upper":"ddd","ndv":1,"count":7,"pre_sum":21},{"lower":"eee","upper":"eee","ndv":1,"count":7,"pre_sum":28}]} |
| |
| -- !check_analysis_job_in_test_1_3 -- |
| |
| -- !check_column_stats_cnt_in_test_1_3 -- |
| 48 |
| |
| -- !check_histogram_stats_cnt_in_test_1_3 -- |
| 8 |
| |
| -- !check_analysis_job_in_test_2_1 -- |
| test_analyze_tbl_p1 MANUAL HISTOGRAM FULL SAMPLE ONCE FINISHED 0 40 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 MANUAL INDEX FULL SAMPLE ONCE FINISHED 0 40 0 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_boolean MANUAL COLUMN FULL SAMPLE ONCE FINISHED 0 40 0 0 {"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_boolean MANUAL HISTOGRAM FULL SAMPLE ONCE FINISHED 0 40 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_datev2 MANUAL COLUMN FULL SAMPLE ONCE FINISHED 0 40 0 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_datev2 MANUAL HISTOGRAM FULL SAMPLE ONCE FINISHED 0 40 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_decimal MANUAL COLUMN FULL SAMPLE ONCE FINISHED 0 40 0 0 {"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_decimal MANUAL HISTOGRAM FULL SAMPLE ONCE FINISHED 0 40 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_double MANUAL COLUMN FULL SAMPLE ONCE FINISHED 0 40 0 0 {"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_double MANUAL HISTOGRAM FULL SAMPLE ONCE FINISHED 0 40 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_float MANUAL COLUMN FULL SAMPLE ONCE FINISHED 0 40 0 0 {"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_float MANUAL HISTOGRAM FULL SAMPLE ONCE FINISHED 0 40 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_id MANUAL COLUMN FULL SAMPLE ONCE FINISHED 0 40 0 0 {"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_id MANUAL HISTOGRAM FULL SAMPLE ONCE FINISHED 0 40 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_int MANUAL COLUMN FULL SAMPLE ONCE FINISHED 0 40 0 0 {"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_int MANUAL HISTOGRAM FULL SAMPLE ONCE FINISHED 0 40 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_varchar MANUAL COLUMN FULL SAMPLE ONCE FINISHED 0 40 0 0 {"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_varchar MANUAL HISTOGRAM FULL SAMPLE ONCE FINISHED 0 40 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| |
| -- !check_column_stats_cnt_in_test_2_1 -- |
| 48 |
| |
| -- !check_histogram_stats_cnt_in_test_2_1 -- |
| 8 |
| |
| -- !check_analysis_job_in_test_2_2 -- |
| test_analyze_tbl_p1 MANUAL HISTOGRAM FULL SAMPLE ONCE FINISHED 80 0 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 MANUAL INDEX FULL SAMPLE ONCE FINISHED 80 0 0 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_boolean MANUAL COLUMN FULL SAMPLE ONCE FINISHED 80 0 0 0 {"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_boolean MANUAL HISTOGRAM FULL SAMPLE ONCE FINISHED 80 0 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_datev2 MANUAL COLUMN FULL SAMPLE ONCE FINISHED 80 0 0 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_datev2 MANUAL HISTOGRAM FULL SAMPLE ONCE FINISHED 80 0 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_decimal MANUAL COLUMN FULL SAMPLE ONCE FINISHED 80 0 0 0 {"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_decimal MANUAL HISTOGRAM FULL SAMPLE ONCE FINISHED 80 0 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_double MANUAL COLUMN FULL SAMPLE ONCE FINISHED 80 0 0 0 {"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_double MANUAL HISTOGRAM FULL SAMPLE ONCE FINISHED 80 0 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_float MANUAL COLUMN FULL SAMPLE ONCE FINISHED 80 0 0 0 {"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_float MANUAL HISTOGRAM FULL SAMPLE ONCE FINISHED 80 0 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_id MANUAL COLUMN FULL SAMPLE ONCE FINISHED 80 0 0 0 {"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_id MANUAL HISTOGRAM FULL SAMPLE ONCE FINISHED 80 0 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_int MANUAL COLUMN FULL SAMPLE ONCE FINISHED 80 0 0 0 {"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_int MANUAL HISTOGRAM FULL SAMPLE ONCE FINISHED 80 0 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_varchar MANUAL COLUMN FULL SAMPLE ONCE FINISHED 80 0 0 0 {"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_varchar MANUAL HISTOGRAM FULL SAMPLE ONCE FINISHED 80 0 128 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| |
| -- !check_column_stats_cnt_in_test_2_2 -- |
| 48 |
| |
| -- !check_histogram_stats_cnt_in_test_2_2 -- |
| 8 |
| |
| -- !check_analysis_job_in_test_3_1 -- |
| test_analyze_tbl_p1 MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_boolean MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_datev2 MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_decimal MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_double MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_float MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_id MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_int MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_varchar MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| |
| -- !check_column_stats_in_test_3_1 -- |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 1 1 10 |
| c_boolean 10 1 3 1 1 10 |
| c_boolean 50 2 15 0 1 50 |
| c_datev2 10 1 0 2023-05-01 2023-05-01 40 |
| c_datev2 10 1 0 2023-05-02 2023-05-02 40 |
| c_datev2 10 1 0 2023-05-03 2023-05-03 40 |
| c_datev2 10 1 0 2023-05-04 2023-05-04 40 |
| c_datev2 10 1 0 2023-05-05 2023-05-05 40 |
| c_datev2 50 5 0 2023-05-01 2023-05-05 200 |
| c_decimal 10 1 3 11.100000000 11.100000000 160 |
| c_decimal 10 1 3 22.200000000 22.200000000 160 |
| c_decimal 10 1 3 33.300000000 33.300000000 160 |
| c_decimal 10 1 3 44.400000000 44.400000000 160 |
| c_decimal 10 1 3 55.500000000 55.500000000 160 |
| c_decimal 50 5 15 11.100000000 55.500000000 800 |
| c_double 10 1 3 11.11 11.11 80 |
| c_double 10 1 3 22.22 22.22 80 |
| c_double 10 1 3 33.33 33.33 80 |
| c_double 10 1 3 44.44 44.44 80 |
| c_double 10 1 3 55.55 55.55 80 |
| c_double 50 5 15 11.11 55.55 400 |
| c_float 10 1 3 11 11 40 |
| c_float 10 1 3 22 22 40 |
| c_float 10 1 3 33 33 40 |
| c_float 10 1 3 44 44 40 |
| c_float 10 1 3 55 55 40 |
| c_float 50 5 15 11 55 200 |
| c_id 10 1 0 10001 10001 160 |
| c_id 10 1 0 10002 10002 160 |
| c_id 10 1 0 10003 10003 160 |
| c_id 10 1 0 10004 10004 160 |
| c_id 10 1 0 10005 10005 160 |
| c_id 50 5 0 10001 10005 800 |
| c_int 10 1 3 11 11 40 |
| c_int 10 1 3 22 22 40 |
| c_int 10 1 3 33 33 40 |
| c_int 10 1 3 44 44 40 |
| c_int 10 1 3 55 55 40 |
| c_int 50 5 15 11 55 200 |
| c_varchar 10 1 3 aaa aaa 21 |
| c_varchar 10 1 3 bbb bbb 21 |
| c_varchar 10 1 3 ccc ccc 21 |
| c_varchar 10 1 3 ddd ddd 21 |
| c_varchar 10 1 3 eee eee 21 |
| c_varchar 50 5 15 aaa eee 105 |
| |
| -- !check_analysis_job_in_test_3_2 -- |
| |
| -- !check_column_stats_in_test_3_2 -- |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 1 1 10 |
| c_boolean 10 1 3 1 1 10 |
| c_boolean 50 2 15 0 1 50 |
| c_datev2 10 1 0 2023-05-01 2023-05-01 40 |
| c_datev2 10 1 0 2023-05-02 2023-05-02 40 |
| c_datev2 10 1 0 2023-05-03 2023-05-03 40 |
| c_datev2 10 1 0 2023-05-04 2023-05-04 40 |
| c_datev2 10 1 0 2023-05-05 2023-05-05 40 |
| c_datev2 50 5 0 2023-05-01 2023-05-05 200 |
| c_decimal 10 1 3 11.100000000 11.100000000 160 |
| c_decimal 10 1 3 22.200000000 22.200000000 160 |
| c_decimal 10 1 3 33.300000000 33.300000000 160 |
| c_decimal 10 1 3 44.400000000 44.400000000 160 |
| c_decimal 10 1 3 55.500000000 55.500000000 160 |
| c_decimal 50 5 15 11.100000000 55.500000000 800 |
| c_double 10 1 3 11.11 11.11 80 |
| c_double 10 1 3 22.22 22.22 80 |
| c_double 10 1 3 33.33 33.33 80 |
| c_double 10 1 3 44.44 44.44 80 |
| c_double 10 1 3 55.55 55.55 80 |
| c_double 50 5 15 11.11 55.55 400 |
| c_float 10 1 3 11 11 40 |
| c_float 10 1 3 22 22 40 |
| c_float 10 1 3 33 33 40 |
| c_float 10 1 3 44 44 40 |
| c_float 10 1 3 55 55 40 |
| c_float 50 5 15 11 55 200 |
| c_id 10 1 0 10001 10001 160 |
| c_id 10 1 0 10002 10002 160 |
| c_id 10 1 0 10003 10003 160 |
| c_id 10 1 0 10004 10004 160 |
| c_id 10 1 0 10005 10005 160 |
| c_id 50 5 0 10001 10005 800 |
| c_int 10 1 3 11 11 40 |
| c_int 10 1 3 22 22 40 |
| c_int 10 1 3 33 33 40 |
| c_int 10 1 3 44 44 40 |
| c_int 10 1 3 55 55 40 |
| c_int 50 5 15 11 55 200 |
| c_varchar 10 1 3 aaa aaa 21 |
| c_varchar 10 1 3 bbb bbb 21 |
| c_varchar 10 1 3 ccc ccc 21 |
| c_varchar 10 1 3 ddd ddd 21 |
| c_varchar 10 1 3 eee eee 21 |
| c_varchar 50 5 15 aaa eee 105 |
| |
| -- !check_inserted_data_of_new_partition -- |
| 10006 false 11 11.0 11.11 11.1000 aaa 2023-05-06 |
| 10006 false 33 33.0 33.33 33.3000 ccc 2023-05-06 |
| 10006 false 55 55.0 55.55 55.5000 eee 2023-05-06 |
| 10006 true 22 22.0 22.22 22.2000 bbb 2023-05-06 |
| 10006 true 44 44.0 44.44 44.4000 ddd 2023-05-06 |
| |
| -- !check_analysis_job_in_test_3_3 -- |
| test_analyze_tbl_p1 MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_datev2":["new_partition"],"c_varchar":["new_partition"],"c_float":["new_partition"],"c_decimal":["new_partition"],"c_double":["new_partition"],"c_id":["new_partition"],"c_int":["new_partition"],"c_boolean":["new_partition"]} |
| test_analyze_tbl_p1 c_boolean MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_boolean":["new_partition"]} |
| test_analyze_tbl_p1 c_datev2 MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_datev2":["new_partition"]} |
| test_analyze_tbl_p1 c_decimal MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_decimal":["new_partition"]} |
| test_analyze_tbl_p1 c_double MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_double":["new_partition"]} |
| test_analyze_tbl_p1 c_float MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_float":["new_partition"]} |
| test_analyze_tbl_p1 c_id MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_id":["new_partition"]} |
| test_analyze_tbl_p1 c_int MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_int":["new_partition"]} |
| test_analyze_tbl_p1 c_varchar MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_varchar":["new_partition"]} |
| |
| -- !check_column_stats_in_test_3_3 -- |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 1 1 10 |
| c_boolean 10 1 3 1 1 10 |
| c_boolean 5 2 0 0 1 5 |
| c_boolean 55 2 15 0 1 55 |
| c_datev2 10 1 0 2023-05-01 2023-05-01 40 |
| c_datev2 10 1 0 2023-05-02 2023-05-02 40 |
| c_datev2 10 1 0 2023-05-03 2023-05-03 40 |
| c_datev2 10 1 0 2023-05-04 2023-05-04 40 |
| c_datev2 10 1 0 2023-05-05 2023-05-05 40 |
| c_datev2 5 1 0 2023-05-06 2023-05-06 20 |
| c_datev2 55 6 0 2023-05-01 2023-05-06 220 |
| c_decimal 10 1 3 11.100000000 11.100000000 160 |
| c_decimal 10 1 3 22.200000000 22.200000000 160 |
| c_decimal 10 1 3 33.300000000 33.300000000 160 |
| c_decimal 10 1 3 44.400000000 44.400000000 160 |
| c_decimal 10 1 3 55.500000000 55.500000000 160 |
| c_decimal 5 5 0 11.100000000 55.500000000 80 |
| c_decimal 55 5 15 11.100000000 55.500000000 880 |
| c_double 10 1 3 11.11 11.11 80 |
| c_double 10 1 3 22.22 22.22 80 |
| c_double 10 1 3 33.33 33.33 80 |
| c_double 10 1 3 44.44 44.44 80 |
| c_double 10 1 3 55.55 55.55 80 |
| c_double 5 5 0 11.11 55.55 40 |
| c_double 55 5 15 11.11 55.55 440 |
| c_float 10 1 3 11 11 40 |
| c_float 10 1 3 22 22 40 |
| c_float 10 1 3 33 33 40 |
| c_float 10 1 3 44 44 40 |
| c_float 10 1 3 55 55 40 |
| c_float 5 5 0 11 55 20 |
| c_float 55 5 15 11 55 220 |
| c_id 10 1 0 10001 10001 160 |
| c_id 10 1 0 10002 10002 160 |
| c_id 10 1 0 10003 10003 160 |
| c_id 10 1 0 10004 10004 160 |
| c_id 10 1 0 10005 10005 160 |
| c_id 5 1 0 10006 10006 80 |
| c_id 55 6 0 10001 10006 880 |
| c_int 10 1 3 11 11 40 |
| c_int 10 1 3 22 22 40 |
| c_int 10 1 3 33 33 40 |
| c_int 10 1 3 44 44 40 |
| c_int 10 1 3 55 55 40 |
| c_int 5 5 0 11 55 20 |
| c_int 55 5 15 11 55 220 |
| c_varchar 10 1 3 aaa aaa 21 |
| c_varchar 10 1 3 bbb bbb 21 |
| c_varchar 10 1 3 ccc ccc 21 |
| c_varchar 10 1 3 ddd ddd 21 |
| c_varchar 10 1 3 eee eee 21 |
| c_varchar 5 5 0 aaa eee 15 |
| c_varchar 55 5 15 aaa eee 120 |
| |
| -- !check_analysis_job_in_test_3_4 -- |
| test_analyze_tbl_p1 MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_datev2":[],"c_varchar":[],"c_float":[],"c_decimal":[],"c_double":[],"c_id":[],"c_int":[],"c_boolean":[]} |
| test_analyze_tbl_p1 c_boolean MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_boolean":[]} |
| test_analyze_tbl_p1 c_datev2 MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_datev2":[]} |
| test_analyze_tbl_p1 c_decimal MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_decimal":[]} |
| test_analyze_tbl_p1 c_double MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_double":[]} |
| test_analyze_tbl_p1 c_float MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_float":[]} |
| test_analyze_tbl_p1 c_id MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_id":[]} |
| test_analyze_tbl_p1 c_int MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_int":[]} |
| test_analyze_tbl_p1 c_varchar MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"c_varchar":[]} |
| |
| -- !check_column_stats_in_test_3_4 -- |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 1 1 10 |
| c_boolean 10 1 3 1 1 10 |
| c_boolean 50 2 15 0 1 50 |
| c_datev2 10 1 0 2023-05-01 2023-05-01 40 |
| c_datev2 10 1 0 2023-05-02 2023-05-02 40 |
| c_datev2 10 1 0 2023-05-03 2023-05-03 40 |
| c_datev2 10 1 0 2023-05-04 2023-05-04 40 |
| c_datev2 10 1 0 2023-05-05 2023-05-05 40 |
| c_datev2 50 5 0 2023-05-01 2023-05-05 200 |
| c_decimal 10 1 3 11.100000000 11.100000000 160 |
| c_decimal 10 1 3 22.200000000 22.200000000 160 |
| c_decimal 10 1 3 33.300000000 33.300000000 160 |
| c_decimal 10 1 3 44.400000000 44.400000000 160 |
| c_decimal 10 1 3 55.500000000 55.500000000 160 |
| c_decimal 50 5 15 11.100000000 55.500000000 800 |
| c_double 10 1 3 11.11 11.11 80 |
| c_double 10 1 3 22.22 22.22 80 |
| c_double 10 1 3 33.33 33.33 80 |
| c_double 10 1 3 44.44 44.44 80 |
| c_double 10 1 3 55.55 55.55 80 |
| c_double 50 5 15 11.11 55.55 400 |
| c_float 10 1 3 11 11 40 |
| c_float 10 1 3 22 22 40 |
| c_float 10 1 3 33 33 40 |
| c_float 10 1 3 44 44 40 |
| c_float 10 1 3 55 55 40 |
| c_float 50 5 15 11 55 200 |
| c_id 10 1 0 10001 10001 160 |
| c_id 10 1 0 10002 10002 160 |
| c_id 10 1 0 10003 10003 160 |
| c_id 10 1 0 10004 10004 160 |
| c_id 10 1 0 10005 10005 160 |
| c_id 50 5 0 10001 10005 800 |
| c_int 10 1 3 11 11 40 |
| c_int 10 1 3 22 22 40 |
| c_int 10 1 3 33 33 40 |
| c_int 10 1 3 44 44 40 |
| c_int 10 1 3 55 55 40 |
| c_int 50 5 15 11 55 200 |
| c_varchar 10 1 3 aaa aaa 21 |
| c_varchar 10 1 3 bbb bbb 21 |
| c_varchar 10 1 3 ccc ccc 21 |
| c_varchar 10 1 3 ddd ddd 21 |
| c_varchar 10 1 3 eee eee 21 |
| c_varchar 50 5 15 aaa eee 105 |
| |
| -- !check_inserted_data_of_new_column -- |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| |
| -- !check_analysis_job_in_test_3_5 -- |
| test_analyze_tbl_p1 MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"new_column":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 new_column MANUAL COLUMN INCREMENTAL FULL ONCE FINISHED 0 0 0 0 {"new_column":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| |
| -- !check_column_stats_in_test_3_5 -- |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 1 1 10 |
| c_boolean 10 1 3 1 1 10 |
| c_boolean 50 2 15 0 1 50 |
| c_datev2 10 1 0 2023-05-01 2023-05-01 40 |
| c_datev2 10 1 0 2023-05-02 2023-05-02 40 |
| c_datev2 10 1 0 2023-05-03 2023-05-03 40 |
| c_datev2 10 1 0 2023-05-04 2023-05-04 40 |
| c_datev2 10 1 0 2023-05-05 2023-05-05 40 |
| c_datev2 50 5 0 2023-05-01 2023-05-05 200 |
| c_decimal 10 1 3 11.100000000 11.100000000 160 |
| c_decimal 10 1 3 22.200000000 22.200000000 160 |
| c_decimal 10 1 3 33.300000000 33.300000000 160 |
| c_decimal 10 1 3 44.400000000 44.400000000 160 |
| c_decimal 10 1 3 55.500000000 55.500000000 160 |
| c_decimal 50 5 15 11.100000000 55.500000000 800 |
| c_double 10 1 3 11.11 11.11 80 |
| c_double 10 1 3 22.22 22.22 80 |
| c_double 10 1 3 33.33 33.33 80 |
| c_double 10 1 3 44.44 44.44 80 |
| c_double 10 1 3 55.55 55.55 80 |
| c_double 50 5 15 11.11 55.55 400 |
| c_float 10 1 3 11 11 40 |
| c_float 10 1 3 22 22 40 |
| c_float 10 1 3 33 33 40 |
| c_float 10 1 3 44 44 40 |
| c_float 10 1 3 55 55 40 |
| c_float 50 5 15 11 55 200 |
| c_id 10 1 0 10001 10001 160 |
| c_id 10 1 0 10002 10002 160 |
| c_id 10 1 0 10003 10003 160 |
| c_id 10 1 0 10004 10004 160 |
| c_id 10 1 0 10005 10005 160 |
| c_id 50 5 0 10001 10005 800 |
| c_int 10 1 3 11 11 40 |
| c_int 10 1 3 22 22 40 |
| c_int 10 1 3 33 33 40 |
| c_int 10 1 3 44 44 40 |
| c_int 10 1 3 55 55 40 |
| c_int 50 5 15 11 55 200 |
| c_varchar 10 1 3 aaa aaa 21 |
| c_varchar 10 1 3 bbb bbb 21 |
| c_varchar 10 1 3 ccc ccc 21 |
| c_varchar 10 1 3 ddd ddd 21 |
| c_varchar 10 1 3 eee eee 21 |
| c_varchar 50 5 15 aaa eee 105 |
| |
| -- !check_analysis_job_in_test_3_6 -- |
| |
| -- !check_column_stats_in_test_3_6 -- |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 1 1 10 |
| c_boolean 10 1 3 1 1 10 |
| c_boolean 50 2 15 0 1 50 |
| c_datev2 10 1 0 2023-05-01 2023-05-01 40 |
| c_datev2 10 1 0 2023-05-02 2023-05-02 40 |
| c_datev2 10 1 0 2023-05-03 2023-05-03 40 |
| c_datev2 10 1 0 2023-05-04 2023-05-04 40 |
| c_datev2 10 1 0 2023-05-05 2023-05-05 40 |
| c_datev2 50 5 0 2023-05-01 2023-05-05 200 |
| c_decimal 10 1 3 11.100000000 11.100000000 160 |
| c_decimal 10 1 3 22.200000000 22.200000000 160 |
| c_decimal 10 1 3 33.300000000 33.300000000 160 |
| c_decimal 10 1 3 44.400000000 44.400000000 160 |
| c_decimal 10 1 3 55.500000000 55.500000000 160 |
| c_decimal 50 5 15 11.100000000 55.500000000 800 |
| c_double 10 1 3 11.11 11.11 80 |
| c_double 10 1 3 22.22 22.22 80 |
| c_double 10 1 3 33.33 33.33 80 |
| c_double 10 1 3 44.44 44.44 80 |
| c_double 10 1 3 55.55 55.55 80 |
| c_double 50 5 15 11.11 55.55 400 |
| c_float 10 1 3 11 11 40 |
| c_float 10 1 3 22 22 40 |
| c_float 10 1 3 33 33 40 |
| c_float 10 1 3 44 44 40 |
| c_float 10 1 3 55 55 40 |
| c_float 50 5 15 11 55 200 |
| c_id 10 1 0 10001 10001 160 |
| c_id 10 1 0 10002 10002 160 |
| c_id 10 1 0 10003 10003 160 |
| c_id 10 1 0 10004 10004 160 |
| c_id 10 1 0 10005 10005 160 |
| c_id 50 5 0 10001 10005 800 |
| c_int 10 1 3 11 11 40 |
| c_int 10 1 3 22 22 40 |
| c_int 10 1 3 33 33 40 |
| c_int 10 1 3 44 44 40 |
| c_int 10 1 3 55 55 40 |
| c_int 50 5 15 11 55 200 |
| c_varchar 10 1 3 aaa aaa 21 |
| c_varchar 10 1 3 bbb bbb 21 |
| c_varchar 10 1 3 ccc ccc 21 |
| c_varchar 10 1 3 ddd ddd 21 |
| c_varchar 10 1 3 eee eee 21 |
| c_varchar 50 5 15 aaa eee 105 |
| |
| -- !check_analysis_job_in_test_5_0 -- |
| test_analyze_tbl_p1 c_boolean MANUAL COLUMN FULL FULL PERIOD FINISHED 0 0 0 90000 {"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_boolean MANUAL HISTOGRAM FULL FULL PERIOD FINISHED 0 0 128 90000 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_datev2 MANUAL COLUMN FULL FULL PERIOD FINISHED 0 0 0 90000 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_datev2 MANUAL HISTOGRAM FULL FULL PERIOD FINISHED 0 0 128 90000 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_decimal MANUAL COLUMN FULL FULL PERIOD FINISHED 0 0 0 90000 {"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_decimal MANUAL HISTOGRAM FULL FULL PERIOD FINISHED 0 0 128 90000 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_double MANUAL COLUMN FULL FULL PERIOD FINISHED 0 0 0 90000 {"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_double MANUAL HISTOGRAM FULL FULL PERIOD FINISHED 0 0 128 90000 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_float MANUAL COLUMN FULL FULL PERIOD FINISHED 0 0 0 90000 {"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_float MANUAL HISTOGRAM FULL FULL PERIOD FINISHED 0 0 128 90000 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_id MANUAL COLUMN FULL FULL PERIOD FINISHED 0 0 0 90000 {"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_id MANUAL HISTOGRAM FULL FULL PERIOD FINISHED 0 0 128 90000 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_int MANUAL COLUMN FULL FULL PERIOD FINISHED 0 0 0 90000 {"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_int MANUAL HISTOGRAM FULL FULL PERIOD FINISHED 0 0 128 90000 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_varchar MANUAL COLUMN FULL FULL PERIOD FINISHED 0 0 0 90000 {"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| test_analyze_tbl_p1 c_varchar MANUAL HISTOGRAM FULL FULL PERIOD FINISHED 0 0 128 90000 {"c_datev2":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_varchar":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_float":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_decimal":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_double":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_id":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_int":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"],"c_boolean":["p_20230501","p_20230502","p_20230503","p_20230504","p_20230505"]} |
| |
| -- !check_column_stats_in_test_5_0 -- |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 1 1 10 |
| c_boolean 10 1 3 1 1 10 |
| c_boolean 50 2 15 0 1 50 |
| c_datev2 10 1 0 2023-05-01 2023-05-01 40 |
| c_datev2 10 1 0 2023-05-02 2023-05-02 40 |
| c_datev2 10 1 0 2023-05-03 2023-05-03 40 |
| c_datev2 10 1 0 2023-05-04 2023-05-04 40 |
| c_datev2 10 1 0 2023-05-05 2023-05-05 40 |
| c_datev2 50 5 0 2023-05-01 2023-05-05 200 |
| c_decimal 10 1 3 11.100000000 11.100000000 160 |
| c_decimal 10 1 3 22.200000000 22.200000000 160 |
| c_decimal 10 1 3 33.300000000 33.300000000 160 |
| c_decimal 10 1 3 44.400000000 44.400000000 160 |
| c_decimal 10 1 3 55.500000000 55.500000000 160 |
| c_decimal 50 5 15 11.100000000 55.500000000 800 |
| c_double 10 1 3 11.11 11.11 80 |
| c_double 10 1 3 22.22 22.22 80 |
| c_double 10 1 3 33.33 33.33 80 |
| c_double 10 1 3 44.44 44.44 80 |
| c_double 10 1 3 55.55 55.55 80 |
| c_double 50 5 15 11.11 55.55 400 |
| c_float 10 1 3 11 11 40 |
| c_float 10 1 3 22 22 40 |
| c_float 10 1 3 33 33 40 |
| c_float 10 1 3 44 44 40 |
| c_float 10 1 3 55 55 40 |
| c_float 50 5 15 11 55 200 |
| c_id 10 1 0 10001 10001 160 |
| c_id 10 1 0 10002 10002 160 |
| c_id 10 1 0 10003 10003 160 |
| c_id 10 1 0 10004 10004 160 |
| c_id 10 1 0 10005 10005 160 |
| c_id 50 5 0 10001 10005 800 |
| c_int 10 1 3 11 11 40 |
| c_int 10 1 3 22 22 40 |
| c_int 10 1 3 33 33 40 |
| c_int 10 1 3 44 44 40 |
| c_int 10 1 3 55 55 40 |
| c_int 50 5 15 11 55 200 |
| c_varchar 10 1 3 aaa aaa 21 |
| c_varchar 10 1 3 bbb bbb 21 |
| c_varchar 10 1 3 ccc ccc 21 |
| c_varchar 10 1 3 ddd ddd 21 |
| c_varchar 10 1 3 eee eee 21 |
| c_varchar 50 5 15 aaa eee 105 |
| |
| -- !check_histogram_stats_in_test_5_0 -- |
| c_boolean 0.0 {"num_buckets":2,"buckets":[{"lower":"0","upper":"0","ndv":1,"count":21,"pre_sum":0},{"lower":"1","upper":"1","ndv":1,"count":14,"pre_sum":21}]} |
| c_datev2 0.0 {"num_buckets":5,"buckets":[{"lower":"2023-05-01","upper":"2023-05-01","ndv":1,"count":10,"pre_sum":0},{"lower":"2023-05-02","upper":"2023-05-02","ndv":1,"count":10,"pre_sum":10},{"lower":"2023-05-03","upper":"2023-05-03","ndv":1,"count":10,"pre_sum":20},{"lower":"2023-05-04","upper":"2023-05-04","ndv":1,"count":10,"pre_sum":30},{"lower":"2023-05-05","upper":"2023-05-05","ndv":1,"count":10,"pre_sum":40}]} |
| c_decimal 0.0 {"num_buckets":5,"buckets":[{"lower":"11.100000000","upper":"11.100000000","ndv":1,"count":7,"pre_sum":0},{"lower":"22.200000000","upper":"22.200000000","ndv":1,"count":7,"pre_sum":7},{"lower":"33.300000000","upper":"33.300000000","ndv":1,"count":7,"pre_sum":14},{"lower":"44.400000000","upper":"44.400000000","ndv":1,"count":7,"pre_sum":21},{"lower":"55.500000000","upper":"55.500000000","ndv":1,"count":7,"pre_sum":28}]} |
| c_double 0.0 {"num_buckets":5,"buckets":[{"lower":"11.11","upper":"11.11","ndv":1,"count":7,"pre_sum":0},{"lower":"22.22","upper":"22.22","ndv":1,"count":7,"pre_sum":7},{"lower":"33.33","upper":"33.33","ndv":1,"count":7,"pre_sum":14},{"lower":"44.44","upper":"44.44","ndv":1,"count":7,"pre_sum":21},{"lower":"55.55","upper":"55.55","ndv":1,"count":7,"pre_sum":28}]} |
| c_float 0.0 {"num_buckets":5,"buckets":[{"lower":"11","upper":"11","ndv":1,"count":7,"pre_sum":0},{"lower":"22","upper":"22","ndv":1,"count":7,"pre_sum":7},{"lower":"33","upper":"33","ndv":1,"count":7,"pre_sum":14},{"lower":"44","upper":"44","ndv":1,"count":7,"pre_sum":21},{"lower":"55","upper":"55","ndv":1,"count":7,"pre_sum":28}]} |
| c_id 0.0 {"num_buckets":5,"buckets":[{"lower":"10001","upper":"10001","ndv":1,"count":10,"pre_sum":0},{"lower":"10002","upper":"10002","ndv":1,"count":10,"pre_sum":10},{"lower":"10003","upper":"10003","ndv":1,"count":10,"pre_sum":20},{"lower":"10004","upper":"10004","ndv":1,"count":10,"pre_sum":30},{"lower":"10005","upper":"10005","ndv":1,"count":10,"pre_sum":40}]} |
| c_int 0.0 {"num_buckets":5,"buckets":[{"lower":"11","upper":"11","ndv":1,"count":7,"pre_sum":0},{"lower":"22","upper":"22","ndv":1,"count":7,"pre_sum":7},{"lower":"33","upper":"33","ndv":1,"count":7,"pre_sum":14},{"lower":"44","upper":"44","ndv":1,"count":7,"pre_sum":21},{"lower":"55","upper":"55","ndv":1,"count":7,"pre_sum":28}]} |
| c_varchar 0.0 {"num_buckets":5,"buckets":[{"lower":"aaa","upper":"aaa","ndv":1,"count":7,"pre_sum":0},{"lower":"bbb","upper":"bbb","ndv":1,"count":7,"pre_sum":7},{"lower":"ccc","upper":"ccc","ndv":1,"count":7,"pre_sum":14},{"lower":"ddd","upper":"ddd","ndv":1,"count":7,"pre_sum":21},{"lower":"eee","upper":"eee","ndv":1,"count":7,"pre_sum":28}]} |
| |
| -- !check_column_stats_in_test_5_1 -- |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 0 0 10 |
| c_boolean 10 1 3 1 1 10 |
| c_boolean 10 1 3 1 1 10 |
| c_boolean 50 2 15 0 1 50 |
| c_datev2 10 1 0 2023-05-01 2023-05-01 40 |
| c_datev2 10 1 0 2023-05-02 2023-05-02 40 |
| c_datev2 10 1 0 2023-05-03 2023-05-03 40 |
| c_datev2 10 1 0 2023-05-04 2023-05-04 40 |
| c_datev2 10 1 0 2023-05-05 2023-05-05 40 |
| c_datev2 50 5 0 2023-05-01 2023-05-05 200 |
| c_decimal 10 1 3 11.100000000 11.100000000 160 |
| c_decimal 10 1 3 22.200000000 22.200000000 160 |
| c_decimal 10 1 3 33.300000000 33.300000000 160 |
| c_decimal 10 1 3 44.400000000 44.400000000 160 |
| c_decimal 10 1 3 55.500000000 55.500000000 160 |
| c_decimal 50 5 15 11.100000000 55.500000000 800 |
| c_double 10 1 3 11.11 11.11 80 |
| c_double 10 1 3 22.22 22.22 80 |
| c_double 10 1 3 33.33 33.33 80 |
| c_double 10 1 3 44.44 44.44 80 |
| c_double 10 1 3 55.55 55.55 80 |
| c_double 50 5 15 11.11 55.55 400 |
| c_float 10 1 3 11 11 40 |
| c_float 10 1 3 22 22 40 |
| c_float 10 1 3 33 33 40 |
| c_float 10 1 3 44 44 40 |
| c_float 10 1 3 55 55 40 |
| c_float 50 5 15 11 55 200 |
| c_id 10 1 0 10001 10001 160 |
| c_id 10 1 0 10002 10002 160 |
| c_id 10 1 0 10003 10003 160 |
| c_id 10 1 0 10004 10004 160 |
| c_id 10 1 0 10005 10005 160 |
| c_id 50 5 0 10001 10005 800 |
| c_int 10 1 3 11 11 40 |
| c_int 10 1 3 22 22 40 |
| c_int 10 1 3 33 33 40 |
| c_int 10 1 3 44 44 40 |
| c_int 10 1 3 55 55 40 |
| c_int 50 5 15 11 55 200 |
| c_varchar 10 1 3 aaa aaa 21 |
| c_varchar 10 1 3 bbb bbb 21 |
| c_varchar 10 1 3 ccc ccc 21 |
| c_varchar 10 1 3 ddd ddd 21 |
| c_varchar 10 1 3 eee eee 21 |
| c_varchar 50 5 15 aaa eee 105 |
| |
| -- !check_histogram_stats_in_test_5_1 -- |
| c_boolean 0.0 {"num_buckets":2,"buckets":[{"lower":"0","upper":"0","ndv":1,"count":21,"pre_sum":0},{"lower":"1","upper":"1","ndv":1,"count":14,"pre_sum":21}]} |
| c_datev2 0.0 {"num_buckets":5,"buckets":[{"lower":"2023-05-01","upper":"2023-05-01","ndv":1,"count":10,"pre_sum":0},{"lower":"2023-05-02","upper":"2023-05-02","ndv":1,"count":10,"pre_sum":10},{"lower":"2023-05-03","upper":"2023-05-03","ndv":1,"count":10,"pre_sum":20},{"lower":"2023-05-04","upper":"2023-05-04","ndv":1,"count":10,"pre_sum":30},{"lower":"2023-05-05","upper":"2023-05-05","ndv":1,"count":10,"pre_sum":40}]} |
| c_decimal 0.0 {"num_buckets":5,"buckets":[{"lower":"11.100000000","upper":"11.100000000","ndv":1,"count":7,"pre_sum":0},{"lower":"22.200000000","upper":"22.200000000","ndv":1,"count":7,"pre_sum":7},{"lower":"33.300000000","upper":"33.300000000","ndv":1,"count":7,"pre_sum":14},{"lower":"44.400000000","upper":"44.400000000","ndv":1,"count":7,"pre_sum":21},{"lower":"55.500000000","upper":"55.500000000","ndv":1,"count":7,"pre_sum":28}]} |
| c_double 0.0 {"num_buckets":5,"buckets":[{"lower":"11.11","upper":"11.11","ndv":1,"count":7,"pre_sum":0},{"lower":"22.22","upper":"22.22","ndv":1,"count":7,"pre_sum":7},{"lower":"33.33","upper":"33.33","ndv":1,"count":7,"pre_sum":14},{"lower":"44.44","upper":"44.44","ndv":1,"count":7,"pre_sum":21},{"lower":"55.55","upper":"55.55","ndv":1,"count":7,"pre_sum":28}]} |
| c_float 0.0 {"num_buckets":5,"buckets":[{"lower":"11","upper":"11","ndv":1,"count":7,"pre_sum":0},{"lower":"22","upper":"22","ndv":1,"count":7,"pre_sum":7},{"lower":"33","upper":"33","ndv":1,"count":7,"pre_sum":14},{"lower":"44","upper":"44","ndv":1,"count":7,"pre_sum":21},{"lower":"55","upper":"55","ndv":1,"count":7,"pre_sum":28}]} |
| c_id 0.0 {"num_buckets":5,"buckets":[{"lower":"10001","upper":"10001","ndv":1,"count":10,"pre_sum":0},{"lower":"10002","upper":"10002","ndv":1,"count":10,"pre_sum":10},{"lower":"10003","upper":"10003","ndv":1,"count":10,"pre_sum":20},{"lower":"10004","upper":"10004","ndv":1,"count":10,"pre_sum":30},{"lower":"10005","upper":"10005","ndv":1,"count":10,"pre_sum":40}]} |
| c_int 0.0 {"num_buckets":5,"buckets":[{"lower":"11","upper":"11","ndv":1,"count":7,"pre_sum":0},{"lower":"22","upper":"22","ndv":1,"count":7,"pre_sum":7},{"lower":"33","upper":"33","ndv":1,"count":7,"pre_sum":14},{"lower":"44","upper":"44","ndv":1,"count":7,"pre_sum":21},{"lower":"55","upper":"55","ndv":1,"count":7,"pre_sum":28}]} |
| c_varchar 0.0 {"num_buckets":5,"buckets":[{"lower":"aaa","upper":"aaa","ndv":1,"count":7,"pre_sum":0},{"lower":"bbb","upper":"bbb","ndv":1,"count":7,"pre_sum":7},{"lower":"ccc","upper":"ccc","ndv":1,"count":7,"pre_sum":14},{"lower":"ddd","upper":"ddd","ndv":1,"count":7,"pre_sum":21},{"lower":"eee","upper":"eee","ndv":1,"count":7,"pre_sum":28}]} |
| |
