MySQL :: HeatWave User Guide :: 11.1.2 MySQL HeatWave Errors

Error number: 1001; Symbol: HW_ER_CHANGE_PROP

Message: Errors detected while propagating changes - %s.

Description: The change propagation operation was not completed successfully.

Workaround: Retry the operation. If the issue persists, reload the table and retry the query with use_secondary_engine session variable set to FORCED.

Error number: 1002; Symbol: HW_ER_INCOMPATIBLE_FUNC_ARGS

Message: Incompatible arguments, ['%s', '%s'], for function, [%s].

Description: This function does not support arguments of the specified data types.

Workaround: Modify the function arguments to use supported data types. If an error occurs with an ENUM argument, use a different data type. Refer to HeatWave documentation for valid function arguments.

Error number: 1003; Symbol: HW_ER_QUERY_SCN_TOO_OLD

Message: Query cannot be offloaded to HeatWave because the resized cluster does not have the required data version.

Description: The cluster lacks the necessary data version for query offloading.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1004; Symbol: HW_ER_QUERY_CANCELLED

Message: Query was canceled during HeatWave query optimization.

Description: The query was interrupted before completion.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1005; Symbol: HW_ER_UNSUPPORTED_QUERY_OPT

Message: Currently unsupported HeatWave query optimization scenario.

Description: This error occurs when the query compiler encounters an unsupported condition or clause, preventing it from generating a valid query execution plan.

Workaround: Rewrite the query to ensure HeatWave compatibility. For example, modify filter conditions or adjust projected columns.

Error number: 1006; Symbol: HW_ER_CLUSTER_OFFLINE

Message: Network error - HeatWave cluster is not online.

Description: HeatWave cluster is unavailable.

Workaround: Start the HeatWave cluster and ensure it is online.

Error number: 1007; Symbol: HW_ER_INTERNAL

Message: HeatWave internal error - %s.

Description: This error happens due to internal issues in HeatWave during logical and physical transformation, though it is not limited to this scenario.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1008; Symbol: HW_ER_NOT_READY_FOR_REQUESTS

Message: HeatWave not in a ready state to handle client requests - %s.

Description: HeatWave plugin is not in the correct state.

Workaround: Verify that HeatWave plugin state is in the correct, ready state.

Error number: 1009; Symbol: HW_ER_QUERY_EXEC

Message: Error encountered during HeatWave query execution - %s.

Description: This error indicates issues such as memory limits, data type range violations, or interruption of the query by the user.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1010; Symbol: HW_ER_SUBQUERY_TRANSFORM

Message: The subquery, [%s], cannot be transformed into a semi-join, anti-join or derived tables.

Description: A problem occured during the logical transformation of the query.

Workaround: Add join conditions for each join, or consider rewriting the query.

Error number: 1011; Symbol: HW_ER_UNSUPPORTED_TYPE_IN_WHERE

Message: %s in WHERE clause, [%s] is not supported.

Description: The specified data type is not supported in the WHERE clause.

Workaround: Consider using a non-string or non-BIT type column in the WHERE clause condition.

Error number: 1012; Symbol: HW_ER_UNSUPPORTED_ARGS_IN_COND

Message: Unsupported arguments in condition, [%s] - %s.

Description: The specified functionality is not supported for these arguments.

Workaround: Please modify the expression to ensure the result is not a constant value. Alternatively, adjust the conditional expression by adding or removing arguments

Error number: 1013; Symbol: HW_ER_UNSUPPORTED_COND_TYPE

Message: The condition type, [%s], is not supported.

Description: The specified condition type is not supported in HeatWave.

Workaround: Use a supported condition type.

Error number: 1014; Symbol: HW_ER_UNSUPPORTED_FUNC_TYPE

Message: The function, [%s], is not supported.

Description: The specified function is not available in HeatWave.

Workaround: Use a supported function, or explore combining supported functions with other supported functions and/or expressions.

Error number: 1015; Symbol: HW_ER_UNSUPPORTED_DECIMAL_PRECISION_FOR_FUNC

Message: For the function, [%s], DECIMAL values with precision greater than 18 are not supported.

Description: The precision of the DECIMAL datatype may exceed HeatWave's supported limits for arithmetic operations.

Workaround: Use a datatype with precision not greater than 18.

Error number: 1016; Symbol: HW_ER_UNSUPPORTED_ARG_FOR_FUNC

Message: Unsupported argument, [%s], for function, [%s] - %s.

Description: HeatWave does not support the specified argument type for this function.

Workaround: Change the argument data type. Refer to HeatWave documentation for valid function arguments and data types.

Error number: 1017; Symbol: HW_ER_UNSUPPORTED_AGGREGATE_FUNC_WITH_VARCHAR_OR_BIT_INPUT

Message: The aggregate function, [%s], with VARCHAR or BIT input, [%s], is not supported.

Description: HeatWave does not support this aggregation function with VARCHAR or BIT input.

Workaround: Change the argument data type. Refer to HeatWave documentation for valid function arguments and data types.

Error number: 1018; Symbol: HW_ER_UNSUPPORTED_OUTPUT_TYPE_IN_FUNC

Message: The output data type, [%s], for the function, [%s], is not supported.

Description: HeatWave does not support this function with the specified output data type.

Workaround: Try casting the output to a different supported data type.

Error number: 1019; Symbol: HW_ER_UNSUPPORTED_AGGREGATE_FUNC

Message: Aggregate function, [%s], is not supported.

Description: HeatWave does not support this aggregation function.

Workaround: To achieve the same result as the aggregate function, rewrite the query using a subquery or use supported aggregation functions.

Error number: 1020; Symbol: HW_ER_UNSUPPORTED_TYPE_IN_PROJ

Message: Unsupported projection item, [%s].

Description: HeatWave is unable to project this item.

Workaround: Use the BIT column in an expression or cast it to a different data type.

Error number: 1021; Symbol: HW_ER_UNSUPPORTED_LATERAL_DERIVED_TABLE_VIEWS

Message: LATERAL views or derived tables are not supported - while processing %s.

Description: LATERAL views or derived tables are not supported.

Workaround: Consider using non-LATERAL table.

Error number: 1022; Symbol: HW_ER_UNSUPPORTED_CALC_FOUND_ROWS

Message: SQL_CALC_FOUND_ROWS and FOUND_ROWS are not supported.

Description: SQL_CALC_FOUND_ROWS and FOUND_ROWS deprecated.

Workaround: Refer to HeatWave documentation for SQL_CALC_FOUND_ROWS or FOUND_ROWS alternatives.

Error number: 1023; Symbol: HW_ER_UNSUPPORTED_TYPE_IN_GBY

