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

["Till (JIRA)" <ji...@apache.org>]

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

Till updated ASTERIXDB-2280:
----------------------------
    Component/s: IDX - Indexes

> 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
>            Priority: Major
>
> 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)