Hi @JKarount , I see, we will take up the bug report internally as it may affect other customers too, in any case thanks for your diagnostics and troubleshooting. In my opinion to achieve the same functionality and most likely it will pass through the ODBC driver as-is, please try to use the Impala's NVL or NVL2 function (or even ZEROIFNULL if it's a numeric column): https://impala.apache.org/docs/build/html/topics/impala_conditional_functions.html#conditional_functions__nvl2 SELECT col1, col2 as col2_orig, NVL2(col2, col2, 0) as col2_1 FROM sandbox.jk_test or SELECT col1, col2 as col2_orig, NVL(col2, 0) as col2_1 FROM sandbox.jk_test  Hope that helps.   Best regards  Miklos ... View more

Hi @JKarount , thank you for the detailed description and reproduction steps. To be able to help you on this, kindly open a formal support case through our Cloudera Support portal. Please also reproduce this with the latest ODBC driver version (2.6.17 as of now) with driver TRACE logs enabled. Please see the ODBC driver install guide https://downloads.cloudera.com/connectors/ClouderaImpala_ODBC_2.6.17.1026/Cloudera-ODBC-Connector-for-Impala-Install-Guide.pdf (in Windows go to the ODBC datasource configuration, and enable it under Logging Options)   The support team will be able to triage this further with our driver team.   Thank you  Miklos Szurap Customer Operations Engineer, Cloudera ... View more

Glad to hear that. 🙂 The "hive.stats.autogather" should be unrelated to this, it just controls whether Hive should gather statistics at the end of INSERT statements, disabling it just speeds up the insert query somewhat. If you see something weird or not working with that enabled, feel free to open a support case on our Support Portal. See this and all the hive configuration descriptions in the HiveConf.java source code. Cheers,  Miklos ... View more

This sounds a Spring boot specific issue, a quick googling was leading me to  https://stackoverflow.com/questions/42073194/unable-to-detect-database-type please check if the suggestions in that discussion helps. ... View more

I assume you meant NVL function returns 0 or 1 if a null is found, or the specified expression in the argument - when using Hive. With Impala and NVL2 you would still need to have the outer query to "sum" up all the 1 values what we have mapped from the column value (from their real value to 0 or to 1). It would just be a bit nicer, but no real change. ... View more

Great, glad to hear that it was helpful. Actually I was thinking about using the NVL function, but in Hive that does not offer a value for the "else" part, like Impala's NVL2 funcion: https://impala.apache.org/docs/build/asf-site-html/topics/impala_conditional_functions.html#conditional_functions__nvl2   with that the query would be much simpler (no need for CASE WHEN ... THEN ... ELSE ... END), just a "NVL2(CustFirstName, 0, 1) SELECT NVL2('ABC', 'Is Not Null', 'Is Null'); -- Returns 'Is Not Null' Again, this is for Impala, Hive does not have this function unfortunately. ... View more

Hi  @ThomasCloudeara , The ImpalaJDBC library/dependency is not published into any public maven repository due to licensing questions. After accepting the license terms you need to download the .zip from our download site, extract it, and "install" the ImpalaJDBC42.jar into one of your company wide or to your machine local maven repository.  Follow the Maven guide: https://maven.apache.org/guides/mini/guide-3rd-party-jars-local.html ... View more