SELECT
*
FROM (
SELECT
regexp_split_to_table('a,b,c', ',') a) AS aa
CROSS JOIN (
SELECT
regexp_split_to_table('1,3', ',') b) AS bb;结果如下：
| a | b |
|---|---|
| a | 1 |
| a | 3 |
| b | 1 |
| b | 3 |
| c | 1 |
| c | 3 |
SELECT
*
FROM (
SELECT
regexp_split_to_table('a,b,c', ',') a) AS aa
CROSS JOIN (
SELECT
regexp_split_to_table('1,3', ',') b) AS bb;结果如下：
| a | b |
|---|---|
| a | 1 |
| a | 3 |
| b | 1 |
| b | 3 |
| c | 1 |
| c | 3 |