[ https://issues.apache.org/jira/browse/ASTERIXDB-2280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chen Luo resolved ASTERIXDB-2280. --------------------------------- Resolution: Fixed > RTree on an optional nested field can't be built. > ------------------------------------------------- > > Key: ASTERIXDB-2280 > URL: https://issues.apache.org/jira/browse/ASTERIXDB-2280 > Project: Apache AsterixDB > Issue Type: Bug > Components: IDX - Indexes > Reporter: Taewoo Kim > Assignee: Chen Luo > Priority: Major > Labels: triaged > > If there is an optional nested field, we can't build an RTree index. > > {code:java} > 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; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)