[ASTERIXDB-3079] Add support to reading loading files of multiple prefixes

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.9.8
• Fix Version/s: 0.9.9
• Component/s: EXT - External data
• Epic Link: Dynamic Prefixes for External Datasets
• Assignee: Hussain Towaileb
• Reporter: Hussain Towaileb
• Created: 16/Sep/22 14:11
• Updated: 16/Sep/22 14:11

Description

Currently, we provide a single prefix and load the files metadata under that prefix. With the support for computed fields for operators like IN operator, we can end up with multiple prefixes.

 

Example, given the following prefix user-data/{userid:int}

 

 

SELECT *

FROM userdata

WHERE user_id IN [1, 2]

 

 

The above translates to loading the data for the prefixes:

 

 

user-data/1

user-data/2