Error while retrieving data from in Impala

Question

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

KO-Ken · Answer

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

calldk50 · Answer

here is the solutions-

please refer this link

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Error-SQLExtendedFetch-Cloudera-ImpalaODBC-120-Error/m-p/930071

tanvir_khan · Answer

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!