
Group[@0]
  Logical Expressions:
    [1] id:296#0 | cost=null | estRows=10,800,000,000 | children=[] | LogicalFileScan ( qualified=truewatch_iceberg_rest_4809.variant_truewatch_60d_pk_20260805_probe_perf5d_b128_range_sp4096.browser_access_pk_variant_unshredded, output=[event_date#0, event_time#1, event_time_ms#2, event_id#3, source#4, dw_keyword#5, load_version#6, message#7, _row_id#8, _last_updated_sequence_number#9], operativeCols=[event_date#0, message#7] )
  Physical Expressions:
    [1] id:382#0 | cost=54,000,000,000 [cpu=54,000,000,000, mem=0, net=0] | estRows=-1 | children=[] | PhysicalFileScan[383]@0 ( table=browser_access_pk_variant_unshredded, stats=null, qualified=truewatch_iceberg_rest_4809.variant_truewatch_60d_pk_20260805_probe_perf5d_b128_range_sp4096.browser_access_pk_variant_unshredded, selected partitions num=0, operativeCols=[event_date#0, message#7] )
  Enforcers:
    (none)
  Chosen Expression ID: 382
  Chosen Properties: DistributionSpecStorageAny Order: ([])
  Statistics
    rows=1.08E10
    tupleSize=70.0
    width=1
    event_date#0 -> ndv=60.0000, min=20260601000000.000000(2026-06-01), max=20260730000000.000000(2026-07-30), count=10800000000.0000, numNulls=0.0000, avgSizeByte=4.000000, hotValues=(null)
    event_time#1 -> ndv=5250066432.0000, min=20260601080000.000000(2026-06-01 08:00:00.000000), max=20260731075959.000000(2026-07-31 07:59:59.999000), count=10800000000.0000, numNulls=0.0000, avgSizeByte=8.000000, hotValues=(null)
    event_time_ms#2 -> ndv=5247328768.0000, min=1780272000000.000000(1780272000000), max=1785455999999.000000(1785455999999), count=10800000000.0000, numNulls=0.0000, avgSizeByte=8.000000, hotValues=(null)
    event_id#3 -> ndv=10774758400.0000, min=32199684108857392.000000(req-0000000076b7ae98), max=32199684112410216.000000(req-ffffffffb0ebb403), count=10800000000.0000, numNulls=0.0000, avgSizeByte=20.000000, hotValues=(null)
    source#4 -> ndv=1.0000, min=27710370788631920.000000(browser-rum), max=27710370788631920.000000(browser-rum), count=10800000000.0000, numNulls=0.0000, avgSizeByte=11.000000, hotValues=(null)
    dw_keyword#5 -> ndv=1.0000, min=27710370788631920.000000(browser_access_log), max=27710370788631920.000000(browser_access_log), count=10800000000.0000, numNulls=0.0000, avgSizeByte=18.000000, hotValues=(null)
    load_version#6 -> ndv=1.0000, min=1.000000(1), max=1.000000(1), count=10800000000.0000, numNulls=0.0000, avgSizeByte=4.000000, hotValues=(null)
    message#7 -> unknown(1.08E10)
    _row_id#8 -> unknown(1.08E10)
    _last_updated_sequence_number#9 -> unknown(1.08E10)
  Lowest Plan
    ── Entry #1 ──────────────────────────────
    Cost: 54,000,000,000
    Properties: ANY
    Expression ID: 382#0
    ── Entry #2 ────────────────────────────── BEST
    Cost: 54,000,000,000
    Properties: DistributionSpecStorageAny Order: ([])
    Expression ID: 382#0
  struct info map
StructInfoMap{ groupExpressionMapByRelationId=[], infoMapByRelationId=[], groupExpressionMapByTableId=[{0}], infoMapByTableId=[], refreshVersion={{0}=84696351}}
═══════════════════════════════════════════════════════════

Group[@1]
  Logical Expressions:
    [1] id:299#1 | cost=null | estRows=180,000,000 | children=[@0] | LogicalFilter[300] ( predicates=(event_date#0 = 2026-06-15) )
  Physical Expressions:
    [1] id:379#1 | cost=0 [cpu=0, mem=0, net=0] | estRows=-1 | children=[@0] | PhysicalFilter[380]@1 ( stats=null, predicates=(event_date#0 = 2026-06-15) )
  Enforcers:
    (none)
  Chosen Expression ID: 379
  Chosen Properties: DistributionSpecStorageAny Order: ([])
  Statistics
    rows=1.8E8
    tupleSize=70.0
    width=1
    event_date#0 -> ndv=1.0000, min=20260615000000.000000(2026-06-15), max=20260615000000.000000(2026-06-15), count=0.0000, numNulls=0.0000, avgSizeByte=4.000000, hotValues=(2026-06-15:100.0)
    event_time#1 -> ndv=180000000.0000, min=20260601080000.000000(2026-06-01 08:00:00.000000), max=20260731075959.000000(2026-07-31 07:59:59.999000), count=10800000000.0000, numNulls=0.0000, avgSizeByte=8.000000, hotValues=(null)
    event_time_ms#2 -> ndv=180000000.0000, min=1780272000000.000000(1780272000000), max=1785455999999.000000(1785455999999), count=10800000000.0000, numNulls=0.0000, avgSizeByte=8.000000, hotValues=(null)
    event_id#3 -> ndv=180000000.0000, min=32199684108857392.000000(req-0000000076b7ae98), max=32199684112410216.000000(req-ffffffffb0ebb403), count=10800000000.0000, numNulls=0.0000, avgSizeByte=20.000000, hotValues=(null)
    source#4 -> ndv=1.0000, min=27710370788631920.000000(browser-rum), max=27710370788631920.000000(browser-rum), count=10800000000.0000, numNulls=0.0000, avgSizeByte=11.000000, hotValues=(null)
    dw_keyword#5 -> ndv=1.0000, min=27710370788631920.000000(browser_access_log), max=27710370788631920.000000(browser_access_log), count=10800000000.0000, numNulls=0.0000, avgSizeByte=18.000000, hotValues=(null)
    load_version#6 -> ndv=1.0000, min=1.000000(1), max=1.000000(1), count=10800000000.0000, numNulls=0.0000, avgSizeByte=4.000000, hotValues=(null)
    message#7 -> unknown(1.08E10)
    _row_id#8 -> unknown(1.08E10)
    _last_updated_sequence_number#9 -> unknown(1.08E10)
  Lowest Plan
    ── Entry #1 ──────────────────────────────
    Cost: 54,000,000,000
    Properties: ANY
    Expression ID: 379#1
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
    ── Entry #2 ────────────────────────────── BEST
    Cost: 54,000,000,000
    Properties: DistributionSpecStorageAny Order: ([])
    Expression ID: 379#1
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
  struct info map
