
Group[@0]
  Logical Expressions:
    [1] id:82#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:135#0 | cost=54,000,000,000 [cpu=54,000,000,000, mem=0, net=0] | estRows=-1 | children=[] | PhysicalFileScan[136]@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: 135
  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: 135#0
    ── Entry #2 ────────────────────────────── BEST
    Cost: 54,000,000,000
    Properties: DistributionSpecStorageAny Order: ([])
    Expression ID: 135#0
  struct info map
StructInfoMap{ groupExpressionMapByRelationId=[], infoMapByRelationId=[], groupExpressionMapByTableId=[{0}], infoMapByTableId=[], refreshVersion={{0}=84696351}}
═══════════════════════════════════════════════════════════

Group[@1]
  Logical Expressions:
    [1] id:85#1 | cost=null | estRows=180,000,000 | children=[@0] | LogicalFilter[86] ( predicates=(event_date#0 = 2026-06-15) )
  Physical Expressions:
    [1] id:132#1 | cost=0 [cpu=0, mem=0, net=0] | estRows=-1 | children=[@0] | PhysicalFilter[133]@1 ( stats=null, predicates=(event_date#0 = 2026-06-15) )
  Enforcers:
    (none)
  Chosen Expression ID: 132
  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: 132#1
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
    ── Entry #2 ────────────────────────────── BEST
    Cost: 54,000,000,000
    Properties: DistributionSpecStorageAny Order: ([])
    Expression ID: 132#1
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
  struct info map
StructInfoMap{ groupExpressionMapByRelationId=[], infoMapByRelationId=[], groupExpressionMapByTableId=[{0}], infoMapByTableId=[], refreshVersion={{0}=84696351}}
═══════════════════════════════════════════════════════════

