drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chun Chang (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-920) var_samp(decimal38) cause internal assertion error
Date Fri, 06 Jun 2014 00:22:01 GMT
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

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:
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

View raw message