Many times, you have data structures with nested arrays that you contain values that you want to join against.

An example JSON data structure:

"values": [

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

To output:

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: