提取产品名称数组的路径为

The path to extract the array of product names is

select concat_ws( "|", get_json_object('{"product_offer":[{"productName":"Plan A"},{"productName":"Plan B"}]}', '$.product_offer[*].productName'

在 spark dbvisualizer 中都可以使用.

which works both in spark dbvisualizer.