将json 数组 行转列 - xd21303/Notebook GitHub Wiki

lateral view explode(
        split(
            regexp_replace(
                regexp_extract(capacityFilterList, '^\\[(.+)\\]$', 1),
                '\\}\\,\\{',
                '\\}\\|\\|\\{'
            ),
            '\\|\\|'
        )
    ) ainfo as capacityFilter;