Converting Nested Arrays to Tables
Many times, you have data structures with nested arrays that you contain values that you want to join against.
An example JSON data structure:
To access values for "hello", you can use the explode function.
Here is an example statement:
- statement: |
(helloValues) => select
from sourceData source
lateral view explode(source.values) a as values
A recipe template that demonstrates explode is Convert Nested Array to Table .
You may also want to look at the inline function if explode doesn't meet your needs.
The inline function will simply convert the array as an table: