Google BigQuery< EOF>中的错误 [英] Error in Google BigQuery <EOF>
本文介绍了Google BigQuery< EOF>中的错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我是Google BigQuery的新手。我需要查询错误的帮助:
I am new to Google BigQuery. I need help with the query error:
在第1行第1列遇到 WITH带有,期望:
EOF
"Encountered " "WITH" "with "" at line 1, column 1. Was expecting: EOF"
with
t1 as
(
select
date(USEC_TO_TIMESTAMP(event_dim.timestamp_micros)) date, event_dim.name
from
[myfoody-1313:it_rawfish_myfoody_ANDROID.app_events_20160727]
where
event_dim.name='pv_detail' and event_dim.params.key='item_id' and
event_dim.params.value.string_value='31'
)
select
date(d) as day, count(event_dim.name)
from
generate_series(current_date - interval '6 day', current_date, '1 day') d
left join t1 on t1.date = d
group by day
order by day;
推荐答案
我需要帮助查询错误:在行
1的第1列中遇到有带,期望:EOF
I need help on a query error: "Encountered " "WITH" "with "" at line 1, column 1. Was expecting: EOF"
BigQuery Standard SQL支持WITH-请参见启用标准SQL -您应启用标准SQL
WITH is supported for BigQuery Standard SQL - see Enabling Standard SQL - you should enable Standard SQL
这篇关于Google BigQuery< EOF>中的错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文