GP 外部表

最新推荐文章于 2023-09-24 21:00:00 发布

lyc417356935

最新推荐文章于 2023-09-24 21:00:00 发布

阅读量2.1k

点赞数 1

分类专栏：数据库

本文链接：https://blog.csdn.net/lyc417356935/article/details/40297571

版权

数据库专栏收录该内容

6 篇文章 0 订阅

订阅专栏

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]