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 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
ERROR 9049: Constraint not supported for complex type column string
ERROR 9050: Constraint not supported for inlined complex type column string
ERROR 9051: Correlation constraint not supported for user defined types and complex types
ERROR 9064: Only Parquet External Tables can use complex types
ERROR 9189: Table with Complex Types "string" cannot be used to create tables with AS SELECT
ERROR 9202: Tables with complex data types cannot have default columns
ERROR 9203: Tables with complex data types cannot have identity columns
ERROR 9369: Internal complex types cannot be reused
The Vertica User Community contains knowledge base articles, blogs, and forum posts that may help you resolve these errors.