BigQuery 是否支持 WITH
子句?我不喜欢格式化太多子查询。
例如:
WITH alias_1 AS (SELECT foo1 c FROM bar)
, alias_2 AS (SELECT foo2 c FROM bar a, alias_1 b WHERE b.c = a.c)
SELECT * FROM alias_2 a;
最近推出的 BigQuery Standard SQL 确实支持 WITH 子句
查看有关 WITH 子句的更多信息
另请参阅如何启用标准 SQL
BigQery Standard SQL 支持WITH
子句。语法如下所示
with table2 as (Select column1,column2 from table1)
select column1 from table2