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

["Chun Chang (JIRA)" <ji...@apache.org>]

Chun Chang created DRILL-920:
--------------------------------

             Summary: 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: Query Planning & Optimization
            Reporter: Chun Chang


#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)