是否可以在BigQuery的所有表中进行全文搜索? [英] Is it possible to do a full text search in all tables in BigQuery?

问题描述

在Oracle和SQL Server中，可以在所有数据库对象中搜索特定文本的引用:选择*来自all_source像％blah％"这样的大写(文本)

In Oracle and SQL Server, it is possible to search all database objects for references of specific text: SELECT * FROM all_source WHERE UPPER(text) LIKE '%blah%'

我想在Google BigQuery中做同样的事情.是否可以在BigQuery中的每个表的每个字段中搜索特定值?

I would like to do the same thing in Google BigQuery. Is it possible to search every field of every table for a particular value in BigQuery?

推荐答案

如果您希望在BigQuery中查询数据集中的多个表，请查看 ，其中讨论了此主题.

If you wish to query multiple tables within a dataset in BigQuery, have a look at querying multiple tables using a wildcard table. If you would also like to search for a word in all columns of a table (or every table in this case), have a look at this SO post where this topic is discussed.

这篇关于是否可以在BigQuery的所有表中进行全文搜索?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！