Example hive query

hive.sql

-- This will give me back a text file for every reducer, then I need to cat * > outfile to get a single text file
-- Feels like there should be a simple setting to tell Hive that I want a single text file back

--query_history
insert overwrite local directory '/tmp/hive/old_backup/query_history'
select
to_date(from_unixtime(CAST(created as int))) as query_date,
account_code,
audit_key,
entity_code,
provider_code,
count(token) as records
from query_history
group by to_date(from_unixtime(CAST(created as int))), account_code, audit_key, entity_code, provider_code;