Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@shong Not sure why but I am unable to attach photos/images here now .
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.