zero-one.geni.sql — zero.one/geni 0.0.9

&& clj

(&& & exprs)

* clj

(* & exprs)

+ clj

(+ & exprs)

- clj

(- & exprs)

->date-col clj

->timestamp-col clj

->utc-timestamp clj

/ clj

(/ & exprs)

< clj

<= clj

=== clj

> clj

>= clj

abs clj

(abs expr)

acos clj

(acos expr)

add-months clj

(add-months expr months)

approx-count-distinct clj

(approx-count-distinct expr)

(approx-count-distinct expr rsd)

array clj

(array exprs)

array-contains clj

(array-contains expr value)

array-distinct clj

(array-distinct expr)

array-except clj

(array-except left right)

array-intersect clj

(array-intersect left right)

array-join clj

(array-join expr delimiter)

(array-join expr delimiter null-replacement)

array-max clj

(array-max expr)

array-min clj

(array-min expr)

array-position clj

(array-position expr value)

array-remove clj

(array-remove expr element)

array-repeat clj

(array-repeat left right)

array-sort clj

(array-sort expr)

array-union clj

(array-union left right)

arrays-overlap clj

(arrays-overlap left right)

arrays-zip clj

(arrays-zip exprs)

asc clj

(asc expr)

asc-nulls-first clj

(asc-nulls-first expr)

asc-nulls-last clj

(asc-nulls-last expr)

ascii clj

(ascii expr)

asin clj

(asin expr)

atan clj

(atan expr)

atan2 clj

(atan2 expr-x expr-y)

base64 clj

(base64 expr)

between clj

(between expr lower-bound upper-bound)

bin clj

(bin expr)

bitwise-not clj

(bitwise-not expr)

broadcast clj

(broadcast dataframe)

bround clj

(bround expr)

cast clj

(cast expr new-type)

cbrt clj

(cbrt expr)

ceil clj

(ceil expr)

collect-list clj

(collect-list expr)

collect-set clj

(collect-set expr)

concat clj

(concat & exprs)

concat-ws clj

(concat-ws sep & exprs)

contains clj

(contains expr literal)

conv clj

(conv expr from-base to-base)

corr clj

(corr l-expr r-expr)

cos clj

(cos expr)

cosh clj

(cosh expr)

count-distinct clj

(count-distinct & exprs)

covar clj

(covar l-expr r-expr)

covar-pop clj

(covar-pop l-expr r-expr)

covar-samp clj

crc32 clj

(crc32 expr)

cube-root clj

cume-dist clj

(cume-dist)

current-date clj

(current-date)

current-timestamp clj

(current-timestamp)

date-add clj

(date-add expr days)

date-diff clj

date-format clj

(date-format expr date-fmt)

date-sub clj

(date-sub expr days)

date-trunc clj

(date-trunc fmt expr)

datediff clj

(datediff l-expr r-expr)

day-of-month clj

(day-of-month expr)

day-of-week clj

(day-of-week expr)

day-of-year clj

(day-of-year expr)

decode clj

(decode expr charset)

degrees clj

(degrees expr)

dense-rank clj

(dense-rank)

desc clj

(desc expr)

desc-nulls-first clj

(desc-nulls-first expr)

desc-nulls-last clj

(desc-nulls-last expr)

element-at clj

(element-at expr value)

encode clj

(encode expr charset)

ends-with clj

(ends-with expr literal)

exp clj

(exp expr)

explode clj

(explode expr)

explode-outer clj

expr clj

(expr s)

factorial clj

(factorial expr)

flatten clj

(flatten expr)

floor clj

(floor expr)

format-number clj

(format-number expr decimal-places)

format-string clj

(format-string fmt exprs)

from-unixtime clj

(from-unixtime expr)

greatest clj

(greatest & exprs)

grouping clj

(grouping expr)

hash clj

(hash & exprs)

hex clj

(hex expr)

hour clj

(hour expr)

hypot clj

(hypot left-expr right-expr)

initcap clj

(initcap expr)

input-file-name clj

(input-file-name)

