You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Denys Kuzmenko (Jira)" <ji...@apache.org> on 2025/07/12 18:56:00 UTC
[jira] [Commented] (HIVE-29080) Query on Decimal column Partitioned table gives incorrect results with Vectorization ON
[ 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)