This topic provides solutions to some common errors in SQL queries.
This section provides troubleshooting for the
CREATE MAPPING statement.
You cannot create mappings to local files in the parquet format.
Hazelcast cannot read the file format that you’re trying to map to. This error could be thrown because you are using the slim distribution of Hazelcast Platform, which doesn’t come with the ability to read the file format by default.
Use the full distribution of Hazelcast Platform or find the missing module and add it to your cluster members' classpaths.
Hazelcast cannot read from the specified file system.
To read from some file systems, you must add additional modules to your cluster members' classpaths. See Supported file systems.
This section provides troubleshooting for using JSON in SQL.
The JsonPath is matching multiple values, which results in invalid JSON.
If the JsonPath expression can match multiple values in some edge cases, add a wrapper, such as the
WITH CONDITIONAL ARRAY WRAPPER clause, to wrap the matches in an array.
The JsonPath in your query is invalid.
Check the supported JsonPath syntax.
If you find that your queries lead to out of memory exceptions (OOME), consider decreasing the value of the Jet engine’s maxProcessorAccumulatedRecords option, or reduce the number of concurrently running queries.