Message: Expression, [%s], in GROUP BY key list is not supported.

Description: The specified data type is not supported in the GROUP BY key list.

Workaround: Modify the expression so that the resulting data type is not BIT. Alternatively, cast the result of the expression to a different data type. If there are precision issues, consider casting to a double or float type, or using a generic floating-point data type for the key.

Error number: 1024; Symbol: HW_ER_TABLE_NOT_LOADED

Message: The table, `%s`.`%s`, %s.

Description: Table is not available in HeatWave.

Workaround: Load the table using ALTER TABLE [table] SECONDARY_LOAD.

Error number: 1026; Symbol: HW_ER_UNSUPPORTED_AGG_OVER_ENUM

Message: Aggregation over an ENUM column is not supported in, [%s].

Description: HeatWave does not support this aggregation function with ENUM datatype.

Workaround: Only count, average, and sum are supported. Use a non-ENUM type for aggregation, or convert the enum to a numeric.

Error number: 1027; Symbol: HW_ER_CONFLICT_IN_OPTIMIZER_CONFIG

Message: HeatWave requires either the Hypergraph Optimizer or the Old Optimizer, but not both.

Description: Only one query optimizer can be used at a time.

Workaround: Use either the Hypergraph Optimizer or the Old Optimizer. Set session variable to use optimizers, SET rapid_use_old_optimizer = 'ON' or SET optimizer_switch= 'hypergraph_optimizer=on'.

Error number: 1028; Symbol: HW_ER_PLUGIN_NOT_READY

Message: HeatWave plugin is not in READY state, yet. Please wait and try again.

Description: For the HeatWave plugin to be usable, it must be in the correct state.

Workaround: Wait for plugin to be in READY state.

Error number: 1029; Symbol: HW_ER_UNEXPECTED_ITEM_TYPE

Message: Unexpected item, [%s] of type, [%s] - %s.

Description: A problem occurred during the logical transformation of the query.

Workaround: Wrap the item inside a function.

Error number: 1030; Symbol: HW_ER_UNSUPPORTED_RECURSIVE_QUERY_EXPRESSIONS

Message: Recursive query expression, [%s], is not supported.

Description: A problem occurred during the logical transformation of the query.

Workaround: Make the expression non-recursive.

Error number: 1031; Symbol: HW_ER_INVALID_JOIN_CONDITION

Message: You have not specified the condition for one of the tables involved in the join condition, [%s].

Description: Tables cannot be joined without a join condition.

Workaround: Add a join condition for each table involved in the join.

Error number: 1032; Symbol: HW_ER_NUM_PROJ_COLS_EXCEEDS_MAX_ALLOWED

Message: The number of projection columns, [%d], exceeds maximum supported columns, [%d].

Description: HeatWave supports projection of limited number of columns.

Workaround: Reduce the number of projected columns. Alternately, split and project the columns across multiple queries.

Error number: 1033; Symbol: HW_ER_FETCHING_NUM_ROWS

Message: Error fetching number of rows for `%s`.`%s`.

Description: The table statistics could be incorrect.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1034; Symbol: HW_ER_ITEM_NOT_FOUND

Message: No projectable field item found while compiling AccessPath for query block id, [%u].

Description: A problem occurred during the logical transformation of the query.

Workaround: Make sure that each query block projects a minimum of one column.

Error number: 1035; Symbol: HW_ER_UNSUPPORTED_DUAL_INPUT

Message: Projecting ['%s'], having input from both sides of a join, is not supported.

Description: A problem occurred during the logical transformation of the query.

Workaround: Ensure that join conditions and projections are specified. Retry the query.

Error number: 1036; Symbol: HW_ER_UNSUPPORTED_ACCESS_PATH_TYPE

Message: Unsupported AccessPath - %s.

Description: A problem occurred during the logical transformation of the query.

Workaround: Retry the query. If that doesn't help, try switching to a different optimizer.

Error number: 1037; Symbol: HW_ER_UNSUPPORTED_EXPR_IN_CORRELATED_SUBQUERIES

Message: The expression, [%s], is not supported for correlated subqueries.

Description: The specific functionality for correlated subqueries is absent in HeatWave.

Workaround: Simplify or modify the expression.

Error number: 1038; Symbol: HW_ER_INCOMPATIBLE_FUNC_ARG_ENCODINGS

Message: Incompatible argument encodings, ['%s', '%s'], for function, [%s].

Description: The encoding of function arguments must be correct.

Workaround: Use supported encoding. Refer to HeatWave documentation for function usage, argument data types and supported encodings.

Error number: 1039; Symbol: HW_ER_DUMMY_PROJ_ABSENT

Message: Could not find dummy projection for %s.

Description: A problem occurred during the logical transformation of the query.

Workaround: Verify that the SELECT list contains desired projection columns.

Error number: 1040; Symbol: HW_ER_FILTER_ACCESS_PATH_CONDITION

Message: Error in extracting required items from filter AccessPath's condition, [%s].

Description: A problem occurred during the logical transformation of the query.

Workaround: Modify the filter condition and retry the query.

Error number: 1041; Symbol: HW_ER_MISSING_ACCESS_PATH_TYPE

Message: AccessPath '%s' is absent - %s.

Description: A problem occurred during the logical transformation of the query.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1042; Symbol: HW_ER_TOPK_QKRN_CREATION

Message: Error - failed to process the sort operation with select limit [%s] and offset limit [%s].

Description: A problem occurred during the logical transformation of the query.

Workaround: Examine and fix any other errors that have been thrown for Top-K.

Error number: 1043; Symbol: HW_ER_ORDER_BY_LIMIT_OFFSET

Message: Error while handling ORDER BY / LIMIT [OFFSET] for Query_term_unary with select_number, [%u].

Description: A problem occurred during the logical transformation of the query.

Workaround: Examine and fix any other errors that have been thrown for ORDER BY.

Error number: 1044; Symbol: HW_ER_INCOMPATIBLE_FUNC_ARG_TYPES

Message: Incompatible argument types, [%d, %d], for function, [%s].

Description: The encoding of function arguments must be correct.

Workaround: Use supported types in function arguments. Refer to HeatWave documentation for function usage and argument data types and supported encodings.

Error number: 1045; Symbol: HW_ER_UNSUPPORTED_ACCESS_PATH_TYPE_WITHOUT_GBY

Message: '%s' without GROUP BY is not supported.

Description: A problem occurred during the logical transformation of the query.

Workaround: Use supported clause within GROUP BY.

Error number: 1046; Symbol: HW_ER_UNSUPPORTED_DERIVED_TABLE_WITHOUT_PROJ

