You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Chun Chang (JIRA)" <ji...@apache.org> on 2014/06/06 02:24:01 UTC
[jira] [Commented] (DRILL-920) var_samp(decimal38) cause internal
assertion error
[ https://issues.apache.org/jira/browse/DRILL-920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14019448#comment-14019448 ]
Chun Chang commented on DRILL-920:
----------------------------------
java.lang.AssertionError: type mismatch:
aggCall type:
DECIMAL(38, 18)
inferred type:
DECIMAL(19, 19)
org.eigenbase.relopt.RelOptUtil.eq(RelOptUtil.java:1467) ~[optiq-core-0.7-20140513.013236-5.jar:na]
org.eigenbase.rel.AggregateRelBase.typeMatchesInferred(AggregateRelBase.java:222) ~[optiq-core-0.7-20140513.013236-5.jar:na]
org.eigenbase.rel.AggregateRelBase.access$000(AggregateRelBase.java:41) ~[optiq-core-0.7-20140513.013236-5.jar:na]
org.eigenbase.rel.AggregateRelBase$2.get(AggregateRelBase.java:200) ~[optiq-core-0.7-20140513.013236-5.jar:na]
org.eigenbase.rel.AggregateRelBase$2.get(AggregateRelBase.java:187) ~[optiq-core-0.7-20140513.013236-5.jar:na]
org.eigenbase.util.CompositeList.get(CompositeList.java:114) ~[optiq-core-0.7-20140513.013236-5.jar:na]
org.eigenbase.reltype.RelDataTypeFactoryImpl$4.getFieldName(RelDataTypeFactoryImpl.java:174) ~[optiq-core-0.7-20140513.013236-5.jar:na]
org.eigenbase.reltype.RelDataTypeFactoryImpl$2.get(RelDataTypeFactoryImpl.java:143) ~[optiq-core-0.7-20140513.013236-5.jar:na]
org.eigenbase.reltype.RelDataTypeFactoryImpl$2.get(RelDataTypeFactoryImpl.java:140) ~[optiq-core-0.7-20140513.013236-5.jar:na]
java.util.AbstractList$Itr.next(AbstractList.java:358) ~[na:1.7.0_45]
java.util.AbstractList.hashCode(AbstractList.java:540) ~[na:1.7.0_45]
org.eigenbase.util.Util.hash(Util.java:225) ~[optiq-core-0.7-20140513.013236-5.jar:na]
org.eigenbase.util.Pair.hashCode(Pair.java:79) ~[optiq-core-0.7-20140513.013236-5.jar:na]
com.google.common.base.Equivalence$Equals.doHash(Equivalence.java:331) ~[guava-14.0.1.jar:na]
com.google.common.base.Equivalence.hash(Equivalence.java:104) ~[guava-14.0.1.jar:na]
com.google.common.cache.LocalCache.hash(LocalCache.java:1899) ~[guava-14.0.1.jar:na]
com.google.common.cache.LocalCache.getIfPresent(LocalCache.java:3988) ~[guava-14.0.1.jar:na]
com.google.common.cache.LocalCache$LocalManualCache.getIfPresent(LocalCache.java:4783) ~[guava-14.0.1.jar:na]
org.eigenbase.reltype.RelDataTypeFactoryImpl.canonize(RelDataTypeFactoryImpl.java:347) ~[optiq-core-0.7-20140513.013236-5.jar:na]
org.eigenbase.reltype.RelDataTypeFactoryImpl.createStructType(RelDataTypeFactoryImpl.java:139) ~[optiq-core-0.7-20140513.013236-5.jar:na]
org.eigenbase.reltype.RelDataTypeFactoryImpl.createStructType(RelDataTypeFactoryImpl.java:167) ~[optiq-core-0.7-20140513.013236-5.jar:na]
org.eigenbase.rel.AggregateRelBase.deriveRowType(AggregateRelBase.java:172) ~[optiq-core-0.7-20140513.013236-5.jar:na]
org.eigenbase.rel.AbstractRelNode.getRowType(AbstractRelNode.java:210) ~[optiq-core-0.7-20140513.013236-5.jar:na]
org.eigenbase.rel.CalcRel.createProject(CalcRel.java:142) ~[optiq-core-0.7-20140513.013236-5.jar:na]
org.eigenbase.rel.CalcRel.createProject(CalcRel.java:88) ~[optiq-core-0.7-20140513.013236-5.jar:na]
org.eigenbase.rel.rules.ReduceAggregatesRule.reduceAggs(ReduceAggregatesRule.java:138) ~[optiq-core-0.7-20140513.013236-5.jar:na]
org.eigenbase.rel.rules.ReduceAggregatesRule.onMatch(ReduceAggregatesRule.java:55) ~[optiq-core-0.7-20140513.013236-5.jar:na]
org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:221) ~[optiq-core-0.7-20140513.013236-5.jar:na]
org.eigenbase.relopt.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:653) ~[optiq-core-0.7-20140513.013236-5.jar:na]
net.hydromatic.optiq.prepare.PlannerImpl.transform(PlannerImpl.java:271) ~[optiq-core-0.7-20140513.013236-5.jar:na]
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:128) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:108) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:129) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:313) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:167) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_45]
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_45]
java.lang.Thread.run(Thread.java:744) [na:1.7.0_45]
> 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)