question How to get header in Impala output csv file in Archives of Support Questions (Read Only)

How to get header in Impala output csv file

chophouse — Fri, 16 Sep 2022 11:20:27 GMT

When I use this command, it produces a nice pipe-delimited file - which is what I want. However, there is no header row. What syntax must I include to ensure that the output csv file has a header row?

impala-shell -i <servername:portname> -B -q 'SELECT from_unixtime(field00) as 'in_date', field01, field02 FROM <table> LIMIT 100;' -o query_out.csv '--output_delimiter=\174'

Re: How to get header in Impala output csv file

chophouse — Sun, 26 Mar 2017 22:36:52 GMT

Found the answer ...

add " --print_header " option to command string

Re: How to get header in Impala output csv file

Lars Volker — Mon, 27 Mar 2017 11:24:18 GMT

Cool, I'm glad you found an answer. Thanks for sharing it here, too.

Cheers, Lars