BigQuery数据类型 [英] BigQuery datatypes

问题描述

我从一个新项目开始，只想在定义表模式之前进行验证。

BigQuery是否支持以下其他内容：

 字符串 -  
整数 -  
浮动 -  
布尔 -  
  

解决方案

BigQuery数据类型官方文档：

• https://cloud.google.com/bigquery/data-types


• https：/ /cloud.google.com/bigquery/docs/reference/standard-sql/data-types

---

上一个答案列出了基本的数据类型：

• STRING


• INTEGER


• FLOAT


• BOOLEAN

支持：

• RECORD（JSON obje cts，查看嵌套记录）
  
• TIMESTAMP


• 字节


• DATE


• TIME


• DATETIME

更多关于：

• 嵌套记录： https：/ /developers.google.com/bigquery/docs/data#nested


• 使用时间戳： https://developers.google.com/bigquery/docs/timestamp


• 文档： https://developers.google.com/bigquery/preparing-data-for-bigquery#datatypes

I am starting with a new project and just wanted to verify before defining the table schema

Does BigQuery support anything other than:

string – 
integer –
float– 
boolean – 

解决方案

BigQuery data types official docs:

• https://cloud.google.com/bigquery/data-types
• https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types

---

The previous answer lists the basic datatypes:

• STRING
• INTEGER
• FLOAT
• BOOLEAN

BigQuery also supports:

• RECORD (JSON objects, see nested records)
• TIMESTAMP
• BYTES
• DATE
• TIME
• DATETIME

More on:

• Nested records: https://developers.google.com/bigquery/docs/data#nested
• Using timestamp: https://developers.google.com/bigquery/docs/timestamp
• Docs: https://developers.google.com/bigquery/preparing-data-for-bigquery#datatypes

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