I'm having some trouble executing function-based Hive queries in QlikView (ODBC connector parse error), and I'm looking to understand if the fault lies in the QV syntax, or if functions are simply not supported by the Hive ODBC driver.
The following works in Hive command line:
select distinct a_date, reverse(a_date) from a_table where a_date > '20151201';
The following fails in QV:
WHERE "a_date" > '20151201';
The QV and connector implementation is fine otherwise; substituting 'reverse' with 'max' executes happily.