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