无法访问类型为ARRAY< STRUCT< hitNumber INT64，时间INT64，小时INT64，...>的Big Query中的字段. [英] Cannot access field in Big Query with type ARRAY<STRUCT<hitNumber INT64, time INT64, hour INT64, ...>>

问题描述

我正在尝试在BigQuery上使用标准SQL方言(即不是传统SQL)运行查询.我的查询是:

I'm trying to run a query using Standard SQL Dialect (ie not Legacy SQL) on BigQuery. My query is:

SELECT
date, hits.referer
FROM `refresh.ga_sessions_xxxxxx*`
LIMIT 1000

但是请继续获取错误

Error: Cannot access field referer on a value with type 
ARRAY<STRUCT<hitNumber INT64, time INT64, hour INT64, ...>> at [2:12]

有人知道正确的语法吗?

Anyone know the proper syntax?

推荐答案

如果您正在寻找所有引荐来源-尝试

if you are looking for all referers - try

SELECT date, h.referer
FROM `refresh.ga_sessions_xxxxxx*`, UNNEST(hits) as h

这篇关于无法访问类型为ARRAY< STRUCT< hitNumber INT64，时间INT64，小时INT64，...>的Big Query中的字段.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！