BigQuery标准SQL-删除多个表 [英] BigQuery standard SQL - DELETE over multiple tables

问题描述

我可以这样进行选择查询:

I can do a select query like this:

SELECT count(*)
FROM
  `test.test_*`
WHERE
  _TABLE_SUFFIX in('aaa', 'bbb')

但是我不能对DELETE做同样的事情.我得到"DML over table test.test_ *不支持以下查询:

But i cant do the same with DELETE. I get "DML over table test.test_* is not supported for the following query:

DELETE FROM
  `test.test_*`
WHERE
  _TABLE_SUFFIX in('aaa', 'bbb') and id = '111'

是否可以删除多个表?

推荐答案

BigQuery不支持通配符表上的DML.

BigQuery doesn't support DML over wildcard tables.

这篇关于BigQuery标准SQL-删除多个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！