Mailing-List: contact notifications-help@asterixdb.incubator.apache.org;
 run by ezmlm
Precedence: bulk
Reply-To: dev@asterixdb.incubator.apache.org
Date: Sun, 14 Feb 2016 06:10:18 +0000 (UTC)
From: "Till Westmann (JIRA)" <jira@apache.org>
To: notifications@asterixdb.incubator.apache.org
Message-ID: <JIRA.12910859.1446761101000.48565.1455430218058@Atlassian.JIRA>
In-Reply-To: <JIRA.12910859.1446761101000@Atlassian.JIRA>
References: <JIRA.12910859.1446761101000@Atlassian.JIRA>
 <JIRA.12910859.1446761101614@arcas>
Subject: [jira] [Commented] (ASTERIXDB-1161) NullPointerException when
 rewriting the spatial-intersect query with an RTree index involved
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/ASTERIXDB-1161?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15146395#comment-15146395 ] 

Till Westmann commented on ASTERIXDB-1161:
------------------------------------------

@Taewoo I'm a little confused about the 2 statements. Is it fixed, if we don't have the left-outer-unnestmap?

> NullPointerException when rewriting the spatial-intersect query with an RTree index involved
> --------------------------------------------------------------------------------------------
>
>                 Key: ASTERIXDB-1161
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1161
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: Optimizer
>            Reporter: Jianfeng Jia
>            Assignee: Taewoo Kim
>
> The following AQL will throw an NPE:
> -------------------------------------
> drop dataverse test if exists;
> create dataverse test;
> use dataverse test;
> create type TPoly as open{
> id: int64,
> geometry: polygon
> }
> create dataset Polygons(TPoly) primary key id;
> create index geoRtree on Polygons(geometry) type rtree;
> create type TSample as closed {
> id : int64,
> location : point
> }
> create dataset Sample(TSample) primary key id;
> insert into dataset Polygons ( [{ "id":1, "geometry": polygon("-1.2,130.0 -214000.0,2.15 -350.0,3.6 -0.0046,4.81")}])
> insert into dataset Sample ( [ {"id": 1, "location" : point("0,0")}] )
> for $s in dataset Sample limit 1 return  {"ids": $s.id,
>   "idp": for $p in dataset Polygons where spatial-intersect($s.location, $p.geometry) return $p.id
> }
> ---------------------------------
> NPE:
> ----------------------------------
> java.lang.NullPointerException
>         at org.apache.asterix.om.util.NonTaggedFormatUtil.isOptional(NonTaggedFormatUtil.java:96)
>         at org.apache.asterix.metadata.entities.Index.getNonNullableType(Index.java:137)
>         at org.apache.asterix.optimizer.rules.am.AbstractIntroduceAccessMethodRule.isMatched(AbstractIntroduceAccessMethodRule.java:323)
>         at org.apache.asterix.optimizer.rules.am.AbstractIntroduceAccessMethodRule.pruneIndexCandidates(AbstractIntroduceAccessMethodRule.java:275)
>         at org.apache.asterix.optimizer.rules.am.AbstractIntroduceAccessMethodRule.pruneIndexCandidates(AbstractIntroduceAccessMethodRule.java:119)
>         at org.apache.asterix.optimizer.rules.am.IntroduceJoinAccessMethodRule.rewritePost(IntroduceJoinAccessMethodRule.java:140)
>         at org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:126)
>         at org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
>         at org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
>         at org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
>         at org.apache.hyracks.algebricks.compiler.rewriter.rulecontrollers.SequentialFixpointRuleController.rewriteWithRuleCollection(SequentialFixpointRuleController.java:53)
>         at org.apache.hyracks.algebricks.core.rewriter.base.HeuristicOptimizer.runOptimizationSets(HeuristicOptimizer.java:95)
>         at org.apache.hyracks.algebricks.core.rewriter.base.HeuristicOptimizer.optimize(HeuristicOptimizer.java:82)
>         at org.apache.hyracks.algebricks.compiler.api.HeuristicCompilerFactoryBuilder$1$1.optimize(HeuristicCompilerFactoryBuilder.java:87)
>         at org.apache.asterix.api.common.APIFramework.compileQuery(APIFramework.java:279)
>         at org.apache.asterix.aql.translator.AqlTranslator.rewriteCompileQuery(AqlTranslator.java:1900)
>         at org.apache.asterix.aql.translator.AqlTranslator.handleQuery(AqlTranslator.java:2480)
>         at org.apache.asterix.aql.translator.AqlTranslator.compileAndExecute(AqlTranslator.java:385)
>         at org.apache.asterix.api.http.servlet.APIServlet.doPost(APIServlet.java:114)
> ---------------------------
> However, it won't be any problem if the ddl doesn't contain a RTree index. 
> E.g. if we comment out this line in the above query it will work fine.
>  // create index geoRtree on Polygons(geometry) type rtree;


--
This message was sent by Atlassian JIRA
(v6.3.4#6332)