Loading Greenplum From An External Table

Ok, we’ve got Greenplum up and running and now we want to load some data. There are several methods available, of which we’ll look at external tables. This demo will load a simple file containing 2 fields and 10 records into an empty table. Here is the input file: gpadmin$ more test1.txt1,aaa2,bbb3,ccc4,ddd5,eee6,fff7,ggg8,hhh9,iii10,jjj So, let’s create […]