Support Questions
Find answers, ask questions, and share your expertise

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

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

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

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

Rising Star

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

New Contributor

Hello @tusharkathpal 

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


rstudio.JPG

Rising Star

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.

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

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.