Quanlong Huang created IMPALA-15751:
---------------------------------------

             Summary: Analytic evaluation could introduce unused partition slots
                 Key: IMPALA-15751
                 URL: https://issues.apache.org/jira/browse/IMPALA-15751
             Project: IMPALA
          Issue Type: Bug
          Components: Frontend
            Reporter: Quanlong Huang
            Assignee: Quanlong Huang


TestHBO.test_agg_over_analytic_cardinality fails in calcite-planner builds due 
to different row-size:
{noformat}
Expected (Original Planner):                                  Actual (Calcite 
Planner):
PLAN-ROOT SINK                                                PLAN-ROOT SINK
|                                                             |   
03:AGGREGATE [FINALIZE]                                       03:AGGREGATE 
[FINALIZE]
|  output: count(*)                                           |  output: count()
|  group by: rank() % 10                                      |  group by: 
mod(rank(), 10) 
|  row-size=16B cardinality=10 (from HBO)                     |  row-size=16B 
cardinality=10 (from HBO)
|                                                             |   
02:ANALYTIC                                                   02:ANALYTIC
|  functions: rank()                                          |  functions: 
rank()
|  order by: id ASC                                           |  order by: id 
ASC 
|  window: RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW  |  window: RANGE 
BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW 
|  row-size=29B cardinality=620                               |  row-size=25B 
cardinality=620
|                                                             |   
04:MERGING-EXCHANGE [UNPARTITIONED]                           
04:MERGING-EXCHANGE [UNPARTITIONED]
|  order by: id ASC                                           |  order by: id 
ASC NULLS LAST
|                                                             |   
01:SORT                                                       01:SORT
|  order by: id ASC                                           |  order by: id 
ASC NULLS LAST
|  row-size=21B cardinality=620                               |  row-size=17B 
cardinality=620
|                                                             |   
00:SCAN HDFS [functional.alltypes]                            00:SCAN HDFS 
[functional.alltypes]
   partition predicates: `month` = 1                             partition 
predicates: functional.alltypes.month = 1 
   HDFS partitions=2/24 files=2 size=40.32KB                     HDFS 
partitions=2/24 files=2 size=40.32KB
   predicates: string_col != 'test_agg_over_analytic'            predicates: 
functional.alltypes.string_col != 'test_agg_over_analytic'
   row-size=21B cardinality=620 (from HBO)                       row-size=17B 
cardinality=620 (from HBO){noformat}

test_join_over_analytic_cardinality also suffers from the same issue but the 
plans are also different.



--
This message was sent by Atlassian Jira
(v10.3.26#10030026)

Reply via email to