版权声明：本文为博主原创文章，未经博主允许不得转载。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 |
| | |
| ~ |