[
https://issues.apache.org/jira/browse/HIVE-29080?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Indhumathi Muthumurugesh updated HIVE-29080:
--------------------------------------------
Description:
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
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
was:
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
> 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
>
> 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)