Message: Derived table without projection not supported.

Description: A problem occurred during the logical transformation of the query.

Workaround: Project necessary columns from the derived TABLE/VIEW/CTE.

Error number: 1047; Symbol: HW_ER_EMPTY_BASE_FIELDS_IN_DERIVED_TABLE

Message: Base fields of a derived table should not have been empty.

Description: A problem occurred during the logical transformation of the query.

Workaround: Project necessary columns from the derived TABLE/VIEW/CTE.

Error number: 1048; Symbol: HW_ER_PROJECTION_OUT_OF_BOUNDS

Message: Projection from derived table or CTE is out of bounds.

Description: A problem occurred during the logical transformation of the query.

Workaround: Project necessary columns from the derived TABLE/VIEW/CTE.

Error number: 1049; Symbol: HW_ER_EMPTY_PROJ_LIST_IN_PARTIAL_PLAN

Message: Projection list should not be empty.

Description: Problem occured during logical transformation of query.

Workaround: The SELECT list should project at least one column.

Error number: 1050; Symbol: HW_ER_JOIN_ABSENT_AFTER_SET

Message: Join absent after SET operation - %s.

Description: Problem occured during logical transformation of query.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1051; Symbol: HW_ER_DISTINCT_AFTER_SET_FAILURE

Message: Failed to handle DISTINCT after SET operation.

Description: Problem occured during logical transformation of query.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1052; Symbol: HW_ER_ORDERBY_LIMIT_OFFSET_AFTER_SET_FAILURE

Message: Error while handling ORDER BY / LIMIT [OFFSET] after SET operation.

Description: Problem occured during logical transformation of query.

Workaround: Check and fix any more errors thrown for ORDER BY.

Error number: 1053; Symbol: HW_ER_UNION_TRANSLATION

Message: Error while translating UNION.

Description: Problem occured during logical transformation of query.

Workaround: Check if UNION is well formed. Check and fix any more errors thrown for SET operation.

Error number: 1054; Symbol: HW_ER_INTERSECT_EXCEPT_TRANSLATION

Message: Error while translating INTERSECT/EXCEPT - %s.

Description: Problem occured during logical transformation of query.

Workaround: Check if INTERSECT/EXCEPT is well formed. Check and fix any more errors thrown for SET operation.

Error number: 1055; Symbol: HW_ER_UNSUPPORTED_MATERIALIZE_TYPE

Message: Unsupported MATERIALIZE type.

Description: Problem occured during logical transformation of query.

Workaround: Try making a few little adjustments to various sections of the query.

Error number: 1056; Symbol: HW_ER_CANT_PROJ_WINDOW_FUNC_FROM_ZEROROWSAGG

Message: Cannot project a WINDOW function from ZeroRowsAggregated - '%s' (while processing [%s]).

Description: Problem occured during logical transformation of query.

Workaround: Set appropriate projections and aggregations for the WINDOW function.

Error number: 1057; Symbol: HW_ER_UNEXPECTED_NULL_JOIN

Message: Root-level UNION ALL - unexpected NULL JOIN under STREAM Access Path.

Description: Problem occured during logical transformation of query.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1058; Symbol: HW_ER_UNSUPPORTED_QUERY_TERM_TYPE

Message: Query term type, [%d] is not supported in HeatWave.

Description: Problem occured during logical transformation of query.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1059; Symbol: HW_ER_UNSUPPORTED_CAST

Message: Unsupported CAST - %s.

Description: The specific functionality in casting operator is not available in HeatWave.

Workaround: Use casting for supported data type.

Error number: 1060; Symbol: HW_ER_INCOMPATIBLE_ENCODINGS

Message: Incompatible encodings - %s.

Description: The operator's specific functionality on the specified encoding is not present in HeatWave.

Workaround: Use supported encoding for the operation.

Error number: 1061; Symbol: HW_ER_INCOMPATIBLE_DATA_TYPES

Message: Incompatible data types - %s.

Description: The operator's specific functionality on the specified data type is not present in HeatWave.

Workaround: Use compatible data types for the operation.

Error number: 1062; Symbol: HW_ER_UNSUPPORTED_OPERATION_OVER_NON_VARLEN_COLS

Message: Unsupported operation over non-varlen encoded cols - %s.

Description: The operator's specific functionality on the non-varlen encoded columns is not present in HeatWave.

Workaround: Either use varlen encoded column for operation.

Error number: 1063; Symbol: HW_ER_UNSUPPORTED_OPERATION_OVER_DICT_ENCODED_COLS

Message: Unsupported operation over dictionary encoded cols - %s.

Description: The operator's specific functionality on the dictionary encoded columns is not present in HeatWave.

Workaround: Use varlen encoded column for the operation.

Error number: 1064; Symbol: HW_ER_UNSUPPORTED_OPERATION_OVER_NON_PVARCHAR_COLS

Message: Compression, [%s], is supported only on padded VARCHAR columns.

Description: The compression functionality for padded VARCHAR columns is not present in HeatWave.

Workaround: Use operation on supported column type.

Error number: 1065; Symbol: HW_ER_UNSUPPORTED_NUM_ARGS_IN_IN_CLAUSE

Message: The number of arguments, [%u], for in-list, [%s], is not supported.

Description: IN-list supports limited number of arguments.

Workaround: Make sure there is one constant list entry on the right side for each row on the left side if the left side is row set.

Error number: 1066; Symbol: HW_ER_UNSUPPORTED_EXPR_OVER_VARLEN_COLS

Message: The expression, [%s], is not supported on varlen encoded columns.

Description: The supported data type for this expression is absent.

Workaround: Avoid varlen encoding in non-supported expression.

Error number: 1067; Symbol: HW_ER_INCOMPATIBLE_CHARSET_COLLATION

Message: Incompatible charset/collation - %s.

Description: Supported of charset/collation for this functionality is absent.

Workaround: Use a compatible charset/collation.

Error number: 1068; Symbol: HW_ER_CANT_EXTRACT_TABLE_REF_FOR_EXPR

Message: Could not extract table ref from expression, [%s].

Description: Problem occured during logical transformation of query.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1069; Symbol: HW_ER_UNSUPPORTED_OPERATION_OVER_DERIVED_TABLE

Message: Trying to construct a column from an Item_field which points into a derived table, is not supported in expression, [%s].

Description: Problem occured during logical transformation of query.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1070; Symbol: HW_ER_VALUE_OUT_OF_RANGE

Message: Value out of range - %s.

Description: HeatWave supports data types with limited range.

Workaround: Use the values within the range.

Error number: 1071; Symbol: HW_ER_DECIMAL_PRECISION_TOO_LARGE