StructInfoMap{ groupExpressionMapByRelationId=[], infoMapByRelationId=[], groupExpressionMapByTableId=[{0}], infoMapByTableId=[], refreshVersion={{0}=84696351}}
═══════════════════════════════════════════════════════════

Group[@2]
  Logical Expressions:
    [1] id:302#2 | cost=null | estRows=180,000,000 | children=[@1] | LogicalProject[303] ( distinct=false, projects=[cast(element_at(message#7, 'mainDomain') as TEXT) AS `expr_cast(element_at(message, 'mainDomain') as TEXT)`#16] )
  Physical Expressions:
    [1] id:374#2 | cost=3.2 [cpu=3.2, mem=0, net=0] | estRows=-1 | children=[@1] | PhysicalProject[375]@2 ( stats=null, projects=[cast(element_at(message#7, 'mainDomain') as TEXT) AS `expr_cast(element_at(message, 'mainDomain') as TEXT)`#16] )
  Enforcers:
    [1] id:390#2 | cost=62,700,000 [cpu=60,000,000, mem=0, net=1,800,000] | estRows=180,000,000 | children=[@2] | PhysicalDistribute[391]@2 ( stats=null, distributionSpec=DistributionSpecHash ( orderedShuffledColumns=[16], shuffleType=EXECUTION_BUCKETED, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[16]], exprIdToEquivalenceSet={16=0} ) )
  Chosen Expression ID: 374
  Chosen Properties: DistributionSpecStorageAny Order: ([])
  Statistics
    rows=1.8E8
    tupleSize=1.0
    width=1
    expr_cast(element_at(message, 'mainDomain') as TEXT)#16 -> unknown(1.0)
  Lowest Plan
    ── Entry #1 ──────────────────────────────
    Cost: 54,000,000,003.2
    Properties: ANY
    Expression ID: 374#2
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
    ── Entry #2 ────────────────────────────── BEST
    Cost: 54,000,000,003.2
    Properties: DistributionSpecStorageAny Order: ([])
    Expression ID: 374#2
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
    ── Entry #3 ──────────────────────────────
    Cost: 54,062,700,003.2
    Properties: DistributionSpecHash ( orderedShuffledColumns=[16], shuffleType=EXECUTION_BUCKETED, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[16]], exprIdToEquivalenceSet={16=0} ) Order: ([])
    Expression ID: 390#2
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
    ── Entry #4 ──────────────────────────────
    Cost: 54,062,700,003.2
    Properties: DistributionSpecHash ( orderedShuffledColumns=[16], shuffleType=REQUIRE, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[16]], exprIdToEquivalenceSet={16=0} ) Order: ([])
    Expression ID: 390#2
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
  struct info map
StructInfoMap{ groupExpressionMapByRelationId=[], infoMapByRelationId=[], groupExpressionMapByTableId=[{0}], infoMapByTableId=[], refreshVersion={{0}=84696351}}
═══════════════════════════════════════════════════════════

Group[@3]
  Logical Expressions:
    [1] id:304#3 | cost=null | estRows=4 | children=[] | LogicalOlapScan ( qualified=internal.variant_perf_doris.dim_domain, indexName=<index_not_selected>, selectedIndexId=1787172442931, preAgg=ON, operativeCol=[main_domain#10, domain_group#11, __DORIS_DELETE_SIGN__#12], virtualColumns=[] )
  Physical Expressions:
    [1] id:407#3 | cost=4 [cpu=4, mem=0, net=0] | estRows=-1 | children=[] | PhysicalOlapScan[408]@3 ( table=dim_domain, stats=null, operativeSlots=[main_domain#10, domain_group#11, __DORIS_DELETE_SIGN__#12], virtualColumns=[] )
  Enforcers:
    (none)
  Chosen Expression ID: 407
  Chosen Properties: DistributionSpecHash ( orderedShuffledColumns=[10], shuffleType=NATURAL, tableId=1787172442930, selectedIndexId=1787172442931, partitionIds=[1787172442929], equivalenceExprIds=[[10]], exprIdToEquivalenceSet={10=0} ) Order: ([])
  Statistics
    rows=4.0
    tupleSize=4.0
    width=1
    main_domain#10 -> unknown(4.0)
    domain_group#11 -> unknown(4.0)
    __DORIS_DELETE_SIGN__#12 -> unknown(1.0)
    __DORIS_VERSION_COL__#13 -> unknown(1.0)
  Lowest Plan
    ── Entry #1 ──────────────────────────────
    Cost: 4
    Properties: ANY
    Expression ID: 407#3
    ── Entry #2 ────────────────────────────── BEST
    Cost: 4
    Properties: DistributionSpecHash ( orderedShuffledColumns=[10], shuffleType=NATURAL, tableId=1787172442930, selectedIndexId=1787172442931, partitionIds=[1787172442929], equivalenceExprIds=[[10]], exprIdToEquivalenceSet={10=0} ) Order: ([])
    Expression ID: 407#3
    ── Entry #3 ──────────────────────────────
    Cost: 4
    Properties: DistributionSpecHash ( orderedShuffledColumns=[10], shuffleType=REQUIRE, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[10]], exprIdToEquivalenceSet={10=0} ) Order: ([])
    Expression ID: 407#3
  struct info map
