【详述】单表查询无数据，添加分区后再次查询有数据
【背景】无特殊操作，实时任务一直无报错运行
【业务影响】
【StarRocks版本】2.2.8
【集群规模】例如：1fe+2be
【机器信息】32C/512G/万兆
【联系方式】社区群11-快乐李
【附件】
PLAN FRAGMENT 0(F01)
Output Exprs:1: event_day | 2: eqp_id | 3: event_time | 4: eqmtlid | 5: put_time | 6: tube_id | 7: boat_id | 8: eqp_type | 9: sites | 10: factory | 11: shift | 12: two_hour | 13: one_hour | 14: half_hour | 15: years | 16: month_of_year | 17: week_of_year | 18: conducttime | 19: cls_cellq | 20: cls_colq | 21: flt_colqcoatthickbrdrthickmax | 22: flt_colqhsvintcolhuemin | 23: flt_colqhsvintcolhuerange | 24: flt_colqhsvbrdrcolhuemean | 25: flt_colqhsvbrdrcolhuerange | 26: flt_colqcoatthickintthickmean | 27: flt_colqcoatthickintthickmin | 28: flt_colqcoatthickintthickmax | 29: flt_colqhsvintcolhuemax | 30: flt_colqcoatthickintthickstddev | 31: flt_colqcoatthickbrdrthickmean | 32: flt_colqcoatthickbrdrthickstddev | 33: flt_colqhsvintcolhuemean | 34: flt_colqcoatthickbrdrthickrange | 35: flt_colqhsvintcolhuestddev | 36: flt_colqhsvbrdrcolhuemin | 37: flt_colqhsvbrdrcolhuemax | 38: flt_colqhsvbrdrcolhuestddev | 39: flt_colqcoatthickintthickrange | 40: flt_colqcoatthickbrdrthickmin | 41: data
Input Partition: UNPARTITIONED
RESULT SINK
1:EXCHANGE
cardinality: 2297964
PLAN FRAGMENT 1(F00)
Input Partition: RANDOM
OutPut Partition: UNPARTITIONED
OutPut Exchange Id: 01
0:OlapScanNode
table: tablename, rollup: tablename
preAggregation: on
partitionsRatio=85/104, tabletsRatio=255/255
tabletList=37111,37114,37117,37084,37087,37090,37093,37096,37099,37102 …
actualRows=2297964, avgRowSize=1377.7205
cardinality: 2297964
column statistics:
* event_day–>[1.6704288E9, 1.6795008E9, 0.0, 4.0, 134.85576923076923] ESTIMATE
* eqp_id–>[-Infinity, Infinity, 0.0, 7.775505, 5.0] ESTIMATE
* event_time–>[1.671074901E9, 1.679390347E9, 0.0, 8.0, 229806.0] ESTIMATE
* eqmtlid–>[-Infinity, Infinity, 0.00591, 17.784935, 1103259.0] ESTIMATE
* put_time–>[-Infinity, Infinity, 0.0, 19.0, 223422.0] ESTIMATE
* tube_id–>[-Infinity, Infinity, 0.0, 0.0, 1.0] ESTIMATE
* boat_id–>[-Infinity, Infinity, 0.0, 0.0, 1.0] ESTIMATE
* eqp_type–>[-Infinity, Infinity, 0.0, 2.094515, 2.0] ESTIMATE
* sites–>[-Infinity, Infinity, 0.0, 4.0, 1.0] ESTIMATE
* factory–>[-Infinity, Infinity, 0.0, 1.0, 1.0] ESTIMATE
* shift–>[-Infinity, Infinity, 0.0, 1.0, 2.0] ESTIMATE
* two_hour–>[-Infinity, Infinity, 0.0, 1.093815, 12.0] ESTIMATE
* one_hour–>[-Infinity, Infinity, 0.0, 2.0, 24.0] ESTIMATE
* half_hour–>[-Infinity, Infinity, 0.0, 2.0, 2.0] ESTIMATE
* years–>[-Infinity, Infinity, 0.0, 5.0, 2.0] ESTIMATE
* month_of_year–>[-Infinity, Infinity, 0.0, 3.0, 4.0] ESTIMATE
* week_of_year–>[-Infinity, Infinity, 0.0, 2.314825, 12.0] ESTIMATE
* conducttime–>[-Infinity, Infinity, 0.0, 19.0, 73100.0] ESTIMATE
* cls_cellq–>[-Infinity, Infinity, 0.0, 1.347895, 4.0] ESTIMATE
* cls_colq–>[-Infinity, Infinity, 0.0, 5.24831, 6.0] ESTIMATE
* flt_colqcoatthickbrdrthickmax–>[-1000.0, 249.0, 0.0, 8.0, 109.0] ESTIMATE
* flt_colqhsvintcolhuemin–>[0.0, 302.117645, 2.2E-4, 8.0, 138.0] ESTIMATE
* flt_colqhsvintcolhuerange–>[0.0, 337.411774, 2.2E-4, 8.0, 141.0] ESTIMATE
* flt_colqhsvbrdrcolhuemean–>[0.0, 305.826965, 2.2E-4, 8.0, 540572.0] ESTIMATE
* flt_colqhsvbrdrcolhuerange–>[0.0, 313.411774, 2.2E-4, 8.0, 186.0] ESTIMATE
* flt_colqcoatthickintthickmean–>[-1000.0, 238.628296, 2.2E-4, 8.0, 741643.0] ESTIMATE
* flt_colqcoatthickintthickmin–>[-1000.0, 195.0, 2.2E-4, 8.0, 50.0] ESTIMATE
* flt_colqcoatthickintthickmax–>[-1000.0, 249.0, 2.2E-4, 8.0, 118.0] ESTIMATE
* flt_colqhsvintcolhuemax–>[0.0, 360.0, 2.2E-4, 8.0, 120.0] ESTIMATE
* flt_colqcoatthickintthickstddev–>[-1000.0, 45.474632, 2.2E-4, 8.0, 1722978.0] ESTIMATE
* flt_colqcoatthickbrdrthickmean–>[-1000.0, 211.736099, 2.2E-4, 8.0, 664285.0] ESTIMATE
* flt_colqcoatthickbrdrthickstddev–>[-1000.0, 41.580589, 2.2E-4, 8.0, 1587262.0] ESTIMATE
* flt_colqhsvintcolhuemean–>[0.0, 335.546661, 2.2E-4, 8.0, 666755.0] ESTIMATE
* flt_colqcoatthickbrdrthickrange–>[-1000.0, 158.0, 2.2E-4, 8.0, 156.0] ESTIMATE
* flt_colqhsvintcolhuestddev–>[0.0, 102.390045, 2.2E-4, 8.0, 1713262.0] ESTIMATE
* flt_colqhsvbrdrcolhuemin–>[0.0, 360.0, 2.2E-4, 8.0, 143.0] ESTIMATE
* flt_colqhsvbrdrcolhuemax–>[0.0, 307.764709, 0.0, 8.0, 60.0] ESTIMATE
* flt_colqhsvbrdrcolhuestddev–>[0.0, 98.603439, 2.2E-4, 8.0, 1686355.0] ESTIMATE
* flt_colqcoatthickintthickrange–>[-1000.0, 158.0, 2.2E-4, 8.0, 158.0] ESTIMATE
* flt_colqcoatthickbrdrthickmin–>[-1000.0, 156.0, 2.2E-4, 8.0, 57.0] ESTIMATE
* data–>[-Infinity, Infinity, 0.0, 1112.0606, 2238386.0] ESTIMATE
PLAN FRAGMENT 0(F00)
Output Exprs:1: event_day | 2: eqp_id | 3: event_time | 4: eqmtlid | 5: put_time | 6: tube_id | 7: boat_id | 8: eqp_type | 9: sites | 10: factory | 11: shift | 12: two_hour | 13: one_hour | 14: half_hour | 15: years | 16: month_of_year | 17: week_of_year | 18: conducttime | 19: cls_cellq | 20: cls_colq | 21: flt_colqcoatthickbrdrthickmax | 22: flt_colqhsvintcolhuemin | 23: flt_colqhsvintcolhuerange | 24: flt_colqhsvbrdrcolhuemean | 25: flt_colqhsvbrdrcolhuerange | 26: flt_colqcoatthickintthickmean | 27: flt_colqcoatthickintthickmin | 28: flt_colqcoatthickintthickmax | 29: flt_colqhsvintcolhuemax | 30: flt_colqcoatthickintthickstddev | 31: flt_colqcoatthickbrdrthickmean | 32: flt_colqcoatthickbrdrthickstddev | 33: flt_colqhsvintcolhuemean | 34: flt_colqcoatthickbrdrthickrange | 35: flt_colqhsvintcolhuestddev | 36: flt_colqhsvbrdrcolhuemin | 37: flt_colqhsvbrdrcolhuemax | 38: flt_colqhsvbrdrcolhuestddev | 39: flt_colqcoatthickintthickrange | 40: flt_colqcoatthickbrdrthickmin | 41: data
Input Partition: RANDOM
RESULT SINK
0:OlapScanNode
table: tablename, rollup: tablename
preAggregation: on
Predicates: [1: event_day, DATE, false] = ‘2023-03-22’
partitionsRatio=1/104, tabletsRatio=1/3
tabletList=187197
actualRows=9915, avgRowSize=1377.7205
cardinality: 6249
column statistics:
* event_day–>[1.6794144E9, 1.6794144E9, 0.0, 4.0, 1.5865384615384615] ESTIMATE
* eqp_id–>[-Infinity, Infinity, 0.0, 7.775505, 5.0] ESTIMATE
* event_time–>[1.671074901E9, 1.679390347E9, 0.0, 8.0, 6249.454545454546] ESTIMATE
* eqmtlid–>[-Infinity, Infinity, 0.00591, 17.784935, 6249.454545454546] ESTIMATE
* put_time–>[-Infinity, Infinity, 0.0, 19.0, 6249.454545454546] ESTIMATE
* tube_id–>[-Infinity, Infinity, 0.0, 0.0, 1.0] ESTIMATE
* boat_id–>[-Infinity, Infinity, 0.0, 0.0, 1.0] ESTIMATE
* eqp_type–>[-Infinity, Infinity, 0.0, 2.094515, 2.0] ESTIMATE
* sites–>[-Infinity, Infinity, 0.0, 4.0, 1.0] ESTIMATE
* factory–>[-Infinity, Infinity, 0.0, 1.0, 1.0] ESTIMATE
* shift–>[-Infinity, Infinity, 0.0, 1.0, 2.0] ESTIMATE
* two_hour–>[-Infinity, Infinity, 0.0, 1.093815, 12.0] ESTIMATE
* one_hour–>[-Infinity, Infinity, 0.0, 2.0, 24.0] ESTIMATE
* half_hour–>[-Infinity, Infinity, 0.0, 2.0, 2.0] ESTIMATE
* years–>[-Infinity, Infinity, 0.0, 5.0, 2.0] ESTIMATE
* month_of_year–>[-Infinity, Infinity, 0.0, 3.0, 4.0] ESTIMATE
* week_of_year–>[-Infinity, Infinity, 0.0, 2.314825, 12.0] ESTIMATE
* conducttime–>[-Infinity, Infinity, 0.0, 19.0, 6249.454545454546] ESTIMATE
* cls_cellq–>[-Infinity, Infinity, 0.0, 1.347895, 4.0] ESTIMATE
* cls_colq–>[-Infinity, Infinity, 0.0, 5.24831, 6.0] ESTIMATE
* flt_colqcoatthickbrdrthickmax–>[-1000.0, 249.0, 0.0, 8.0, 109.0] ESTIMATE
* flt_colqhsvintcolhuemin–>[0.0, 302.117645, 2.2E-4, 8.0, 138.0] ESTIMATE
* flt_colqhsvintcolhuerange–>[0.0, 337.411774, 2.2E-4, 8.0, 141.0] ESTIMATE
* flt_colqhsvbrdrcolhuemean–>[0.0, 305.826965, 2.2E-4, 8.0, 6249.454545454546] ESTIMATE
* flt_colqhsvbrdrcolhuerange–>[0.0, 313.411774, 2.2E-4, 8.0, 186.0] ESTIMATE
* flt_colqcoatthickintthickmean–>[-1000.0, 238.628296, 2.2E-4, 8.0, 6249.454545454546] ESTIMATE
* flt_colqcoatthickintthickmin–>[-1000.0, 195.0, 2.2E-4, 8.0, 50.0] ESTIMATE
* flt_colqcoatthickintthickmax–>[-1000.0, 249.0, 2.2E-4, 8.0, 118.0] ESTIMATE
* flt_colqhsvintcolhuemax–>[0.0, 360.0, 2.2E-4, 8.0, 120.0] ESTIMATE
* flt_colqcoatthickintthickstddev–>[-1000.0, 45.474632, 2.2E-4, 8.0, 6249.454545454546] ESTIMATE
* flt_colqcoatthickbrdrthickmean–>[-1000.0, 211.736099, 2.2E-4, 8.0, 6249.454545454546] ESTIMATE
* flt_colqcoatthickbrdrthickstddev–>[-1000.0, 41.580589, 2.2E-4, 8.0, 6249.454545454546] ESTIMATE
* flt_colqhsvintcolhuemean–>[0.0, 335.546661, 2.2E-4, 8.0, 6249.454545454546] ESTIMATE
* flt_colqcoatthickbrdrthickrange–>[-1000.0, 158.0, 2.2E-4, 8.0, 156.0] ESTIMATE
* flt_colqhsvintcolhuestddev–>[0.0, 102.390045, 2.2E-4, 8.0, 6249.454545454546] ESTIMATE
* flt_colqhsvbrdrcolhuemin–>[0.0, 360.0, 2.2E-4, 8.0, 143.0] ESTIMATE
* flt_colqhsvbrdrcolhuemax–>[0.0, 307.764709, 0.0, 8.0, 60.0] ESTIMATE
* flt_colqhsvbrdrcolhuestddev–>[0.0, 98.603439, 2.2E-4, 8.0, 6249.454545454546] ESTIMATE
* flt_colqcoatthickintthickrange–>[-1000.0, 158.0, 2.2E-4, 8.0, 158.0] ESTIMATE
* flt_colqcoatthickbrdrthickmin–>[-1000.0, 156.0, 2.2E-4, 8.0, 57.0] ESTIMATE
* data–>[-Infinity, Infinity, 0.0, 1112.0606, 6249.454545454546] ESTIMATE