Creating Impala table with resaved words as column name

[Mmm1632937913]

Hi,

I'm using the tImpalaCreateTable component to create an Impala table, some of my columns names defined in my schema are Impala resaved words (Impala 3.0, for example: condition, trigger) so the component fails with the error: "A reserved word cannot be used as an identifier"

when creating an Impala table by script the solution is enclosed the names with backticks (`

condition`, `trigger`

).

any way to deal with it using the create table component?

Thanks!

[Anonymous]

Hello,

It's not recommended that you use a reserved word as an identifier.

Have you tried to change the name of the identifier to exclude reserved words or use back quote `` ?

You can check Impala Reserved Words from

https://docs.cloudera.com/documentation/enterprise/latest/topics/impala_reserved_words.html

Best regards

Sabrina

[Mmm1632937913]

I know it's not recommended to use these words, but this is the case (also list of reserved words is updated between versions..)

I can't change columns names and Talend does not allow to insert back quote (``) in the schema column name.