I am evaluating my options for low latency query engines. Does HAWQ have capabilities of using and calling hive UDF? Please do not provide me other options for low latency engines as that is not the question.
HAWQ allows access to Hive tables (data) via PXF extension framework, but the queries are still via HAWQ and thus postgreSQL. http://hdb.docs.pivotal.io/200/hawq/pxf/PivotalExtensionFrameworkPXF.html
HAWQ allows UDFS to be written in these languages: PL/Java, PL/pgSQL, PL/R
HAWQ does not have access to Hive UDFs, which all extend ora.apache.hadoop.hive.sq.exec.UDF.