Problem with opening AVRO file

Question

Hi all, I'm trying to open a 36MB AVRO file in the Input Data tool but Alteryx would hang after that...it was not responding after 20-30 minutes and I had to terminate the Alteryx process.  The Input Data tool was able to open a smaller sample file (60KB).  I'm using Alteryx v 2022.3.1.486 Patch 3.  Thanks for any advice in advance!

JohnL248 · Answer

@apathetichell , thank for your suggestion!  The avro file is already on my local c: drive and AMP has been turned off.  Alteryx is still frozen after almost one hour.  Unfortunately I can't downgrade the Alteryx version since this is a company installation.

apathetichell · Answer

Is this file on a local drive - if not - place it on a local drive and then retry.

next issue - turn off amp - let's see if there is another error which amp isn't allowing to be flagged.

finally - downgrade Alteryx.I just ran a 100,000,000 row multi-gb file in 2021.4.

update! just remembered that I had 2022.3 on my system from an earlier test. I'll see if I can get the same file to load in 2022.3. so without AMP it ran - but then had some issues when I went back to the input data tool I'd recommend downgrading to 2022.1 or 2021.4.

JohnL248 · Answer

thanks for your suggestion, @amadra !  I have a python script already to read the avro file.  I'm hoping to do that in Alteryx to perform additional data analytics.