question Re: How can I export query results to a csv file in Impala shell? in Support Questions

How can I export query results to a csv file in Impala shell?

Shreesha — Fri, 16 Sep 2022 09:05:34 GMT

How can I export query results to a csv file in Impala shell?

Re: How can I export query results to a csv file in Impala shell?

daai_evangelist — Wed, 20 Aug 2014 23:18:56 GMT

You can use -o filename or --output_file filename & --output_delimiter=character options to generate output in csv file format.

Re: How can I export query results to a csv file in Impala shell?

Shreesha — Wed, 20 Aug 2014 23:22:23 GMT

Thanks a lot for the response, I tried that but somehow its not working, do you have any sample example...

Re: How can I export query results to a csv file in Impala shell?

daai_evangelist — Thu, 21 Aug 2014 01:57:21 GMT

Try below syntax. Remove -k if your environment is not kerberosized -

impala-shell -k -i servername:portname -B -q 'select * from table' -o filename '--output_delimiter=\001'

Re: How can I export query results to a csv file in Impala shell?

lamxan — Mon, 24 Aug 2015 09:13:14 GMT

Can i do same with JDBC driver in java?

Re: How can I export query results to a csv file in Impala shell?

chophouse — Sat, 25 Mar 2017 16:50:07 GMT

This command produces an output file but there is no header. How can I produce an output csv file with a header?

Re: How can I export query results to a csv file in Impala shell?

pushyami — Fri, 31 Mar 2017 15:47:22 GMT

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=,'

Re: How can I export query results to a csv file in Impala shell?

chophouse — Fri, 31 Mar 2017 16:17:38 GMT

Thanks pushyami, for the bit about adding a header

Re: How can I export query results to a csv file in Impala shell?

ekaifan — Tue, 22 Aug 2017 17:28:15 GMT

Great! This is helpful

Re: How can I export query results to a csv file in Impala shell?

HadDEV — Mon, 20 Mar 2023 05:43:27 GMT

But it will not allow to append result of multiple impala queries. Can it be possible to have any option in the command will will allow user to add results of multiple impala queries result in same output file with headers specific to each query.