Group[@2]
  Logical Expressions:
    [1] id:88#2 | cost=null | estRows=180,000,000 | children=[@1] | LogicalProject[89] ( distinct=false, projects=[(((((((((((((((((((((((((((((((((((((((((((((((((cast(coalesce(length(cast(element_at(message#7, 'accessTime') as TEXT)), 0) as BIGINT) + cast(coalesce(length(cast(element_at(message#7, 'anomalyType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'browser') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'browserFingerprint') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'browserVersion') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'cdnNode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'clientType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'companyId') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'deviceBrand') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'deviceModel') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'deviceNo') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'dnsCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'dw_keyword') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'httpStatusCode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'mainDomain') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'totalCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'url') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey000') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey001') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey002') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey003') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey004') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey005') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey006') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey007') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey008') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey009') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey010') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey011') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey012') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey013') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey014') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey015') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey016') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey017') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey018') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey019') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey020') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey021') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey022') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey023') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey024') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey025') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey026') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey027') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey028') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey029') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey030') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey031') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey032') as TEXT)), 0) as BIGINT)) AS `(((((((((((((((((((((((((((((((((((((((((((((((((cast(coalesce(length(cast(element_at(message, 'accessTime') as TEXT)), 0) as BIGINT) + cast(coalesce(length(cast(element_at(message, 'anomalyType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browser') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserFingerprint') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserVersion') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'cdnNode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'clientType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'companyId') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceBrand') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceModel') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceNo') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dnsCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dw_keyword') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'httpStatusCode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'mainDomain') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'totalCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'url') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey000') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey001') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey002') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey003') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey004') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey005') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey006') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey007') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey008') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey009') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey010') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey011') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey012') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey013') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey014') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey015') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey016') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey017') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey018') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey019') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey020') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey021') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey022') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey023') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey024') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey025') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey026') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey027') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey028') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey029') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey030') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey031') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey032') as TEXT)), 0) as BIGINT))`#11] )
  Physical Expressions:
    [1] id:127#2 | cost=235.8 [cpu=235.8, mem=0, net=0] | estRows=-1 | children=[@1] | PhysicalProject[128]@2 ( stats=null, projects=[(((((((((((((((((((((((((((((((((((((((((((((((((cast(coalesce(length(cast(element_at(message#7, 'accessTime') as TEXT)), 0) as BIGINT) + cast(coalesce(length(cast(element_at(message#7, 'anomalyType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'browser') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'browserFingerprint') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'browserVersion') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'cdnNode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'clientType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'companyId') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'deviceBrand') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'deviceModel') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'deviceNo') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'dnsCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'dw_keyword') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'httpStatusCode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'mainDomain') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'totalCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'url') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey000') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey001') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey002') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey003') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey004') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey005') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey006') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey007') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey008') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey009') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey010') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey011') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey012') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey013') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey014') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey015') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey016') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey017') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey018') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey019') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey020') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey021') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey022') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey023') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey024') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey025') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey026') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey027') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey028') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey029') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey030') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey031') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey032') as TEXT)), 0) as BIGINT)) AS `(((((((((((((((((((((((((((((((((((((((((((((((((cast(coalesce(length(cast(element_at(message, 'accessTime') as TEXT)), 0) as BIGINT) + cast(coalesce(length(cast(element_at(message, 'anomalyType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browser') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserFingerprint') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserVersion') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'cdnNode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'clientType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'companyId') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceBrand') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceModel') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceNo') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dnsCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dw_keyword') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'httpStatusCode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'mainDomain') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'totalCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'url') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey000') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey001') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey002') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey003') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey004') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey005') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey006') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey007') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey008') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey009') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey010') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey011') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey012') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey013') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey014') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey015') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey016') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey017') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey018') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey019') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey020') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey021') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey022') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey023') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey024') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey025') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey026') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey027') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey028') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey029') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey030') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey031') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey032') as TEXT)), 0) as BIGINT))`#11] )
  Enforcers:
    [1] id:150#2 | cost=2,700,000 [cpu=0, mem=0, net=1,800,000] | estRows=180,000,000 | children=[@2] | PhysicalDistribute[151]@2 ( stats=null, distributionSpec=DistributionSpecGather )
  Chosen Expression ID: 127
  Chosen Properties: DistributionSpecStorageAny Order: ([])
  Statistics
    rows=1.8E8
    tupleSize=1.0
    width=1
    (((((((((((((((((((((((((((((((((((((((((((((((((cast(coalesce(length(cast(element_at(message, 'accessTime') as TEXT)), 0) as BIGINT) + cast(coalesce(length(cast(element_at(message, 'anomalyType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browser') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserFingerprint') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserVersion') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'cdnNode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'clientType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'companyId') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceBrand') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceModel') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceNo') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dnsCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dw_keyword') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'httpStatusCode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'mainDomain') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'totalCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'url') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey000') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey001') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey002') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey003') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey004') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey005') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey006') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey007') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey008') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey009') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey010') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey011') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey012') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey013') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey014') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey015') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey016') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey017') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey018') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey019') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey020') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey021') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey022') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey023') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey024') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey025') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey026') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey027') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey028') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey029') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey030') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey031') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey032') as TEXT)), 0) as BIGINT))#11 -> ndv=1.0000, min=-Infinity(null), max=Infinity(null), count=0.0000, numNulls=1.0000, avgSizeByte=1.000000, hotValues=(null)
  Lowest Plan
    ── Entry #1 ──────────────────────────────
    Cost: 54,000,000,235.8
    Properties: ANY
    Expression ID: 127#2
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
    ── Entry #2 ────────────────────────────── BEST
    Cost: 54,000,000,235.8
    Properties: DistributionSpecStorageAny Order: ([])
    Expression ID: 127#2
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
    ── Entry #3 ──────────────────────────────
    Cost: 54,002,700,235.8
    Properties: GATHER
    Expression ID: 150#2
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
  struct info map
StructInfoMap{ groupExpressionMapByRelationId=[], infoMapByRelationId=[], groupExpressionMapByTableId=[{0}], infoMapByTableId=[], refreshVersion={{0}=84696351}}
═══════════════════════════════════════════════════════════

Group[@3]
  Logical Expressions:
    [1] id:91#3 | cost=null | estRows=1 | children=[@2] | LogicalAggregate[92] ( groupByExpr=[], outputExpr=[sum((((((((((((((((((((((((((((((((((((((((((((((((((cast(coalesce(length(cast(element_at(message, 'accessTime') as TEXT)), 0) as BIGINT) + cast(coalesce(length(cast(element_at(message, 'anomalyType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browser') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserFingerprint') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserVersion') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'cdnNode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'clientType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'companyId') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceBrand') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceModel') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceNo') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dnsCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dw_keyword') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'httpStatusCode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'mainDomain') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'totalCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'url') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey000') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey001') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey002') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey003') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey004') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey005') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey006') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey007') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey008') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey009') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey010') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey011') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey012') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey013') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey014') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey015') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey016') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey017') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey018') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey019') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey020') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey021') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey022') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey023') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey024') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey025') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey026') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey027') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey028') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey029') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey030') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey031') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey032') as TEXT)), 0) as BIGINT))#11) AS `sum((((((((((((((((((((((((((((((((((((((((((((((((((cast(coalesce(length(cast(element_at(message, 'accessTime') as TEXT)), 0) as BIGINT) + cast(coalesce(length(cast(element_at(message, 'anomalyType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browser') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserFingerprint') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserVersion') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'cdnNode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'clientType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'companyId') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceBrand') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceModel') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceNo') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dnsCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dw_keyword') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'httpStatusCode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'mainDomain') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'totalCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'url') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey000') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey001') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey002') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey003') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey004') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey005') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey006') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey007') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey008') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey009') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey010') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey011') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey012') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey013') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey014') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey015') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey016') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey017') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey018') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey019') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey020') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey021') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey022') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey023') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey024') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey025') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey026') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey027') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey028') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey029') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey030') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey031') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey032') as TEXT)), 0) as BIGINT)))`#12], hasRepeat=false )
  Physical Expressions:
    [1] id:116#3 | cost=360,000,000 [cpu=180,000,000, mem=180,000,000, net=0] | estRows=-1 | children=[@2] | PhysicalHashAggregate[117]@3 ( stats=null, aggPhase=GLOBAL, aggMode=INPUT_TO_RESULT, maybeUseStreaming=false, groupByExpr=[], outputExpr=[sum((((((((((((((((((((((((((((((((((((((((((((((((((cast(coalesce(length(cast(element_at(message, 'accessTime') as TEXT)), 0) as BIGINT) + cast(coalesce(length(cast(element_at(message, 'anomalyType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browser') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserFingerprint') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserVersion') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'cdnNode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'clientType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'companyId') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceBrand') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceModel') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceNo') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dnsCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dw_keyword') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'httpStatusCode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'mainDomain') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'totalCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'url') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey000') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey001') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey002') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey003') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey004') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey005') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey006') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey007') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey008') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey009') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey010') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey011') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey012') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey013') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey014') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey015') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey016') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey017') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey018') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey019') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey020') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey021') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey022') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey023') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey024') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey025') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey026') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey027') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey028') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey029') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey030') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey031') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey032') as TEXT)), 0) as BIGINT))#11) AS `sum((((((((((((((((((((((((((((((((((((((((((((((((((cast(coalesce(length(cast(element_at(message, 'accessTime') as TEXT)), 0) as BIGINT) + cast(coalesce(length(cast(element_at(message, 'anomalyType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browser') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserFingerprint') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserVersion') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'cdnNode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'clientType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'companyId') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceBrand') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceModel') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceNo') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dnsCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dw_keyword') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'httpStatusCode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'mainDomain') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'totalCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'url') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey000') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey001') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey002') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey003') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey004') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey005') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey006') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey007') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey008') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey009') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey010') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey011') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey012') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey013') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey014') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey015') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey016') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey017') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey018') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey019') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey020') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey021') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey022') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey023') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey024') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey025') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey026') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey027') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey028') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey029') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey030') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey031') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey032') as TEXT)), 0) as BIGINT)))`#12], partitionExpr=Optional.empty, topnFilter=false, topnPushDown=false )
    [2] id:122#3 | cost=2.02 [cpu=1.02, mem=1, net=0] | estRows=1 | children=[@6] | PhysicalHashAggregate[123]@3 ( stats=null, aggPhase=GLOBAL, aggMode=BUFFER_TO_RESULT, maybeUseStreaming=false, groupByExpr=[], outputExpr=[sum(partial_sum((((((((((((((((((((((((((((((((((((((((((((((((((cast(coalesce(length(cast(element_at(message, 'accessTime') as TEXT)), 0) as BIGINT) + cast(coalesce(length(cast(element_at(message, 'anomalyType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browser') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserFingerprint') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserVersion') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'cdnNode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'clientType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'companyId') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceBrand') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceModel') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceNo') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dnsCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dw_keyword') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'httpStatusCode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'mainDomain') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'totalCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'url') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey000') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey001') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey002') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey003') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey004') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey005') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey006') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey007') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey008') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey009') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey010') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey011') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey012') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey013') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey014') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey015') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey016') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey017') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey018') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey019') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey020') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey021') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey022') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey023') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey024') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey025') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey026') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey027') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey028') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey029') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey030') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey031') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey032') as TEXT)), 0) as BIGINT)))#13) AS `sum((((((((((((((((((((((((((((((((((((((((((((((((((cast(coalesce(length(cast(element_at(message, 'accessTime') as TEXT)), 0) as BIGINT) + cast(coalesce(length(cast(element_at(message, 'anomalyType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browser') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserFingerprint') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserVersion') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'cdnNode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'clientType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'companyId') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceBrand') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceModel') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceNo') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dnsCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dw_keyword') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'httpStatusCode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'mainDomain') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'totalCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'url') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey000') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey001') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey002') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey003') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey004') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey005') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey006') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey007') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey008') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey009') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey010') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey011') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey012') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey013') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey014') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey015') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey016') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey017') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey018') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey019') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey020') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey021') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey022') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey023') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey024') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey025') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey026') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey027') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey028') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey029') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey030') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey031') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey032') as TEXT)), 0) as BIGINT)))`#12], partitionExpr=Optional.empty, topnFilter=false, topnPushDown=false )
  Enforcers:
    (none)
  Chosen Expression ID: 122
  Chosen Properties: GATHER
  Statistics
    rows=1.0
    tupleSize=8.0
    width=1
    sum((((((((((((((((((((((((((((((((((((((((((((((((((cast(coalesce(length(cast(element_at(message, 'accessTime') as TEXT)), 0) as BIGINT) + cast(coalesce(length(cast(element_at(message, 'anomalyType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browser') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserFingerprint') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserVersion') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'cdnNode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'clientType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'companyId') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceBrand') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceModel') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceNo') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dnsCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dw_keyword') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'httpStatusCode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'mainDomain') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'totalCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'url') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey000') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey001') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey002') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey003') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey004') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey005') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey006') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey007') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey008') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey009') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey010') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey011') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey012') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey013') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey014') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey015') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey016') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey017') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey018') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey019') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey020') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey021') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey022') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey023') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey024') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey025') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey026') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey027') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey028') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey029') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey030') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey031') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey032') as TEXT)), 0) as BIGINT)))#12 -> unknown(1.0)
  Lowest Plan
    ── Entry #1 ──────────────────────────────
    Cost: 54,120,000,237.84
    Properties: ANY
    Expression ID: 122#3
    ChildrenRequires:
      [0] GATHER
    ── Entry #2 ────────────────────────────── BEST
    Cost: 54,120,000,237.84
    Properties: GATHER
    Expression ID: 122#3
    ChildrenRequires:
      [0] GATHER
  struct info map
StructInfoMap{ groupExpressionMapByRelationId=[], infoMapByRelationId=[], groupExpressionMapByTableId=[{0}], infoMapByTableId=[{0}], refreshVersion={{0}=84696351}}
═══════════════════════════════════════════════════════════

Group[@4]
  Logical Expressions:
    [1] id:94#4 | cost=null | estRows=1 | children=[@3] | LogicalProject[95] ( distinct=false, projects=[sum((((((((((((((((((((((((((((((((((((((((((((((((((cast(coalesce(length(cast(element_at(message, 'accessTime') as TEXT)), 0) as BIGINT) + cast(coalesce(length(cast(element_at(message, 'anomalyType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browser') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserFingerprint') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserVersion') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'cdnNode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'clientType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'companyId') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceBrand') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceModel') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceNo') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dnsCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dw_keyword') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'httpStatusCode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'mainDomain') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'totalCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'url') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey000') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey001') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey002') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey003') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey004') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey005') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey006') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey007') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey008') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey009') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey010') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey011') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey012') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey013') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey014') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey015') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey016') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey017') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey018') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey019') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey020') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey021') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey022') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey023') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey024') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey025') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey026') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey027') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey028') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey029') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey030') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey031') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey032') as TEXT)), 0) as BIGINT)))#12 AS `total_value_bytes`#10] )
  Physical Expressions:
    [1] id:107#4 | cost=0 [cpu=0, mem=0, net=0] | estRows=-1 | children=[@3] | PhysicalProject[108]@4 ( stats=null, projects=[sum((((((((((((((((((((((((((((((((((((((((((((((((((cast(coalesce(length(cast(element_at(message, 'accessTime') as TEXT)), 0) as BIGINT) + cast(coalesce(length(cast(element_at(message, 'anomalyType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browser') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserFingerprint') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserVersion') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'cdnNode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'clientType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'companyId') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceBrand') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceModel') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceNo') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dnsCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dw_keyword') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'httpStatusCode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'mainDomain') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'totalCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'url') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey000') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey001') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey002') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey003') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey004') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey005') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey006') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey007') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey008') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey009') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey010') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey011') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey012') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey013') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey014') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey015') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey016') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey017') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey018') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey019') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey020') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey021') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey022') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey023') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey024') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey025') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey026') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey027') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey028') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey029') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey030') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey031') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey032') as TEXT)), 0) as BIGINT)))#12 AS `total_value_bytes`#10] )
  Enforcers:
    (none)
  Chosen Expression ID: 107
  Chosen Properties: GATHER
  Statistics
    rows=1.0
    tupleSize=8.0
    width=1
    total_value_bytes#10 -> unknown(1.0)
  Lowest Plan
    ── Entry #1 ──────────────────────────────
    Cost: 54,120,000,237.84
    Properties: ANY
    Expression ID: 107#4
    ChildrenRequires:
      [0] GATHER
    ── Entry #2 ────────────────────────────── BEST
    Cost: 54,120,000,237.84
    Properties: GATHER
    Expression ID: 107#4
    ChildrenRequires:
      [0] GATHER
  struct info map
StructInfoMap{ groupExpressionMapByRelationId=[], infoMapByRelationId=[], groupExpressionMapByTableId=[{0}], infoMapByTableId=[{0}], refreshVersion={{0}=84696351}}
═══════════════════════════════════════════════════════════

ROOT Group[@5]
  Logical Expressions:
    [1] id:97#5 | cost=null | estRows=1 | children=[@4] | LogicalResultSink[98] ( outputExprs=[total_value_bytes#10] )
  Physical Expressions:
    [1] id:102#5 | cost=0 [cpu=0, mem=0, net=0] | estRows=-1 | children=[@4] | PhysicalResultSink[103] ( outputExprs=[total_value_bytes#10] )
  Enforcers:
    (none)
  Chosen Expression ID: 102
  Chosen Properties: GATHER
  Statistics
    rows=1.0
    tupleSize=8.0
    width=1
    total_value_bytes#10 -> unknown(1.0)
  Lowest Plan
    ── Entry #1 ──────────────────────────────
    Cost: 54,120,000,237.84
    Properties: ANY
    Expression ID: 102#5
    ChildrenRequires:
      [0] GATHER
    ── Entry #2 ────────────────────────────── BEST
    Cost: 54,120,000,237.84
    Properties: GATHER
    Expression ID: 102#5
    ChildrenRequires:
      [0] GATHER
  struct info map
StructInfoMap{ groupExpressionMapByRelationId=[], infoMapByRelationId=[], groupExpressionMapByTableId=[], infoMapByTableId=[], refreshVersion={}}
═══════════════════════════════════════════════════════════

Group[@6]
  Logical Expressions:
    (none)
  Physical Expressions:
    [1] id:119#6 | cost=120,000,000 [cpu=60,000,000, mem=60,000,000, net=0] | estRows=1 | children=[@2] | PhysicalHashAggregate[120]@6 ( stats=null, aggPhase=LOCAL, aggMode=INPUT_TO_BUFFER, maybeUseStreaming=false, groupByExpr=[], outputExpr=[partial_sum((((((((((((((((((((((((((((((((((((((((((((((((((cast(coalesce(length(cast(element_at(message, 'accessTime') as TEXT)), 0) as BIGINT) + cast(coalesce(length(cast(element_at(message, 'anomalyType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browser') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserFingerprint') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserVersion') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'cdnNode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'clientType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'companyId') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceBrand') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceModel') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceNo') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dnsCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dw_keyword') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'httpStatusCode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'mainDomain') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'totalCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'url') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey000') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey001') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey002') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey003') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey004') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey005') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey006') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey007') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey008') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey009') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey010') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey011') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey012') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey013') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey014') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey015') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey016') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey017') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey018') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey019') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey020') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey021') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey022') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey023') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey024') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey025') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey026') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey027') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey028') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey029') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey030') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey031') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey032') as TEXT)), 0) as BIGINT))#11) AS `partial_sum((((((((((((((((((((((((((((((((((((((((((((((((((cast(coalesce(length(cast(element_at(message, 'accessTime') as TEXT)), 0) as BIGINT) + cast(coalesce(length(cast(element_at(message, 'anomalyType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browser') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserFingerprint') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserVersion') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'cdnNode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'clientType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'companyId') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceBrand') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceModel') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceNo') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dnsCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dw_keyword') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'httpStatusCode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'mainDomain') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'totalCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'url') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey000') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey001') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey002') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey003') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey004') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey005') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey006') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey007') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey008') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey009') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey010') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey011') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey012') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey013') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey014') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey015') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey016') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey017') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey018') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey019') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey020') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey021') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey022') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey023') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey024') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey025') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey026') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey027') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey028') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey029') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey030') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey031') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey032') as TEXT)), 0) as BIGINT)))`#13], partitionExpr=Optional.empty, topnFilter=false, topnPushDown=false )
  Enforcers:
    [1] id:147#6 | cost=0.01 [cpu=0, mem=0, net=0.01] | estRows=1 | children=[@6] | PhysicalDistribute[148]@6 ( stats=null, distributionSpec=DistributionSpecGather )
  Chosen Enforcer(ID, RequiredProperties):
      (0)147,  GATHER
  Chosen Expression ID: 119
  Chosen Properties: DistributionSpecStorageAny Order: ([])
  Statistics
    rows=1.0
    tupleSize=8.0
    width=1
    partial_sum((((((((((((((((((((((((((((((((((((((((((((((((((cast(coalesce(length(cast(element_at(message, 'accessTime') as TEXT)), 0) as BIGINT) + cast(coalesce(length(cast(element_at(message, 'anomalyType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browser') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserFingerprint') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserVersion') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'cdnNode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'clientType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'companyId') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceBrand') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceModel') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceNo') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dnsCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dw_keyword') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'httpStatusCode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'mainDomain') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'totalCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'url') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey000') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey001') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey002') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey003') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey004') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey005') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey006') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey007') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey008') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey009') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey010') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey011') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey012') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey013') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey014') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey015') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey016') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey017') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey018') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey019') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey020') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey021') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey022') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey023') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey024') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey025') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey026') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey027') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey028') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey029') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey030') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey031') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey032') as TEXT)), 0) as BIGINT)))#13 -> unknown(1.0)
  Lowest Plan
    ── Entry #1 ──────────────────────────────
    Cost: 54,120,000,235.8
    Properties: ANY
    Expression ID: 119#6
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
    ── Entry #2 ────────────────────────────── BEST
    Cost: 54,120,000,235.8
    Properties: DistributionSpecStorageAny Order: ([])
    Expression ID: 119#6
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
    ── Entry #3 ────────────────────────────── BEST
    Cost: 54,120,000,235.82
    Properties: GATHER
    Expression ID: 147#6
    ChildrenRequires:
      [0] DistributionSpecStorageAny Order: ([])
  struct info map
StructInfoMap{ groupExpressionMapByRelationId=[], infoMapByRelationId=[], groupExpressionMapByTableId=[], infoMapByTableId=[], refreshVersion={}}

========== OPTIMIZED PLAN ==========
PhysicalResultSink[230] ( outputExprs=[total_value_bytes#10] )
+--PhysicalProject[226]@4 ( stats=1, projects=[sum((((((((((((((((((((((((((((((((((((((((((((((((((cast(coalesce(length(cast(element_at(message, 'accessTime') as TEXT)), 0) as BIGINT) + cast(coalesce(length(cast(element_at(message, 'anomalyType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browser') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserFingerprint') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserVersion') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'cdnNode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'clientType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'companyId') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceBrand') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceModel') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceNo') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dnsCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dw_keyword') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'httpStatusCode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'mainDomain') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'totalCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'url') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey000') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey001') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey002') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey003') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey004') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey005') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey006') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey007') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey008') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey009') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey010') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey011') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey012') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey013') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey014') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey015') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey016') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey017') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey018') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey019') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey020') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey021') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey022') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey023') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey024') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey025') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey026') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey027') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey028') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey029') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey030') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey031') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey032') as TEXT)), 0) as BIGINT)))#12 AS `total_value_bytes`#10] )
   +--PhysicalHashAggregate[222]@3 ( stats=1, aggPhase=GLOBAL, aggMode=BUFFER_TO_RESULT, maybeUseStreaming=false, groupByExpr=[], outputExpr=[sum(partial_sum((((((((((((((((((((((((((((((((((((((((((((((((((cast(coalesce(length(cast(element_at(message, 'accessTime') as TEXT)), 0) as BIGINT) + cast(coalesce(length(cast(element_at(message, 'anomalyType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browser') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserFingerprint') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserVersion') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'cdnNode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'clientType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'companyId') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceBrand') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceModel') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceNo') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dnsCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dw_keyword') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'httpStatusCode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'mainDomain') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'totalCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'url') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey000') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey001') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey002') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey003') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey004') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey005') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey006') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey007') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey008') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey009') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey010') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey011') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey012') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey013') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey014') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey015') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey016') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey017') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey018') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey019') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey020') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey021') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey022') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey023') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey024') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey025') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey026') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey027') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey028') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey029') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey030') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey031') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey032') as TEXT)), 0) as BIGINT)))#13) AS `sum((((((((((((((((((((((((((((((((((((((((((((((((((cast(coalesce(length(cast(element_at(message, 'accessTime') as TEXT)), 0) as BIGINT) + cast(coalesce(length(cast(element_at(message, 'anomalyType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browser') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserFingerprint') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserVersion') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'cdnNode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'clientType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'companyId') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceBrand') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceModel') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceNo') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dnsCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dw_keyword') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'httpStatusCode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'mainDomain') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'totalCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'url') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey000') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey001') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey002') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey003') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey004') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey005') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey006') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey007') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey008') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey009') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey010') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey011') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey012') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey013') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey014') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey015') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey016') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey017') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey018') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey019') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey020') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey021') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey022') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey023') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey024') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey025') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey026') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey027') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey028') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey029') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey030') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey031') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey032') as TEXT)), 0) as BIGINT)))`#12], partitionExpr=Optional.empty, topnFilter=false, topnPushDown=false )
      +--PhysicalDistribute[218]@6 ( stats=1, distributionSpec=DistributionSpecGather )
         +--PhysicalHashAggregate[214]@6 ( stats=1, aggPhase=LOCAL, aggMode=INPUT_TO_BUFFER, maybeUseStreaming=false, groupByExpr=[], outputExpr=[partial_sum((((((((((((((((((((((((((((((((((((((((((((((((((cast(coalesce(length(cast(element_at(message, 'accessTime') as TEXT)), 0) as BIGINT) + cast(coalesce(length(cast(element_at(message, 'anomalyType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browser') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserFingerprint') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserVersion') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'cdnNode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'clientType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'companyId') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceBrand') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceModel') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceNo') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dnsCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dw_keyword') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'httpStatusCode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'mainDomain') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'totalCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'url') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey000') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey001') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey002') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey003') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey004') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey005') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey006') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey007') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey008') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey009') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey010') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey011') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey012') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey013') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey014') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey015') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey016') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey017') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey018') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey019') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey020') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey021') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey022') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey023') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey024') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey025') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey026') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey027') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey028') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey029') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey030') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey031') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey032') as TEXT)), 0) as BIGINT))#11) AS `partial_sum((((((((((((((((((((((((((((((((((((((((((((((((((cast(coalesce(length(cast(element_at(message, 'accessTime') as TEXT)), 0) as BIGINT) + cast(coalesce(length(cast(element_at(message, 'anomalyType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browser') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserFingerprint') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserVersion') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'cdnNode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'clientType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'companyId') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceBrand') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceModel') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceNo') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dnsCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dw_keyword') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'httpStatusCode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'mainDomain') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'totalCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'url') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey000') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey001') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey002') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey003') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey004') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey005') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey006') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey007') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey008') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey009') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey010') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey011') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey012') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey013') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey014') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey015') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey016') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey017') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey018') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey019') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey020') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey021') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey022') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey023') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey024') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey025') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey026') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey027') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey028') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey029') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey030') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey031') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey032') as TEXT)), 0) as BIGINT)))`#13], partitionExpr=Optional.empty, topnFilter=false, topnPushDown=false )
            +--PhysicalProject[210]@2 ( stats=180,000,000, projects=[(((((((((((((((((((((((((((((((((((((((((((((((((cast(coalesce(length(cast(element_at(message#7, 'accessTime') as TEXT)), 0) as BIGINT) + cast(coalesce(length(cast(element_at(message#7, 'anomalyType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'browser') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'browserFingerprint') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'browserVersion') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'cdnNode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'clientType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'companyId') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'deviceBrand') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'deviceModel') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'deviceNo') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'dnsCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'dw_keyword') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'httpStatusCode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'mainDomain') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'totalCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'url') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey000') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey001') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey002') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey003') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey004') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey005') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey006') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey007') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey008') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey009') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey010') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey011') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey012') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey013') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey014') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey015') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey016') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey017') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey018') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey019') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey020') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey021') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey022') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey023') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey024') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey025') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey026') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey027') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey028') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey029') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey030') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey031') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message#7, 'extraKey032') as TEXT)), 0) as BIGINT)) AS `(((((((((((((((((((((((((((((((((((((((((((((((((cast(coalesce(length(cast(element_at(message, 'accessTime') as TEXT)), 0) as BIGINT) + cast(coalesce(length(cast(element_at(message, 'anomalyType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browser') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserFingerprint') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserVersion') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'cdnNode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'clientType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'companyId') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceBrand') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceModel') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceNo') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dnsCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dw_keyword') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'httpStatusCode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'mainDomain') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'totalCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'url') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey000') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey001') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey002') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey003') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey004') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey005') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey006') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey007') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey008') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey009') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey010') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey011') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey012') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey013') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey014') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey015') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey016') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey017') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey018') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey019') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey020') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey021') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey022') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey023') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey024') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey025') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey026') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey027') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey028') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey029') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey030') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey031') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey032') as TEXT)), 0) as BIGINT))`#11] )
               +--PhysicalFilter[206]@1 ( stats=180,000,000, predicates=(event_date#0 = 2026-06-15) )
                  +--PhysicalFileScan[202]@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] )

========== 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] ), Query function roll up fail:queryExpression = sum((((((((((((((((((((((((((((((((((((((((((((((((((cast(coalesce(length(cast(element_at(message, 'accessTime') as TEXT)), 0) as BIGINT) + cast(coalesce(length(cast(element_at(message, 'anomalyType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browser') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserFingerprint') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'browserVersion') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'cdnNode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'clientType') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'companyId') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceBrand') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceModel') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'deviceNo') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dnsCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'dw_keyword') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'httpStatusCode') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'mainDomain') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'totalCostMs') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'url') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey000') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey001') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey002') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey003') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey004') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey005') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey006') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey007') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey008') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey009') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey010') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey011') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey012') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey013') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey014') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey015') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey016') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey017') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey018') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey019') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey020') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey021') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey022') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey023') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey024') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey025') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey026') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey027') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey028') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey029') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey030') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey031') as TEXT)), 0) as BIGINT)) + cast(coalesce(length(cast(element_at(message, 'extraKey032') as TEXT)), 0) as BIGINT)))#12,
 mvExprToMvScanExprQueryBased = {event_date#0=event_date#14, cast(element_at(message#7, 'mainDomain') as TEXT)=main_domain#16, cast(element_at(message#7, 'anomalyType') as TEXT)=anomaly_type#17, count(*)=visit_count#18, sum(if(( not (cast(element_at(message#7, 'anomalyType') as TEXT) = 'normal')), 1, 0))=anomaly_count#19, date_trunc(event_time#1, 'hour')=event_hour#15}, Query function roll up fail:queryExpression = total_value_bytes#10,
 mvExprToMvScanExprQueryBased = {event_date#0=event_date#14, cast(element_at(message#7, 'mainDomain') as TEXT)=main_domain#16, cast(element_at(message#7, 'anomalyType') as TEXT)=anomaly_type#17, count(*)=visit_count#18, sum(if(( not (cast(element_at(message#7, 'anomalyType') as TEXT) = 'normal')), 1, 0))=anomaly_count#19, date_trunc(event_time#1, 'hour')=event_hour#15}
