[
https://issues.apache.org/jira/browse/DRILL-6405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16471682#comment-16471682
]
Arina Ielchiieva commented on DRILL-6405:
-----------------------------------------
[~timothyfarkas] could you please describe what exactly the problem is? Which
test fail with exception?
> Boolean Cast Exceptions in Tests
> --------------------------------
>
> Key: DRILL-6405
> URL: https://issues.apache.org/jira/browse/DRILL-6405
> Project: Apache Drill
> Issue Type: Improvement
> Reporter: Timothy Farkas
> Assignee: Timothy Farkas
> Priority: Major
>
> 15:56:49.937 [250b31cd-e445-ddac-532d-d09cec14ff3c:foreman] ERROR
> o.a.drill.exec.work.foreman.Foreman - SYSTEM ERROR: IllegalArgumentException:
> Invalid value for boolean: A
> [Error Id: 03cbfc62-c929-4897-80ae-eda08c9427d7 on drillu4.qa.lab:31022]
> org.apache.drill.common.exceptions.UserException: SYSTEM ERROR:
> IllegalArgumentException: Invalid value for boolean: A
> [Error Id: 03cbfc62-c929-4897-80ae-eda08c9427d7 on drillu4.qa.lab:31022]
> at
> org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:633)
> ~[drill-common-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
> at
> org.apache.drill.exec.work.foreman.Foreman$ForemanResult.close(Foreman.java:761)
> [classes/:na]
> at
> org.apache.drill.exec.work.foreman.QueryStateProcessor.checkCommonStates(QueryStateProcessor.java:325)
> [classes/:na]
> at
> org.apache.drill.exec.work.foreman.QueryStateProcessor.planning(QueryStateProcessor.java:221)
> [classes/:na]
> at
> org.apache.drill.exec.work.foreman.QueryStateProcessor.moveToState(QueryStateProcessor.java:83)
> [classes/:na]
> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:281)
> [classes/:na]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> [na:1.8.0_161]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> [na:1.8.0_161]
> at java.lang.Thread.run(Thread.java:748) [na:1.8.0_161]
> Caused by: org.apache.drill.exec.work.foreman.ForemanException: Unexpected
> exception during fragment initialization: Error while applying rule
> ReduceExpressionsRule(Project), args
> [rel#177367:LogicalProject.NONE.ANY([]).[](input=rel#177366:Subset#0.NONE.ANY([]).[0],b_val=CAST('A'):BOOLEAN
> NOT NULL)]
> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:282)
> [classes/:na]
> ... 3 common frames omitted
> Caused by: java.lang.RuntimeException: Error while applying rule
> ReduceExpressionsRule(Project), args
> [rel#177367:LogicalProject.NONE.ANY([]).[](input=rel#177366:Subset#0.NONE.ANY([]).[0],b_val=CAST('A'):BOOLEAN
> NOT NULL)]
> at
> org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:236)
> ~[calcite-core-1.16.0-drill-r0.jar:1.16.0-drill-r0]
> at
> org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:652)
> ~[calcite-core-1.16.0-drill-r0.jar:1.16.0-drill-r0]
> at
> org.apache.calcite.tools.Programs$RuleSetProgram.run(Programs.java:368)
> ~[calcite-core-1.16.0-drill-r0.jar:1.16.0-drill-r0]
> at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform(DefaultSqlHandler.java:419)
> ~[classes/:na]
> at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform(DefaultSqlHandler.java:359)
> ~[classes/:na]
> at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToRawDrel(DefaultSqlHandler.java:258)
> ~[classes/:na]
> at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:308)
> ~[classes/:na]
> at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:178)
> ~[classes/:na]
> at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:145)
> ~[classes/:na]
> at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:83)
> ~[classes/:na]
> at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
> [classes/:na]
> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
> [classes/:na]
> ... 3 common frames omitted
> Caused by: java.lang.RuntimeException: Error in evaluating function of castBIT
> at
> org.apache.drill.exec.expr.fn.interpreter.InterpreterEvaluator$EvalVisitor.visitFunctionHolderExpression(InterpreterEvaluator.java:347)
> ~[classes/:na]
> at
> org.apache.drill.exec.expr.fn.interpreter.InterpreterEvaluator$EvalVisitor.visitFunctionHolderExpression(InterpreterEvaluator.java:194)
> ~[classes/:na]
> at
> org.apache.drill.common.expression.FunctionHolderExpression.accept(FunctionHolderExpression.java:53)
> ~[drill-logical-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
> at
> org.apache.drill.exec.expr.fn.interpreter.InterpreterEvaluator.evaluateConstantExpr(InterpreterEvaluator.java:69)
> ~[classes/:na]
> at
> org.apache.drill.exec.planner.logical.DrillConstExecutor.reduce(DrillConstExecutor.java:150)
> ~[classes/:na]
> at
> org.apache.calcite.rex.RexSimplify.simplifyCast(RexSimplify.java:949)
> ~[calcite-core-1.16.0-drill-r0.jar:1.16.0-drill-r0]
> at org.apache.calcite.rex.RexSimplify.simplify(RexSimplify.java:146)
> ~[calcite-core-1.16.0-drill-r0.jar:1.16.0-drill-r0]
> at
> org.apache.calcite.rex.RexUtil$ExprSimplifier.visitCall(RexUtil.java:2625)
> ~[calcite-core-1.16.0-drill-r0.jar:1.16.0-drill-r0]
> at
> org.apache.calcite.rex.RexUtil$ExprSimplifier.visitCall(RexUtil.java:2585)
> ~[calcite-core-1.16.0-drill-r0.jar:1.16.0-drill-r0]
> at org.apache.calcite.rex.RexCall.accept(RexCall.java:107)
> ~[calcite-core-1.16.0-drill-r0.jar:1.16.0-drill-r0]
> at org.apache.calcite.rex.RexShuttle.apply(RexShuttle.java:284)
> ~[calcite-core-1.16.0-drill-r0.jar:1.16.0-drill-r0]
> at
> org.apache.calcite.rel.rules.ReduceExpressionsRule.reduceExpressions(ReduceExpressionsRule.java:547)
> ~[calcite-core-1.16.0-drill-r0.jar:1.16.0-drill-r0]
> at
> org.apache.calcite.rel.rules.ReduceExpressionsRule$ProjectReduceExpressionsRule.onMatch(ReduceExpressionsRule.java:288)
> ~[calcite-core-1.16.0-drill-r0.jar:1.16.0-drill-r0]
> at
> org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:212)
> ~[calcite-core-1.16.0-drill-r0.jar:1.16.0-drill-r0]
> ... 14 common frames omitted
> Caused by: java.lang.IllegalArgumentException: Invalid value for boolean: A
> at org.apache.drill.exec.expr.BooleanType.get(BooleanType.java:74)
> ~[classes/:na]
> at
> org.apache.drill.exec.expr.fn.impl.SimpleCastFunctions$CastVarCharBoolean.eval(SimpleCastFunctions.java:50)
> ~[classes/:na]
> at
> org.apache.drill.exec.expr.fn.interpreter.InterpreterEvaluator.evaluateFunction(InterpreterEvaluator.java:129)
> ~[classes/:na]
> at
> org.apache.drill.exec.expr.fn.interpreter.InterpreterEvaluator$EvalVisitor.visitFunctionHolderExpression(InterpreterEvaluator.java:334)
> ~[classes/:na]
> ... 27 common frames omitted
> Running
> org.apache.drill.exec.sql.TestSimpleCastFunctions#testIncorrectNumericBoolean
> 15:56:49.989 [250b31ce-0218-e398-c3aa-5694688d3616:foreman] ERROR
> o.a.drill.exec.work.foreman.Foreman - SYSTEM ERROR: IllegalArgumentException:
> Invalid value for boolean: 123
> [Error Id: 78c118d2-8315-4a3c-a57f-8a109722a370 on drillu4.qa.lab:31022]
> org.apache.drill.common.exceptions.UserException: SYSTEM ERROR:
> IllegalArgumentException: Invalid value for boolean: 123
> [Error Id: 78c118d2-8315-4a3c-a57f-8a109722a370 on drillu4.qa.lab:31022]
> at
> org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:633)
> ~[drill-common-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
> at
> org.apache.drill.exec.work.foreman.Foreman$ForemanResult.close(Foreman.java:761)
> [classes/:na]
> at
> org.apache.drill.exec.work.foreman.QueryStateProcessor.checkCommonStates(QueryStateProcessor.java:325)
> [classes/:na]
> at
> org.apache.drill.exec.work.foreman.QueryStateProcessor.planning(QueryStateProcessor.java:221)
> [classes/:na]
> at
> org.apache.drill.exec.work.foreman.QueryStateProcessor.moveToState(QueryStateProcessor.java:83)
> [classes/:na]
> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:281)
> [classes/:na]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> [na:1.8.0_161]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> [na:1.8.0_161]
> at java.lang.Thread.run(Thread.java:748) [na:1.8.0_161]
> Caused by: org.apache.drill.exec.work.foreman.ForemanException: Unexpected
> exception during fragment initialization: Error while applying rule
> ReduceExpressionsRule(Project), args
> [rel#177391:LogicalProject.NONE.ANY([]).[](input=rel#177390:Subset#0.NONE.ANY([]).[0],b_val=CAST(123):BOOLEAN
> NOT NULL)]
> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:282)
> [classes/:na]
> ... 3 common frames omitted
> Caused by: java.lang.RuntimeException: Error while applying rule
> ReduceExpressionsRule(Project), args
> [rel#177391:LogicalProject.NONE.ANY([]).[](input=rel#177390:Subset#0.NONE.ANY([]).[0],b_val=CAST(123):BOOLEAN
> NOT NULL)]
> at
> org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:236)
> ~[calcite-core-1.16.0-drill-r0.jar:1.16.0-drill-r0]
> at
> org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:652)
> ~[calcite-core-1.16.0-drill-r0.jar:1.16.0-drill-r0]
> at
> org.apache.calcite.tools.Programs$RuleSetProgram.run(Programs.java:368)
> ~[calcite-core-1.16.0-drill-r0.jar:1.16.0-drill-r0]
> at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform(DefaultSqlHandler.java:419)
> ~[classes/:na]
> at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform(DefaultSqlHandler.java:359)
> ~[classes/:na]
> at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToRawDrel(DefaultSqlHandler.java:258)
> ~[classes/:na]
> at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:308)
> ~[classes/:na]
> at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:178)
> ~[classes/:na]
> at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:145)
> ~[classes/:na]
> at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:83)
> ~[classes/:na]
> at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
> [classes/:na]
> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
> [classes/:na]
> ... 3 common frames omitted
> Caused by: java.lang.RuntimeException: Error in evaluating function of castBIT
> at
> org.apache.drill.exec.expr.fn.interpreter.InterpreterEvaluator$EvalVisitor.visitFunctionHolderExpression(InterpreterEvaluator.java:347)
> ~[classes/:na]
> at
> org.apache.drill.exec.expr.fn.interpreter.InterpreterEvaluator$EvalVisitor.visitFunctionHolderExpression(InterpreterEvaluator.java:194)
> ~[classes/:na]
> at
> org.apache.drill.common.expression.FunctionHolderExpression.accept(FunctionHolderExpression.java:53)
> ~[drill-logical-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
> at
> org.apache.drill.exec.expr.fn.interpreter.InterpreterEvaluator.evaluateConstantExpr(InterpreterEvaluator.java:69)
> ~[classes/:na]
> at
> org.apache.drill.exec.planner.logical.DrillConstExecutor.reduce(DrillConstExecutor.java:150)
> ~[classes/:na]
> at
> org.apache.calcite.rex.RexSimplify.simplifyCast(RexSimplify.java:949)
> ~[calcite-core-1.16.0-drill-r0.jar:1.16.0-drill-r0]
> at org.apache.calcite.rex.RexSimplify.simplify(RexSimplify.java:146)
> ~[calcite-core-1.16.0-drill-r0.jar:1.16.0-drill-r0]
> at
> org.apache.calcite.rex.RexUtil$ExprSimplifier.visitCall(RexUtil.java:2625)
> ~[calcite-core-1.16.0-drill-r0.jar:1.16.0-drill-r0]
> at
> org.apache.calcite.rex.RexUtil$ExprSimplifier.visitCall(RexUtil.java:2585)
> ~[calcite-core-1.16.0-drill-r0.jar:1.16.0-drill-r0]
> at org.apache.calcite.rex.RexCall.accept(RexCall.java:107)
> ~[calcite-core-1.16.0-drill-r0.jar:1.16.0-drill-r0]
> at org.apache.calcite.rex.RexShuttle.apply(RexShuttle.java:284)
> ~[calcite-core-1.16.0-drill-r0.jar:1.16.0-drill-r0]
> at
> org.apache.calcite.rel.rules.ReduceExpressionsRule.reduceExpressions(ReduceExpressionsRule.java:547)
> ~[calcite-core-1.16.0-drill-r0.jar:1.16.0-drill-r0]
> at
> org.apache.calcite.rel.rules.ReduceExpressionsRule$ProjectReduceExpressionsRule.onMatch(ReduceExpressionsRule.java:288)
> ~[calcite-core-1.16.0-drill-r0.jar:1.16.0-drill-r0]
> at
> org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:212)
> ~[calcite-core-1.16.0-drill-r0.jar:1.16.0-drill-r0]
> ... 14 common frames omitted
> Caused by: java.lang.IllegalArgumentException: Invalid value for boolean: 123
> at org.apache.drill.exec.expr.BooleanType.get(BooleanType.java:74)
> ~[classes/:na]
> at
> org.apache.drill.exec.expr.fn.impl.SimpleCastFunctions$CastVarCharBoolean.eval(SimpleCastFunctions.java:50)
> ~[classes/:na]
> at
> org.apache.drill.exec.expr.fn.interpreter.InterpreterEvaluator.evaluateFunction(InterpreterEvaluator.java:129)
> ~[classes/:na]
> at
> org.apache.drill.exec.expr.fn.interpreter.InterpreterEvaluator$EvalVisitor.visitFunctionHolderExpression(InterpreterEvaluator.java:334)
> ~[classes/:na]
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
