Our Community is getting an upgrade! To get everything ready for the relaunch, we’ll be placing the site in read-only mode starting September 21st.
We really appreciate your understanding while we get things set up behind the scenes. Catch up on all the exciting details about the move here.
Need help or have questions? Drop us a line at [email protected]
Created on 03-26-2017 12:46 PM - edited 09-16-2022 04:20 AM
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'
Created 03-26-2017 03:36 PM
Created 03-26-2017 03:36 PM
Found the answer ...
add " --print_header " option to command string
Created 03-27-2017 04:24 AM
Cool, I'm glad you found an answer. Thanks for sharing it here, too.
Cheers, Lars