GAUSS-00851 -- GAUSS-00860

Updated on 2024-03-15 GMT+08:00

View PDF

GAUSS-00851: "cannot %s '%s' because it is in use"

SQLSTATE: 55006

Description: When an SQL statement is executed, the data partition to be queried is being accessed.

Solution: Run this SQL statement after the data partition access is complete.

GAUSS-00852: "there is no column for a partitioned table!"

SQLSTATE: 42601

Description: When the partition key sequence is obtained from a partitioned table, the column of the partitioned table is empty.

Solution: Ensure that the partitioned table has no empty column.

GAUSS-00853: "there is no partition key!"

SQLSTATE: 42601

Description: When the partition key sequence is obtained from a partitioned table, the value of all partition keys is null.

Solution: Set the values of partition keys to valid ones.

GAUSS-00854: "duplicate partition key: %s"

SQLSTATE: 42701

Description: When the partition key sequence is obtained from a partitioned table, the partitioned table contains duplicate partition keys.

Solution: Delete the duplicate partition keys from this partitioned table.

GAUSS-00855: "undefined column'%s' is used as a partitioning column"

SQLSTATE: 42703

Description: When the partition key sequence is obtained from a partitioned table, an undefined column is detected in the partitioned table.

Solution: Modify this partitioned table to define the column.

GAUSS-00856: "must be one partition key for interval partition"

SQLSTATE: 42601

Description: An interval partition does not have one partition key.

Solution: Set merely one partition key for one interval partition.

GAUSS-00857: "column %s cannot serve as an interval partitioning column because of its datatype"

SQLSTATE: 42804

Description: The data type of a column does not meet the requirements on interval partition columns.

Solution: Modify the data type of the column to meet the requirements.

Parent topic: GAUSS-00801 -- GAUSS-00900

Previous topic: GAUSS-00841 -- GAUSS-00850

Next topic: GAUSS-00861 -- GAUSS-00870

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel