ERROR: syntax error at or near

Four Stars

ERROR: syntax error at or near

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]

Forteen Stars TRF
Forteen Stars

Re: ERROR: syntax error at or near

This is a PostgreSQL runtime error.

Share your tPostgesqlOutput component's settings.


TRF
Four Stars

Re: ERROR: syntax error at or near

 
Forteen Stars TRF
Forteen Stars

Re: ERROR: syntax error at or near

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)


TRF
Four Stars

Re: ERROR: syntax error at or near

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.

Moderator

Re: ERROR: syntax error at or near

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Forteen Stars TRF
Forteen Stars

Re: ERROR: syntax error at or near

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


TRF