Message: Decimal precision, [%s], is too large to be supported in HeatWave.

Description: HeatWave supports finite precision.

Workaround: Use precision within supported range.

Error number: 1072; Symbol: HW_ER_CANNOT_REPLACE_ENUM

Message: Cannot replace [%s], on ENUM input with [%s], in [%s].

Description: The specific functionality for ENUM data type is not available in HeatWave.

Workaround: Use valid ENUM value.

Error number: 1073; Symbol: HW_ER_UNSUPPORTED_OPERATION_OVER_UNSORTED_DICT_COLS

Message: Unsupported operation on unsorted column - %s.

Description: The operation can be used only on sorted dictionary columns.

Workaround: Use sorted dictionary column for the operation.

Error number: 1074; Symbol: HW_ER_UNSUPPORTED_SORT_ON_UNSORTED_DICT

Message: Sort on unsorted DICT, is not supported in [%s].

Description: The sorting on unsorted dictionary column is not available.

Workaround: Avoid sorting on dictionary encoded column.

Error number: 1075; Symbol: HW_ER_UNEXPECTED_NON_OPERATOR_EXPR_FOR_JOIN

Message: Unexpected non-operator expression for JOIN predicate, #%u [`%s`].

Description: Problem occured during logical transformation of query.

Workaround: Use a valid operator expression for JOIN predicate.

Error number: 1076; Symbol: HW_ER_UNEXPECTED_NON_BINARY_EXPR_FOR_JOIN

Message: Unexpected non-binary expression for JOIN predicate, [%s].

Description: Problem occured during logical transformation of query.

Workaround: Use a binary expression with correct number of arguments for JOIN predicate.

Error number: 1077; Symbol: HW_ER_CANNOT_CREATE_ORDERBY_KEY

Message: Error when creating ORDER BY key, `%s`.

Description: Problem occured during logical transformation of query.

Workaround: Please check and resolve if any other error.

Error number: 1078; Symbol: HW_ER_INVALID_DATA_TYPE_FOR_CONST

Message: Data type for constant is not supported - error while processing, [%s].

Description: The constant value is of usupported data type.

Workaround: Change the data type of constant or use a column.

Error number: 1079; Symbol: HW_ER_DUMMY_OPERAND_NOT_POPULATED

Message: RV - dummy operand [%s], not populated.

Description: Problem occured during logical transformation of query.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1080; Symbol: HW_ER_INVALID_DUMMY_PROJ

Message: There is an invalid dummy projection, [%s], in a '%s' node.

Description: Problem occured during logical transformation of query.

Workaround: Remove the dummy projection.

Error number: 1081; Symbol: HW_ER_UNSUPPORTED_COLUMN_ENCODING

Message: Unsupported encoding, '%s', while processing [%s].

Description: The columns has unsupported encoding.

Workaround: Use supported encoding for column.

Error number: 1082; Symbol: HW_ER_NONPRIMITIVE_GBY_TRANSFORMATION

Message: GROUP BY transformation failed - %s.

Description: Problem occured during logical transformation of query.

Workaround: Avoid ROLLUP or CUBE in GROUP BY.

Error number: 1083; Symbol: HW_ER_UNSUPPORTED_OPERATION_OVER_VARLEN_COLS

Message: IS TRUE/FALSE function with varlen argument is not supported.

Description: The specific functionality is not available in HeatWave.

Workaround: Use non-varlen column with IS TRUE or IS FALSE.

Error number: 1084; Symbol: HW_ER_CANT_FIND_SUBSTITUTE_ITEM_FIELD

Message: Cannot find substitute item field for, [%s], in order by key, [%s].

Description: Problem occured during logical transformation of query.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1085; Symbol: HW_ER_UNSUPPORTED_WINDOW_FUNC_FRAME_DEF

Message: WINDOW function's frame definition, is not supported.

Description: The specific functionality of WINDOW function is not available in HeatWave.

Workaround: Adjust the frame definition of the WINDOW function.

Error number: 1086; Symbol: HW_ER_UNSUPPORTED_EXCL_IN_WINDOW_FUNC_FRAME

Message: Exclusion in WINDOW function's frame, is not supported.

Description: The specific functionality of WINDOW function is not available in HeatWave.

Workaround: Remove the exclusion from WINDOW function definition.

Error number: 1087; Symbol: HW_ER_UNSUPPORTED_NONPRIMITIVE_GBY_MODIFIER_WITH_DUPLICATE_KEYS

Message: GROUP BY with %s modifier and duplicate GROUP BY keys, is not supported in [%s].

Description: The specific functionality of GROUP BY clause is not available in HeatWave.

Workaround: Remove duplicate keys from GROUP BY.

Error number: 1088; Symbol: HW_ER_UNSUPPORTED_TYPE_IN_DISTINCT

Message: Type in DISTINCT [%s], is not supported.

Description: The specific functionality of DISTINCT clause is not available in HeatWave.

Workaround: Change the type of DISTINCT.

Error number: 1089; Symbol: HW_ER_INCOMPATIBLE_FUNC_ARG

Message: Incompatible argument, ['%s'], for function [%s].

Description: The support of this data type in argument of function is not available in HeatWave.

Workaround: Use a supported type for the function parameter. Refer to HeatWave documentation for function usage and argument data types.

Error number: 1090; Symbol: HW_ER_UNSUPPORTED_JOIN_PREDICATE

Message: JOIN predicate, [%s], is not supported.

Description: The specific functionality in JOIN predicate is not available in HeatWave.

Workaround: Equality or NULL-safe equality should be present in the JOIN predicate.

Error number: 1091; Symbol: HW_ER_UNSUPPORTED_GBY_ON_FIXED_PRECISION

Message: GROUP BY on fixed precision floating point numbers, [%s], is not supported.

Description: The specific functionality is not available in HeatWave.

Workaround: Switch from fixed precision to variable precision GROUP BY key.

Error number: 1092; Symbol: HW_ER_JOIN_BETWEEN_DISTINCT_ROOTS

Message: Error during JOIN between distinct roots.

Description: Problem occured during logical transformation of query.

Workaround: Retry the query. Or, try to remove some COUNT DISTINCT keys.

Error number: 1093; Symbol: HW_ER_GBY_KEY_EXTRACT_FOR_INTERSECT_EXCEPT

Message: Extracting GROUP BY key failed for INTERSECT/EXCEPT operation.

Description: Problem occured during logical transformation of query.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1094; Symbol: HW_ER_UNSUPPORTED_NONPRIMITIVE_GBY_MODIFIER_WITH_DISTINCT_IN_ITEM

