topic Re: Syntax error at tVerticaoutput on schema name in Talend Studio

Syntax error at tVerticaoutput on schema name

PJain1676374048 — Fri, 15 Nov 2024 22:06:13 GMT

Dear Community,

I am using tverticaoutput to send data to vertica database, it shows an error Syntax error at or near "201852_" ,

my vertica schema name is "201852_ssap_hdp", it is working fine in tverticarow component but its showing error in this only, i tried everything on this , i have to transfer data from another DB so i am bound to use this.

Please let me know if you have any suggestion on this.

Re: Syntax error at tVerticaoutput on schema name

Anonymous — Thu, 16 Feb 2023 06:34:17 GMT

Hello,

Did you define the default schema for the query?

What's in your tVerticaOutput schema?

Could you please share your tVerticaoutput component's settings screenshots here?

Best regards

Sabrina

Re: Syntax error at tVerticaoutput on schema name

PJain1676374048 — Thu, 16 Feb 2023 07:43:26 GMT

Hi @Xiaodi Shi

Thanks for the reply ,

no i don't use the default schema, here is the screenshot attached

the main issue is , it is not taking the schema name start with number .

please let me know if you need more

Re: Syntax error at tVerticaoutput on schema name

Anonymous — Fri, 17 Feb 2023 07:51:17 GMT

Hello,

The column starting with number is a limitation in java framework hence since Talend is build on java, it inherits the same limitation.

It is not a limitation of Java language. It is a rule of java programming language.

Refer to link: https://docs.oracle.com/javase/tutorial/java/nutsandbolts/variables.html

Best regards

Sabrina