|
Answer» When a SELECT statement fails, the cause usually FALLS into one of the FOLLOWING categories:
- A timeout because of a performance, capacity, or network issue affecting one particular NODE.
- Excessive memory use for a join query, resulting in automatic cancellation of the query.
- A low-level issue affecting how native code is generated on each node to handle particular WHERE clauses in the query. For example, a MACHINE instruction could be generated that is not supported by the processor of a certain node. If the error MESSAGE in the log suggests the cause was an illegal instruction, consider turning off native code generation temporarily, and trying the query again.
- Malformed input data, such as a text data file with an enormously long line, or with a delimiter that does not match the character specified in the FIELDS TERMINATED BY clause of the CREATE TABLE statement.
When a SELECT statement fails, the cause usually falls into one of the following categories:
|
