topic Re: ERROR: syntax error at or near in Talend Studio

ERROR: syntax error at or near

Anonymous — Sat, 16 Nov 2024 08:21:50 GMT

Démarrage du job loading_dimension a 12:13 23/04/2018.
[statistics] connecting to socket on port 3613
[statistics] connected
ERROR: syntax error at or near "dim_temps"ERROR: syntax error at or near "dim_localisation"ERROR: syntax error at or near "dim_age"ERROR: syntax error at or near "dim_sexe"ERROR: syntax error at or near "dim_soldeEmoney"ERROR: syntax error at or near "dim_achatIshop"ERROR: syntax error at or near "dim_education"ERROR: syntax error at or near "dim_operateurTelecom"ERROR: syntax error at or near "dim_specialite"ERROR: syntax error at or near "dim_campagne"ERROR: syntax error at or near "dim_facebook"ERROR: syntax error at or near "dim_twitter"ERROR: syntax error at or near "dim_linkedin"ERROR: syntax error at or near "dim_whatsapps"
[statistics] disconnected
Job loading_dimension terminé à 12:13 23/04/2018. [Code sortie=0]

Re: ERROR: syntax error at or near

TRF — Mon, 23 Apr 2018 14:28:47 GMT

This is a PostgreSQL runtime error.

Share your tPostgesqlOutput component's settings.

Re: ERROR: syntax error at or near

TRF — Mon, 23 Apr 2018 14:41:56 GMT

What's in your tPostgesqlOutput schema?

It's definied as based on a generic schema from the repository but the corresponding schema is not selected.

Else, can you make some sentences to explain what you have tried?

(if you prefer you can do it in french)

Re: ERROR: syntax error at or near

Anonymous — Mon, 23 Apr 2018 14:46:55 GMT

Disons que mes données proviennent d'un annuaire LDAP deja connecter et tout.

Je dois creer un entrepot de donnée sous PostgreSQL choix bien pensé.

J'avais deja cree un entrepot avec Mysql mais ca marcher facilement mais avec postgres c'est comme si il ne reconnaissait pas les tables de dimensions.

Meme apres creation des tables dimensions si j'essai de charger les tables de faits il ne reconnait pas les tables de dimensions.

Je suis nouveau su talend.

Re: ERROR: syntax error at or near

Anonymous — Wed, 25 Apr 2018 10:34:43 GMT

Hello,

This is an international forum and English is the language we use. Posting in English will allow you to get more visibility and more help. Thanks for your understanding!

Best regards

Sabrina

Re: ERROR: syntax error at or near

TRF — Wed, 25 Apr 2018 10:37:52 GMT

@bigathepa did you defined the default schema for the query?