Backports of Hive 2.2.0 UDF functions to Hive 0.13.0.

Find the list of backported functions in this DDL.

Usage

-- build jars
$ bin/build.sh

-- run Hive cli session
$ hive

-- deploy jar
add jar target/hive-udf-backports-x.y.z.jar;

-- load functions
source resources/create-functions.hive;

Maven repository

<dependency>
    <groupId>io.github.myui</groupId>
    <artifactId>hive-udf-backports</artifactId>
    <version>0.0.2</version>
</dependency>

List of Functions

-- since v1.1.0
greatest
least
add_months
last_day
initcap

-- since v1.2.0
factorial
cbrt
shiftleft
shiftright
shiftrightunsigned
current_date
current_timestamp
next_day
trunc
months_between
date_format
levenshtein
soundex

-- since v1.3.0
quarter
chr
replace
substring_index
md5
sha1
crc32
sha2
aes_encrypt
aes_decrypt

-- since v2.1.0
mask
mask_first_n
mask_last_n
mask_show_first_n
mask_show_last_n
mask_hash

-- since v2.2.0
nullif
character_length
regr_avgx
regr_avgy
regr_count
regr_intercept
regr_r2
regr_slope
regr_sxx
regr_sxy
regr_syy