如何计算bigquery行大小? [英] How to calculate bigquery row size?

问题描述

我正在使用bigquery流api(java)插入数据，并意识到表行的大小限制为1MB，但是没有人知道此限制的更多信息，例如1MB的计算方式吗?(我猜应该不应该是TableRow对象的大小).谢谢！

I'm using bigquery streaming api(java) to insert data, and realized there is a size limitation of 1MB on table row, but does anyone know more about this limitation, like how this 1MB was calculated? (I guess it shouldn't be the size of TableRow object). Thanks!

推荐答案

数据大小是根据每种数据类型的大小计算的.

data size is calculated based on the size of each data type.

Data type   Size
STRING      2 bytes + the UTF-8 encoded string size
INTEGER     8 bytes
FLOAT       8 bytes
BOOLEAN     1 byte
TIMESTAMP   8 bytes
RECORD      0 bytes + the size of the contained fields

请参见 https://cloud.google.com/bigquery/pricing#datafor更多详细信息

这篇关于如何计算bigquery行大小?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！