MapReduce服务 MRS-UNNEST:使用多个列

时间:2023-11-01 16:25:24

使用多个列

SELECT numbers, animals, n, aFROM (VALUES(ARRAY[2, 5], ARRAY['dog', 'cat', 'bird']),(ARRAY[7, 8, 9], ARRAY['cow', 'pig'])) AS x (numbers, animals)CROSS JOIN UNNEST(numbers, animals) AS t (n, a);
support.huaweicloud.com/cmpntguide-lts-mrs/mrs_01_249074.html