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

Posted to issues@hive.apache.org by "Stamatis Zampetakis (Jira)" <ji...@apache.org> on 2026/01/13 12:53:00 UTC

[jira] [Resolved] (HIVE-29399) Remove SqlSyntax.FUNCTION_STAR from AVG and SUM functions

     [ https://issues.apache.org/jira/browse/HIVE-29399?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Stamatis Zampetakis resolved HIVE-29399.
----------------------------------------
    Fix Version/s: 4.3.0
       Resolution: Fixed

Fixed in https://github.com/apache/hive/commit/9e7f289d7738d6308b15d676aaf81b3e99eb01d0

> Remove SqlSyntax.FUNCTION_STAR from AVG and SUM functions
> ---------------------------------------------------------
>
>                 Key: HIVE-29399
>                 URL: https://issues.apache.org/jira/browse/HIVE-29399
>             Project: Hive
>          Issue Type: Task
>            Reporter: Stamatis Zampetakis
>            Assignee: Stamatis Zampetakis
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 4.3.0
>
>
> The AVG (HiveSqlAverageAggFunction) and SUM (HiveSqlSumAggFunction) functions don't support the special FUNCTION_STAR syntax and trying to write queries including AVG(\*) or SUM(\*) currently fail (see invalid_avg_syntax.q, invalid_sum_syntax.q tests).
> The SqlSyntax.FUNCTION_STAR syntax for SUM/AVG was incorrectly set by HIVE-29339 so this ticket is a follow-up to restore the previous and correct behavior.



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