Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Parikhharshal
Creator III
Creator III

Double quotes in column names for Redshift

Hi talend experts

 

I have a scenario where I am trying to add doublt quotes in table column in dbrow component for redshift but it does not work and not sure what I am doing wrong.

 

This i how I have written SQL:

 

UPDATE landing.sut_student_hub_user_event_history

SET   

user_event_id=src.user_event_id,

user_id=src.user_id,

category=src.category,

value = src.value,

created_at=src.created_at,

action =src.action,

label=src.label,

\"tag\"=src.\"tag\", (this is the column where I need double quotes in name)

heading=src.heading,

Update_Audit_Key = "+context.auditKey+",

Update_Timestamp = current_timestamp

FROM landing.sut_student_hub_user_event_history as tgt

INNER JOIN landing.sut_student_hub_user_event as src

ON tgt.user_event_id = src.user_event_id;

 

Thanks

Harshal.

Labels (2)
2 Replies
Anonymous
Not applicable

Do you have any error message when you execute this query?
Parikhharshal
Creator III
Creator III
Author

@shong  Not sure why but I am unable to attach photos/images here now 0683p000009MPcz.png.

 

The erorr msg I receive is 

java.sql.SQLException: [Amazon](500310) Invalid operation: Target table must be part of an equijoin predicate;

 

As soon as I comment out 'Tag' column line in SQL it works fine.