Support Questions
Find answers, ask questions, and share your expertise

Export query to csv with no delimeter and no extra quotes

Explorer

I want to export an impala query where it concats many columns into one without a delimeter and the extra quotes that come with it .

 

Here is my query 

impala-shell --ssl -B -i ${load_balancer} -f  ${sql_file_local_subscriber} -o ${file_path_edge_subscriber}  --print_header;

Basically it gives " ""A"",""B"",""C"" "

 

I want "A" , "B" , "C".

 

How can I accomplish this through impala.

 

Thank you

1 REPLY 1

Re: Export query to csv with no delimeter and no extra quotes

Expert Contributor

Hi @gimp077,

You need to use this option of impala-shell

--output_delimiter=character

I think in you case you have to do:

impala-shell ... '--output_delimiter=,'


source: https://www.cloudera.com/documentation/enterprise/latest/topics/impala_shell_options.html

 


Good luck.