Neeraja created DRILL-460:
-----------------------------
Summary: 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
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)
