[
https://issues.apache.org/jira/browse/DRILL-460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13948943#comment-13948943
]
Neeraja commented on DRILL-460:
-------------------------------
Got the new build and some of these functions started working.
Facing a different issue with one of the aggregates. I can file a separate JIRA
if needed.
0: jdbc:drill:> select l_returnflag,avg(l_quantity) from lineitem group by
l_returnflag order by l_returnflag;
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while
running query.[error_id: "e4ca061a-275f-4f2c-9b4f-0cf1e2c87827"
endpoint {
address: "ubuntu"
user_port: 31013
control_port: 31014
data_port: 31015
}
error_type: 0
message: "Failure while running fragment. < ArithmeticException:[ / by zero ]"
]
Error: exception while executing query (state=,code=0)
> 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)
