[ https://issues.apache.org/jira/browse/DRILL-920?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Volodymyr Vysotskyi resolved DRILL-920. --------------------------------------- Resolution: Fixed Fixed in the scope of DRILL-6094 > 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: Volodymyr Vysotskyi > Priority: Major > 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 (v7.6.3#76005)