question Re: Supported functions in Hive ODBC driver in Support Questions

Supported functions in Hive ODBC driver

Markyd — Tue, 06 Sep 2022 08:49:03 GMT

I'm looking for a list of supported ODBC functions in the HIVE ODBC driver..

I have a particular issue with { fn EXTRACT(YEAR FROM "datecolumn") } which is not recognised but a comprehensive list would be great.

Thanks

Re: Supported functions in Hive ODBC driver

araujo — Tue, 06 Sep 2022 11:17:37 GMT

@Markyd ,

Functions used in Hive queries are usually passed to the Hive service as is. I don't think the ODBC driver does any particular processing or validation of those functions. At the end of the day it's a matter of whether the Hive version you're using supports that function or not, and this depends on the Hive version being used, not the driver version.

Here you can see a comprehensive list of Hive functions and the associated Hive version where they were introduced: https://cwiki.apache.org/confluence/display/hive/languagemanual+udf

Which version of Hive are you using?

Are you using the Cloudera ODBC Drivers for Hive? Which version?

Cheers,

André

Re: Supported functions in Hive ODBC driver

Markyd — Tue, 06 Sep 2022 17:57:03 GMT

Thanks for the info, that's very useful. It's Hive 3.1.2, Cloudera ODBC for Hive 2.6.1

Interestingly I get the following results querying though the ODBC driver (use native query = false)

SELECT extract (year FROM "datecolumn") -- accepted

SELECT { fn extract (year FROM "datecolumn") } -- ParseException

and yet

SELECT { fn year("datecolumn") } - accepted

So there may be an inconsistency in the way the driver parses the ODBC function syntax.

Mark