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)
