GP 外部表

来源：互联网发布：剧情游戏知乎编辑：程序博客网时间：2024/05/30 02:52
CREATE [READABLE] EXTERNAL TABLE table_name ( column_name data_type [, ...] | LIKE other_table ) LOCATION ('file://seghost[:port]/path/file' [, ...]) | ('gpfdist://filehost[:port]/file_pattern[#transform]' | ('gpfdists://filehost[:port]/file_pattern[#transform]' [, ...])       | ('gphdfs://hdfs_host[:port]/path/file')    FORMAT 'TEXT'          [( [HEADER]             [DELIMITER [AS] 'delimiter' | 'OFF']             [NULL [AS] 'null string']             [ESCAPE [AS] 'escape' | 'OFF']             [NEWLINE [ AS ] 'LF' | 'CR' | 'CRLF']             [FILL MISSING FIELDS] )]         | 'CSV'          [( [HEADER]             [QUOTE [AS] 'quote']             [DELIMITER [AS] 'delimiter']             [NULL [AS] 'null string']             [FORCE NOT NULL column [, ...]]             [ESCAPE [AS] 'escape']             [NEWLINE [ AS ] 'LF' | 'CR' | 'CRLF']             [FILL MISSING FIELDS] )]         | 'CUSTOM' (Formatter=<formatter specifications>)   [ ENCODING 'encoding' ]   [ [LOG ERRORS INTO error_table] SEGMENT REJECT LIMIT count    [ROWS|PRECENT]
1 0