[
https://issues.apache.org/jira/browse/HIVE-29080?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18004894#comment-18004894
]
Denys Kuzmenko commented on HIVE-29080:
---------------------------------------
Thanks [~Indhumathi27] for the fix!
> 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
> Components: Vectorization
> Affects Versions: 4.0.0, 4.0.1
> Reporter: Indhumathi Muthumurugesh
> Assignee: Indhumathi Muthumurugesh
> Priority: Major
> Labels: hive-4.1.0-must, pull-request-available
> Fix For: 4.1.0, 4.2.0
>
>
> 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);
> INSERT INTO decimal_part PARTITION (sales_percent) VALUES (2, 24518.02);
>
> 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,2
>
> SELECT count(*), sales_percent FROM decimal_part1 GROUP BY sales_percent;
> with hive.vectorized.execution.enabled=true, -->
> 2 245.18
> with hive.vectorized.execution.enabled=false, -->
> 1 24518.02
> 1 24518.01
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
