BigRquery将不会连接，并且错误消息为空

问题描述

我试图利用R中的'bigrquery'库将R连接到我们的大型查询数据库。当我在R studio的本地安装副本上运行时，我没有任何问题，但是当我在运行R Studio Server的服务器上运行它时，我从query_exec命令中收到奇怪的错误消息。我将粘贴以下代码：

  library（bigrquery）
 project ='projectIdentifier'
 sql< ;  - SELECT * FROM [bradWorking.bradTempTable] WHERE f0_> ='2015-10-22'AND f0_< ='2015-11-01'
 data<  -  query_exec（query = sql， project = project，max_pages = Inf，destination_table ='bradWorking.bradTempTable2'）
错误：
  

之前我从来没有看到错误，只是说'错误'。有没有人有任何建议来找出发生了什么事？这可能与我正在使用的libssl有关吗？

以下是来自R /

<$ p $的系统信息p> > sessionInfo（）
R版本3.2.3（2015-12-10）
平台：x86_64-pc-linux-gnu（64位）
运行于：Ubuntu 14.04.3 LTS

locale：
[1] LC_CTYPE = en_CA.UTF-8 LC_NUMERIC = C
[3] LC_TIME = en_CA.UTF-8 LC_COLLATE = en_CA.UTF-8
[5] LC_MONETARY = en_CA.UTF-8 LC_MESSAGES = en_CA.UTF-8
[7] LC_PAPER = en_CA.UTF-8 LC_NAME = C
[9] LC_ADDRESS = C LC_TELEPHONE = C
[11] LC_MEASUREMENT = en_CA.UTF-8 LC_IDENTIFICATION = C

附加基础软件包：
[1] stats graphics grDevices utils数据集方法
[7] base

其他附加软件包：
[1] bigrquery_0.1.0

通过名称空间加载（并未附加）：
[1] httr_1.1.0 magrittr_1。 5 R6_2.1.2
[4] assertthat_0.1 parallel_3.2.3 DBI_0.3.1
[7] tools_3.2.3 dplyr_0.4.3 curl_0.9.5
[10] Rcpp_0.12.3 jsonlite_0.9.19 openssl_0 0.9 .1


谢谢

解决方案

我对bigrquery不是很熟悉，但看起来这可能是bigrquery和httr 1.1.0之间的不兼容：

I'm trying to make use of the 'bigrquery' library in R to connect R to our big query databases. When I run this on a locally installed copy of R studio I don't have any problems, but when I'm running it on a server running R Studio Server I get a strange error message from the query_exec command. I will paste the code below:

library(bigrquery)
project = 'projectIdentifier'
sql <- "SELECT * FROM [bradWorking.bradTempTable] WHERE f0_ >= '2015-10-22' AND f0_ <= '2015-11-01'"
data <- query_exec(query = sql, project=project, max_pages = Inf, destination_table = 'bradWorking.bradTempTable2')
Error:

I have never seen an error before that simply states 'Error'. Does anyone have any suggestions for ways to figure out what's going on? Could this be related to the libssl that I'm using?

Here's the system information from R

> sessionInfo()
R version 3.2.3 (2015-12-10)
Platform: x86_64-pc-linux-gnu (64-bit)
Running under: Ubuntu 14.04.3 LTS

locale:
 [1] LC_CTYPE=en_CA.UTF-8       LC_NUMERIC=C
 [3] LC_TIME=en_CA.UTF-8        LC_COLLATE=en_CA.UTF-8
 [5] LC_MONETARY=en_CA.UTF-8    LC_MESSAGES=en_CA.UTF-8
 [7] LC_PAPER=en_CA.UTF-8       LC_NAME=C
 [9] LC_ADDRESS=C               LC_TELEPHONE=C
[11] LC_MEASUREMENT=en_CA.UTF-8 LC_IDENTIFICATION=C

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods
[7] base

other attached packages:
[1] bigrquery_0.1.0

loaded via a namespace (and not attached):
 [1] httr_1.1.0      magrittr_1.5    R6_2.1.2
 [4] assertthat_0.1  parallel_3.2.3  DBI_0.3.1
 [7] tools_3.2.3     dplyr_0.4.3     curl_0.9.5
 [10] Rcpp_0.12.3     jsonlite_0.9.19 openssl_0.9.1

Thanks

解决方案

I am not very familiar with bigrquery, but it looks like this could be an incompatibility between bigrquery and httr 1.1.0: https://github.com/rstats-db/bigrquery/issues/86

这篇关于BigRquery将不会连接，并且错误消息为空的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！