Cannot allocate sufficient memory for COPY statement (536870912 requested, 268435456 permitted)
What I have:
Vertica Community Edition on Ubuntu (Single node, 32 GB)
I am Community Edition user of Vertica. I am loading the JSON file like:
_CREATE EXTERNAL TABLE customers(id INT, address VARCHAR, transactions ARRAY[INT]) AS COPY FROM 'cust.json' PARSER fjsonparser();_
The table is also being successfully copied with all the data with all of the 6 Million rows.
When I am running a simple
select count(*) statement, I am getting the above error (title). This error isn't occurring on a table with 200,000 rows or 800,000 rows.
I have also referred to this link regarding the same error:
Even when I increase the memory size of the unsuccessful query's resource pool, I am facing the same error.
Is there anything additional that needs to be ensured in order to have a successful run?
Any help will be appreciated.