Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Error SQLExtendedFetch:Cloudera ImpalaODBC 120 Error

calldk50
5 - Atom

Hi All,

when i tried to run query in Alteryx Designer thru input tools, i founded this error-

Error SQLExtendedFetch:Cloudera ImpalaODBC 120 Error

 

calldk50_1-1650607409769.png

 

Solutions: getting the solution after tried more-

1: open the ODBC data sources 64 bit

2: default page in user DSN- select the ODBC driver for impala

3:click on config- advance options

4: Rows fetched per block- increase the size 

Socket Timeout- increase the size

String Column Length - increase the size

then ok -ok-ok

calldk50_0-1650607254007.png

 

and your issue resolved now!!!

 

Thanks

calldk50

1 REPLY 1
  • Hi i'm facing this error now while loading data from impala. I tried your solution but didn't worked. Can you please let me know why it's not working.
Labels