hive中的所有函数

hive>show functions;查看所有函数
hive>describe function unix_timestamp;查看函数的使用方法

unix_timestamp(date[, pattern]) - Converts the time to a number

!

!=

%

&

*

+

-

/

<

<=

<=>

<>

=

==

>

>=

^

abs

acos

add_months

and

array

array_contains

ascii

asin

assert_true

atan

avg

base64

base64tostring

between

bin

case

cbrt

ceil

ceiling

coalesce

collect_all

collect_list

collect_set

compute_stats

concat

concat_ws

context_ngrams

conv

corr

cos

count

covar_pop

covar_samp

crc32

create_union

csum

cume_dist

current_database

current_date

current_timestamp

current_user

date_add

date_format

date_sub

datediff

day

dayofmonth

decode

degrees

dense_rank

div

e

elt

encode

encryptindex

ewah_bitmap

ewah_bitmap_and

ewah_bitmap_empty

ewah_bitmap_or

exp

explode

factorial

field

find_in_set

first_value

floor

format_number

from_unixtime

from_utc_timestamp

fulltohalf

geocomutils

geometricmean

geoudf

get_date_time

get_index

get_json_object

getbrowser

getcommision

getconn

getdatatypebyskuid

getendtime

getiparea

getmapping

getmaxenddate

getrand

getscore

getskuprcgrade

getstick

gettime

getuserprcgrade

getuv

getyj

greatest

hash

hex

hexadecimalgb

histogram_numeric

hour

hv

if

in

in_file

index

indexchange

initcap

inline

instr

isnotnull

isnull

java_method

json_tuple

lag

last_day

last_value

lcase

lead

least

length

levenshtein

like

ln

locate

log

log10

log2

lower

lpad

ltrim

map

map_keys

map_values

matchpath

max

md5

min

minute

mon_firstday

month

month_add

months_between

named_struct

negative

newband

next_day

ngrams

noop

noopstreaming

noopwithmap

noopwithmapstreaming

norm

not

ntile

numbertostring

nvl

or

pageregexp

pageregexp1

parse_url

parse_url_tuple

percent_rank

percentile

percentile_approx

pi

pmod

posexplode

positive

pow

power

printf

quarter

radians

rand

rank

reflect

reflect2

regexp

regexp_extract

regexp_replace

repeat

reverse

rlike

round

row_number

rpad

rtrim

second

sentences

sha

sha1

sha2

shiftleft

shiftright

shiftrightunsigned

sign

sin

size

sort_array

soundex

space

split

sqrt

stack

std

stddev

stddev_pop

stddev_samp

str_to_map

string2map

struct

substr

substring

substring_index

sum

sysdate

tan

time2est

to_date

to_unix_timestamp

to_utc_timestamp

translate

trim

trunc

ucase

unbase64

unhex

unix_timestamp

upper

var_pop

var_samp

variance

week

weekofyear

when

windowingtablefunction

xpath

xpath_boolean

xpath_double

xpath_float

xpath_int

xpath_long

xpath_number

xpath_short

xpath_string

year

|

~