I upgraded my SciDB from 16.9->18.1 and I faced some issues.
One of the issue is regrid aggregate operation.
It really worked fine in previous version of SciDB, but now the query using the regrid is failed.
For example, when I execute query like below:
4, 4, 4, 1,
The SciDB returns error like this:
UserException in file: src/array/MemChunk.cpp function: writeItem line: 990
Error id: scidb::SCIDB_SE_OPERATOR::SCIDB_LE_CHUNK_TOO_LARGE
Error description: Operator error. Attempt to create chunk of size 134217744 which exceeds configured limit (128 MiB).
Failed query id: 0.1544147533281230523
But I can’t understand that the regrid operator produces larger size of chunk then the ARRAY_A (original array).
As the regrid operator builds subarrays and performs aggregation on them, I expect that the size of the chunk will be reduced then the original array.
I insert the data in ARRAY_A using the redimension operator and it works fine.
How can I fix it?
The detail of ARRAY_A is:
AFL% aggregate(ARRAY_A, COUNT(*));