Jesus Camacho Rodriguez created HIVE-22978:
----------------------------------------------
Summary: Fix decimal precision and scale inference for aggregate
rewriting in Calcite
Key: HIVE-22978
URL: https://issues.apache.org/jira/browse/HIVE-22978
Project: Hive
Issue Type: Bug
Components: CBO
Reporter: Jesus Camacho Rodriguez
Assignee: Jesus Camacho Rodriguez
Calcite rules can do rewritings of aggregate functions, e.g., {{avg}} into
{{sum/count}}. When type of {{avg}} is decimal, inference of intermediate
precision and scale for the division is not done correctly. The reason is that
we miss support for some types in method {{getDefaultPrecision}} in
{{HiveTypeSystemImpl}}. Additionally, {{deriveSumType}} should be overridden in
{{HiveTypeSystemImpl}} to abide by the Hive semantics for sum aggregate type
inference.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
