Error Messages Associated with SQLSTATE 42V16

This topic lists the errors associated with the SQLSTATE 42V16.

SQLSTATE 42V16 Description

ERRCODE_INVALID_TABLE_DEFINITION

Error messages associated with this SQLState

ERROR 2104: A table cannot have only IDENTITY/AUTO-INCREMENT columns

ERROR 2420: Cannot drop the constraint. (Table "string" has a foreign key constraint referencing the specified primary key constraint)

ERROR 2622: Column "string" cannot be declared SETOF

ERROR 2626: Column "string" from table "string" in the SEGMENTED BY expression is required to be present in the projection, but is not

ERROR 2712: Constraint "string" for relation "string" already exists

ERROR 3508: IDENTITY/AUTO-INCREMENT columns are not allowed in temporary tables

ERROR 3874: Local temporary table constraint cannot reference a non-local table

ERROR 3901: MATCH types other than SIMPLE (the default) are not supported for foreign key constraints

ERROR 3987: Multiple primary keys for table "string" are not allowed

ERROR 4162: Non-local table constraint cannot reference a local temporary table

ERROR 4229: ON DELETE actions other than NO ACTION are not supported for foreign key constraints

ERROR 4234: ON UPDATE actions other than NO ACTION are not supported for foreign key constraints

ERROR 4413: Primary constraint for relation "string" already exists

ERROR 4415: Primary keys not specified

ERROR 4469: Projection anchor table is not partitioned

ERROR 4550: Referenced primary key constraint does not exist

ERROR 4876: Table "string" does not exist

ERROR 4881: Table "string" is not partitioned

ERROR 4899: Table is not partitioned

ERROR 4900: Table must have at least one column

ERROR 5269: Unsupported constraint type

ERROR 5548: Constraint not supported for user defined type column string

ERROR 5552: Correlation constraint not supported for user defined types

ERROR 5874: Failed to add table string of hcatalog schema string to catalog: no columns

ERROR 5876: Failed to alter table string of hcatalog schema string to catalog: no columns

ERROR 5879: Failed to describe hcatalog table

ERROR 5948: Local temporary objects may not specify a schema name

ERROR 6171: Cannot merge multiple partitions on an aggregate projection

ERROR 6396: SEGMENTED BY expression contains expressions not present in the SELECT list

ERROR 6434: TM task is not applicable to projections with aggregates

ERROR 6839: Key constraints on an external table cannot be enabled or disabled

ERROR 7122: Staging table's partition key and target table's partition key have different datatype

ERROR 7233: Check constraint 'string' does not reference any columns in the table

ERROR 7234: Check constraint 'string': references to column 'string' are not allowed in check predicates

ERROR 7235: Check constraint 'string': subqueries are not allowed in check predicates

ERROR 7236: Check constraint predicate is too long; value bytes, maximum length is value

ERROR 7237: Check constraints on an external table cannot be enabled or disabled

ERROR 7238: Column "string" referenced by check constraint 'string' is not in the table

ERROR 7260: Function "string" referenced by check constraint 'string' is a meta-function

ERROR 7261: Function "string" referenced by check constraint 'string' is an aggregate function

ERROR 7262: Function "string" referenced by check constraint 'string' is not immutable

ERROR 7263: Function "string" referenced by check constraint 'string' returns a set rather than a single value

ERROR 8091: Failed to parse JSON format Hive table description string: string