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