[ATLAS-4417] Using multivalued Fields in Atlas Search

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.1.0, 2.2.0
• Component/s: atlas-core, atlas-intg
• Labels: Search atlas search
• Assignee: Unassigned
• Reporter: Thorben Ortmann
• Created: 09/Sep/21 06:19
• Updated: 09/Sep/21 06:21

Description

The improvement I am requesting is the functionality to use multivalued fields (like array<string>) in search. Let me give an example to elaborate on this:

Let's say we have an entity of a type called Dataset.
Dataset has an attribute called tags of type array<string>.
In tags we put multiple strings; maybe about a product, branch or country a Dataset belongs to (note that a Dataset may belong to multiple products, branches, etc.).

Assigning the values via putting them in the tags attribute of a Dataset is no problem. What I have not been able to achieve is to search for Datasets using the tags attribute as it is of type array<string> (or multivalued). To my knowledge, no search type offers this functionality. Something like:

FROM Dataset WHERE tags CONTAINS "tag_value_to_search_by"

is not possible via Advanced Search. There only is the LIKE operator in the DSL and in Basic Search the contains also only works with String attributes and Free-text Search only considers String attributes; afaik.

I think this functionality would be very valuable for a lot of use cases.

(Please let me know, if I am missing something and the described functionality to search with multivalued attributes is already there or if there is a workaround.)