By default VectorH rejects queries that exhaust all available work memory. If you are unable to increase the memory available to such queries, it is possible to enable disk for use as temporary query space, at the cost of slowing down execution for those queries that need it. See the “spilling to disk” options described in the User Guide.