topic Double quotes in column names for Redshift in Talend Studio

Double quotes in column names for Redshift

Parikhharshal — Sat, 16 Nov 2024 03:32:05 GMT

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.

Re: Double quotes in column names for Redshift

Anonymous — Mon, 20 Jan 2020 02:08:38 GMT

Do you have any error message when you execute this query?

Re: Double quotes in column names for Redshift

Parikhharshal — Mon, 20 Jan 2020 03:44:28 GMT

@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.