Syntax error at tVerticaoutput on schema name

[PJain1676374048]

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.

[Anonymous]

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

[PJain1676374048]

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

[Anonymous]

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