SemanticException [Error 10004]: line 14:13 Invalid table alias or column reference ‘a‘: .....

原查询如下：

with table1 as 
(SELECT
    a.mid,
    a.summary_time as summary_time
FROM
    hst_dwd.dwd_member_consume_info a,
    hst_dwd.dwd_business_info b
WHERE
    a.business_id = b.business_id
AND a.market_id = 218
AND b.type_id = 4
)

select count(a.mid) from table1  where summary_time BETWEEN date_sub(summary_time,7) and date_sub(summary_time,1) 

报错信息如下：

 修改查询如下：

with table1 as 
(SELECT
    a.mid,
    a.summary_time as summary_time
FROM
    hst_dwd.dwd_member_consume_info a,
    hst_dwd.dwd_business_info b
WHERE
    a.business_id = b.business_id
AND a.market_id = 218
AND b.type_id = 4
)

select count(a.mid) from table1 a where summary_time BETWEEN date_sub(summary_time,7) and date_sub(summary_time,1) 

别比对了，忘记别名，就这儿....