Help Center/ GaussDB(DWS)/ 8.2.0 and earlier versions/ Data Warehouse Service Error Codes/ GAUSS-04601 -- GAUSS-04700/ GAUSS-04691 -- GAUSS-04700
Updated on 2023-12-22 GMT+08:00
View PDF
Share

GAUSS-04691 -- GAUSS-04700

GAUSS-04692: "Value-based partition table should have one column at least"

SQLSTATE: 42601

Description: The value-based partitioned table has at least one column.

Solution: Contact technical support.

GAUSS-04693: "Value-Based partition table creation encounters unexpected data in unnecessary fields"

SQLSTATE: XX000

Description: Unexpected data is generated when the value-based partitioned table is created.

Solution: Contact technical support.

GAUSS-04694: "too many grouping sets present (max 4096)"

SQLSTATE: 54001

Description: The number of groups cannot exceed 4096.

Solution: Modify the SQL statement.

GAUSS-04695: "arguments to GROUPING must be grouping expressions of the associated query level"

SQLSTATE: 42803

Description: The grouping parameter is not found in the group by clause.

Solution: Modify the SQL statement.

GAUSS-04696: "GROUPING must have fewer than 32 arguments"

SQLSTATE: 54023

Description: The number of grouping parameters is less than 32.

Solution: Modify the SQL statement.

GAUSS-04697: "ngram parser only support UTF8/GBK encoding"

SQLSTATE: XX000

Description: The ngram segmentation algorithm supports only the UTF8 or GBK database encoding format.

Solution: NGRAM is a segmentation algorithm to support Chinese full text retrieval. Ensure that the database coding is UTF8 or GBK format when the NGRAM is used.

GAUSS-04698: "syntax error in zhparser_extra_dicts '%s'"

SQLSTATE: XX000

Description: The user-defined dictionary name is incorrect.

Solution: Change the user-defined dictionary name. Use commas (,) to separate multiple dictionary names.

GAUSS-04699: "incorrect extra dicts file name '%s' in zhparser_extra_dicts"

SQLSTATE: XX000

Description: The user-defined dictionary name is incorrect.

Solution: The naming rule must follow the prefix.encoding.xdb format.

GAUSS-04700: "Fail to load scws dict from : '%s'"

SQLSTATE: XX000

Description: The user-defined dictionary fails to be loaded.

Solution: Reset the dictionary file or the dictionary file path. The dictionary file must be generated by the SCWS component.