StructInfoMap{ groupExpressionMapByRelationId=[], infoMapByRelationId=[], groupExpressionMapByTableId=[{1}], infoMapByTableId=[], refreshVersion={{0}=84696351}}
═══════════════════════════════════════════════════════════

Group[@4]
  Logical Expressions:
    [1] id:307#4 | cost=null | estRows=4 | children=[@3] | LogicalFilter[308] ( predicates=(__DORIS_DELETE_SIGN__#12 = 0) )
  Physical Expressions:
    [1] id:404#4 | cost=0 [cpu=0, mem=0, net=0] | estRows=-1 | children=[@3] | PhysicalFilter[405]@4 ( stats=null, predicates=(__DORIS_DELETE_SIGN__#12 = 0) )
  Enforcers:
    (none)
  Chosen Expression ID: 404
  Chosen Properties: DistributionSpecHash ( orderedShuffledColumns=[10], shuffleType=NATURAL, tableId=1787172442930, selectedIndexId=1787172442931, partitionIds=[1787172442929], equivalenceExprIds=[[10]], exprIdToEquivalenceSet={10=0} ) Order: ([])
  Statistics
    rows=4.0
    tupleSize=4.0
    width=1
    main_domain#10 -> unknown(4.0)
    domain_group#11 -> unknown(4.0)
    __DORIS_DELETE_SIGN__#12 -> unknown(1.0)
    __DORIS_VERSION_COL__#13 -> unknown(1.0)
  Lowest Plan
    ── Entry #1 ──────────────────────────────
    Cost: 4
    Properties: ANY
    Expression ID: 404#4
    ChildrenRequires:
      [0] DistributionSpecHash ( orderedShuffledColumns=[10], shuffleType=NATURAL, tableId=1787172442930, selectedIndexId=1787172442931, partitionIds=[1787172442929], equivalenceExprIds=[[10]], exprIdToEquivalenceSet={10=0} ) Order: ([])
    ── Entry #2 ────────────────────────────── BEST
    Cost: 4
    Properties: DistributionSpecHash ( orderedShuffledColumns=[10], shuffleType=NATURAL, tableId=1787172442930, selectedIndexId=1787172442931, partitionIds=[1787172442929], equivalenceExprIds=[[10]], exprIdToEquivalenceSet={10=0} ) Order: ([])
    Expression ID: 404#4
    ChildrenRequires:
      [0] DistributionSpecHash ( orderedShuffledColumns=[10], shuffleType=NATURAL, tableId=1787172442930, selectedIndexId=1787172442931, partitionIds=[1787172442929], equivalenceExprIds=[[10]], exprIdToEquivalenceSet={10=0} ) Order: ([])
    ── Entry #3 ──────────────────────────────
    Cost: 4
    Properties: DistributionSpecHash ( orderedShuffledColumns=[10], shuffleType=REQUIRE, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[10]], exprIdToEquivalenceSet={10=0} ) Order: ([])
    Expression ID: 404#4
    ChildrenRequires:
      [0] DistributionSpecHash ( orderedShuffledColumns=[10], shuffleType=NATURAL, tableId=1787172442930, selectedIndexId=1787172442931, partitionIds=[1787172442929], equivalenceExprIds=[[10]], exprIdToEquivalenceSet={10=0} ) Order: ([])
  struct info map
StructInfoMap{ groupExpressionMapByRelationId=[], infoMapByRelationId=[], groupExpressionMapByTableId=[{1}], infoMapByTableId=[], refreshVersion={{0}=84696351}}
═══════════════════════════════════════════════════════════

