About chophouse

chophouse · ‎03-14-2018

Thanks Tim. That works for my use case

chophouse · ‎01-05-2018

How would you do this in reverse: given a unixtime value of 13949501310621, how would you convert to : 2014-03-16 00:08:51.621 ?

chophouse · ‎03-31-2017

Thanks pushyami, for the bit about adding a header

chophouse · ‎03-26-2017

Found the answer ... add " --print_header " option to command string

chophouse · ‎03-26-2017

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'

chophouse · ‎03-25-2017

This command produces an output file but there is no header. How can I produce an output csv file with a header?

Online	Offline
Last Visited	‎03-15-2018 12:02 PM

Member Since	‎03-25-2017 09:35 AM
Last Visited	‎03-15-2018 12:02 PM
Posts	11
Kudos received	2

Cloudera Community

Re: How to get header in Impala output csv file

Re: Get timestamp in milliseconds in Impala

Re: Get timestamp in milliseconds in Impala

Re: How can I export query results to a csv file i...

Re: How to get header in Impala output csv file

How to get header in Impala output csv file

Re: How can I export query results to a csv file i...