Error from DBI library with IMPALA

[martinocrippa]

Hi everybody,
i'm using DBI with Clouder Impala odbc 64 bit, to get data.

# libreries
suppressPackageStartupMessages(library("DBI"))
suppressPackageStartupMessages(library("tictoc"))
suppressPackageStartupMessages(library("skimr"))
suppressPackageStartupMessages(library("dplyr"))
suppressPackageStartupMessages(library("dbplyr"))
suppressPackageStartupMessages(library("lubridate"))
suppressPackageStartupMessages(library("stringr"))
suppressPackageStartupMessages(library("tidyr"))

# open impala connection
conHD <- DBI::dbConnect(odbc::odbc(),
                        SERVER_NAME_HDP,
                        uid = userIdHdp,
                        pwd = passwordHdp)
# query definition
query <- "select * from dwh.dwh.tbl_dati_invii;"
# execute query
TBL_DATI_INVII_P <- DBI::dbGetQuery(conHD,
                                    query ) %>%
    as_tibble()

sometimes Impala odbc return:

>
Error in result_fetch(res@ptr, n, ...) : 
  nanodbc/nanodbc.cpp:2525: 08S01: [Cloudera][ImpalaODBC] (120) Error while retrieving data from in Impala: [08S01] : SSL_read: error code: 0 
>
Warning message:
In dbClearResult(rs) : Result already cleared

there's some check to solve the problem? my it departmente say that "there'snt network problem".

Machine setting:

> print(sessionInfo())
R version 3.5.3 (2019-03-11)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows Server x64 (build 14393)

Matrix products: default

locale:
[1] LC_COLLATE=Italian_Italy.1252  LC_CTYPE=Italian_Italy.1252    LC_MONETARY=Italian_Italy.1252 LC_NUMERIC=C                   LC_TIME=Italian_Italy.1252    

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

other attached packages:
[1] tidyr_1.0.0     stringr_1.4.0   lubridate_1.7.4 dbplyr_1.4.2    dplyr_0.8.3     skimr_1.0.7     tictoc_1.0      DBI_1.0.0      

loaded via a namespace (and not attached):
 [1] Rcpp_1.0.2       rstudioapi_0.10  magrittr_1.5     hms_0.5.1        odbc_1.1.6       bit_1.1-14       tidyselect_0.2.5 R6_2.4.0         rlang_0.4.0      blob_1.2.0      
[11] tools_3.5.3      bit64_0.9-7      assertthat_0.2.1 tibble_2.1.3     lifecycle_0.1.0  crayon_1.3.4     purrr_0.3.2      vctrs_0.2.0      zeallot_0.1.0    glue_1.3.1      
[21] stringi_1.4.3    compiler_3.5.3   pillar_1.4.2     backports_1.1.4  pkgconfig_2.0.3 
> 

thanks in advance
have nice day

MC

[Rodrigue]

Hi,

I think you miss the Driver and the port; something like this:

con <- DBI::dbConnect(odbc::odbc(),
                      Driver = "[your driver's name]",
                      Host   = "[your server's path]",
                      Schema = "[your schema's name]",
                      UID    = rstudioapi::askForPassword("Database user"),
                      PWD    = rstudioapi::askForPassword("Database password"),
                      Port   = 21050)

See Rstudio doc about it:

Apache Impala from R

Hope this help

[martinocrippa]

Thank you very much for the response, but connection work without problem
Sometimes the connection fall down, return:

Error in result_fetch(res@ptr, n, ...) : 
  nanodbc/nanodbc.cpp:2525: 08S01: [Cloudera][ImpalaODBC] (120) Error while retrieving data from in Impala: [08S01] : SSL_read: error code: 0 

i try to reduce row numbers but i have the return error message randomly.
thanks