SQL Functions

kld(double mu1, double sigma1, double mu2, double sigma2) – Returns KL divergence between two distributions

json_map(json) – Returns a map of key-value pairs from a JSON string Platforms: WhereOS, Spark,

java_method(class, method[, arg1[, arg2 ..]]) – Calls a method with reflection. Platforms: WhereOS, Spark, Hive

jobconf_gets() – Returns the value from JobConf Platforms: WhereOS, Spark, Hive Class: hivemall.tools.mapred.JobConfGetsUDF More functions

jobid() – Returns the value of mapred.job.id Platforms: WhereOS, Spark, Hive Class: hivemall.tools.mapred.JobIdUDF More functions

Platforms: WhereOS, Spark, Hive Class: brickhouse.udf.collect.JoinArrayUDF More functions can be added to WhereOS via Python