asterixdb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Till Westmann (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (ASTERIXDB-1084) INSERT doesn't return when inserting into a dataset with filter and multiple secondary indexes
Date Mon, 14 Sep 2015 17:25:45 GMT

     [ https://issues.apache.org/jira/browse/ASTERIXDB-1084?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Till Westmann updated ASTERIXDB-1084:
-------------------------------------
    Component/s: Optimizer

> 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)

Mime
View raw message