Messages associated with SQLSTATE 42V16

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

SQLSTATE 42V16 description

INVALID_TABLE_DEFINITION

Messages associated with this SQLState

Error messages

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 4885: Table string does not exist
ERROR 4892: 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 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 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
ERROR 10116: Constraint not supported for primitive type column string
ERROR 10329: Only Parquet or Orc External Tables can use string
ERROR 10502: Cannot have SET USING expressions on complex type columns

Warning messages

WARNING 7233: Check constraint 'string' does not reference any columns in
              the table
WARNING 10227: Mergeout is disabled on string