instr clj

(instr expr substr)

isin clj

(isin expr coll)

kurtosis clj

(kurtosis expr)

lag clj

(lag expr offset)

(lag expr offset default)

last clj

(last expr)

last-day clj

(last-day expr)

lead clj

(lead expr offset)

(lead expr offset default)

least clj

(least & exprs)

length clj

(length expr)

levenshtein clj

(levenshtein left-expr right-expr)

like clj

(like expr literal)

lit clj

(lit expr)

locate clj

(locate substr expr)

log clj

(log expr)

log1p clj

(log1p expr)

log2 clj

(log2 expr)

lower clj

(lower expr)

lpad clj

(lpad expr length pad)

ltrim clj

(ltrim expr)

md5 clj

(md5 expr)

minute clj

(minute expr)

mod clj

(mod left-expr right-expr)

monotonically-increasing-id clj

(monotonically-increasing-id)

month clj

(month expr)

months-between clj

(months-between l-expr r-expr)

nan? clj

(nan? expr)

nanvl clj

(nanvl left-expr right-expr)

negate clj

(negate expr)

next-day clj

(next-day expr day-of-week)

not clj

(not expr)

ntile clj

(ntile n)

null-count clj

(null-count expr)

null-rate clj

(null-rate expr)

null? clj

(null? expr)

percent-rank clj

(percent-rank)

pi clj

pmod clj

(pmod left-expr right-expr)

posexplode clj

(posexplode expr)

posexplode-outer clj

pow clj

(pow base exponent)

quarter clj

(quarter expr)

radians clj

(radians expr)

rand clj

(rand)

(rand seed)

randn clj

(randn)

(randn seed)

rank clj

(rank)

regexp-extract clj

(regexp-extract expr regex idx)

regexp-replace clj

(regexp-replace expr pattern-expr replacement-expr)

reverse clj

(reverse expr)

rint clj

(rint expr)

rlike clj

(rlike expr literal)

round clj

(round expr)

row-number clj

(row-number)

rpad clj

(rpad expr length pad)

rtrim clj

(rtrim expr)

second clj

(second expr)

sequence clj

(sequence start stop step)

sha1 clj

(sha1 expr)

sha2 clj

(sha2 expr n-bits)

shift-left clj

(shift-left expr num-bits)

shift-right clj

(shift-right expr num-bits)

shift-right-unsigned clj

(shift-right-unsigned expr num-bits)

shuffle clj

(shuffle expr)

sign clj

signum clj

(signum expr)

sin clj

(sin expr)

sinh clj

(sinh expr)

size clj

(size expr)

skewness clj

(skewness expr)

slice clj

(slice expr start length)

sort-array clj

(sort-array expr)

(sort-array expr asc)

spark-partition-id clj

(spark-partition-id)

split clj

(split expr pattern)

sqr clj

(sqr expr)

sqrt clj

(sqrt expr)

starts-with clj

(starts-with expr literal)

stddev clj

(stddev expr)

stddev-pop clj

(stddev-pop expr)

stddev-samp clj

struct clj

(struct & exprs)

substring clj

(substring expr pos len)

sum-distinct clj

(sum-distinct expr)

tan clj

(tan expr)

tanh clj

(tanh expr)

to-date clj

(to-date expr)

(to-date expr date-format)

to-timestamp clj

(to-timestamp expr)

(to-timestamp expr date-format)

to-utc-timestamp clj

(to-utc-timestamp expr)

translate clj

(translate expr match replacement)

trim clj

(trim expr trim-string)

unbase64 clj

(unbase64 expr)

unhex clj

(unhex expr)

unix-timestamp clj

(unix-timestamp)

(unix-timestamp expr)

(unix-timestamp expr pattern)

upper clj

(upper expr)

var-pop clj

(var-pop expr)

var-samp clj

variance clj

(variance expr)

week-of-year clj

(week-of-year expr)

when clj

(when condition if-expr)

(when condition if-expr else-expr)

year clj

(year expr)

|| clj

(|| & exprs)