Skip to content

[Enhancement] support extract common SPJG plan as cte #26211

[Enhancement] support extract common SPJG plan as cte

[Enhancement] support extract common SPJG plan as cte #26211

Triggered via pull request October 18, 2024 12:47
@SeavenSeaven
synchronize #51808
Status Success
Total duration 22s
Artifacts

ci-proto-checker.yml

on: pull_request_target
PROTO FILTER
2s
PROTO FILTER
ADD PROTO REVIEW LABEL
4s
ADD PROTO REVIEW LABEL
Fit to window
Zoom out
Zoom in

Annotations

7 errors and 3 warnings
ADD PROTO REVIEW LABEL
Error: failed to remove labels: PROTO-REVIEW
TestSQLCases.test_feedback: TestSQLCases#L1
False is not true : assert expect RightChildEstimationErrorTuningGuide is not found in plan (('PLAN FRAGMENT 0',), (' OUTPUT EXPRS:9: count',), (' PARTITION: UNPARTITIONED',), ('',), (' RESULT SINK',), ('',), (' 9:AGGREGATE (merge finalize)',), (' | output: count(9: count)',), (' | group by: ',), (' | ',), (' 8:EXCHANGE',), ('',), ('PLAN FRAGMENT 1',), (' OUTPUT EXPRS:',), (' PARTITION: HASH_PARTITIONED: 3: c2',), ('',), (' STREAM DATA SINK',), (' EXCHANGE ID: 08',), (' UNPARTITIONED',), ('',), (' 7:AGGREGATE (update serialize)',), (' | output: count(*)',), (' | group by: ',), (' | ',), (' 6:Project',), (' | <slot 11> : 1',), (' | ',), (' 5:HASH JOIN',), (' | join op: INNER JOIN (PARTITIONED)',), (' | colocate: false, reason: ',), (' | equal join conjunct: 3: c2 = 7: c2',), (' | ',), (' |----4:EXCHANGE',), (' | ',), (' 1:EXCHANGE',), ('',), ('PLAN FRAGMENT 2',), (' OUTPUT EXPRS:',), (' PARTITION: RANDOM',), ('',), (' STREAM DATA SINK',), (' EXCHANGE ID: 04',), (' HASH_PARTITIONED: 7: c2',), ('',), (' 3:Project',), (' | <slot 7> : 7: c2',), (' | ',), (' 2:OlapScanNode',), (' TABLE: c1_skew',), (' PREAGGREGATION: ON',), (' VECTORINDEX: OFF',), (" PREDICATES: 7: c2 IS NOT NULL, 6: c1 = 'f'",), (' partitions=1/1',), (' rollup: c1_skew',), (' tabletRatio=5/5',), (' tabletList=30179,30181,30183,30185,30187',), (' cardinality=833',), (' avgRowSize=2.0000224',), ('',), ('PLAN FRAGMENT 3',), (' OUTPUT EXPRS:',), (' PARTITION: RANDOM',), ('',), (' STREAM DATA SINK',), (' EXCHANGE ID: 01',), (' HASH_PARTITIONED: 3: c2',), ('',), (' 0:OlapScanNode',), (' TABLE: c1_skew',), (' PREAGGREGATION: ON',), (' VECTORINDEX: OFF',), (' PREDICATES: 3: c2 IS NOT NULL',), (' partitions=1/1',), (' rollup: c1_skew',), (' tabletRatio=5/5',), (' tabletList=30179,30181,30183,30185,30187',), (' cardinality=5000',), (' avgRowSize=1.0000225',))
TestSQLCases.test_group_execution_join: TestSQLCases#L1
Element counts were not equal: First has 1, Second has 0: '99\t4950\t4950\t4950.0\t4950.0' First has 0, Second has 1: '40960\t838881280\t838881280\t838881280.0\t838881280.0' : sql result not match: - [SQL]: with agged_table as ( select distinct c0, c1,c3 from t0) select /*+SET_VAR(cbo_cte_reuse_rate=-1) */ count(*) ,sum(l.c0), sum(r.c0), sum(l.c1), sum(r.c1) from agged_table l join [bucket] agged_table r on l.c0 = r.c0 and l.c1 = r.c1 where r.c3 < 100; - [exp]: ['99\t4950\t4950\t4950.0\t4950.0'] - [act]: ['40960\t838881280\t838881280\t838881280.0\t838881280.0'] ---
TestSQLCases.test_phased_schedule: TestSQLCases#L1
Element counts were not equal: First has 1, Second has 0: '81921\t1677762560.0\t1677762560.0' First has 0, Second has 1: '81920\t1677762560.0\t1677762560.0' : sql result not match: - [SQL]: with agged_table as ( select distinct c0, c1 from t0) select /*+SET_VAR(cbo_cte_reuse_rate=-1) */ count(*), sum(c0),sum(c1) from (select * from agged_table union all select l.c1, l.c0 from agged_table l join t0 r on l.c0=r.c2) tb; - [exp]: ['81921\t1677762560.0\t1677762560.0'] - [act]: ['81920\t1677762560.0\t1677762560.0'] ---
TestSQLCases.test_transparent_mv_union_hive: TestSQLCases#L1
Element counts were not equal: First has 1, Second has 0: '2020-06-15\t4' First has 1, Second has 0: '2020-06-18\t5' First has 1, Second has 0: '2020-06-21\t7' First has 0, Second has 1: '' : sql result not match: - [SQL]: SELECT * FROM (SELECT dt, sum(num) as num FROM mv_hive_c9ea22f9df954db59e968880b53f277f.mv_hive_db_c9ea22f9df954db59e968880b53f277f.t1 GROUP BY dt having sum(num) > 10 UNION ALL SELECT dt, sum(num) as num FROM mv_hive_c9ea22f9df954db59e968880b53f277f.mv_hive_db_c9ea22f9df954db59e968880b53f277f.t1 GROUP BY dt) t order by 1, 2 limit 3; - [exp]: ['2020-06-15\t4', '2020-06-18\t5', '2020-06-21\t7'] - [act]: [''] ---
TestSQLCases.test_transparent_mv_union_iceberg: TestSQLCases#L1
Element counts were not equal: First has 1, Second has 0: '2020-06-15\t4' First has 1, Second has 0: '2020-06-18\t5' First has 1, Second has 0: '2020-06-21\t7' First has 0, Second has 1: '' : sql result not match: - [SQL]: SELECT * FROM (SELECT dt, sum(num) as num FROM mv_iceberg_9f456431dbad4fe890ae531bd40046bb.mv_iceberg_db_9f456431dbad4fe890ae531bd40046bb.t1 GROUP BY dt having sum(num) > 10 UNION ALL SELECT dt, sum(num) as num FROM mv_iceberg_9f456431dbad4fe890ae531bd40046bb.mv_iceberg_db_9f456431dbad4fe890ae531bd40046bb.t1 GROUP BY dt) t order by 1, 2 limit 3; - [exp]: ['2020-06-15\t4', '2020-06-18\t5', '2020-06-21\t7'] - [act]: [''] ---
TestSQLCases.test_transparent_mv_union_olap: TestSQLCases#L1
False is not true : assert expect test_mv1 is not found in plan
ADD PROTO REVIEW LABEL
The following actions uses node12 which is deprecated and will be forced to run on node16: actions-ecosystem/action-remove-labels@v1. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/
ADD PROTO REVIEW LABEL
The following actions use a deprecated Node.js version and will be forced to run on node20: actions-ecosystem/action-remove-labels@v1. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
ADD PROTO REVIEW LABEL
failed to remove label: PROTO-REVIEW: HttpError: Label does not exist