Message: %s in combination with [%s], in [%s], is not supported.

Description: The support for this combination of different functionalities is absent in HeatWave.

Workaround: Remove GROUP BY modifier.

Error number: 1095; Symbol: HW_ER_UNSUPPORTED_NONPRIMITIVE_GBY_MODIFIER_WITH_DISTINCT

Message: %s in combination with [%s], is not supported.

Description: The support for this combination of different functionalities is absent in HeatWave.

Workaround: Remove GROUP BY modifier if using HLL or DISTINCT.

Error number: 1096; Symbol: HW_ER_DISTINCT_KEY_OUT_OF_BOUNDS

Message: DISTINCT key, [%s], is out of bounds.

Description: Problem occured during logical transformation of query.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1097; Symbol: HW_ER_UNSUPPORTED_INTERVAL_TYPE

Message: The INTERVAL type, [%s], is not supported.

Description: The specific functionality of INTERVAL is not available in HeatWave.

Workaround: Use supported precision for time INTERVAL.

Error number: 1098; Symbol: HW_ER_NO_LOADED_COLS_FROM_TABLE

Message: No columns loaded to HeatWave from table, `%s`.`%s`.

Description: HeatWave required columns from table to be loaded.

Workaround: Load all columns of table to HeatWave.

Error number: 1099; Symbol: HW_ER_SELECT_EXPR_NOT_PROJECTED

Message: %s : expr, [%s], cannot be projected.

Description: Problem occured during logical transformation of query.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1100; Symbol: HW_ER_ITEM_LIST_RESIZE_FAILURE

Message: More columns found than expected and resize failed - %s.

Description: Problem occured during logical transformation of query.

Workaround: Modify the projection columns and retry the query.

Error number: 1101; Symbol: HW_ER_CANNOT_FIND_OBY_KEY_AFTER_SET

Message: Could not find key for ORDER BY, [%s], after SET operation.

Description: Problem occured during logical transformation of query.

Workaround: Retry the query. Make sure the ORDER BY keys are correctly defined.

Error number: 1102; Symbol: HW_ER_EMPTY_PROJ_KEYS_FOR_OBY_AFTER_SET

Message: SET operation children, do not project keys for ORDER BY, [%s], after SET operation.

Description: Problem occured during logical transformation of query.

Workaround: Retry the query. Make sure the ORDER BY keys are correctly defined.

Error number: 1103; Symbol: HW_ER_CHARSET_CONVERSION_FAILED

Message: Conversion charset between SET operation columns failed.

Description: Problem occured during logical transformation of query.

Workaround: Use same charset for columns.

Error number: 1104; Symbol: HW_ER_INCOMPATIBLE_DATA_TYPES_FOR_SET_OPERATION

Message: SET operation between expressions with data types, [%s, %s], is not supported.

Description: Problem occured during logical transformation of query.

Workaround: Use same data type for both arguments.

Error number: 1105; Symbol: HW_ER_INCOMPATIBLE_ENCODINGS_FOR_SET_OPERATION

Message: SET operation between differently encoded DICT columns, is not supported.

Description: SET operations are supported on similarly DICT encoded columns.

Workaround: Use same DICT encoding for columns.

Error number: 1106; Symbol: HW_ER_CANT_CREATE_TABLE_SCAN_QKRN

Message: Could not create TableScan operation - %s.

Description: Problem occured during logical transformation of query.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1107; Symbol: HW_ER_INTERSECT_DISTINCT_TRANSLATION

Message: Error during translation of INTERSECT DISTINCT.

Description: Problem occured during logical transformation of query.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1108; Symbol: HW_ER_EXCEPT_DISTINCT_TRANSLATION

Message: Error during translation of EXCEPT DISTINCT.

Description: Problem occured during logical transformation of query.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1109; Symbol: HW_ER_INTERSECT_ALL_TRANSLATION

Message: Error during translation of INTERSECT ALL.

Description: Problem occured during logical transformation of query.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1110; Symbol: HW_ER_INVALID_ENCODING

Message: Invalid encoding found for %s operation, used in qkrn node with id, [%lu].

Description: Problem occured during logical transformation of query.

Workaround: Use supported encoding for the columns and operations.

Error number: 1111; Symbol: HW_ER_EXCEPT_ALL_TRANSLATION

Message: Error during translation of EXCEPT ALL.

Description: Problem occured during logical transformation of query.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1112; Symbol: HW_ER_UNSUPPORTED_ENCODING_TYPE

Message: Encoding type, [%d], is not supported for comparison.

Description: The specific functionality is not available in HeatWave.

Workaround: Use supported encoding for the columns and operations.

Error number: 1113; Symbol: HW_ER_UNSUPPORTED_EXPR_FOR_IN_OPERATION

Message: Multi-value binary expression, [%s], with NULL left operand is not supported.

Description: The specific functionality is not available in HeatWave.

Workaround: Use a column in place of a constant.

Error number: 1114; Symbol: HW_ER_UNSUPPORTED_MULTIVAL_BINARY_EXPR

Message: Multi-value binary expression, [%s], is not supported - %s.

Description: The specific functionality is not available in HeatWave.

Workaround: Use a column in place of a constant.

Error number: 1115; Symbol: HW_ER_INVALID_ENUM_IN_BINARY_EXPR

Message: ENUM, [%s], in binary expression, [%s], is not supported.

Description: The specific functionality is not available in HeatWave.

Workaround: Cast ENUM type to a supported type.

Error number: 1116; Symbol: HW_ER_UNABLE_TO_GENERATE_ARG_FOR_FUNC

Message: Failed to generate left side argument for function, [%s].

Description: Problem occured during logical transformation of query.

Workaround: Check and resolve any other error. Retry the query.

Error number: 1117; Symbol: HW_ER_GENERATING_PRECISION_CONST

Message: Failed to generate precision const for function, [%s] with non-zero precision, [%f].

Description: Problem occured during logical transformation of query.

Workaround: Use arguments with similar data type. Use data types with similar precision.

Error number: 1118; Symbol: HW_ER_CTAS_BINLOG_FORMAT_STMT

Message: `CREATE TABLE ... AS SELECT` or `INSERT INTO ... SELECT` statements using HeatWave tables are not supported when binlog_format is set to STATEMENT.

Description: STATEMENT based replication blocks `CREATE TABLE ... AS SELECT` or `INSERT INTO ... SELECT` statements using HeatWave tables.

Workaround: binlog_format needs to be set to ROW/MIXED for `CREATE TABLE ... AS SELECT` or `INSERT INTO ... SELECT` statements using HeatWave tables

Error number: 1119; Symbol: HW_ER_INCOMPATIBLE_DATA_TYPES_IN_BINARY_EXPR

