ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

ERROR SSL_read in ImpalaODBC while refreshing tables from ALteryx SQL Prepare

cse_victor
5 - Atom

Recently we have been "randomly" receiving and inpalaODBC error in our batch jobs while refreshing our tables using Alrteryx SQL prepare. The ERROR is shown only in the Workflow log, when we review the query history in claudera, all the refresh table statements were successful. 

The error is:

Error SQLPrepare: [Cloudera][ImpalaODBC] (450) Error when calling the Impala Thrift API ExecuteStatement: SSL_read: error code: 0

 

PaulNo
10 - Fireball

Hi @cse_victor,

 

Thank you for posting. 

 

From ODBC Data Source Administrator, could you please provide:

 

- the version of your Impala driver (at the bottom of the window when you click on "Configure" for your driver entry)

- a screenshot of your Advanced Options for your driver settings

 

I would suspect either an issue with the driver itself (solved by a reinstall, or an update) or a timeout problem, depending on your volume of data.

 

The versions of the driver tested by Alteryx are available here: https://help.alteryx.com/current/designer/apache-impala 

 

Best,

 

PaulN