Group[@5]
  Logical Expressions:
    [1] id:310#5 | cost=null | estRows=4 | children=[@4] | LogicalProject[311] ( distinct=false, projects=[main_domain#10, domain_group#11] )
  Physical Expressions:
    [1] id:399#5 | cost=1 [cpu=1, mem=0, net=0] | estRows=-1 | children=[@4] | PhysicalProject[400]@5 ( stats=null, projects=[main_domain#10, domain_group#11] )
  Enforcers:
    [1] id:419#5 | cost=1.39 [cpu=1.33, mem=0, net=0.04] | estRows=-1 | children=[@5] | PhysicalDistribute[420]@5 ( stats=null, distributionSpec=DistributionSpecHash ( orderedShuffledColumns=[10], shuffleType=EXECUTION_BUCKETED, tableId=1787172442930, selectedIndexId=1787172442931, partitionIds=[1787172442929], equivalenceExprIds=[[10]], exprIdToEquivalenceSet={10=0} ) )
    [2] id:422#5 | cost=0.18 [cpu=0, mem=0, net=0.12] | estRows=4 | children=[@5] | PhysicalDistribute[423]@5 ( stats=null, distributionSpec=DistributionSpecReplicated )
    [3] id:441#5 | cost=1.39 [cpu=1.33, mem=0, net=0.04] | estRows=-1 | children=[@5] | PhysicalDistribute[442]@5 ( stats=null, distributionSpec=DistributionSpecHash ( orderedShuffledColumns=[10], shuffleType=EXECUTION_BUCKETED, tableId=1787172442930, selectedIndexId=1787172442931, partitionIds=[1787172442929], equivalenceExprIds=[[10]], exprIdToEquivalenceSet={10=0} ) )
  Chosen Enforcer(ID, RequiredProperties):
      (0)422,  REPLICATED
  Chosen Expression ID: 399
  Chosen Properties: DistributionSpecHash ( orderedShuffledColumns=[10], shuffleType=NATURAL, tableId=1787172442930, selectedIndexId=1787172442931, partitionIds=[1787172442929], equivalenceExprIds=[[10]], exprIdToEquivalenceSet={10=0} ) Order: ([])
  Statistics
    rows=4.0
    tupleSize=2.0
    width=1
    main_domain#10 -> unknown(4.0)
    domain_group#11 -> unknown(4.0)
  Lowest Plan
    ── Entry #1 ──────────────────────────────
    Cost: 5
    Properties: ANY
    Expression ID: 399#5
    ChildrenRequires:
      [0] DistributionSpecHash ( orderedShuffledColumns=[10], shuffleType=NATURAL, tableId=1787172442930, selectedIndexId=1787172442931, partitionIds=[1787172442929], equivalenceExprIds=[[10]], exprIdToEquivalenceSet={10=0} ) Order: ([])
    ── Entry #2 ────────────────────────────── BEST
    Cost: 5
    Properties: DistributionSpecHash ( orderedShuffledColumns=[10], shuffleType=NATURAL, tableId=1787172442930, selectedIndexId=1787172442931, partitionIds=[1787172442929], equivalenceExprIds=[[10]], exprIdToEquivalenceSet={10=0} ) Order: ([])
    Expression ID: 399#5
    ChildrenRequires:
      [0] DistributionSpecHash ( orderedShuffledColumns=[10], shuffleType=NATURAL, tableId=1787172442930, selectedIndexId=1787172442931, partitionIds=[1787172442929], equivalenceExprIds=[[10]], exprIdToEquivalenceSet={10=0} ) Order: ([])
    ── Entry #3 ──────────────────────────────
    Cost: 5
    Properties: DistributionSpecHash ( orderedShuffledColumns=[10], shuffleType=REQUIRE, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[10]], exprIdToEquivalenceSet={10=0} ) Order: ([])
    Expression ID: 399#5
    ChildrenRequires:
      [0] DistributionSpecHash ( orderedShuffledColumns=[10], shuffleType=NATURAL, tableId=1787172442930, selectedIndexId=1787172442931, partitionIds=[1787172442929], equivalenceExprIds=[[10]], exprIdToEquivalenceSet={10=0} ) Order: ([])
    ── Entry #4 ────────────────────────────── BEST
    Cost: 5.18
    Properties: REPLICATED
    Expression ID: 422#5
    ChildrenRequires:
      [0] DistributionSpecHash ( orderedShuffledColumns=[10], shuffleType=NATURAL, tableId=1787172442930, selectedIndexId=1787172442931, partitionIds=[1787172442929], equivalenceExprIds=[[10]], exprIdToEquivalenceSet={10=0} ) Order: ([])
    ── Entry #5 ──────────────────────────────
    Cost: 6.39
    Properties: DistributionSpecHash ( orderedShuffledColumns=[10], shuffleType=EXECUTION_BUCKETED, tableId=1787172442930, selectedIndexId=1787172442931, partitionIds=[1787172442929], equivalenceExprIds=[[10]], exprIdToEquivalenceSet={10=0} ) Order: ([])
    Expression ID: 419#5
    ChildrenRequires:
      [0] DistributionSpecHash ( orderedShuffledColumns=[10], shuffleType=NATURAL, tableId=1787172442930, selectedIndexId=1787172442931, partitionIds=[1787172442929], equivalenceExprIds=[[10]], exprIdToEquivalenceSet={10=0} ) Order: ([])
  struct info map
StructInfoMap{ groupExpressionMapByRelationId=[], infoMapByRelationId=[], groupExpressionMapByTableId=[{1}], infoMapByTableId=[], refreshVersion={{0}=84696351}}
═══════════════════════════════════════════════════════════

Group[@6]
  Logical Expressions:
    [1] id:313#6 | cost=null | estRows=180,000,000 | children=[@2, @5] | LogicalJoin[314] ( type=INNER_JOIN, markJoinSlotReference=Optional.empty, hashJoinConjuncts=[(expr_cast(element_at(message, 'mainDomain') as TEXT)#16 = main_domain#10)], otherJoinConjuncts=[], markJoinConjuncts=[] )
  Physical Expressions:
    [1] id:369#6 | cost=360,000,008 [cpu=360,000,004, mem=4, net=0] | estRows=-1 | children=[@2, @5] | PhysicalHashJoin[370]@6 ( stats=null, type=INNER_JOIN, hashCondition=[(expr_cast(element_at(message, 'mainDomain') as TEXT)#16 = main_domain#10)], otherCondition=[], markCondition=[] )
  Enforcers:
    [1] id:444#6 | cost=62,700,000 [cpu=60,000,000, mem=0, net=1,800,000] | estRows=180,000,000 | children=[@6] | PhysicalDistribute[445]@6 ( stats=null, distributionSpec=DistributionSpecHash ( orderedShuffledColumns=[11], shuffleType=EXECUTION_BUCKETED, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[11]], exprIdToEquivalenceSet={11=0} ) )
    [2] id:447#6 | cost=62,700,000 [cpu=60,000,000, mem=0, net=1,800,000] | estRows=180,000,000 | children=[@6] | PhysicalDistribute[448]@6 ( stats=null, distributionSpec=DistributionSpecHash ( orderedShuffledColumns=[11], shuffleType=EXECUTION_BUCKETED, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[11]], exprIdToEquivalenceSet={11=0} ) )
  Chosen Expression ID: 369
  Chosen Properties: DistributionSpecStorageAny Order: ([])
  Statistics
    rows=1.8E8
    tupleSize=3.0
    width=2
    main_domain#10 -> unknown(1.0)
    domain_group#11 -> unknown(4.0)
    expr_cast(element_at(message, 'mainDomain') as TEXT)#16 -> unknown(1.0)
  Lowest Plan
    ── Entry #1 ──────────────────────────────
    Cost: 54,360,000,016.38
    Properties: ANY
    Expression ID: 369#6
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
      [1] REPLICATED
    ── Entry #2 ────────────────────────────── BEST
    Cost: 54,360,000,016.38
    Properties: DistributionSpecStorageAny Order: ([])
    Expression ID: 369#6
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
      [1] REPLICATED
    ── Entry #3 ──────────────────────────────
    Cost: 54,422,700,016.38
    Properties: DistributionSpecHash ( orderedShuffledColumns=[11], shuffleType=EXECUTION_BUCKETED, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[11]], exprIdToEquivalenceSet={11=0} ) Order: ([])
    Expression ID: 447#6
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
    ── Entry #4 ──────────────────────────────
    Cost: 54,422,700,016.38
    Properties: DistributionSpecHash ( orderedShuffledColumns=[11], shuffleType=REQUIRE, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[11]], exprIdToEquivalenceSet={11=0} ) Order: ([])
    Expression ID: 447#6
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
    ── Entry #5 ──────────────────────────────
    Cost: 54,422,700,017.59
    Properties: DistributionSpecHash ( orderedShuffledColumns=[16], shuffleType=EXECUTION_BUCKETED, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[16, 10]], exprIdToEquivalenceSet={16=0, 10=0} ) Order: ([])
    Expression ID: 369#6
    ChildrenRequires:
      [0] DistributionSpecHash ( orderedShuffledColumns=[16], shuffleType=EXECUTION_BUCKETED, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[16]], exprIdToEquivalenceSet={16=0} ) Order: ([])
      [1] DistributionSpecHash ( orderedShuffledColumns=[10], shuffleType=EXECUTION_BUCKETED, tableId=1787172442930, selectedIndexId=1787172442931, partitionIds=[1787172442929], equivalenceExprIds=[[10]], exprIdToEquivalenceSet={10=0} ) Order: ([])
  struct info map
