I am facing some issues in HPLSQL.I am using Hive 1.2 version Can you please help me out. 1. TRIM in plsql supports trimming of a pattern from a string.. but TRIM in hplsql removes only spaces but doesnt support removing a pattern. 2. UDFs created on hive on cannot be used in a hplsql script as its antl4 parser doesnt have it in its lexicon ... View more

Hive UDFs Similar to Oracle Funcitons https://github.com/nexr/hive-udf/wiki ... View more

For folks interested in data science, HAWQ supports Apache MADlib (incubating) http://madlib.incubator.apache.org/ which is a mature, distributed, in-database machine learning library. Hive does not have an integrated machine learning capability at the current time. ... View more