我想在BQ上的两个分区(不同的分区日期(上进行一些查询。
表格格式如下
crm_id, attribute#1, attribute#2,attribute#3
对于第 1 周和第 2 周常见的 ID,我想看看有多少更改的属性 #1、属性 #2 和属性 # 3
我从内部连接开始,使用:
WITH t1 AS
(SELECT crm_id AS w1_crm
FROM `table`
WHERE DATE(_PARTITIONTIME) = "date1"
)
SELECT crm_id
FROM `table`
WHERE DATE(_PARTITIONTIME) = "date2"
INNER JOIN
t1
ON
w1_crm = crm_id
我在内部连接上收到错误
试试下面
WITH t1 AS (
SELECT crm_id AS w1_crm
FROM `table`
WHERE DATE(_PARTITIONTIME) = "date1"
), t2 AS (
SELECT crm_id
FROM `table`
WHERE DATE(_PARTITIONTIME) = "date2"
)
SELECT crm_id
FROM t2
INNER JOIN t1
ON w1_crm = crm_id