大查询更新或删除问题 [英] Big query update or delete issue

问题描述

我无法通过php进行任何更新或删除操作。有任何技术来完成这项任务。

解决方案

2016-08：支持UPDATE和DELETE的BigQuery：）

BigQuery是否支持UPDATE，DELETE和INSERT（ SQL DML）语句？

---

您可以通过BigQuery实现UPDATE和DELETE - 它不是本地操作。

要删除表中的行，请重新实现，而不使用不需要的行：

  SELECT * 
 FROM [my.table1] 
 WHERE NOT ID IN（19239,192392139,129391）
  

（设置为选项允许大量结果和将结果写入my.table1）

更新行，你可以做类似的事情：

  SELECT * FROM（
 SELECT * FROM [my.table1] 
 WHERE不是id IN（SELECT id FROM [my.updated_rows] 
），（
 SELECT * FROM [my.updated_rows] 
）
  

换句话说：BigQuery是一个解析数据库，其中DELETE和UPDATE不是优化操作 - 但是您可以使用单个SELECT语句覆盖原始表。

I can't do any update or delete operation by big query api via php. Have any techniques to complete this task.

解决方案

2016-08: BigQuery support for UPDATE and DELETE :)

Does BigQuery support UPDATE, DELETE, and INSERT (SQL DML) statements?

---

You can achieve UPDATEs and DELETEs with BigQuery - it's just not a native operation.

To delete rows from a table, re-materialize without the un-desired rows:

SELECT *
FROM [my.table1]
WHERE NOT id IN (19239,192392139,129391)

(set as options "allow large results" and "write results to my.table1")

To update rows, you can do something similar:

SELECT * FROM (
  SELECT * FROM [my.table1]
  WHERE NOT id IN (SELECT id FROM [my.updated_rows]
), (
  SELECT * FROM [my.updated_rows]
)

In other words: BigQuery is an analytical database, where DELETE and UPDATE are not optimized operations - but you pull them off with a single SELECT statement that overwrites the original table.

这篇关于大查询更新或删除问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！