BigQuery类型中有多少个字节

本文介绍了BigQuery类型中有多少个字节的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

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