hive数据库numeric_HIVE支持的函数

hive的函数支持还是蛮丰富的，

需要用到hive函数的同志们可以用下列两个命令查询hive支持的函数。

查询函数的说明：

hive> describe

function substr;

OK

substr(str, pos[, len]) - returns the substring of str that starts

at pos and is of length len

Time taken: 0.205 seconds

查询hive支持哪些函数

hive> show

functions;

!

!=

%

&

*

+

-

/

<

<=

<>

=

==

>

>=

^

abs

acos

and

array

array_contains

ascii

asin

atan

avg

bigint

bin

boolean

case

ceil

ceiling

coalesce

concat

concat_ws

conv

cos

count

date_add

date_sub

datediff

day

dayofmonth

degrees

div

double

e

elt

exp

explode

field

find_in_set

float

floor

from_unixtime

get_json_object

hash

hex

histogram_numeric

hour

if

in

index

instr

int

isnotnull

isnull

lcase

length

like

ln

locate

log

log10

log2

lower

lpad

ltrim

map

max

min

minute

month

negative

not

or

parse_url

percentile

pi

pmod

positive

pow

power

radians

rand

regexp

regexp_extract

regexp_replace

repeat

reverse

rlike

round

rpad

rtrim

second

sign

sin

size

smallint

space

split

sqrt

std

stddev

stddev_pop

stddev_samp

string

struct

substr

substring

sum

tan

tinyint

to_date

trim

ucase

unhex

unix_timestamp

upper

var_pop

var_samp

variance

weekofyear

when

xpath

xpath_boolean

xpath_double

xpath_float

xpath_int

xpath_long

xpath_number

xpath_short

xpath_string

year