Row limit for Hyper Extracts?

Hello,

I have tried generating .hyper extracts for two separate tables with over 500 Million records and both extracts ended up with 238,212,877 rows. Has anyone else come across this limitation? Is there a workaround or a fix in the horizon?

Thanks,
Carlos

Output

Accepted answers

BenMoss

Never heard of this being an issue (though it was only released the other day).

Could you share more details about the file.

How many cells does it actually have (i.e. columns *rows). What size of file is it generating?

All comments

BenMoss

cfernand77

Screen Shot 2018-03-16 at 8.55.58 AM.png

cfernand77

Hi Ben,

I attached a screen grab with the file sizes (approximately 3.2 GB each). Did the math and the number of cells in the files generated is 4,287,831,786 . Guessing the difference in file size has to do with the fact some of the fields have the same value (-1) for every record in one of the files. Either way, I'm expecting each of these extracts to be closer to 500 - 600M records.

*** Note for Alteryx Team: The main reason we are interested in .hyper extracts is the potential for being able to migrate some of our dashboards (ones with several hundred million records) from the DB to extracts. Having this row limit for extracts from Alteryx is a major roadblock.

Thanks,

Carlos

cfernand77

Turns out this was as user error.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703