[ https://issues.apache.org/jira/browse/ASTERIXDB-2280?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16418289#comment-16418289 ]
ASF subversion and git services commented on ASTERIXDB-2280: ------------------------------------------------------------ Commit 6a38e2b62e333e1f20b055cde293fdd5d27c7a4b in asterixdb's branch refs/heads/master from [~luochen01] [ https://git-wip-us.apache.org/repos/asf?p=asterixdb.git;h=6a38e2b ] [ASTERIXDB-2280][IDX] Fix Index on Optional Nested Field - user model changes: no - storage format changes: no - interface changes: no Details: - Fix the creation of indexes on optional nested field by handling AUnionType properly. - Fix the nullability check of primary keys. Change-Id: If098ff4a45db3c4e8b65d098cbb0940c8b7ab845 Reviewed-on: https://asterix-gerrit.ics.uci.edu/2477 Tested-by: Jenkins <jenk...@fulliautomatix.ics.uci.edu> Integration-Tests: Jenkins <jenk...@fulliautomatix.ics.uci.edu> Reviewed-by: Dmitry Lychagin <dmitry.lycha...@couchbase.com> Contrib: Jenkins <jenk...@fulliautomatix.ics.uci.edu> > 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)