I have the following Redshift Code -
select '"'||N.Name||'"' from (select cast('Sample' as varchar) as Name) N
Which gives the following output -
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
Solved! Go to Solution.
That worked ! I thought the error was the the pipe symbol. Never realized that it was the double quotes that was causing it.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
The Talend Cloud Developer Series was created to give you a solid foundational understanding of Talend’s Cloud Integration Platform
An integration platform-as-a-serviceto help enterprises collect, govern, transform, and share data from any data sources
Move from On-Premises to the Cloud by following the advice of experts