我使用这个查询来检查BigQuery的使用情况
SELECT
job_id,
user_email,
xx.project_id,
query,
creation_time,
cache_hit,
TIMESTAMP_DIFF(end_time,start_time,MILLISECOND)/1000 AS duration,
SUM(total_bytes_processed/1000000000) AS GB,
SUM(total_bytes_billed/1000000000) AS GB_billed,
ARRAY_TO_STRING(ARRAY_AGG(authorTable.table_id), '--') AS base_table,
FROM
`region-asia-northeast1`.INFORMATION_SCHEMA.JOBS_BY_PROJECT xx
CROSS JOIN
UNNEST(referenced_tables) AS authorTable
GROUP BY
1,
2,
3,
4,
5,
6,
7当我删除交叉连接时,cache_hit返回正确的结果( false和true),但是当我重新添加它时,所有的缓存命中都变成了false?
发布于 2021-03-24 18:46:35
我打开了一个bug报告,解决方案是将交叉连接替换为左连接
https://stackoverflow.com/questions/66757909
复制相似问题