云数据仓库ADB如果有两个列要拆可以这么写吗？[阿里云云原生数据仓库] 暂停朗读为您朗读

云数据仓库ADB如果有两个列要拆可以这么写吗？

SELECT 
    user_name,
    temp_brand AS brand,
    temp_plate AS plate
FROM (
    SELECT
        user_name, 
        split(brand, ',') AS numbers_array,
        split(plate, ',') AS numbers_array1
    FROM bi_user_limit
    WHERE user_name = 'PingAn' AND shop = 1
) AS temp_table
CROSS JOIN UNNEST(numbers_array) AS temp_brand
CROSS JOIN UNNEST(numbers_array1) AS temp_plate;