drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-920) var_samp(decimal38) cause internal assertion error
Date Wed, 02 Jul 2014 01:53:27 GMT

    [ https://issues.apache.org/jira/browse/DRILL-920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14049525#comment-14049525
] 

Jacques Nadeau commented on DRILL-920:
--------------------------------------

These are inexact functions against exact datatypes.  Will provide implicit cast from decimal
to double later.  For now, if you need this functionality you should use [funcname](cast x
as double) to explicitly cast your input.

> var_samp(decimal38) cause internal assertion error
> --------------------------------------------------
>
>                 Key: DRILL-920
>                 URL: https://issues.apache.org/jira/browse/DRILL-920
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Functions - Drill
>            Reporter: Chun Chang
>            Assignee: Mehant Baid
>             Fix For: Future
>
>
> #Mon Jun 02 10:18:35 PDT 2014
> git.commit.id.abbrev=8490d74
> The following query caused the internal assertion while applying rule reduce aggregate
rule. Note, it complains type mismatch, inferred type decimal(19,19)???
> 0: jdbc:drill:schema=dfs> select var_samp(cast(c_decimal38 as decimal(38,18))) from
data where c_row < 15;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id:
"beb1c5ab-6132-416c-a45d-49a20af8d416"
> endpoint {
>   address: "qa-node117.qa.lab"
>   user_port: 31010
>   control_port: 31011
>   data_port: 31012
> }
> error_type: 0
> message: "Failure while setting up Foreman. < AssertionError:[ Internal error: Error
while applying rule ReduceAggregatesRule, args [rel#28051:AggregateRel.NONE.ANY([]).[](child=rel#28050:Subset#2.NONE.ANY([]).[],group={},EXPR$0=VAR_SAMP($0))]
] < AssertionError:[ type mismatch:
> aggCall type:
> DECIMAL(38, 18)
> inferred type:
> DECIMAL(19, 19) ]"
> ]
> Error: exception while executing query (state=,code=0)



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message