gpcontrib/gpcloud/regress/output/1_01_normal.source

CREATE READABLE EXTERNAL TABLE s3regress_normal (date text, time text, open float, high float,
        low float, volume int) LOCATION('s3://s3-us-west-2.amazonaws.com/@read_prefix@/normal/ config=@config_file@') FORMAT 'csv';
SELECT count(*) count, round(sum(open)) sum, round(avg(open)) avg FROM s3regress_normal;
  count   |    sum     | avg 
----------+------------+-----
 31033039 | 1490754474 |  48
(1 row)

DROP EXTERNAL TABLE s3regress_normal;
CREATE READABLE EXTERNAL TABLE s3regress_normal_onmaster (date text, time text, open float, high float,
        low float, volume int) LOCATION('s3://s3-us-west-2.amazonaws.com/@read_prefix@/normal/ config=@config_file@') ON COORDINATOR FORMAT 'csv';
SELECT count(*) count, round(sum(open)) sum, round(avg(open)) avg FROM s3regress_normal_onmaster;
  count   |    sum     | avg 
----------+------------+-----
 31033039 | 1490754474 |  48
(1 row)

DROP EXTERNAL TABLE s3regress_normal_onmaster;