BigQuery中以下类型占用多少字节:
How many bytes do the following types take up in BigQuery:
- 时间戳
- 约会时间
- 日期
我的猜测是日期可以存储为2个字节,时间戳可以存储8个,但是我不确定,因此 cloud.google/bigquery/docs/reference/standard-sql/data-types 页
My guess was that date could be stored in 2 bytes, and a timestamp perhaps 8, but I wasn't sure about that and it is not mentioned on the cloud.google/bigquery/docs/reference/standard-sql/data-types page.
推荐答案BigQuery数据类型的大小如下:
The size of BigQuery's data types is as follows:
Data type Size INT64/INTEGER 8 bytes FLOAT64/FLOAT 8 bytes NUMERIC 16 bytes BOOL/BOOLEAN 1 byte STRING 2 bytes + the UTF-8 encoded string size BYTES 2 bytes + the number of bytes in the value DATE 8 bytes DATETIME 8 bytes TIME 8 bytes TIMESTAMP 8 bytes STRUCT/RECORD 0 bytes + the size of the contained fields GEOGRAPHY 16 bytes + 24 bytes * the number of vertices in the geography type (you can verify the number of vertices using the ST_NumPoints function)任何数据类型的空值都将计算为0个字节.
Null values for any data type are calculated as 0 bytes.
将重复的列存储为数组,并计算大小基于值的数量.例如,整数列(INT64)计算重复(ARRAY)并包含4个条目为32个字节(4个条目x 8个字节).
A repeated column is stored as an array, and the size is calculated based on the number of values. For example, an integer column (INT64) that is repeated (ARRAY) and contains 4 entries is calculated as 32 bytes (4 entries x 8 bytes).
在数据大小计算部分中查看更多详细信息://cloud.google/bigquery/pricing"rel =" noreferrer>定价文档
See more details in Data size calculation section of Pricing documentation
更多推荐
BigQuery类型中有多少个字节
发布评论