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

问题描述

BigQuery支持SELECT语句，但它是否支持像INSERT，UPDATE和DELETE这样的DML语句？ 是，BigQuery现在使用标准SQL支持SQL DML作为测试版（取消选中显示选项下的使用旧版SQL）。旧版SQL不支持SQL DML。

官方文档位于以下位置：
https://cloud.google.com/bigquery/sql-reference/data-manipulation-language

UPDATE或DELETE DML语句不是支持通过包含流缓冲区的表

>

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

解决方案

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

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

NOTE: UPDATE or DELETE DML statements are not supported over tables with streaming buffer

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