[
https://issues.apache.org/jira/browse/DRILL-460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau resolved DRILL-460.
----------------------------------
Resolution: Fixed
Assignee: Jacques Nadeau
Should be fixed as part of 129cd77
> Unsupported errors for aggregate functions
> ------------------------------------------
>
> Key: DRILL-460
> URL: https://issues.apache.org/jira/browse/DRILL-460
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Neeraja
> Assignee: Jacques Nadeau
>
> Seeing following errors with using aggregates on Hive tables.
> 1.select l_returnflag, sum(l_quantity) from lineitem group by l_returnflag
> order by l_returnflag;
> message: "Failure while running fragment. < UnsupportedOperationException:[
> Missing function implementation: [sum(FLOAT8-REQUIRED)] ]"
> 2. select l_returnflag,l_linestatus,min(l_quantity), count(*) from lineitem
> group by l_returnflag, l_linestatus order by l_returnflag,l_linestatus;
> message: "Failure while parsing sql. < ExpressionParsingException:[ Unable to
> find function definition for function named \'min\' ]"
> 3. select l_returnflag,l_linestatus,avg(l_quantity),min(l_quantity), count(*)
> from lineitem group by l_returnflag, l_linestatus order by
> l_returnflag,l_linestatus;
> message: "Failure while parsing sql. < ExpressionParsingException:[ Unable to
> find function definition for function named \'avg\' ]"
--
This message was sent by Atlassian JIRA
(v6.2#6252)