StructInfoMap{ groupExpressionMapByRelationId=[], infoMapByRelationId=[], groupExpressionMapByTableId=[{0, 1}], infoMapByTableId=[], refreshVersion={{0}=84696351}}
═══════════════════════════════════════════════════════════

Group[@7]
  Logical Expressions:
    [1] id:316#7 | cost=null | estRows=180,000,000 | children=[@6] | LogicalProject[317] ( distinct=false, projects=[domain_group#11] )
  Physical Expressions:
    [1] id:363#7 | cost=1 [cpu=1, mem=0, net=0] | estRows=-1 | children=[@6] | PhysicalProject[364]@7 ( stats=null, projects=[domain_group#11] )
  Enforcers:
    [1] id:438#7 | cost=62,700,000 [cpu=60,000,000, mem=0, net=1,800,000] | estRows=180,000,000 | children=[@7] | PhysicalDistribute[439]@7 ( stats=null, distributionSpec=DistributionSpecHash ( orderedShuffledColumns=[11], shuffleType=EXECUTION_BUCKETED, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[11]], exprIdToEquivalenceSet={11=0} ) )
  Chosen Expression ID: 363
  Chosen Properties: DistributionSpecStorageAny Order: ([])
  Statistics
    rows=1.8E8
    tupleSize=1.0
    width=2
    domain_group#11 -> unknown(4.0)
  Lowest Plan
    ── Entry #1 ──────────────────────────────
    Cost: 54,360,000,017.38
    Properties: ANY
    Expression ID: 363#7
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
    ── Entry #2 ────────────────────────────── BEST
    Cost: 54,360,000,017.38
    Properties: DistributionSpecStorageAny Order: ([])
    Expression ID: 363#7
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
    ── Entry #3 ──────────────────────────────
    Cost: 54,422,700,017.38
    Properties: DistributionSpecHash ( orderedShuffledColumns=[11], shuffleType=EXECUTION_BUCKETED, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[11]], exprIdToEquivalenceSet={11=0} ) Order: ([])
    Expression ID: 438#7
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
    ── Entry #4 ──────────────────────────────
    Cost: 54,422,700,017.38
    Properties: DistributionSpecHash ( orderedShuffledColumns=[11], shuffleType=REQUIRE, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[11]], exprIdToEquivalenceSet={11=0} ) Order: ([])
    Expression ID: 438#7
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
  struct info map
StructInfoMap{ groupExpressionMapByRelationId=[], infoMapByRelationId=[], groupExpressionMapByTableId=[{0, 1}], infoMapByTableId=[], refreshVersion={{0}=84696351}}
═══════════════════════════════════════════════════════════

