如何在BigQuery中声明列表类型变量,以便可以在where子句中使用它?我有这个代码
WITH
subquery AS (
SELECT
1 AS col1
UNION ALL
SELECT
2 AS col1
UNION ALL
SELECT
3 AS col1 )
SELECT
col1
FROM
subquery
WHERE
col1 IN (1, 2)
相反,我想用查询中的变量来说明问题
DECLARE list ARRAY;
SET list = (1,2);
WITH
subquery AS (
SELECT
1 AS col1
UNION ALL
SELECT
2 AS col1
UNION ALL
SELECT
3 AS col1 )
SELECT
col1
FROM
subquery
WHERE
col1 IN list
我尝试了DECLARE列表STRUCT [小于] int64,int64 [大于]它不接受
尝试以下代码:
DECLARE list ARRAY <INT64>;
SET list = [1,2];
WITH
subquery AS (
SELECT
1 AS col1
UNION ALL
SELECT
2 AS col1
UNION ALL
SELECT
3 AS col1 )
SELECT
col1
FROM
subquery
WHERE
col1 IN UNNEST(list)
是的,谢谢。我很难理解数组和结构。有什么好的资源吗?
您可以在以下链接中找到有关此信息的有用信息: cloud.google.com/bigquery/docs/reference/standard-sql/…