[SOLR-9562] Minimize queried collections for time series alias - ASF JIRA

Attach files

Attach Screenshot

Add vote

Voters

Watch issue

Watchers

Create sub-task

Link

Clone

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: Improvement
Status: Reopened
Priority: Minor
Resolution: Unresolved
Affects Version/s: None
Fix Version/s: None
Component/s: None
Labels:
None

Description

For indexing time series data(such as large log data), we can create a new collection regularly(hourly, daily, etc.) with a write alias and create a read alias for all of those collections. But all of the collections of the read alias are queried even if we search over very narrow time window. In this case, the docs to be queried may be stored in very small portion of collections. So we don't need to do that.

I suggest this patch for read alias to minimize queried collections. Three parameters for CREATEALIAS action are added.

Key	Type	Required	Description
timeField	string	No	The time field name for time series data. It should be date type.
dateTimeFormat	string	No	The format of timestamp for collection creation. Every collection should has a suffix(start with "_") with this format. Ex. dateTimeFormat: yyyyMMdd, collectionName: col_20160927 See DateTimeFormatter.
timeZone	string	No	The time zone information for dateTimeFormat parameter. Ex. GMT+9. See DateTimeFormatter.

And then when we query with filter query like this "timeField:[fromTime TO toTime]", only the collections have the docs for a given time range will be queried.