Help Center> Data Warehouse Service (DWS)> 8.2.0 and earlier versions> Data Warehouse Service Error Codes> GAUSS-01101 -- GAUSS-01200> GAUSS-01181 -- GAUSS-01190
Updated on 2023-12-22 GMT+08:00
View PDF

GAUSS-01181 -- GAUSS-01190

GAUSS-01181: "COPY delimiter must be less than %d bytes"

SQLSTATE: 0A000

Description: The delimiter specified by COPY exceeds the maximum length.

Solution: Ensure that the length of the delimiter specified by COPY is within 10 bytes.

GAUSS-01182: "COPY delimiter cannot be newline or carriage return"

SQLSTATE: 22023

Description: Line breaks or carriage return is used as the delimiter for COPY.

Solution: Use a horizontal tab or comma as the delimiter for COPY. For details, see "Copy" in the SQL Syntax.

GAUSS-01183: "COPY null representation cannot use newline or carriage return"

SQLSTATE: 22023

Description: The copy null character uses line breaks or carriage return.

Solution: Do not use line breaks or carriage return for the copy null character.

GAUSS-01184: "delimiter '%s' cannot contain any characters in'%s'"

SQLSTATE: 22023

Description: When a non-CSV file is imported, the specified delimiter contains forbidden characters, such as lowercase letters (a-z), digits (0-9), dots (.), and backslashes (\).

Solution: Change the delimiter to ensure no forbidden characters are included.

GAUSS-01185: "COPY HEADER available only in CSV mode"

SQLSTATE: 0A000

Description: The copy header is not in CSV mode.

Solution: Ensure that the copy header is in CSV mode.

GAUSS-01186: "COPY quote available only in CSV mode"

SQLSTATE: 0A000

Description: The copy quote is not in CSV mode.

Solution: Ensure that the copy quote is in CSV mode.

GAUSS-01187: "COPY quote must be a single one-byte character"

SQLSTATE: 0A000

Description: The copy quote is not a single-byte character.

Solution: Ensure that the copy quote is a single-byte character.

GAUSS-01188: "delimiter cannot contain quote character"

SQLSTATE: 22023

Description: When a CSV file is imported, the delimiter contains quotation characters.

Solution: Change the quotation characters to allowed CSV delimiters.

GAUSS-01189: "COPY escape available only in CSV mode"

SQLSTATE: 0A000

Description: The copy escape is not in CSV mode.

Solution: Ensure that the copy escape is in CSV mode.

GAUSS-01190: "COPY escape must be a single one-byte character"

SQLSTATE: 0A000

Description: The copy escape is not a single-byte character.

Solution: Ensure that the copy escape is a single-byte character.