blob: a1ab93549319e4b3ba48b069dce06e1efdec87ef [file] [log] [blame]
CREATE READABLE EXTERNAL TABLE parallel1 (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 parallel1;
count | sum | avg
----------+------------+-----
31033039 | 1490754474 | 48
(1 row)
DROP EXTERNAL TABLE parallel1;