[ 
https://issues.apache.org/jira/browse/HIVE-29742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Ruben Q L updated HIVE-29742:
-----------------------------
    Description: 
Due to HIVE-29641 (Calcite upgrade 1.42) some queries in 
materialized_view_partitioned_2.q are choosing a sub-optimal plan 
({{partition_mv_2@value=...}}  instead of {{partition_mv_3}}), more info: 
https://github.com/apache/hive/pull/6523
This is due to a bug on Calcite side 
(https://issues.apache.org/jira/browse/CALCITE-7635), so after an eventual 
Calcite upgrade 1.43 (HIVE-29743) this test should go back to its original plan.

  was:
Due to HIVE-29641 (Calcite upgrade 1.42) some queries in 
materialized_view_partitioned_2.q are choosing a sub-optimal plan 
({{partition_mv_2@value=...}}  instead of {{partition_mv_3}}).
This is due to a bug on Calcite side (), so after an eventual Calcite upgrade 
1.43 this test should go back to its original plan.


> materialized_view_partitioned_2.q chooses the wrong partitioned MV
> ------------------------------------------------------------------
>
>                 Key: HIVE-29742
>                 URL: https://issues.apache.org/jira/browse/HIVE-29742
>             Project: Hive
>          Issue Type: Bug
>          Components: CBO
>            Reporter: Ruben Q L
>            Priority: Blocker
>             Fix For: 4.3.0
>
>
> Due to HIVE-29641 (Calcite upgrade 1.42) some queries in 
> materialized_view_partitioned_2.q are choosing a sub-optimal plan 
> ({{partition_mv_2@value=...}}  instead of {{partition_mv_3}}), more info: 
> https://github.com/apache/hive/pull/6523
> This is due to a bug on Calcite side 
> (https://issues.apache.org/jira/browse/CALCITE-7635), so after an eventual 
> Calcite upgrade 1.43 (HIVE-29743) this test should go back to its original 
> plan.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to