[ASTERIXDB-2280] RTree on an optional nested field can't be built.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: IDX - Indexes
• Labels: triaged
• Assignee: Chen Luo
• Reporter: Taewoo Kim
• Created: 07/Feb/18 01:59
• Updated: 29/Mar/18 00:59
• Resolved: 29/Mar/18 00:59

Description

If there is an optional nested field, we can't build an RTree index.

 

use twitter;

create type typePlace if not exists as open{
country : string,
country_code : string,
full_name : string,
id : string,
name : string,
place_type : string,
bounding_box : rectangle
};

create type typeTweet2 if not exists as open {
create_at : datetime,
id: int64,
text: string,
in_reply_to_status : int64,
in_reply_to_user : int64,
favorite_count : int64,
coordinate: point?,
retweet_count : int64,
lang : string,
is_retweet: boolean,
hashtags : {{ string }} ?,
user_mentions : {{ int64 }} ? ,
place : typePlace?
};

create dataset ds_test(typeTweet2) primary key id with filter on create_at;

// success
CREATE INDEX dsTwIphoneIdx ON ds_test(create_at) TYPE BTREE;

// success
CREATE INDEX dsTwIphoneIdxCo ON ds_test(coordinate) TYPE RTREE;

// fail
CREATE INDEX dsTwIphoneIdxBBox ON ds_test(place.bounding_box) TYPE RTREE;