[
https://issues.apache.org/jira/browse/IMPALA-8513?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Armstrong reassigned IMPALA-8513:
-------------------------------------
Assignee: Fang-Yu Rao (was: Tim Armstrong)
> PlannerTest.testEmpty fails with java.lang.IllegalStateException: Illegal
> expr eval result. Expr=ifnull(NULL, FALSE)
> --------------------------------------------------------------------------------------------------------------------
>
> Key: IMPALA-8513
> URL: https://issues.apache.org/jira/browse/IMPALA-8513
> Project: IMPALA
> Issue Type: Bug
> Components: Frontend
> Affects Versions: Impala 3.3.0
> Reporter: Tim Armstrong
> Assignee: Fang-Yu Rao
> Priority: Blocker
> Labels: broken-build
>
> This failed with head commit "IMPALA-8341: Data cache for remote reads". It
> appears to be intermittent. It's very strange - I looked at the code and it
> looks "impossible" to me, but clearly it isn't. It could be related to recent
> code changes in this area, but I don't see a problem after having taken a
> second look. [~fangyurao] maybe you have some ideas?
> {noformat}
> org.apache.impala.planner.PlannerTest.testEmpty
> Failing for the past 1 build (Since Failed#781 )
> Took 5.5 sec.
> add description
> Error Message
> Query:
> select t1.int_col, count(*)
> from functional.alltypestiny t1
> left outer join functional.alltypes t2
> on t1.id = t2.id
> group by t1.int_col
> having ifnull(null, false)
> Error Stack:
> java.lang.IllegalStateException: Illegal expr eval result. Expr=ifnull(NULL,
> FALSE)
> TExpBatch=TExprBatch(exprs:[TExpr(nodes:[TExprNode(node_type:FUNCTION_CALL,
> type:TColumnType(types:[TTypeNode(type:SCALAR,
> scalar_type:TScalarType(type:BOOLEAN))]), num_children:2, is_constant:true,
> fn:TFunction(name:TFunctionName(db_name:_impala_builtins,
> function_name:ifnull), binary_type:BUILTIN,
> arg_types:[TColumnType(types:[TTypeNode(type:SCALAR,
> scalar_type:TScalarType(type:BOOLEAN))]),
> TColumnType(types:[TTypeNode(type:SCALAR,
> scalar_type:TScalarType(type:BOOLEAN))])],
> ret_type:TColumnType(types:[TTypeNode(type:SCALAR,
> scalar_type:TScalarType(type:BOOLEAN))]), has_var_args:false,
> signature:ifnull(BOOLEAN, BOOLEAN), scalar_fn:TScalarFunction(symbol:),
> is_persistent:true, last_modified_time:-1)),
> TExprNode(node_type:NULL_LITERAL,
> type:TColumnType(types:[TTypeNode(type:SCALAR,
> scalar_type:TScalarType(type:BOOLEAN))]), num_children:0, is_constant:true),
> TExprNode(node_type:BOOL_LITERAL,
> type:TColumnType(types:[TTypeNode(type:SCALAR,
> scalar_type:TScalarType(type:BOOLEAN))]), num_children:0, is_constant:true,
> bool_literal:TBoolLiteral(value:false))])])
> Result=TResultRow(colVals:null)
> at
> org.apache.impala.service.FeSupport.EvalExprWithoutRowBounded(FeSupport.java:201)
> at org.apache.impala.service.FeSupport.EvalExprWithoutRow(FeSupport.java:183)
> at org.apache.impala.service.FeSupport.EvalPredicate(FeSupport.java:264)
> at
> org.apache.impala.analysis.Analyzer.markConstantConjunct(Analyzer.java:1089)
> at org.apache.impala.analysis.Analyzer.registerConjuncts(Analyzer.java:1060)
> at
> org.apache.impala.analysis.SelectStmt$SelectAnalyzer.buildResultExprs(SelectStmt.java:805)
> at
> org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyze(SelectStmt.java:227)
> at
> org.apache.impala.analysis.SelectStmt$SelectAnalyzer.access$100(SelectStmt.java:194)
> at org.apache.impala.analysis.SelectStmt.analyze(SelectStmt.java:187)
> at
> org.apache.impala.analysis.AnalysisContext.analyze(AnalysisContext.java:450)
> at
> org.apache.impala.analysis.AnalysisContext.analyzeAndAuthorize(AnalysisContext.java:420)
> at org.apache.impala.service.Frontend.doCreateExecRequest(Frontend.java:1270)
> at org.apache.impala.service.Frontend.getTExecRequest(Frontend.java:1237)
> at org.apache.impala.service.Frontend.createExecRequest(Frontend.java:1207)
> at
> org.apache.impala.planner.PlannerTestBase.testPlan(PlannerTestBase.java:516)
> at
> org.apache.impala.planner.PlannerTestBase.runTestCase(PlannerTestBase.java:421)
> at
> org.apache.impala.planner.PlannerTestBase.runPlannerTestFile(PlannerTestBase.java:887)
> at
> org.apache.impala.planner.PlannerTestBase.runPlannerTestFile(PlannerTestBase.java:852)
> at org.apache.impala.planner.PlannerTest.testEmpty(PlannerTest.java:111)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at
> org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
> at
> org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
> at
> org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
> at
> org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
> at
> org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
> at
> org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
> at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
> at
> org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
> at
> org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
> at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
> at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
> at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
> at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
> at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
> at
> org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
> at
> org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
> at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
> at
> org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
> at
> org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:272)
> at
> org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:236)
> at
> org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
> at
> org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:386)
> at
> org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:323)
> at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:143)
> Stacktrace
> java.lang.AssertionError:
> Query:
> select t1.int_col, count(*)
> from functional.alltypestiny t1
> left outer join functional.alltypes t2
> on t1.id = t2.id
> group by t1.int_col
> having ifnull(null, false)
> Error Stack:
> java.lang.IllegalStateException: Illegal expr eval result. Expr=ifnull(NULL,
> FALSE)
> TExpBatch=TExprBatch(exprs:[TExpr(nodes:[TExprNode(node_type:FUNCTION_CALL,
> type:TColumnType(types:[TTypeNode(type:SCALAR,
> scalar_type:TScalarType(type:BOOLEAN))]), num_children:2, is_constant:true,
> fn:TFunction(name:TFunctionName(db_name:_impala_builtins,
> function_name:ifnull), binary_type:BUILTIN,
> arg_types:[TColumnType(types:[TTypeNode(type:SCALAR,
> scalar_type:TScalarType(type:BOOLEAN))]),
> TColumnType(types:[TTypeNode(type:SCALAR,
> scalar_type:TScalarType(type:BOOLEAN))])],
> ret_type:TColumnType(types:[TTypeNode(type:SCALAR,
> scalar_type:TScalarType(type:BOOLEAN))]), has_var_args:false,
> signature:ifnull(BOOLEAN, BOOLEAN), scalar_fn:TScalarFunction(symbol:),
> is_persistent:true, last_modified_time:-1)),
> TExprNode(node_type:NULL_LITERAL,
> type:TColumnType(types:[TTypeNode(type:SCALAR,
> scalar_type:TScalarType(type:BOOLEAN))]), num_children:0, is_constant:true),
> TExprNode(node_type:BOOL_LITERAL,
> type:TColumnType(types:[TTypeNode(type:SCALAR,
> scalar_type:TScalarType(type:BOOLEAN))]), num_children:0, is_constant:true,
> bool_literal:TBoolLiteral(value:false))])])
> Result=TResultRow(colVals:null)
> at
> org.apache.impala.service.FeSupport.EvalExprWithoutRowBounded(FeSupport.java:201)
> at
> org.apache.impala.service.FeSupport.EvalExprWithoutRow(FeSupport.java:183)
> at org.apache.impala.service.FeSupport.EvalPredicate(FeSupport.java:264)
> at
> org.apache.impala.analysis.Analyzer.markConstantConjunct(Analyzer.java:1089)
> at
> org.apache.impala.analysis.Analyzer.registerConjuncts(Analyzer.java:1060)
> at
> org.apache.impala.analysis.SelectStmt$SelectAnalyzer.buildResultExprs(SelectStmt.java:805)
> at
> org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyze(SelectStmt.java:227)
> at
> org.apache.impala.analysis.SelectStmt$SelectAnalyzer.access$100(SelectStmt.java:194)
> at org.apache.impala.analysis.SelectStmt.analyze(SelectStmt.java:187)
> at
> org.apache.impala.analysis.AnalysisContext.analyze(AnalysisContext.java:450)
> at
> org.apache.impala.analysis.AnalysisContext.analyzeAndAuthorize(AnalysisContext.java:420)
> at
> org.apache.impala.service.Frontend.doCreateExecRequest(Frontend.java:1270)
> at
> org.apache.impala.service.Frontend.getTExecRequest(Frontend.java:1237)
> at
> org.apache.impala.service.Frontend.createExecRequest(Frontend.java:1207)
> at
> org.apache.impala.planner.PlannerTestBase.testPlan(PlannerTestBase.java:516)
> at
> org.apache.impala.planner.PlannerTestBase.runTestCase(PlannerTestBase.java:421)
> at
> org.apache.impala.planner.PlannerTestBase.runPlannerTestFile(PlannerTestBase.java:887)
> at
> org.apache.impala.planner.PlannerTestBase.runPlannerTestFile(PlannerTestBase.java:852)
> at org.apache.impala.planner.PlannerTest.testEmpty(PlannerTest.java:111)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at
> org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
> at
> org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
> at
> org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
> at
> org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
> at
> org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
> at
> org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
> at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
> at
> org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
> at
> org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
> at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
> at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
> at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
> at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
> at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
> at
> org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
> at
> org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
> at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
> at
> org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
> at
> org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:272)
> at
> org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:236)
> at
> org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
> at
> org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:386)
> at
> org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:323)
> at
> org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:143)
> at org.junit.Assert.fail(Assert.java:88)
> at
> org.apache.impala.planner.PlannerTestBase.runPlannerTestFile(PlannerTestBase.java:908)
> at
> org.apache.impala.planner.PlannerTestBase.runPlannerTestFile(PlannerTestBase.java:852)
> at org.apache.impala.planner.PlannerTest.testEmpty(PlannerTest.java:111)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at
> org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
> at
> org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
> at
> org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
> at
> org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
> at
> org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
> at
> org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
> at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
> at
> org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
> at
> org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
> at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
> at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
> at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
> at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
> at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
> at
> org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
> at
> org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
> at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
> at
> org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
> at
> org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:272)
> at
> org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:236)
> at
> org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
> at
> org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:386)
> at
> org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:323)
> at
> org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:143)
> {noformat}
> I'm going to try to loop the query locally to see if I can reproduce this:
> {noformat}
> while impala-shell.sh -q 'explain select t1.int_col, count(*) from
> functional.alltypestiny t1 left outer join functional.alltypes t2 on t1.id =
> t2.id group by t1.int_col having ifnull(null, false);' ; do date; done
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org
For additional commands, e-mail: issues-all-h...@impala.apache.org
