Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Can HAWQ call hive UDF?

Highlighted

Can HAWQ call hive UDF?

Super Guru

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.

1 REPLY 1

Re: Can HAWQ call hive UDF?

Guru

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

http://hdb.docs.pivotal.io/200/hawq/plext/UsingProceduralLanguages.html

HAWQ does not have access to Hive UDFs, which all extend ora.apache.hadoop.hive.sq.exec.UDF.

Don't have an account?
Coming from Hortonworks? Activate your account here