topic Creating Impala table with resaved words as column name in Talend Studio

Creating Impala table with resaved words as column name

Mmm1632937913 — Fri, 15 Nov 2024 23:40:32 GMT

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!

Re: Creating Impala table with resaved words as column name

Anonymous — Thu, 30 Sep 2021 07:03:10 GMT

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

Re: Creating Impala table with resaved words as column name

Mmm1632937913 — Thu, 30 Sep 2021 13:17:48 GMT

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.