Shulou(Shulou.com)06/01 Report--

Option

Meaning

Default value

DELIMITER

Specifies the column value delimiter.

CSV: comma','

TEXT: tab'\ t'

NULL

Specifies a string that represents a null value.

CSV: space''

TEXT: "\ n"

ESCAPE

Specifies the escape character. The OFF option is not supported for HDFS external tables.

CSV: double quotes'"'

TEXT: backslash'\'

QUOTE

Specifies the substitute character for quotation marks.

Double quotation marks'"

FORCE QUOTE

Forces quotation marks on non-NULL column values of the specified column. Valid only for writable external tables in CSV format.

N/A

FORCE NOT NULL

Casts to an empty string for the specified column null value. Valid only for external table readings in CSV format.

N/A

NEWLINE

Specifies the line split form.

LF

HEADER

Specifies that the first row contains only column name information and needs to be ignored.

N/A

FILL MISSING FIELDS

Forces the column of the specified value to be populated with NULL.

N/A

ENCODING

Specifies the external table encoding.

Default external table encoding

LOG ERRORS INTO

Import the contents of the error line into the error table. The error table of the external table of HDFS is also an external table. HAWQ automatically creates the external table of the error table. Users can get the path of the automatically created error table by checking pg_exttable, and the user needs to delete the error table manually.

N/A

SEGMENT REJECT LIMIT

When the accumulated error lines on a HAWQ VSEG exceed the specified number of rows, the read process exits with an error. Currently, HAWQ external tables only support specifying a specific number of rows, not percentages.

N/A

For more information on using HDFS external tables to implement import and export, please refer to

Http://oushu.io/docs/hawq/user-guide/import-export/intro/

Appreciate

Under the influence of Apple's new regulations, the appreciation function of Wechat's iOS version has been turned off and can be transferred to support official accounts through QR codes.

Read complaints and write messages

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.