ERROR SSL_read: error code: 0 with IMPALA from R programming with DBI LIBRARY

[#1]

Hi Everybody,

i'm using with R programming the library DBI (developed by Rstudio) that used impala obbc 64-bit.

Sometimes impala return data and sometimes connection fall down and R give to me:

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 

 how check i can make to solve the problem? 

thank in advance

have nice day

MC

[#2]

PROBLEM SOLVED!

it's problem about timeout parameters and rows fetched blocks, eith long running query connection fall down!

[#3]

Hello

Can i know where did you find these parameters please?

BR!!

[#4]

Hello @Moudma 

Open the ODBC application in Windows and click on any one of the DSN and further click on Advanced Options... to get the above window.

Regards,

Tushar

[#5]

Hello @tusharkathpal 

I am using Rstudio web so do not need to configure ODBC on windows.

[#6]

Hello @Moudma 

Rstudio is an application which I guess might be running on windows or mac OS. On these OS you will be downloading the ODBC application where you configure the DSN parameters. Under that configuration only, there is an Advanced Option where you will find the properties.

[#7]

Hello @tusharkathpal 

What i mean that i am not using an application but web link.

My rstudio web server is running on linux et the client is connecting with http://IP_ADDRESS:8787/.

Thanks.

BR!!