Error while retrieving data from in Impala

[tanvir_khan]

Hi all:

I'm receiving an error while extracting data from Impala. I've created 5 input nodes due to large data volume (60 days data) and it works fine for the first 4 nodes but always fails for the last one (Tool Id: 113).

I'm using Coludera ODBC driver for Impala and there's no problem with it as other workflows are working fine.

Can anyone advise me in this regard?

Error SQLExtendedFetch: [Cloudera][ImpalaODBC] (120) Error while retrieving data from in Impala: [08S01] ImpalaThriftAPICallFailed (Tool Id: 113)

thanks in advance,

tanvir

[BrandonB]

From this thread on the Cloudera forums it looks like "Each Impala Daemon can only accept a finite total number of active client connections, which is likely what you are running into.": https://community.cloudera.com/t5/Support-Questions/Error-message-from-ODBC-connection/td-p/89507 

[tanvir_khan]

Hi @BrandonB 

I've seen that thread but I don't think in may case multiple input nodes are trying simultaneously because it runs one after another. i.e. one starts loading data when another one completes the task. But I'm not sure these Alteryx nodes disposes connections right after finishing or keeps it open for sometime. Is there anyway to dispose connection forcefully? 

thanks!

[calldk50]

here is the solutions-

please refer this link

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Error-SQLExtendedFetch-Cloudera-Impala...

[KO-Ken]

Followed instructions linked above, solved my issue with ImpalaThriftAPICallFailed error.