You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Till Westmann (Jira)" <ji...@apache.org> on 2020/03/13 17:17:00 UTC
[jira] [Commented] (ASTERIXDB-2705) Selection after an inner join
throws an error
[ https://issues.apache.org/jira/browse/ASTERIXDB-2705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17058942#comment-17058942 ]
Till Westmann commented on ASTERIXDB-2705:
------------------------------------------
{noformat}
10:14:20.176 [HttpExecutor(port:19001)-7] ERROR org.apache.asterix - null
java.lang.NullPointerException: null
at org.apache.asterix.om.typecomputer.impl.TypeComputeUtils.getActualType(TypeComputeUtils.java:206) ~[classes/:?]
at org.apache.asterix.om.typecomputer.impl.TypeComputeUtils.getActualType(TypeComputeUtils.java:185) ~[classes/:?]
at org.apache.asterix.om.typecomputer.impl.TypeComputeUtils.resolveResultType(TypeComputeUtils.java:90) ~[classes/:?]
at org.apache.asterix.om.typecomputer.base.AbstractResultTypeComputer.computeType(AbstractResultTypeComputer.java:44) ~[classes/:?]
at org.apache.asterix.dataflow.data.common.ExpressionTypeComputer.getTypeForFunction(ExpressionTypeComputer.java:84) ~[classes/:?]
at org.apache.asterix.dataflow.data.common.ExpressionTypeComputer.getType(ExpressionTypeComputer.java:55) ~[classes/:?]
at org.apache.hyracks.algebricks.core.algebra.typing.AbstractTypeEnvironment.getType(AbstractTypeEnvironment.java:45) ~[classes/:?]
at org.apache.asterix.om.typecomputer.impl.AbstractIfMissingOrNullTypeComputer.computeType(AbstractIfMissingOrNullTypeComputer.java:49) ~[classes/:?]
at org.apache.asterix.om.typecomputer.impl.IfMissingOrNullTypeComputer.computeType(IfMissingOrNullTypeComputer.java:26) ~[classes/:?]
at org.apache.asterix.dataflow.data.common.ExpressionTypeComputer.getTypeForFunction(ExpressionTypeComputer.java:84) ~[classes/:?]
at org.apache.asterix.dataflow.data.common.ExpressionTypeComputer.getType(ExpressionTypeComputer.java:55) ~[classes/:?]
at org.apache.hyracks.algebricks.core.algebra.typing.AbstractTypeEnvironment.getType(AbstractTypeEnvironment.java:45) ~[classes/:?]
at org.apache.asterix.optimizer.rules.typecast.StaticTypeCastUtil.rewriteListExpr(StaticTypeCastUtil.java:114) ~[classes/:?]
at org.apache.asterix.optimizer.rules.IntroduceEnforcedListTypeRule.rewriteExpressions(IntroduceEnforcedListTypeRule.java:91) ~[classes/:?]
at org.apache.asterix.optimizer.rules.IntroduceEnforcedListTypeRule.rewritePost(IntroduceEnforcedListTypeRule.java:80) ~[classes/:?]
at org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:121) ~[classes/:?]
at org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:95) ~[classes/:?]
at org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:95) ~[classes/:?]
at org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:95) ~[classes/:?]
at org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:95) ~[classes/:?]
at org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:95) ~[classes/:?]
at org.apache.hyracks.algebricks.compiler.rewriter.rulecontrollers.SequentialFixpointRuleController.rewriteWithRuleCollection(SequentialFixpointRuleController.java:52) ~[classes/:?]
at org.apache.hyracks.algebricks.core.rewriter.base.HeuristicOptimizer.runOptimizationSets(HeuristicOptimizer.java:89) ~[classes/:?]
at org.apache.hyracks.algebricks.core.rewriter.base.HeuristicOptimizer.runLogicalOptimizationSets(HeuristicOptimizer.java:80) ~[classes/:?]
at org.apache.hyracks.algebricks.core.rewriter.base.HeuristicOptimizer.optimize(HeuristicOptimizer.java:61) ~[classes/:?]
at org.apache.hyracks.algebricks.compiler.api.HeuristicCompilerFactoryBuilder$1$1.optimize(HeuristicCompilerFactoryBuilder.java:94) ~[classes/:?]
at org.apache.asterix.api.common.APIFramework.compileQuery(APIFramework.java:255) ~[classes/:?]
at org.apache.asterix.app.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator.java:2227) ~[classes/:?]
at org.apache.asterix.app.translator.QueryTranslator.lambda$handleQuery$3(QueryTranslator.java:2725) ~[classes/:?]
at org.apache.asterix.app.translator.QueryTranslator.createAndRunJob(QueryTranslator.java:2857) ~[classes/:?]
at org.apache.asterix.app.translator.QueryTranslator.deliverResult(QueryTranslator.java:2761) ~[classes/:?]
at org.apache.asterix.app.translator.QueryTranslator.handleQuery(QueryTranslator.java:2740) ~[classes/:?]
at org.apache.asterix.app.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:423) ~[classes/:?]
at org.apache.asterix.api.http.server.ApiServlet.post(ApiServlet.java:158) [classes/:?]
at org.apache.hyracks.http.server.AbstractServlet.handle(AbstractServlet.java:92) [classes/:?]
at org.apache.hyracks.http.server.HttpRequestHandler.handle(HttpRequestHandler.java:83) [classes/:?]
at org.apache.hyracks.http.server.HttpRequestHandler.call(HttpRequestHandler.java:68) [classes/:?]
at org.apache.hyracks.http.server.HttpRequestHandler.call(HttpRequestHandler.java:37) [classes/:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
at java.lang.Thread.run(Thread.java:834) [?:?]
{noformat}
> Selection after an inner join throws an error
> ---------------------------------------------
>
> Key: ASTERIXDB-2705
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2705
> Project: Apache AsterixDB
> Issue Type: Bug
> Affects Versions: 0.9.5
> Reporter: Gift Sinthong
> Assignee: Till Westmann
> Priority: Major
>
> I use the GleambookUsers and GleambookMessages datasets from the AsterixDB tutorial. The first query uses left outer join returns correct results but the second query which uses inner join throws an internal Nullpointer exception error.
> {code:java}
> USE TinySocial;
> SELECT VALUE t
> FROM (SELECT u.*, m.*
> FROM GleambookUsers u
> LEFT OUTER JOIN GleambookMessages m
> ON u.id=m.authorId) t
> WHERE t.authorId = 2;
> SELECT VALUE t
> FROM (SELECT u.*, m.*
> FROM GleambookUsers u
> INNER JOIN GleambookMessages m
> ON u.id=m.authorId) t
> WHERE t.authorId = 2;
> {code}
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)