In tRedshiftOutput, Action on table --> Create table is not working

[Anonymous]

Hi,
Below is my job flow in which i am exracting a data from mysql, transforming it twice using tmap and creating a csv file. Now i want this csv file to be inserted in my Redshift. I do not have that table in Redshift. So i selected Action on table --> Create table in tRedshiftOutput component. But it keeps on failing stating
Exception in component tRedshiftOutput_2
org.postgresql.util.PSQLException: ERROR: relation "my_csv_table" does not exist

[Anonymous]

Hi,
Is there any sensitive problem of your table name in your DB component?
Best regards
Sabrina

[Anonymous]

Dont think so. Check attached screenshot

[Anonymous]

Hi,
Have you tried option "Drop table if exists and create"?
Best regards
Sabrina

[Anonymous]

Yes. I have tried create table, create table if does not exist, drop table if exists and create,. But still get same error.
This is really driving me crazy. Not sure what is wrong.

[Anonymous]

Hi,
Is your Host "redshift.amazonaws.com" Hostname or IP address of the database server?
Best regards
Sabrina

[Anonymous]

I have shortened it here. Its rather a long name.
That should not be a problem because if the table is exsiting in Redshift, I am able to insert data successfully. Problem only occurs when table is not represent and Talend needs to create it.

[Anonymous]

Hi,
Due to PostgreSQL is case sensitive for table and column names, have you tried to use double quotes for your table name?
Have you tried another Data Base (tMySqlOutPut) to see if this issue repro? What's the build version you are using?
Best regards
Sabrina

[Anonymous]

I haven't tried tmysqloutput.
I am using talend open studio for data integration
Version: 5.5.1
Build id: r118616-20140617-1110

[Anonymous]

Hi,
Due to PostgreSQL is case sensitive for table and column names, have you tried to use double quotes for your table name?
Best regards
Sabrina