dtbc37573 2016-07-14 18:33
浏览 338
已采纳

向分区的BigQuery表添加数据并查询

In BigQuery I'm making a partitioned data table (partitioned by hour) and while data are going into it, it doesn't appear that the results have a _PARTITIONTIME pseudocolumn; when I do

SELECT
  _PARTITIONTIME AS pt,
  *
FROM
  [my_dataset.my_partitioned_table]
LIMIT
  1000

I get all the regular columns of my table, but _PARTITIONTIME is null for every entry. The data are being sent in from a call to the Go BigQuery API the same way they were when I was sending the data to an unpartitioned table, and they're queried from the BigQuery console. Would the data be more likely to be being inserted wrong or queried wrong?

  • 写回答

1条回答 默认 最新

  • dongzhuner6981 2016-07-14 18:50
    关注

    Currently only DAY is supported as a partitioning type!

    See more details in timePartitioning property

    And see more about Partitioned Tables in general

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?