The 1st column is returned as a list, but no values returned. But data exported from the same query through console are correct. Any help to correct this problem is appreciated.
o_bigrdownload <- bq_table_download(bq_dataset_query(
"mydatasets.x",
"select * from t limit 10",
destination_table = NULL,
billing = NULL,
quiet = NA,
bigint=c("integer64")
),page_size = 100)
str(o_bigrdownload)
Classes ‘tbl_df’, ‘tbl’ and 'data.frame': 10 obs. of 4 variables:
key :List of 10 .. :List of 1
.. .. map:List of 1 .. .. .. :Classes ‘tbl_df’, ‘tbl’ and 'data.frame': 0 obs. of 2 variables:
.. .. .. .. key : chr .. .. .. .. value: chr
.. :List of 1 .. .. map:List of 1
.. .. .. :Classes ‘tbl_df’, ‘tbl’ and 'data.frame': 0 obs. of 2 variables: .. .. .. .. key : chr
.. .. .. .. value: chr .. :List of 1
.. .. map:List of 1 .. .. .. :Classes ‘tbl_df’, ‘tbl’ and 'data.frame': 0 obs. of 2 variables:
.. .. .. .. key : chr .. .. .. .. value: chr
.. :List of 1 .. .. map:List of 1
.. .. .. :Classes ‘tbl_df’, ‘tbl’ and 'data.frame': 0 obs. of 2 variables: .. .. .. .. key : chr
.. .. .. .. value: chr .. :List of 1
.. .. map:List of 1 .. .. .. :Classes ‘tbl_df’, ‘tbl’ and 'data.frame': 0 obs. of 2 variables:
.. .. .. .. key : chr .. .. .. .. value: chr
.. :List of 1 .. .. map:List of 1
.. .. .. :Classes ‘tbl_df’, ‘tbl’ and 'data.frame': 0 obs. of 2 variables: .. .. .. .. key : chr
.. .. .. .. value: chr .. :List of 1
.. .. map:List of 1 .. .. .. :Classes ‘tbl_df’, ‘tbl’ and 'data.frame': 0 obs. of 2 variables:
.. .. .. .. key : chr .. .. .. .. value: chr
.. :List of 1 .. .. map:List of 1
.. .. .. :Classes ‘tbl_df’, ‘tbl’ and 'data.frame': 0 obs. of 2 variables: .. .. .. .. key : chr
.. .. .. .. value: chr .. :List of 1
.. .. map:List of 1 .. .. .. :Classes ‘tbl_df’, ‘tbl’ and 'data.frame': 0 obs. of 2 variables:
.. .. .. .. key : chr .. .. .. .. value: chr
.. :List of 1 .. .. map:List of 1
.. .. .. :Classes ‘tbl_df’, ‘tbl’ and 'data.frame': 0 obs. of 2 variables: .. .. .. .. key : chr
.. .. .. .. value: chr col2 : chr "xxxxxxx" "yyyyyyyyyyy" "zzzzzzzzzzzzz" "aaaaaaaaa" ...
value2: num 12 12 12 12 12 12 12 12 12 12 id : chr "1001" "1001" "1001" "1001" ..
sessionInfo()
R version 3.6.2 (2019-12-12)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 10 x64 (build 17763)
Matrix products: default
locale:
[1] LC_COLLATE=English_United States.1252 LC_CTYPE=English_United States.1252 LC_MONETARY=English_United States.1252
[4] LC_NUMERIC=C LC_TIME=English_United States.1252
attached base packages:
[1] stats graphics grDevices utils datasets methods base
other attached packages:
[1] RCurl_1.98-1.2 base64_2.0 microbenchmark_1.4-7 expm_0.999-6 Matrix_1.2-18 DBI_1.1.0 here_0.1
[8] httr_1.4.1 bigrquery_1.3.2 jsonlite_1.6.1 ......