[jira] [Updated] (DRILL-920) var_samp(decimal38) cause internal assertion error

["Jacques Nadeau (JIRA)" <ji...@apache.org>]

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

Jacques Nadeau updated DRILL-920:
---------------------------------
    Issue Type: New Feature  (was: Bug)

> var_samp(decimal38) cause internal assertion error
> --------------------------------------------------
>
>                 Key: DRILL-920
>                 URL: https://issues.apache.org/jira/browse/DRILL-920
>             Project: Apache Drill
>          Issue Type: New Feature
>          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.3.4#6332)