GAUSS-01701 -- GAUSS-01710
GAUSS-01701: "invalid system attribute number %d"
SQLSTATE: XX000
Description: Internal system error.
Solution: Contact technical support.
GAUSS-01702: "permission denied to create '%s.%s'"
SQLSTATE: 42501
Description: Creating the heap table fails probably because the creating mode or the database namespace is not allowed by the system.
Solution: Ensure that the creating mode or the database namespace is correct.
GAUSS-01703: "column name '%s' specified more than once"
SQLSTATE: 42701
Description: Duplicate attribute names exist in the table.
Solution: Ensure that a specific attribute name is used more than once while defining the table.
GAUSS-01704: "column '%s' has pseudo-type %s"
SQLSTATE: 42P16
Description: Unknown attribute types exist in the table, causing attribute check failures.
Solution: Ensure that the current attribute type is supported by the system.
GAUSS-01705: "composite type %s cannot be made a member of itself"
SQLSTATE: 42P16
Description: The name of the composite type is the same as that of the current type, which is not allowed.
Solution: Ensure that the name of the composite type is the same as that of the current type.
GAUSS-01706: "no collation was derived for column '%s' with collatable type %s"
SQLSTATE: 42P16
Description: The attribute column supports attcollation but the attcollation is invalid, and the heap table cannot be created.
Solution: Ensure that the collation definition in the attribute column is valid when the table is created.
GAUSS-01707: "Invalid distribution column specified"
SQLSTATE: 42P16
Description: The attribute names used to mark distribution status is not contained in the attribute column. As a result, the number of the attribute column is equal to or less than zero.
Solution: Ensure that the attribute name in the DISTRIBUTE BY statement exists in the attribute column defined by the table.
GAUSS-01708: "Column %s is not a hash distributable data type"
SQLSTATE: 42809
Description: The data type cannot be distributed in the hash mode.
Solution: Ensure that the data used in the current column can be distributed in hash mode.
GAUSS-01709: "Column %s is not modulo distributable data type"
SQLSTATE: 42809
Description: The data type cannot be distributed in modulo mode.
Solution: Ensure that the data used in the current column can be distributed in modulo mode.
GAUSS-01710: "Invalid distribution type"
SQLSTATE: 42P16
Description: The system does not support the specified distribution type.
Solution: Ensure that the distribution type in use is supported by the system.
Last Article: GAUSS-01701 -- GAUSS-01800
Next Article: GAUSS-01711 -- GAUSS-01720
Did this article solve your problem?
Thank you for your score!Your feedback would help us improve the website.