Reply
Highlighted
Explorer
Posts: 8
Registered: ‎03-25-2017
Accepted Solution

How to get header in Impala output csv file

 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'

Explorer
Posts: 8
Registered: ‎03-25-2017

Re: How to get header in Impala output csv file

Found the answer ...

 

 add " --print_header " option to command string

Cloudera Employee
Posts: 73
Registered: ‎12-07-2015

Re: How to get header in Impala output csv file

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

 

Cheers, Lars

Announcements