Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
New Contributor

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

 

6 REPLIES 6

avatar
New Contributor

PROBLEM SOLVED!

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

 

SCRSHT_cloudera_advance_options_timeout.png

avatar
New Contributor
Hello
Can i know where did you find these parameters please?
 
BR!!
 

avatar
Expert Contributor

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

avatar
New Contributor

Hello @tusharkathpal 

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


rstudio.JPG

avatar
Expert Contributor

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.

avatar
New Contributor

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!!