Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How to get header in Impala output csv file

avatar
Contributor

 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'

1 ACCEPTED SOLUTION

avatar
Contributor

Found the answer ...

 

 add " --print_header " option to command string

View solution in original post

2 REPLIES 2

avatar
Contributor

Found the answer ...

 

 add " --print_header " option to command string

avatar
Super Collaborator

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

 

Cheers, Lars