Member since
09-06-2022
2
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1604 | 09-06-2022 10:57 AM |
09-06-2022
10:57 AM
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
... View more
09-06-2022
01:49 AM
Hi 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
... View more
Labels: