`UNNEST` - Githubissues

UBOdin / mimir

Data-ish exploration through SQL+Uncertainty

http://mimirdb.info

Apache License 2.0

27 stars 13 forks source link

`UNNEST` #212

Open okennedy opened 7 years ago

okennedy commented 7 years ago

It would be nice to have an UNNEST operator, essentially an inverse aggregate (one row/cell to many).

Examples:

Iterate over the elements of a JSON array
Regexp matches in a given object
Fields of a CSV

SQLite already supports something of this flavor (e.g.,. The JSON TVFs), but the way it's implemented is a violation of classical SQL (so it's going to need a special implementation within Mimir).

okennedy commented 5 years ago

Spark also has this functionality. It should be much easier now.