BigQuery中的列数限制? [英] Number of columns limitation in BigQuery?

问题描述

BigQuery中的列数是否有限制?

Is there limitation on number of columns in BigQuery?

我正在考虑按照建议的最佳做法准备大量专栏. https://developers.google.com/bigquery/articles/ingestionbestpractices

I'm thinking to prepare large number of columns as suggested the best practices. https://developers.google.com/bigquery/articles/ingestionbestpractices

推荐答案

限制为10,000列.假设没有人会超过1万列，则此限制是一个比较武断的限制.查看错误日志，确实有人达到了此限制并得到了错误. 导入时，行的总大小(CSV数据的字节)也有64k的限制.

The limit is 10,000 columns. This limit was imposed as a somewhat arbitrary one, with the assumption that no one would have more than 10k columns. Looking at the error logs, someone indeed hit this limitation and got an error. There is also a 64k limit on the total size of the row (bytes of CSV data) on import.

这篇关于BigQuery中的列数限制?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！