.sql

create external table audience_sessions (
 machine_id string, 
 domain_name string,
 url_hosts string,
 url_dirs string, 
 url_pages string,
 patterns string, 
 actions int, 
 start_time bigint, 
 end_time bigint,
 duration bigint,
 total_duration bigint,
 concurrent_sessions string,
 dt string,
 WHF int,
 recipe_sites int,
 grocery int,
 discount_club int)
row FORMAT DELIMITED FIELDS TERMINATED BY '\001' 
STORED AS TEXTFILE LOCATION 's3://digitas-admin/home/graham.thomson/pitch/wholefoods/audience_sessions';