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

[Taewoo Kim (JIRA)]

Taewoo Kim created ASTERIXDB-2280:
-------------------------------------

             Summary: 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
            Reporter: Taewoo Kim


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)