You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "okumin (Jira)" <ji...@apache.org> on 2024/02/20 03:01:00 UTC

[jira] [Created] (HIVE-28082) HiveAggregateReduceFunctionsRule could generate an inconsistent result

okumin created HIVE-28082:
-----------------------------

             Summary: HiveAggregateReduceFunctionsRule could generate an inconsistent result
                 Key: HIVE-28082
                 URL: https://issues.apache.org/jira/browse/HIVE-28082
             Project: Hive
          Issue Type: Bug
          Components: CBO
    Affects Versions: 4.0.0-beta-1
            Reporter: okumin
            Assignee: okumin


HiveAggregateReduceFunctionsRule translates AVG, STDDEV_POP, STDDEV_SAMP, VAR_POP, and VAR_SAMP. Those UDFs accept string types and try to decode them as floating point values. It is possible that undecodable values exist.

We found that it could cause inconsistent behaviors with or without CBO.
{code:java}
0: jdbc:hive2://hive-hiveserver2:10000/defaul> SELECT AVG('text');
...
+------+
| _c0  |
+------+
| 0.0  |
+------+
1 row selected (18.229 seconds)
0: jdbc:hive2://hive-hiveserver2:10000/defaul> set hive.cbo.enable=false;
No rows affected (0.013 seconds)
0: jdbc:hive2://hive-hiveserver2:10000/defaul> SELECT AVG('text');
...
+-------+
|  _c0  |
+-------+
| NULL  |
+-------+ {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)