topic Re: Invalid Character Constant Inside tRedshiftRow Component. in Talend Studio

Invalid Character Constant Inside tRedshiftRow Component.

Anonymous — Sat, 16 Nov 2024 08:54:44 GMT

I have the following Redshift Code -

select '"'||N.Name||'"' from (select cast('Sample' as varchar) as Name) N

Which gives the following output -

"Sample"

When i try to write this in the query part of the tRedshiftRow Component. It gives the Invalid Character Constant Error.

I checked the java code part and confirmed that the error lies near the " || " (double pipe) symbol.

How do i handle this error ?

Thanks in advance

Anonymous — Thu, 28 Dec 2017 08:33:26 GMT

Try this
"select '\"'||N.Name||'\"' from (select cast('Sample' as varchar) as Name) N"

Anonymous — Thu, 28 Dec 2017 08:43:04 GMT

That worked ! I thought the error was the the pipe symbol. Never realized that it was the double quotes that was causing it.

Thank you