Hive v0.13 or later supports permanent functions that lives across sessions.

Permanent functions are useful when you are using Hive through Hiveserver or to avoid hivemall installation for each session.

Put hivemall jar to HDFS

First, put hivemall jar to HDFS as follows:

hadoop fs -mkdir -p /apps/hivemall
hadoop fs -put hivemall-all-xxx.jar /apps/hivemall

Create permanent functions

The following is an auxiliary step to define functions for hivemall databases, not for the default database.

CREATE DATABASE IF NOT EXISTS hivemall;
USE hivemall;

Then, create permanent functions using define-all-as-permanent.hive, a DDL script to define permanent UDFs.

set hivevar:hivemall_jar=hdfs:///apps/hivemall/hivemall-all-xxx.jar.jar;

source /tmp/define-all-as-permanent.hive;

Confirm functions

show functions "hivemall.*";

> hivemall.adadelta
> hivemall.adagrad

Caution

You need to specify "hivemall." prefix to call hivemall UDFs in your queries if UDFs are loaded into non-default scheme, in this case hivemall.

results matching ""

    No results matching ""