Alteryx is not responding post data base connection

[adevnath]

Hello,

I am trying to connect Alteryx input with Hive data and for the same I have downloaded the ODBC driver and successfully tested connection over Alteryx. However post that as soon as I am clicking on connect tab workflow is going into NOT REPONDING mode.

Same error Screenshot I have attached here for reference. Let me know how I can fix this issue.

[apathetichell]

is it pausing at connect in-db for the first time? or during the initial creation of the connection name and info in Alteryx? If it it's the former -and if you have  a large amoun tof DB objects in your Hive - this may be normal. Can you give it 15-20 minutes? The initial Database object cache which happens the first time you take a connect in-db onto your canvas can take an extended amount of time - if you have a larger footprint in the db.

[adevnath]

Its not working with connect in-db as well. I have waited for more than 30 min for this. Prior to this I did try to set up a connection with input data  tool and  as I have mentioned early same thing happening with that too. While trying that I have waited for more than 3 hours, but it still did not respond.

As I understand it! my Hive data might be too large, which could be the reason its not working. Could you help me with this.

[apathetichell]

do you have network issues? how huge is your hive db? It should be number of db object/not size of the db. I don't have too much experience with hive specifically @simonaubert_bd is the local community hive expert - any advice on this?

[adevnath]

Based on my understanding this hive sever consist multiple tables.

I have establish  a connection is my local ODBC driver in my system and same connection I have tested in Alteryx. Both tool[ODBC driver and Alteryx] test connections are successful but after that as soon as I am clicking to connect it to input data tool / connect in db particular workflow is going into not responding mode.

Am I doing it correct or I can try other work-around. I did basic troubleshooting such as increasing virtual memory of the system, limiting auto run mode from option tab in Alteryx, still its not working. Let me know what you think.

[apathetichell]

When you say virtual memory of your system - are you on a mac? When you say driver in odbc - is it a 32 bit driver? If so - this will not work. a 32 bit driver is compatable with mac architecture but not Alteryx. Alteryx (and most other systems) require 64 bit drivers which are not supported by ARM chips. 

If that's not the case - turn on logging in your odbc - set a log directory. capture your logs. look at your logs.

[adevnath]

No ,  I have 64 Bit machine  and ODBC for the same. Also I am using Windows system.

[apathetichell]

Cool - it's worth checking on your logs.

[adevnath]

Its empty. As I have mentioned as soon as I am clicking connect tab workflow going into not responding mode. Error may come once I am able to run the workflow post connection.

[apathetichell]

Not your Alteryx logs - your ODBC driver logs.