Bigquery：如何保留派生表中的嵌套数据？ [英] Bigquery: how to preserve nested data in derived tables?

问题描述

我有几个带有RECORD字段类型的大型小时上传表格。我想从这些表中拉出选定的记录，并将它们放入每日每个客户表中。我遇到的麻烦是使用QUERY来做到这一点似乎会使数据变平。

I have a few large hourly upload tables with RECORD fieldtypes. I want to pull select records out of those tables and put them in daily per-customer tables. The trouble I'm running into is that using QUERY to do this seems to flatten the data out.

有没有办法保留嵌套的RECORD，或者我需要重新考虑我的方法吗？

Is there some way to preserve the nested RECORDs, or do I need to rethink my approach?

如果有帮助，我使用的是Python API。

If it helps, I'm using the Python API.

推荐答案

这篇关于Bigquery：如何保留派生表中的嵌套数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！