presto cross unnest

Presto中的CROSS JOIN和UNNEST是用于将数组拆分成行的操作。CROSS JOIN用于将两个表的每一行进行组合，而UNNEST则用于将数组中的元素展开成多行数据。在给出的引用中，UNNEST被用于将order_ids这个数组拆分成多行，并将每个元素作为b表的order_id列的值。同时，CROSS JOIN将tmp_col_to_row表和UNNEST操作后的结果进行了组合，从而得到了最终的查询结果。 [2<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [【presto】行转列和列转行](https://blog.csdn.net/lz6363/article/details/124557442)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"]
- *2* [Hive/Spark/Presto/标准SQL实现行转列和列转行](https://blog.csdn.net/soaring0121/article/details/99870447)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"]
- *3* [datax支持presto读取](https://download.csdn.net/download/qq_27048639/13489400)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"]
[ .reference_list ]