Using Vertica to store files
We're thinking to store extracted files in Vertica. We'll be extracting a huge number of files in Vertica and planning to store files chunks in Vertica in a table. The chunk can be stored in the BLOB data type, and each file may go into multiple rows if it can't fit in a single row. We're not sure how Vertica will handle it? Will it be bad to use Vertica in this use case?
Do you know if anyone has used Vertica in such a way?