BigQuery类型中有多少个字节 [英] How many bytes in BigQuery types

问题描述

BigQuery中以下类型占用多少字节:

How many bytes do the following types take up in BigQuery:

• 时间戳
• 约会时间
• 日期

我的猜测是日期可以存储为2个字节，时间戳可以存储8个，但是我不确定，因此

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 https://cloud.google.com/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.com/bigquery/pricing"rel =" noreferrer>定价文档

See more details in Data size calculation section of Pricing documentation

这篇关于BigQuery类型中有多少个字节的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！