[jira] [Created] (HIVE-29080) Join Query on Decimal column Partitioned table gives incorrect results with Vectorization ON

Wed, 09 Jul 2025 02:18:04 -0700 

Indhumathi Muthumurugesh created HIVE-29080:
-----------------------------------------------

             Summary: Join 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


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)

Reply via email to