Backports of Hive UDFs

Backports of recent Hive UDF functions to Hive 0.13.0

License	Apache License, Version 2.0
GroupId	io.github.myui
ArtifactId	hive-udf-backports
Last Version	0.0.2
Release Date	May 23, 2017
Type	jar
Description	Backports of Hive UDFs Backports of recent Hive UDF functions to Hive 0.13.0
Project URL	https://github.com/myui/hive-udf-backports
Source Code Management	https://github.com/myui/hive-udf-backports.git

Download hive-udf-backports

Filename	Size
hive-udf-backports-0.0.2.pom
hive-udf-backports-0.0.2.jar	55 KB
hive-udf-backports-0.0.2-sources.jar	30 KB
hive-udf-backports-0.0.2-javadoc.jar	174 KB

How to add to project

Apache Maven

<!-- https://jarcasting.com/artifacts/io.github.myui/hive-udf-backports/ -->
<dependency>
    <groupId>io.github.myui</groupId>
    <artifactId>hive-udf-backports</artifactId>
    <version>0.0.2</version>
</dependency>

Gradle Groovy

// https://jarcasting.com/artifacts/io.github.myui/hive-udf-backports/
implementation 'io.github.myui:hive-udf-backports:0.0.2'

Gradle Kotlin

// https://jarcasting.com/artifacts/io.github.myui/hive-udf-backports/
implementation ("io.github.myui:hive-udf-backports:0.0.2")

Apache Buildr

'io.github.myui:hive-udf-backports:jar:0.0.2'

Apache Ivy

<dependency org="io.github.myui" name="hive-udf-backports" rev="0.0.2">
  <artifact name="hive-udf-backports" type="jar" />
</dependency>

Groovy Grape

@Grapes(
@Grab(group='io.github.myui', module='hive-udf-backports', version='0.0.2')
)

Scala SBT

libraryDependencies += "io.github.myui" % "hive-udf-backports" % "0.0.2"

Leiningen

[io.github.myui/hive-udf-backports "0.0.2"]

Dependencies

provided (2)

Group / Artifact	Type	Version
org.apache.hadoop : hadoop-common	jar	2.4.0
org.apache.hive : hive-exec	jar	0.13.0

test (1)

Group / Artifact	Type	Version
junit : junit	jar	4.12

Project Modules

There are no modules declared in this project.

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

Versions

Version
0.0.2 May 23, 2017
0.0.1 May 8, 2017