CREATE EXTERNAL TABLE totals STORED AS CSV WITH HEADER ROW LOCATION '../_data/totals.csv'; SELECT count(*) FROM totals;