我试图使用bigrquery和dbplyr获取 (即与lubridate::week()相同,即library(dbplyr)# [1] 32到目前为止我尝试过的transactionsgot keyword AS at [1:54] [invalidQuery]
In addition: Warni
,date_purchased FROM zen_orders WHERE orders_status IN (3,48,49,53)和‘+ dataInicial +’和‘+dataFinal’之间的last_modified);
您的SQL语法中有一个错误;请查看与您的MySQL服务器版本对应的手册,了解要在第1行(linha 12)的'00:00:00 AND 2012-11-02 22:00:00‘附近使用的正确语法