Group[@8]
  Logical Expressions:
    [1] id:319#8 | cost=null | estRows=60,000,000 | children=[@7] | LogicalAggregate[320] ( groupByExpr=[domain_group#11], outputExpr=[domain_group#11, count(*) AS `visits`#14], hasRepeat=false )
  Physical Expressions:
    [1] id:352#8 | cost=120,000,000 [cpu=60,000,000, mem=60,000,000, net=0] | estRows=-1 | children=[@7] | PhysicalHashAggregate[353]@8 ( stats=null, aggPhase=GLOBAL, aggMode=INPUT_TO_RESULT, maybeUseStreaming=false, groupByExpr=[domain_group#11], outputExpr=[domain_group#11, count(*) AS `visits`#14], partitionExpr=Optional.empty, topnFilter=false, topnPushDown=false )
    [2] id:358#8 | cost=40,000,000.02 [cpu=20,000,000.02, mem=20,000,000, net=0] | estRows=20,000,000 | children=[@12] | PhysicalHashAggregate[359]@8 ( stats=null, aggPhase=GLOBAL, aggMode=BUFFER_TO_RESULT, maybeUseStreaming=false, groupByExpr=[domain_group#11], outputExpr=[domain_group#11, count(partial_count(*)#22) AS `visits`#14], partitionExpr=Optional.empty, topnFilter=false, topnPushDown=false )
  Enforcers:
    [1] id:435#8 | cost=900,000 [cpu=0, mem=0, net=600,000] | estRows=60,000,000 | children=[@8] | PhysicalDistribute[436]@8 ( stats=null, distributionSpec=DistributionSpecGather )
  Chosen Expression ID: 358
  Chosen Properties: DistributionSpecHash ( orderedShuffledColumns=[11], shuffleType=EXECUTION_BUCKETED, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[11]], exprIdToEquivalenceSet={11=0} ) Order: ([])
  Statistics
    rows=6.0E7
    tupleSize=9.0
    width=1
    domain_group#11 -> unknown(4.0)
    visits#14 -> unknown(1.0)
  Lowest Plan
    ── Entry #1 ──────────────────────────────
    Cost: 54,540,900,017.4
    Properties: ANY
    Expression ID: 358#8
    ChildrenRequires:
      [0] DistributionSpecHash ( orderedShuffledColumns=[11], shuffleType=EXECUTION_BUCKETED, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[11]], exprIdToEquivalenceSet={11=0} ) Order: ([])
    ── Entry #2 ────────────────────────────── BEST
    Cost: 54,540,900,017.4
    Properties: DistributionSpecHash ( orderedShuffledColumns=[11], shuffleType=EXECUTION_BUCKETED, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[11]], exprIdToEquivalenceSet={11=0} ) Order: ([])
    Expression ID: 358#8
    ChildrenRequires:
      [0] DistributionSpecHash ( orderedShuffledColumns=[11], shuffleType=EXECUTION_BUCKETED, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[11]], exprIdToEquivalenceSet={11=0} ) Order: ([])
    ── Entry #3 ──────────────────────────────
    Cost: 54,541,800,017.4
    Properties: GATHER
    Expression ID: 435#8
    ChildrenRequires:
      [0] DistributionSpecHash ( orderedShuffledColumns=[11], shuffleType=EXECUTION_BUCKETED, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[11]], exprIdToEquivalenceSet={11=0} ) Order: ([])
  struct info map
StructInfoMap{ groupExpressionMapByRelationId=[], infoMapByRelationId=[], groupExpressionMapByTableId=[{0, 1}], infoMapByTableId=[], refreshVersion={{0}=84696351}}
═══════════════════════════════════════════════════════════

