在BigQuery,标准SQL中,如何在多个表上使用_TABLE_SUFFIX?请参见示例:
select *
from `table1.*` t1
left join `table2.*` t2 on t1.lel=t2.lel
where _TABLE_SUFFIX between '2017-01-01' and '2017-01-02' <--- this can't be used 我是不是必须先创建一个应用了table_suffix的table2的子查询?
https://stackoverflow.com/questions/44495014
复制相似问题