Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Export query to csv with no delimeter and no extra quotes

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
Highlighted

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.

Don't have an account?
Coming from Hortonworks? Activate your account here