产品动态
公告
* | SELECT * FROM UNNEST(ARRAY['value1','value2',...]) AS table_name(key_name)
* | SELECT * FROM UNNEST(map) AS table_name(key1_name, key2_name,...)
* | SELECT * FROM UNNEST(ARRAY[1,2]) AS t(number)
number |
1 |
2 |
* | SELECT * FROM UNNEST(map_from_entries(ARRAY[('SQL',1974),('Java', 1995)])) AS t(language, first_appeared_year)
language | first_appeared_year |
SQL | 1974 |
Java | 1995 |
## 第一条原始日志rsp_time: 0.004, 0.002url: /demo/test1## 第二条原始日志rsp_time: 0.006, 0.008url: /demo/test2
* | SELECT time,urlFROM (SELECT split(rsp_time,',') AS time_array,url) tCROSS JOIN UNNEST(time_array) AS t(time)
time | url |
0.004 | /demo/test1 |
0.002 | /demo/test1 |
0.006 | /demo/test2 |
0.008 | /demo/test2 |
## 第一条原始日志rsp_time: 0.004, 0.002rsp_status: 200, 502url: /demo/test1## 第二条原始日志rsp_time: 0.006, 0.008rsp_status: 500, 404url: /demo/test2
* | SELECT time,status,urlFROM (SELECT zip(split(rsp_time,','),split(rsp_status,',')) as data_array,url) tCROSS JOIN UNNEST(data_array) AS t(time,status)
time | status | url |
0.004 | 200 | /demo/test1 |
0.002 | 502 | /demo/test1 |
0.006 | 500 | /demo/test2 |
0.008 | 404 | /demo/test2 |
文档反馈