03-26-2017 12:46 PM
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'
Solved! Go to Solution.