DynamoDBtoCSV icon indicating copy to clipboard operation
DynamoDBtoCSV copied to clipboard

Result was on the console for huge records

Open tharun06 opened this issue 8 years ago • 8 comments

For small tables it worked fine and when I tried on a table around 50,000 rows the output was on the console and csv file was empty.

tharun06 avatar Oct 12 '17 14:10 tharun06

I no longer have access to a dynamodb access. When I did, it was millions of rows long so I am surprised. If do get access to a large db again, I'll look into this.

edasque avatar Oct 12 '17 15:10 edasque

I am facing same issue. Unable to fetch 65000 records from same table.

shubho-acc avatar Feb 13 '18 11:02 shubho-acc

Are you though? Do you see the output on the console?

edasque avatar Feb 13 '18 12:02 edasque

No i dont see any error or log, i had to wait for like couple of mints but when i saw output file it was blank. I tested on 8GB server.

shubho-acc avatar Feb 13 '18 13:02 shubho-acc

Why not migrate to using a dataFrame and exporting to .csv from there. (most libraries have 'low memory' flag to avoid loading everything into memory)

PS: I'm a python guy so here is my little contribution

ghost avatar Mar 08 '18 15:03 ghost

@shubho-acc @tharun06 This is related to changes I made to be able to handle tables where the "schema" is not fixed. Essentially we have to read all the records to be able to figure out what the headers should be. We can create a new mode where if you know the schema is fixed, then the output can be streamed as we receive them, rather than being stored in memory, which is what is causing the problem. Reply to this thread if you're still interested in seeing a fix for this.

tcchau avatar Mar 08 '18 16:03 tcchau

@tcchau Why not add a simple flag for fixed schema that would just read the schema on the first line and generate based on that

ghost avatar Mar 08 '18 17:03 ghost

@MarcoPorracin Yes, that's exactly what I mean. The new mode of operation would be triggered by the flag.

tcchau avatar Mar 08 '18 17:03 tcchau