spyql
spyql copied to clipboard
Multiple EXPLODEs
Allow multiple explosions in a single EXPLODE statement.
Some possible syntaxes:
-
EXPLODE json->i_am_an_array[]->i_am_an_object->i_am_another_array[]
-
EXPLODE json->i_am_an_array, json->i_am_an_array->i_am_an_object->i_am_another_array
The 2nd is easier to parse and allows for explosions in different braches, but it is more verbose. The 2nd is also explicit about the order of explosions.
Consider using JMESPath