Message: Type, [%s], is not supported in binary expression, [%s].

Description: The specific functionality is not available in HeatWave.

Workaround: Cast left or right hand side of binary expression to a supported data type.

Error number: 1120; Symbol: HW_ER_UNSUPPORTED_DTYPE_CONVERSION

Message: GREATEST/LEAST function, [%s], where result data type is not STRING and at least one argument data type is STRING column or operator, is not supported.

Description: The specific functionality is not available in HeatWave.

Workaround: Use supported data types for arguments in operators.

Error number: 1121; Symbol: HW_ER_CANT_EXTRACT_EXPR_FROM_DERIVED_TBL

Message: Error when extracting expression from derived table, in [%s].

Description: Problem occured during logical transformation of query.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1122; Symbol: HW_ER_UNSUPPORTED_FUNC_OVER_ENUM

Message: Function, [%s], is not supported with ENUM columns.

Description: The specific functionality is not available in HeatWave.

Workaround: Use non-enum column with function.

Error number: 1123; Symbol: HW_ER_UNSUPPORTED_MULTIARG_BINARY_EXPR

Message: Binary multi-argument expression, with constant lhs, is not supported in, [%s].

Description: The specific functionality is not available in HeatWave.

Workaround: The left hand side of expression should not be constant. A NULL column can be used instead.

Error number: 1124; Symbol: HW_ER_UNSUPPORTED_NATIVE_IN_WITH_DIFFERENT_PRECISIONS

Message: Native-in on numbers with different precisions, is not supported in, [%s].

Description: The specific functionality is not available in HeatWave.

Workaround: Use same precision for numerical arguments in the IN list. Use an explicit cast operator with the same precision for floats or decimals arguments.

Error number: 1126; Symbol: HW_ER_UNSUPPORTED_COND_IN_CASE

Message: The CASE expression, [%s], returns a constant value. This is not advised and is not supported. It is recommended to eliminate this expression.

Description: The specific functionality is not available in HeatWave.

Workaround: Simplify the expression to avoid constant return value. Modify this expression to make the outcome non-constant. Try constructing an expression that returns a column or replacing constants with a column.

Error number: 1127; Symbol: HW_ER_TOO_MANY_FUNC_ARGS

Message: HeatWave supports only up to %u function arguments. The function is [%s], and number of arguments is %u.

Description: HeatWave supports only limited number of function arguments.

Workaround: Reduce the number of arguments to function within supported limit. Refer to HeatWave documentation for usage of built-in functions.

Error number: 1128; Symbol: HW_ER_UNSUPPORTED_STRING_OUTPUT_FUNC

Message: The function, [%s], results in a string output, which is not supported.

Description: The specific functionality is not available in HeatWave.

Workaround: Remove any user defined function. Or, simplify the string expression.

Error number: 1129; Symbol: HW_ER_UNSUPPORTED_FUNC_WITHOUT_ARGS

Message: Function, [%s], without arguments, is not supported.

Description: HeatWave require arguments for this function.

Workaround: Provide the function with a minimum of one argument. Refer to HeatWave documentation for the function usage.

Error number: 1130; Symbol: HW_ER_UNSUPPORTED_EQUALITY_BETWEEN_NULL_ITEMS

Message: Equality on 2 NULL items, [%s], is not supported.

Description: The specific functionality is not available in HeatWave.

Workaround: Use minimum one non-NULL item for comparison.

Error number: 1131; Symbol: HW_ER_INCOMPATIBLE_DATA_TYPES_IN_JOIN_COND

Message: Incompatible data types, ('%s','%s'), in join condition, [%s], is not supported.

Description: The specific functionality is not available in HeatWave.

Workaround: Define the join condition with same data type. Alternatively use cast operator to convert into same data type.

Error number: 1132; Symbol: HW_ER_UNSUPPORTED_NUM_OF_ARGS_IN_IF

Message: IF, [%s] is not supported. IF expression is currently only supported with exactly 3 arguments in HeatWave.

Description: The specific functionality is not available in HeatWave.

Workaround: For three or more arguments, use nested IF. Alternatively use a SWITCH CASE.

Error number: 1133; Symbol: HW_ER_UNSUPPORTED_CASE_COND_OVER_CONSTS

Message: A CASE conditioned over constants cannot be evaluated. It is recommended to eliminate this CASE expression, [%s].

Description: The specific functionality is not available in HeatWave.

Workaround: Simplify CASE expression for evaluation. Or remove CASE expression.

Error number: 1134; Symbol: HW_ER_UNSUPPORTED_ARG_TYPE_FOR_LIKE

Message: The argument type in, [%s], is not supported.

Description: The specific functionality is not available in HeatWave.

Workaround: Use a varlen input to LIKE clause.

Error number: 1135; Symbol: HW_ER_INTERPRETING_ESCAPE_CHARACTER

Message: Error interpreting the escape character in expr, [%s].

Description: Escape character could be incorrect in expression.

Workaround: Double-check the escape character in expression.

Error number: 1136; Symbol: HW_ER_UNSUPPORTED_LIKE_EXPR

Message: LIKE expression, [%s] is not supported.

Description: The specific functionality is not available in HeatWave.

Workaround: Try some alternative in pattern string. E.g. eliminate '_' or use '%' at the end .

Error number: 1137; Symbol: HW_ER_UNSUPPORTED_STORED_PROCEDURES

Message: Statements that reference stored functions are not supported in secondary engines.

Description: The specific functionality is not available in HeatWave.

Workaround: Do not use stored functions.

Error number: 1138; Symbol: HW_ER_UNSUPPORTED_CONVERSION_FUNC

Message: Only decimal to binary conversion is supported in function, [%s].

Description: The specific functionality is not available in HeatWave.

Workaround: Use this function for converting decimals to binary. Refer to HeatWave documentation for function usage and argument data types and supported encodings.

Error number: 1139; Symbol: HW_ER_UNSUPPORTED_FUNC_WITH_NUM_ARGS

Message: Function, [%s], with %u arguments is not supported.

Description: HeatWave supports functions with finite number of arguments.

Workaround: Use supported number of arguments in function. Refer to HeatWave documentation for function usage and argument data types.

Error number: 1140; Symbol: HW_ER_COLS_MARKED_NOT_SECONDARY

Message: You have marked one or more read columns as NOT SECONDARY, which is not supported.

Description: HeatWave secondary storage engine execution is not supported, if some query columns are not loaded in secondary engine.

Workaround: Remove NOT SECONDARY attribute from the column definition, then reload the table.

Error number: 1141; Symbol: HW_ER_UNSUPPORTED_WHERE_CLAUSE

