How do I download hive query results to a local machine?

If you are using HUE you can directly download the hive result as excel or CSV.

If you want to do it in command line then you use below commands

hive -e “sequence of commands” > output.csv

hive -f “filename.sql” > output.csv