Page History

T

explode(a ARRAY<T>)

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

TkT_key,TvT_value

explode(m MAP<Tk,Tv>MAP<T_key,T_value>)

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,T2T₁,...,TnT_n

inline(a ARRAY<STRUCT<f1:T1,f2:T2ARRAY<STRUCT<f₁:T₁,...,fn:Tn>>f_n:T_n>>)

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

string₁,...,string_n

json_tuple(jsonStr string,k₁ string,...,k_n string)

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

string ₁,...,string_n

parse_url_tuple(urlStr string,p₁ string,...,p_n string)

Takes URL string and a set of n URL parts, and returns a tuple of n values.

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>.

T1,...,Tn/r

stack(r int, V1 T1,V2 T2,...,Vn-1 Tn/r-1,Vn Tn/r)