Group[@9]
  Logical Expressions:
    [1] id:322#9 | cost=null | estRows=60,000,000 | children=[@8] | LogicalSort[323] ( orderKeys=[domain_group#11 asc null first] )
  Physical Expressions:
    [1] id:340#9 | cost=210,000,000 [cpu=60,000,000, mem=60,000,000, net=60,000,000] | estRows=60,000,000 | children=[@11] | PhysicalQuickSort[341]@9 ( stats=null, orderKeys=[domain_group#11 asc null first], phase=MERGE_SORT )
    [2] id:343#9 | cost=6,150,000,000 [cpu=60,000,000, mem=6,000,000,000, net=60,000,000] | estRows=-1 | children=[@8] | PhysicalQuickSort[344]@9 ( stats=null, orderKeys=[domain_group#11 asc null first], phase=GATHER_SORT )
  Enforcers:
    (none)
  Chosen Expression ID: 340
  Chosen Properties: DistributionSpecGather Order: ([domain_group#11 asc null first])
  Statistics
    rows=6.0E7
    tupleSize=9.0
    width=1
    domain_group#11 -> unknown(4.0)
    visits#14 -> unknown(1.0)
  Lowest Plan
    ── Entry #1 ──────────────────────────────
    Cost: 54,961,800,017.4
    Properties: ANY
    Expression ID: 340#9
    ChildrenRequires:
      [0] GATHER
    ── Entry #2 ────────────────────────────── BEST
    Cost: 54,961,800,017.4
    Properties: DistributionSpecGather Order: ([domain_group#11 asc null first])
    Expression ID: 340#9
    ChildrenRequires:
      [0] GATHER
  struct info map
StructInfoMap{ groupExpressionMapByRelationId=[], infoMapByRelationId=[], groupExpressionMapByTableId=[], infoMapByTableId=[], refreshVersion={}}
═══════════════════════════════════════════════════════════

ROOT Group[@10]
  Logical Expressions:
    [1] id:325#10 | cost=null | estRows=60,000,000 | children=[@9] | LogicalResultSink[326] ( outputExprs=[domain_group#11, visits#14] )
  Physical Expressions:
    [1] id:330#10 | cost=0 [cpu=0, mem=0, net=0] | estRows=-1 | children=[@9] | PhysicalResultSink[331] ( outputExprs=[domain_group#11, visits#14] )
  Enforcers:
    (none)
  Chosen Expression ID: 330
  Chosen Properties: GATHER
  Statistics
    rows=6.0E7
    tupleSize=9.0
    width=1
    domain_group#11 -> unknown(4.0)
    visits#14 -> unknown(1.0)
  Lowest Plan
    ── Entry #1 ──────────────────────────────
    Cost: 54,961,800,017.4
    Properties: ANY
    Expression ID: 330#10
    ChildrenRequires:
      [0] DistributionSpecGather Order: ([domain_group#11 asc null first])
    ── Entry #2 ────────────────────────────── BEST
    Cost: 54,961,800,017.4
    Properties: GATHER
    Expression ID: 330#10
    ChildrenRequires:
      [0] DistributionSpecGather Order: ([domain_group#11 asc null first])
  struct info map
StructInfoMap{ groupExpressionMapByRelationId=[], infoMapByRelationId=[], groupExpressionMapByTableId=[], infoMapByTableId=[], refreshVersion={}}
═══════════════════════════════════════════════════════════

Group[@11]
  Logical Expressions:
    (none)
  Physical Expressions:
    [1] id:337#11 | cost=210,000,000 [cpu=60,000,000, mem=60,000,000, net=60,000,000] | estRows=60,000,000 | children=[@8] | PhysicalQuickSort[338]@11 ( stats=null, orderKeys=[domain_group#11 asc null first], phase=LOCAL_SORT )
  Enforcers:
    [1] id:455#11 | cost=900,000 [cpu=0, mem=0, net=600,000] | estRows=60,000,000 | children=[@11] | PhysicalDistribute[456]@11 ( stats=null, distributionSpec=DistributionSpecGather )
  Chosen Enforcer(ID, RequiredProperties):
      (0)455,  GATHER
  Chosen Expression ID: 337
  Chosen Properties: DistributionSpecHash ( orderedShuffledColumns=[11], shuffleType=EXECUTION_BUCKETED, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[11]], exprIdToEquivalenceSet={11=0} ) Order: ([domain_group#11 asc null first])
  Statistics
    rows=6.0E7
    tupleSize=9.0
    width=1
    domain_group#11 -> unknown(4.0)
    visits#14 -> unknown(1.0)
  Lowest Plan
    ── Entry #1 ──────────────────────────────
    Cost: 54,750,900,017.4
    Properties: ANY
    Expression ID: 337#11
    ChildrenRequires:
      [0] DistributionSpecHash ( orderedShuffledColumns=[11], shuffleType=EXECUTION_BUCKETED, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[11]], exprIdToEquivalenceSet={11=0} ) Order: ([])
    ── Entry #2 ────────────────────────────── BEST
    Cost: 54,750,900,017.4
    Properties: DistributionSpecHash ( orderedShuffledColumns=[11], shuffleType=EXECUTION_BUCKETED, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[11]], exprIdToEquivalenceSet={11=0} ) Order: ([domain_group#11 asc null first])
    Expression ID: 337#11
    ChildrenRequires:
      [0] DistributionSpecHash ( orderedShuffledColumns=[11], shuffleType=EXECUTION_BUCKETED, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[11]], exprIdToEquivalenceSet={11=0} ) Order: ([])
    ── Entry #3 ────────────────────────────── BEST
    Cost: 54,751,800,017.4
    Properties: GATHER
    Expression ID: 455#11
    ChildrenRequires:
      [0] DistributionSpecHash ( orderedShuffledColumns=[11], shuffleType=EXECUTION_BUCKETED, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[11]], exprIdToEquivalenceSet={11=0} ) Order: ([domain_group#11 asc null first])
  struct info map
StructInfoMap{ groupExpressionMapByRelationId=[], infoMapByRelationId=[], groupExpressionMapByTableId=[], infoMapByTableId=[], refreshVersion={}}
═══════════════════════════════════════════════════════════

Group[@12]
  Logical Expressions:
    (none)
  Physical Expressions:
    [1] id:355#12 | cost=120,000,000 [cpu=60,000,000, mem=60,000,000, net=0] | estRows=60,000,000 | children=[@7] | PhysicalHashAggregate[356]@12 ( stats=null, aggPhase=LOCAL, aggMode=INPUT_TO_BUFFER, maybeUseStreaming=true, groupByExpr=[domain_group#11], outputExpr=[domain_group#11, partial_count(*) AS `partial_count(*)`#22], partitionExpr=Optional.empty, topnFilter=false, topnPushDown=false )
  Enforcers:
    [1] id:432#12 | cost=20,900,000 [cpu=20,000,000, mem=0, net=600,000] | estRows=60,000,000 | children=[@12] | PhysicalDistribute[433]@12 ( stats=null, distributionSpec=DistributionSpecHash ( orderedShuffledColumns=[11], shuffleType=EXECUTION_BUCKETED, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[11]], exprIdToEquivalenceSet={11=0} ) )
  Chosen Enforcer(ID, RequiredProperties):
      (0)432,  DistributionSpecHash ( orderedShuffledColumns=[11], shuffleType=EXECUTION_BUCKETED, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[11]], exprIdToEquivalenceSet={11=0} ) Order: ([])
  Chosen Expression ID: 355
  Chosen Properties: DistributionSpecStorageAny Order: ([])
  Statistics
    rows=6.0E7
    tupleSize=9.0
    width=1
    domain_group#11 -> unknown(4.0)
    partial_count(*)#22 -> unknown(1.0)
  Lowest Plan
    ── Entry #1 ──────────────────────────────
    Cost: 54,480,000,017.38
    Properties: ANY
    Expression ID: 355#12
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
    ── Entry #2 ────────────────────────────── BEST
    Cost: 54,480,000,017.38
    Properties: DistributionSpecStorageAny Order: ([])
    Expression ID: 355#12
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
    ── Entry #3 ────────────────────────────── BEST
    Cost: 54,500,900,017.38
    Properties: DistributionSpecHash ( orderedShuffledColumns=[11], shuffleType=EXECUTION_BUCKETED, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[11]], exprIdToEquivalenceSet={11=0} ) Order: ([])
    Expression ID: 432#12
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
    ── Entry #4 ──────────────────────────────
    Cost: 54,500,900,017.38
    Properties: DistributionSpecHash ( orderedShuffledColumns=[11], shuffleType=REQUIRE, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[11]], exprIdToEquivalenceSet={11=0} ) Order: ([])
    Expression ID: 432#12
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
  struct info map
StructInfoMap{ groupExpressionMapByRelationId=[], infoMapByRelationId=[], groupExpressionMapByTableId=[], infoMapByTableId=[], refreshVersion={}}

========== OPTIMIZED PLAN ==========
PhysicalResultSink[560] ( outputExprs=[domain_group#11, visits#14] )
+--PhysicalQuickSort[556]@9 ( stats=60,000,000, orderKeys=[domain_group#11 asc null first], phase=MERGE_SORT )
   +--PhysicalDistribute[552]@11 ( stats=60,000,000, distributionSpec=DistributionSpecGather )
      +--PhysicalQuickSort[548]@11 ( stats=60,000,000, orderKeys=[domain_group#11 asc null first], phase=LOCAL_SORT )
         +--PhysicalHashAggregate[544]@8 ( stats=60,000,000, aggPhase=GLOBAL, aggMode=BUFFER_TO_RESULT, maybeUseStreaming=false, groupByExpr=[domain_group#11], outputExpr=[domain_group#11, count(partial_count(*)#22) AS `visits`#14], partitionExpr=Optional.empty, topnFilter=false, topnPushDown=false )
            +--PhysicalDistribute[540]@12 ( stats=60,000,000, distributionSpec=DistributionSpecHash ( orderedShuffledColumns=[11], shuffleType=EXECUTION_BUCKETED, tableId=-1, selectedIndexId=-1, partitionIds=[], equivalenceExprIds=[[11]], exprIdToEquivalenceSet={11=0} ) )
               +--PhysicalHashAggregate[536]@12 ( stats=60,000,000, aggPhase=LOCAL, aggMode=INPUT_TO_BUFFER, maybeUseStreaming=true, groupByExpr=[domain_group#11], outputExpr=[domain_group#11, partial_count(*) AS `partial_count(*)`#22], partitionExpr=Optional.empty, topnFilter=false, topnPushDown=false )
                  +--PhysicalProject[532]@7 ( stats=180,000,000, projects=[domain_group#11] )
                     +--PhysicalHashJoin[528]@6 ( stats=180,000,000, type=INNER_JOIN, hashCondition=[(expr_cast(element_at(message, 'mainDomain') as TEXT)#16 = main_domain#10)], otherCondition=[], markCondition=[] )
                        |--PhysicalProject[511]@2 ( stats=180,000,000, projects=[cast(element_at(message#7, 'mainDomain') as TEXT) AS `expr_cast(element_at(message, 'mainDomain') as TEXT)`#16] )
                        |  +--PhysicalFilter[507]@1 ( stats=180,000,000, predicates=(event_date#0 = 2026-06-15) )
                        |     +--PhysicalFileScan[503]@0 ( table=browser_access_pk_variant_unshredded, stats=10,800,000,000, qualified=truewatch_iceberg_rest_4809.variant_truewatch_60d_pk_20260805_probe_perf5d_b128_range_sp4096.browser_access_pk_variant_unshredded, selected partitions num=0, operativeCols=[event_date#0, message#7] )
                        +--PhysicalDistribute[524]@5 ( stats=4, distributionSpec=DistributionSpecReplicated )
                           +--PhysicalProject[520]@5 ( stats=4, projects=[main_domain#10, domain_group#11] )
                              +--PhysicalFilter[516]@4 ( stats=4, predicates=(__DORIS_DELETE_SIGN__#12 = 0) )
                                 +--PhysicalOlapScan[512]@3 ( table=dim_domain, stats=4, operativeSlots=[main_domain#10, domain_group#11, __DORIS_DELETE_SIGN__#12], virtualColumns=[] )

========== MATERIALIZATIONS ==========

MaterializedView
MaterializedViewRewriteSuccessAndChose:

MaterializedViewRewriteSuccessButNotChose:

MaterializedViewRewriteFail:
 CBO.internal.variant_perf_doris.mv_truewatch_spark_unshredded fail
  FailInfo: View struct info is invalid:view plan is LogicalResultSink[111] ( outputExprs=[event_date#0, event_hour#10, main_domain#11, anomaly_type#12, visit_count#13, anomaly_count#14] )
+--LogicalProject[110] ( distinct=false, projects=[event_date#0, event_hour#10, main_domain#11, anomaly_type#12, visit_count#13, sum(CASE WHEN ( not (cast(element_at(message, 'anomalyType') as TEXT) = 'normal')) THEN 1 ELSE 0 END)#16 AS `anomaly_count`#14] )
   +--LogicalAggregate[109] ( groupByExpr=[event_date#0, event_hour#10, main_domain#11, anomaly_type#12], outputExpr=[event_date#0, event_hour#10, main_domain#11, anomaly_type#12, count(*) AS `visit_count`#13, sum(CASE WHEN ( not (cast(element_at(message, 'anomalyType') as TEXT) = 'normal')) THEN 1 ELSE 0 END#15) AS `sum(CASE WHEN ( not (cast(element_at(message, 'anomalyType') as TEXT) = 'normal')) THEN 1 ELSE 0 END)`#16], hasRepeat=false )
      +--LogicalProject[108] ( distinct=false, projects=[event_date#0, date_trunc(event_time#1, 'hour') AS `event_hour`#10, cast(element_at(message#7, 'mainDomain') as TEXT) AS `main_domain`#11, cast(element_at(message#7, 'anomalyType') as TEXT) AS `anomaly_type`#12, if(( not (cast(element_at(message#7, 'anomalyType') as TEXT) = 'normal')), 1, 0) AS `CASE WHEN ( not (cast(element_at(message, 'anomalyType') as TEXT) = 'normal')) THEN 1 ELSE 0 END`#15] )
         +--LogicalFilter[107] ( predicates=(event_date#0 = 2026-06-15) )
            +--LogicalFileScan ( qualified=truewatch_iceberg_rest_4809.variant_truewatch_60d_pk_20260805_probe_perf5d_b128_range_sp4096.browser_access_pk_variant_unshredded, output=[event_date#0, event_time#1, event_time_ms#2, event_id#3, source#4, dw_keyword#5, load_version#6, message#7, _row_id#8, _last_updated_sequence_number#9], operativeCols=[event_date#0, event_time#1, message#7] )
