[
https://issues.apache.org/jira/browse/HIVE-29080?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Indhumathi Muthumurugesh updated HIVE-29080:
--------------------------------------------
Summary: Query on Decimal column Partitioned table gives incorrect results
with Vectorization ON (was: Join Query on Decimal column Partitioned table
gives incorrect results with Vectorization ON)
> Query on Decimal column Partitioned table gives incorrect results with
> Vectorization ON
> ---------------------------------------------------------------------------------------
>
> Key: HIVE-29080
> URL: https://issues.apache.org/jira/browse/HIVE-29080
> Project: Hive
> Issue Type: Bug
> Reporter: Indhumathi Muthumurugesh
> Assignee: Indhumathi Muthumurugesh
> Priority: Major
>
> DROP TABLE IF EXISTS decimal_part;
> CREATE EXTERNAL TABLE decimal_part (quantity INT) PARTITIONED BY
> (sales_percent DECIMAL(10,2)) STORED AS ORC;
> INSERT INTO decimal_part PARTITION (sales_percent) VALUES (1, 24518.01);
>
> SELECT d1.quantity FROM decimal_part d1 JOIN decimal_part d2 ON
> d1.sales_percent=d2.sales_percent;
>
> with hive.vectorized.execution.enabled=true, --> output: empty results
> with hive.vectorized.execution.enabled=false, --> output: 1
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
