Save Impala Shell query results in CSV

Question

How can I save my query results in a CSV file via the Impala Shell.

My Code:

impala-shell -q "use test;
select * from teams;
-- From this point I need to save the query results to /Desktop (for example).
"

The problem that I am getting is that I have to select the DB first and then operate the query, but I only see syntax commands that directly uses the query instead of using the DB and then the query.

score 8 · Accepted Answer · answered Apr 14 '18 at 16:12

8

Found it.

impala-shell -B -o output.csv --output_delimiter=',' -q "use test;
select * from teams;"

answered Apr 14 '18 at 16:12

4

if looking for adding header as well, then include `--print header` in the command. https://community.cloudera.com/t5/Interactive-Short-cycle-SQL/How-to-get-header-in-Impala-output-csv-file/td-p/52673 – prashanth Nov 30 '18 at 09:12
In Impala Shell v2.12.0-cdh5.16.2 it is `--print_header` – arun Apr 28 '20 at 15:55

score 1 · Answer 2 · answered May 09 '19 at 14:04

1

You can use

impala-shell -B -q "select * from anylbi.tablename_1;" -o extract.csv
--print_header '--output_delimiter=,'

if you have a particular server you're trying to connect you can use the -i option and then the server name after impala-shell

answered May 09 '19 at 14:04

Yags

482
1
6
18

Rishabh Jain · Answer 3 · 2022-01-09T19:48:03.897

0

eg:

Server : SERVER_NAME

Output File : output.csv

Database : test

Table name : teams

Delimiter : |

impala-shell -k -i SERVER_NAME --ssl -B -o output.csv --print_header --output_delimiter=| -q "use test; select * from teams";

edited Jan 09 '22 at 19:48

answered Jan 05 '22 at 12:45

Rishabh Jain

1
2

As it’s currently written, your answer is unclear. Please [edit] to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Jan 05 '22 at 14:52

Save Impala Shell query results in CSV

3 Answers3