Page History

T

explode(a ARRAY<T>)

Explode Explodes an array to multiple rows. Returns a row-set with a single column (col), one row for each element from the array.

Tk,Tv

explode(m MAP<Tk,Tv>)

Explode Explodes a map to multiple rows. Returns a row-set with a two columns (key,value) , one row for each key-value pair from the input map. (As of Hive 0.8.0.).

T1,T2,...,Tn

inline(a ARRAY<STRUCT<f1:T1,f2:T2,...,fn:Tn>>)

Explode Explodes an array of structs to multiple rows. Returns a row-set with N columns (N = number of top level elements in the struct), one row per struct from the array. (As of Hive 0.10.)

tuple

json_tuple(jsonStr, k1, k2, ...)

Takes a set of names (keys) and a JSON string, and returns a tuple of values. This is a more efficient version of the get_json_object UDF because it can get multiple keys with just one call.

tuple

parse_url_tuple(url, p1, p2, ...)

This is similar to the parse_url() UDF but can extract multiple parts at once out of a URL. Valid part names are: HOST, PATH, QUERY, REF, PROTOCOL, AUTHORITY, FILE, USERINFO, QUERY:<KEY>.

N rowsT1,...,Tr/n

stack(INT n, v_1, v_2, r int, V1 T1,..., v_kVn Tn)

Breaks up v_1 n values - V1,..., v_k Vn into n rrows. Each row will have k r/n columns. n r must be constant.