Message: WHERE clause, [%s], is not supported.

Description: The specific functionality is not available in HeatWave.

Workaround: Modify the condition in WHERE clause and use suuported data types for arguments.

Error number: 1142; Symbol: HW_ER_AUTOCOMMIT_TURNED_OFF

Message: You cannot be offload queries to HeatWave secondary engine because autocommit is disabled.

Description: HeatWave secondary storage engine execution is not supported, if autocommit option is turned off.

Workaround: Use "SET autocommit = 0;" to enable auto-commit.

Error number: 1143; Symbol: HW_ER_QUERY_TABLE_READ_OR_WRITE_LOCKED

Message: Query is run in a prelocked table mode, at least one of the query tables are read or write locked.

Description: HeatWave secondary storage engine execution is not supported, if tables are read or write locked.

Workaround: Check if you have a trigger that has a forced secondary engine statement. Run the query after unlocking the locked tables.

Error number: 1144; Symbol: HW_ER_QUERY_PART_OF_MULTISTMT_TRANSACTION

Message: Query is part of a multi-statement transaction, which is not supported in secondary engines.

Description: HeatWave secondary storage engine execution is not supported, if the query is part of a multi-statement transaction.

Workaround: Break multi-statement transaction into separate single transactions.

Error number: 1145; Symbol: HW_ER_ILLEGAL_ARGS_IN_REGULAR_EXPR

Message: Illegal argument, [%s], to a regular expression, [%s].

Description: Arguments of regular expression might be incorrect.

Workaround: Use non-empty input for regular expression. E.g. remove if any string ('') argument.

Error number: 1146; Symbol: HW_ER_UNSUPPORTED_OUTPUT_DATA_TYPE_FOR_FUNC

Message: Unexpected data type as output of function, [%s].

Description: Function with this output data type is not supported.

Workaround: Use supported data type if function output is an argument to another function.

Error number: 1147; Symbol: HW_ER_COULD_NOT_CONSTRUCT_OPERATOR

Message: Error while constructing operator for function, [%s].

Description: Problem occured during logical transformation of query.

Workaround: Check for any errors or warnings related to operators, expressions, data types, etc. and fix them. Use SHOW WARNINGS for warnings or SHOW ERRORS for erros. Resolve the issue and retry the query.

Error number: 1148; Symbol: HW_ER_UNSUPPORTED_COND_EXPR

Message: Conditional expression, [%s] is not supported.

Description: The specific functionality is not available in HeatWave.

Workaround: Use only AND or OR in this expression.

Error number: 1149; Symbol: HW_ER_OR_CONDITION

Message: There is an error while processing the OR [%s] condition.

Description: A problem occurred during the logical transformation of the query.

Workaround: Verify that the condition is well-formed. Simplify and resolve the problem with condition and retry the query.

Error number: 1150; Symbol: HW_ER_UNSUPPORTED_COUNT_NULL

Message: COUNT(NULL) as an input argument, [%s], is not supported.

Description: The specific functionality is not available in HeatWave.

Workaround: Remove COUNT(NULL) from expression. Alternatively, replace NULL with non-NULL argument.

Error number: 1152; Symbol: HW_ER_UNSUPPORTED_BINARY_EXPR_WITH_AGG_FUNC

Message: Binary expression involving aggregate function, [%s], is not supported.

Description: The specific functionality is not available in HeatWave.

Workaround: Use constant or column instead of aggregate function.

Error number: 1153; Symbol: HW_ER_UNSUPPORTED_PROJ_OF_NON_NULL_FROM_FTAG

Message: Projecting of non-nullable item as part of FTAG is not allowed in, [%s].

Description: A problem occurred during the logical transformation of the query.

Workaround: Either make the item nullable or use a item which is nullable.

Error number: 1154; Symbol: HW_ER_UNSUPPORTED_EXPR_TYPE

Message: Expression, [%s], of type, [%s], is not supported in HeatWave.

Description: The specific functionality is not available in HeatWave.

Workaround: For valid values in other data types, use casting function to convert the expression's data type into supported one.

Error number: 1155; Symbol: HW_ER_UNSUPPORTED_OPERATOR_WITH_ARG_IN_FUNC

Message: Operator, [%s], is not supported with argument, [%s], in function, [%s].

Description: The specific functionality is not available in HeatWave.

Workaround: Use supported type for operator. Refer to HeatWave documentation for function and operators usage and argument data types.

Error number: 1156; Symbol: HW_ER_UNSUPPORTED_COND_EXPR_WITH_GBY_OR_DISTINCT

Message: GROUP BY or DISTINCT cannot handle conditional expression, [%s], which evaluates to a constant, [%s].

Description: The specific functionality is not available in HeatWave.

Workaround: Modify this expression to result in a non-constant or write an expression that returns a column or try replacing constants with a column.

Error number: 1157; Symbol: HW_ER_UNSUPPORTED_BETWEEN_OVER_ENUM

Message: BETWEEN, [%s], over ENUM, [%s], is not supported with, [%s, %s].

Description: The specific functionality is not available in HeatWave.

Workaround: Use non-ENUM for BETWEEN clause.

Error number: 1158; Symbol: HW_ER_UNSUPPORTED_ARG_TYPES_FOR_FUNC

