BigQuery with子句的问题

Question

我正在尝试使用文档中描述的BigQuery的WITH子句。当运行以下查询时，我得到一个错误:

WITH subQ1 AS (SELECT "1"),
     subQ2 AS (SELECT "2")
SELECT * FROM subQ1
UNION ALL
SELECT * FROM subQ2;

抛出的错误是:

Error: Encountered " "WITH" "WITH "" at line 1, column 1. Was expecting: <EOF>

有人知道我做错了什么吗?

Answer 1

您应该启用标准SQL
而不是这样——你应该表现得很好!

BigQuery Legacy SQL不支持WITH