[jira] [Commented] (ASTERIXDB-1202) StackOverflow when using LSM-filter with two more index on the dataset

["Abdullah Alamoudi (JIRA)" <ji...@apache.org>]

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

Abdullah Alamoudi commented on ASTERIXDB-1202:
----------------------------------------------

I have this fixed in the upsert change being reviewed and added test cases for it.

> StackOverflow when using LSM-filter with two more index on the dataset
> ----------------------------------------------------------------------
>
>                 Key: ASTERIXDB-1202
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1202
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: Optimizer, Storage
>            Reporter: Jianfeng Jia
>
> I plan to use the LSM filter on a field. It works fine if there is only one  secondary index. However, if there are two secondary indexes on the dataset, the "with filter on" statement will throw a StackOverflow exception.
> {code}
> drop dataverse test if exists;
> create dataverse test;
> use dataverse test;
> create type FacebookMessageType as closed {
>         message-id: int64,
>         author-id: int64,
>         in-response-to: int64?,
>         sender-location: point,
>         message: string,
>         send-time: datetime
> }
> create dataset FacebookMessages(FacebookMessageType)
> primary key message-id with filter on send-time;
> create index idxa on FacebookMessages(in-response-to) type btree;
> create index idxb on FacebookMessages(sender-location) type rtree;
> use dataverse test;
> insert into dataset FacebookMessages ({"message-id":1,"author-id":3,"in-response-to":2,"sender-location":point("47.16,77.75"),"message":" love sprint its shortcut-menu is awesome:)","send-time":datetime("2012-01-20T10:10:00")}
> )
> {code}
> The exception is following:
> {code}
> java.lang.StackOverflowError
>   at org.apache.hyracks.algebricks.core.algebra.operators.logical.visitors.UsedVariableVisitor.visitAssignOperator(UsedVariableVisitor.java:75)
>   at org.apache.hyracks.algebricks.core.algebra.operators.logical.AssignOperator.accept(AssignOperator.java:64)
>   at org.apache.hyracks.algebricks.core.algebra.operators.logical.visitors.VariableUtilities.getUsedVariables(VariableUtilities.java:40)
>   at org.apache.asterix.optimizer.rules.RemoveUnusedOneToOneEquiJoinRule.removeUnusedJoin(RemoveUnusedOneToOneEquiJoinRule.java:95)
>   at org.apache.asterix.optimizer.rules.RemoveUnusedOneToOneEquiJoinRule.removeUnusedJoin(RemoveUnusedOneToOneEquiJoinRule.java:112)
>   at org.apache.asterix.optimizer.rules.RemoveUnusedOneToOneEquiJoinRule.removeUnusedJoin(RemoveUnusedOneToOneEquiJoinRule.java:112)
>   at org.apache.asterix.optimizer.rules.RemoveUnusedOneToOneEquiJoinRule.removeUnusedJoin(RemoveUnusedOneToOneEquiJoinRule.java:112)
>   at org.apache.asterix.optimizer.rules.RemoveUnusedOneToOneEquiJoinRule.removeUnusedJoin(RemoveUnusedOneToOneEquiJoinRule.java:112)
>   at org.apache.asterix.optimizer.rules.RemoveUnusedOneToOneEquiJoinRule.removeUnusedJoin(RemoveUnusedOneToOneEquiJoinRule.java:112)
>   at org.apache.asterix.optimizer.rules.RemoveUnusedOneToOneEquiJoinRule.removeUnusedJoin(RemoveUnusedOneToOneEquiJoinRule.java:112)
>   at org.apache.asterix.optimizer.rules.RemoveUnusedOneToOneEquiJoinRule.removeUnusedJoin(RemoveUnusedOneToOneEquiJoinRule.java:112)
> {code}



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