Message: Unsupported argument types, ('%s, '%s'), for function, [%s].

Description: The specific functionality is not available in HeatWave.

Workaround: Use supported data types for arguments. Refer to HeatWave documentation for function usage and argument data types.

Error number: 1159; Symbol: HW_ER_UNSUPPORTED_FUNC_ON_NON_VECTOR_TYPE

Message: Function, [%s], requires a vector type column.

Description: The specific functionality is not available in HeatWave.

Workaround: Use vector type column as argument of the function. Refer to HeatWave documentation for function usage and argument data types.

Error number: 1160; Symbol: HW_ER_UNSUPPORTED_EXPR_ITEM

Message: Expr, [%s], is not supported.

Description: The specific functionality is not available in HeatWave.

Workaround: Use supported type for expression. Refer to HeatWave documentation for function, operator, expression usage and argument data types.

Error number: 1161; Symbol: HW_ER_UNSUPPORTED_CUSTOM_AGGREGATION

Message: Custom aggregation function, [%s], is not supported.

Description: The support for custom aggregation function is not available in HeatWave.

Workaround: Use the existing aggregation functions to express the functionality of a user-defined function.

Error number: 1162; Symbol: HW_ER_UNSUPPORTED_DISTANCE_METRIC

Message: DISTANCE metric, [%s] is not supported (supported metrics are: DOT, COSINE, EUCLIDEAN).

Description: The specific functionality is not available in HeatWave.

Workaround: Use supported DISTANCE metric. Refer to HeatWave documentation for function, operator, expression usage and argument data types.

Error number: 1163; Symbol: HW_ER_NO_HW_PLAN_GENERATED

Message: All plans were rejected by HeatWave secondary engine.

Description: Query offload to HeatWave secondary engine failed as no suitable HeatWave query plan was generated.

Workaround: Retry the query with use_secondary_engine session variable set to ON or contact support for further assistance.

Error number: 1164; Symbol: HW_ER_PARTITION_NOT_LOADED

Message: Accessed partition has not been loaded - %s.

Description: The execution of query by HeatWave needs the partition to be loaded.

Workaround: Load the partition into HeatWave.

Error number: 1165; Symbol: HW_ER_UNSUPPORTED_LOAD_POOL

Message: Schema %s.%s is in SNAPSHOT pool, explicit partition selection requires TRANSACTIONAL pool.

Description: A partition selective scan cannot be offloaded if the table is not loaded to TRANSACTIONAL pool.

Workaround: Set the table pool to TRANSACTIONAL and reload the table.

Error number: 1166; Symbol: HW_ER_TABLE_NOT_PARTITIONED

Message: Schema %s.%s is not logically partitioned.

Description: A partition selective scan cannot be offloaded if the table is not logically partitioned.

Workaround: Verify that the logical partitions are properly defined and are loaded in HeatWave.

Error number: 1167; Symbol: HW_ER_COLUMN_NOT_LOADED

Message: Column `%s`.`%s`.`%s` is not loaded to HeatWave.

Description: All columns from the table accessed by the query must be loaded to HeatWave.

Workaround: Reload the table.

Error number: 1168; Symbol: HW_ER_UNSUPPORTED_TYPE_IN_OBY

Message: Expr, [%s], in ORDER BY list is not supported.

Description: The expression in the ORDER BY list might be incorrect.

Workaround: Check and resolve any other expression related error.

Error number: 1169; Symbol: HW_ER_UNSUPPORTED_TYPE_IN_ON_CLAUSE

Message: ON clause, [%s], is not supported.

Description: The specific functionality of ON clause is not available in HeatWave.

Workaround: Either remove the ON clause or simplify the expression.

Error number: 1170; Symbol: HW_ER_UNSUPPORTED_GBY_TRANSFORMATION

Message: Error during GROUP BY transformation - %s.

Description: A problem occurred during the logical transformation of the query.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1171; Symbol: HW_ER_TOO_MANY_CUBE_ARGS

Message: CUBE with distinct aggregate functions and GROUP_CONCAT with ORDER BY is supported for a maximum of five elements in the GROUP BY list.

Description: HeatWave supports finite number of arguments in CUBE argument.

Workaround: Limit the number of keys to five in GROUP BY clause.

Error number: 1172; Symbol: HW_ER_REQUESTED_ABORT

Message: Query is aborted/interrupted.

Description: Query was aborted during logical transformation.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1173; Symbol: HW_ER_UNSUPPORTED_SESSION_PROTOCOL

Message: The session protocol is not supported.

Description: The specific functionality is not available in HeatWave.

Workaround: Do not use unsupported protocol.

Error number: 1174; Symbol: HW_ER_QUERY_EXEC_TASK_ABORTED

Message: Error during HeatWave query execution - %s (task [%s] has been aborted).

Description: Problem occured during execution of query.

Workaround: Retry the query. If the issue persists, try rewriting the query to work around the error.

Error number: 1175; Symbol: HW_ER_UNSUPPORTED_RECURSIVE_COMMON_TABLE_EXPRESSIONS

Message: Recursive common table expressions are not supported in HeatWave.

Description: The specific functionality is not available in HeatWave.

Workaround: Transform a common table expression into a non-recursive structure.

Error number: 1176; Symbol: HW_ER_UNSUPPORTED_ARITHMETIC_AGGREGATION_ON_VARCHAR_COLS

Message: Arithmetic aggregation on VARCHAR columns is not supported in [%s].

Description: The specific functionality is not available in HeatWave.

Workaround: Use supported aggregation on VARCHAR columns.

Error number: 1177; Symbol: HW_ER_UNSUPPORTED_FUNC_OVER_DICT_ENCODED_COLS

Message: Function, [%s], on dictionary encoded columns, is not supported.

Description: The specific functionality is not available in HeatWave.

Workaround: Use varlen encoded column in function. Refer to HeatWave documentation for function usage and argument data types.

Error number: 1178; Symbol: HW_ER_BOOTSTRAP_NOT_ON

Message: Query cannot be executed in HeatWave when rapid_bootstrap is not ON.

Description: HeatWave query execution is disabled when the system variable rapid_bootstrap is not set to ON.

Workaround: Retry the query with rapid_bootstrap system variable set to ON.

Error number: 1179; Symbol: HW_ER_UNSUPPORTED_OPERATOR_WITH_ARGS_IN_FUNC

Message: Operator, [%s], is not supported on arguments, ['%s', '%s'], in function, [%s].

Description: The specific functionality is not available in HeatWave.

Workaround: Refer to HeatWave documentation for operator and function usage and argument data types.

Error number: 1180; Symbol: HW_ER_THREAD_STACK_OVERRUN_SECONDARY

Message: Preventing potential stack overflow in %s

Description: Unexpected internal stackoverflow while processing the query.

Workaround: An internal error occurred due to stackoverflow while processing the query, please contact support to discuss and resolve the issue.

Error number: 1181; Symbol: HW_ER_UNSUPPORTED_ARG_IN_FUNC

Message: Unsupported argument, [%s], in function, [%s].

Description: An unsupported argument was passed to a function in HeatWave.

Workaround: Refer to HeatWave documentation for operator and function usage and argument data types.

Error number: 1182; Symbol: HW_ER_EXPORT_TO_JSON_FORMAT

Message: Error during export to JSON format - %s.

Description: An error was encountered during JSON export in HeatWave.

Workaround: Refer to HeatWave documentation for supported types for JSON export.

Error number: 1183; Symbol: HW_ER_UNSUPPORTED_ITEM_FOR_EXPORT

Message: Unsupported item for export - %s.

Description: An error was encountered during export in HeatWave.

Workaround: Refer to HeatWave documentation for supported types for export.

Error number: 1184; Symbol: HW_ER_UNSUPPORTED_AI_MODE_OPERATION

Message: Unsupported AI Mode Operation - %s.

Description: Unsupported operation found while running query in HeatWave AI mode.

Workaround: Refer to HeatWave documentation for supported queries in AI mode.