| 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; |