GreenPlum创建外部表示例.pdfVIP

ZZhhoonngg WWeeiicchheenngg SSttuuddyy NNootteess IInnssiisstt oonn hhiiss oowwnn iiddeeaall,, aanndd ttoo aattttaaiinn iitt.. GGrreeeennPPlluumm创创建建外外部部 示示例例 分类： GreenPlum 2013-12-14 22:16 238人阅读 评论 (0) 收藏 举报 GreenPlum Example 1—Single Greenplum file server (gpfdist) instance on multiple NIC machine Creates a readable external table named ext_expenses using the gpfdist protocol. The files are formatted w ith a pipe ( | ) as the column delimiter. CREATE EXTERNAL TABLE ext_expenses ( name text, date date, amount float4, category text, desc text )