BigQuery 是否支持 UPDATE、DELETE 和 INSERT (SQL DML) 语句? [英] Does BigQuery support UPDATE, DELETE, and INSERT (SQL DML) statements?

问题描述

BigQuery 支持 SELECT 语句，但它是否支持 INSERT、UPDATE 和 DELETE 等 DML 语句?

BigQuery supports SELECT statements, but does it support DML statements like INSERT, UPDATE and DELETE?

推荐答案

是的，BigQuery 现在支持使用标准 SQL 的 SQL DML(取消选中显示选项"下的使用旧版 SQL").旧版 SQL 不支持 SQL DML.

Yes, BigQuery now supports SQL DML with standard SQL (uncheck "Use Legacy SQL" under "Show Options"). SQL DML is not supported with legacy SQL.

官方文档可在此处获得:https://cloud.google.com/bigquery/sql-reference/data-操作语言

Official documentation is available here: https://cloud.google.com/bigquery/sql-reference/data-manipulation-language

注意:UPDATE、DELETE 和 MERGE DML 语句支持带有流缓冲区的表，只要该语句不影响流缓冲区中的行.

NOTE: UPDATE, DELETE and MERGE DML statements are supported over tables with streaming buffer as long as the statement doesn't affect rows that are in the streaming buffer.

这篇关于BigQuery 是否支持 UPDATE、DELETE 和 INSERT (SQL DML) 语句?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！