与 SQLSTATE 42V16 关联的消息

本主题列出了与 SQLSTATE 42V16 关联的消息。

SQLSTATE 42V16 说明

INVALID_TABLE_DEFINITION

与此 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 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 7233: Check constraint 'string' does not reference any columns in
              the table

WARNING 10227: Mergeout is disabled on string