Celonis EMS Impala error due to "-symbols in query

Hey @joos.buijs,

I sadly don't have experience with the Impala Connector, but my guess that it has something do to with the Unicode.

According to the Celonis documentation for Cloudera Impala, there is a field you alter called usesqlunicodetypes. By setting this on 0 Impala will use the default Unicode data types.

Documentation: Cloudera Impala: How do I set up my database connection? (celonis.com)

Hopefully this will help you in some way.

Kind regards,

Sverre Klein

Thanks for your reply @sverre.klein11 !

During our investigation, and thanks to @Bart Hompes we found the following as possible causes/solutions:

1. Set the JDBC property SQL_IDENTIFIER_QUOTE_CHAR to backtick, however we are not certain where/how to pass this property. The extractor fails when passing this in the JDBC string.
2. Set the property UseNativeQuery=0, same issue as above
3. Pass identifier.quote=”`”  in the connection properties, but this also seems to break the extractor

Any insights to help us further from anyone is much appreciated, as this is getting quite blocking for us currently :)

Hi @joos.buijs,

I was wondering if you were able to solve the above issue. If you did, I'm curious to know how 😎.

If not, I hope you will find a solution soon.. sadly I don't have experience with Impala :(

We have opened a support ticket with Celonis, but are still waiting a technical discussion/assistance. We'll let you know if we found a solution but are still open for inspiration :)