设为首页 加入收藏

TOP

hive中的所有函数
2018-12-07 01:23:26 】 浏览:6
Tags:hive 所有 函数
版权声明:本文为博主原创文章,未经博主允许不得转载。http://blog.csdn.net/dataastron https://blog.csdn.net/dataastron/article/details/78900037

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

编程开发网
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇hive 如何去掉重复数据,显示第一.. 下一篇Hive UNION ALL的使用和Hive子查询

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

array(4) { ["type"]=> int(8) ["message"]=> string(24) "Undefined variable: jobs" ["file"]=> string(32) "/mnt/wp/cppentry/do/bencandy.php" ["line"]=> int(214) }