topic Re: how to use unload component in talend? in Talend Studio

how to use unload component in talend?

k526 — Sat, 16 Nov 2024 09:31:53 GMT

Hi,

am using redshift.i used select query in unload component in talend.

it was working in redshift but in talend its not working .I was getting an error

unterminated quoted string at or near "'

My query:

select campaignid,code,' 'as campainmember,' ' as lead,''sun'' as leadname from ms_is.bystyn.

is there any one to unload the file with header?

can anyone help me ?

Thank you

Re: how to use unload component in talend?

Anonymous — Tue, 25 Jul 2017 10:01:21 GMT

Hello,

Are you using talend component tRedshiftUnload? Screenshots of your component setting will be preferred.

Can you successfully unload your file without header in talend?

Best regards

Sabrina

Re: how to use unload component in talend?

k526 — Tue, 25 Jul 2017 12:48:52 GMT

Hi Sabrina,
am using talend (tredshiftunload)component.but i am getting some errors. (')single quotes is not working in talend.so, is there any other way to unload the table in s3 path.
kindly provide any solution ? and thanks For the reply.please find the screenshots.
Thank you

unlaod.PNG
unlaod1.PNG

Re: how to use unload component in talend?

Anonymous — Wed, 26 Jul 2017 04:24:43 GMT

Hello,

Have you tried to use sql query like:

select campaignid,code, as campainmember, as leadsun, as leadname from ms_is.bystyn without (')single quotes to see if it works?

Which is talend build version you are using?

Best regards

Sabrina

Re: how to use unload component in talend?

cterenzi — Wed, 26 Jul 2017 14:26:07 GMT

It would be helpful to see the entire query string just to make sure there's nothing off at the end of the string.

I don't know if it makes a difference, but there is no space between '' and "as campainmember"

Side note: You appear to be using a context variable in the tablename setting. It doesn't usually make a difference in database input components if that setting is correct, but you don't want quotes around context variables.

Re: how to use unload component in talend?

Anonymous — Fri, 29 Mar 2019 06:20:03 GMT

hi ,

I am facing the single quotes issue in where clause as in attachment.

please help me out

Re: how to use unload component in talend?

Anonymous — Mon, 01 Apr 2019 04:15:02 GMT

Hello @harshadathorat ,

Could you please check your "Code" tab in your job to see if there will be your compile error highlighted in red line?

Best regards

Sabrina

Re: how to use unload component in talend?

Rahul_V — Thu, 13 Jun 2019 16:01:19 GMT

Is there still a way to get headers in the delimited file using "tredshiftunload" component ??

Re: how to use unload component in talend?

Anonymous — Mon, 17 Jun 2019 11:06:47 GMT

Hello,

So far, we won't do this new feature and we are relying on Amazon for this feature request.
A workaround exists by leveraging custom SQL with Union in order to add the header.

Let us know if it is OK with you.

Best regards

Sabrina

Re: how to use unload component in talend?

Rahul_V — Fri, 21 Jun 2019 07:18:00 GMT

Hi Sabrina,

Thank you for your reply. But looking at amazon unload command it has an option to enable the headers. Please refer to this link . Can we also get an option to enable the headers in the tredshiftunload component ? The header option which amazon provides it writes the header into all the files which are split. In case of Union it will write the header only to first page/file only.

As my requirement is to have the headers in all the files. Please let me know how can we achieve this as each file is having a size of 6.2 GB ?

Regards,
Rahul

Re: how to use unload component in talend?

Rahul_V — Tue, 25 Jun 2019 19:52:45 GMT

Found Workaround:
Use tRedshiftinputrow component and use your "unload query" to get the headers option in all the files.

Regards,
Rahul