通过 BigQuery 加入更新

本文介绍了通过 BigQuery 加入更新的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

是否可以基于 JOIN 与 BigQuery 中的现有表对表执行更新?

Is it possible to do an UPDATE on a table based on a JOIN with an existing table in BigQuery?

当我在以下数据库 (bigquery.cloud.google/dataset/pfamdb:pfam31)，

When I try this statement on the following database (bigquery.cloud.google/dataset/pfamdb:pfam31),

UPDATE pfam31.uniprot SET uniprot.auto_architecture = uniprot_architecture.auto_architecture INNER JOIN pfam31.uniprot_architecture using(uniprot_acc)

我收到与 INNER JOIN 相关的错误，而应使用 WHERE.我应该怎么做(如果可能的话)?

I get errors relating to the INNER JOIN, with WHERE being expected instead. How should I be doing this (if it's possible)?

推荐答案

UPDATE `pfam31.uniprot` a SET a.auto_architecture = b.auto_architecture FROM `pfam31.uniprot_architecture` b WHERE a.uniprot_acc = b.uniprot_acc