[
https://issues.apache.org/jira/browse/ASTERIXDB-1084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15012605#comment-15012605
]
Abdullah Alamoudi commented on ASTERIXDB-1084:
----------------------------------------------
This has been fixed but not yet merged. It is currently part of the upsert
change being reviewed.
> INSERT doesn't return when inserting into a dataset with filter and multiple
> secondary indexes
> ----------------------------------------------------------------------------------------------
>
> Key: ASTERIXDB-1084
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1084
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: AsterixDB, Optimizer
> Reporter: Abdullah Alamoudi
> Assignee: Abdullah Alamoudi
> Labels: features
>
> When a dataset with multiple secondary indexes is created, queries which
> insert into this dataset don't come back after submission.
> To reproduce, execute the following commands:
> 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;
> create dataset FacebookMessages2(FacebookMessageType)
> primary key message-id with filter on send-time;
> load dataset FacebookMessages using localfs
> (("path"="nc1://data/fbm-with-send-time.adm"),("format"="adm"));
> create index AuthIdx on FacebookMessages2(author-id);
> create index ResIdx on FacebookMessages2(in-response-to);
> create index fbSenderLocIndex on FacebookMessages2(sender-location) type
> rtree;
> // The bug is here
> insert into dataset FacebookMessages2 (
> for $m in dataset('FacebookMessages')
> return $m
> );
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
