Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Duplicate
-
2.1.1, 3.0.0
-
None
-
None
Description
This is relatively easier than the other AVG() implementations, since the operation accepts and returns primitive data types.
See https://github.com/hortonworks/hive-testbench/blob/hive14/sample-queries-tpcds/query65.sql
as an example where the AVG() is used in COMPLETE mode.