I was trying to out put a query to a file after ssh into the server where impala was running. This is the query that i used impala-shell -B -q 'select * from requests limit 1' -o query_result.txt '--output_delimiter=,'   Here is the another way to have a complex query/queries(delimited by 😉 in a file and output result to a file impala-shell -B -f my-query.txt -o query_result.txt '--output_delimiter=,'     adding headers to the output data impala-shell -B -f my-query.txt -o query_result.txt --print_header '--output_delimiter=,'   ... View more