ERROR 8617: Request size too big (MaxParsedQuerySizeMB)
I have a problem with selecting data from table which contains varchar (64000) records.
select start_timestamp, request, ... from projection_used where start_timestamp > '...' ERROR 8617: Request size too big DETAIL: Total allocated memory (MiB) = 1024.006 is about to exceed limit imposed by MaxParsedQuerySizeMB (MiB) = 1024.000
Column "request" has the type varchar (64000)
Every hour we save new records from query_requests and dc_projection_used to a regular table. And then we make extracts from the table for technical analysis.
Everything worked fine for over a year (9.0, 9.1), but after upgrading to 9.2 there was a problem.
If the incremental extract contains more than 200k-400k records, then this leads to problems with the MaxParsedQuerySizeMB value = 1 GB
I tried to increase the value, but with a large interval of data (29M records) this stops helping even with 16GB
Vertica version is v9.2.0-0 CE