Steve Carlin created IMPALA-14814:
-------------------------------------
Summary: Calcite planner: orc stats predicate not created due to
decimal cast
Key: IMPALA-14814
URL: https://issues.apache.org/jira/browse/IMPALA-14814
Project: IMPALA
Issue Type: Sub-task
Reporter: Steve Carlin
In orc-stats.test for the following query:
select count(*) from functional_orc_def.decimal_tbl where d1 > 132842.0;
The orc statistics predicate is not getting created in the Calcite Planner.
This is because the predicate is finding a common type for the filter
condition, which is:
CAST(functional_orc_def.decimal_tbl.d1 AS DECIMAL(10,1)) > CAST(132842.0 AS
DECIMAL(10,1))
d1 is a (9,0)
In the original planner, no casting is done, so the orc stats predicate gets
created:
d1 > CAST(132842.0 AS DECIMAL(7,1))
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
