hive中的所有函数

来源：互联网发布：不知道自己做什么知乎编辑：程序博客网时间：2024/06/03 20:07

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

unix_timestamp(date[, pattern]) - Converts the time to a number
!!=%&*+-/<<=<=><>===>>=^absacosadd_monthsandarrayarray_containsasciiasinassert_trueatanavgbase64base64tostringbetweenbincasecbrtceilceilingcoalescecollect_allcollect_listcollect_setcompute_statsconcatconcat_wscontext_ngramsconvcorrcoscountcovar_popcovar_sampcrc32create_unioncsumcume_distcurrent_databasecurrent_datecurrent_timestampcurrent_userdate_adddate_formatdate_subdatediffdaydayofmonthdecodedegreesdense_rankdiveeltencodeencryptindexewah_bitmapewah_bitmap_andewah_bitmap_emptyewah_bitmap_orexpexplodefactorialfieldfind_in_setfirst_valuefloorformat_numberfrom_unixtimefrom_utc_timestampfulltohalfgeocomutilsgeometricmeangeoudfget_date_timeget_indexget_json_objectgetbrowsergetcommisiongetconngetdatatypebyskuidgetendtimegetipareagetmappinggetmaxenddategetrandgetscoregetskuprcgradegetstickgettimegetuserprcgradegetuvgetyjgreatesthashhexhexadecimalgbhistogram_numerichourhvifinin_fileindexindexchangeinitcapinlineinstrisnotnullisnulljava_methodjson_tuplelaglast_daylast_valuelcaseleadleastlengthlevenshteinlikelnlocateloglog10log2lowerlpadltrimmapmap_keysmap_valuesmatchpathmaxmd5minminutemon_firstdaymonthmonth_addmonths_betweennamed_structnegativenewbandnext_dayngramsnoopnoopstreamingnoopwithmapnoopwithmapstreamingnormnotntilenumbertostringnvlorpageregexppageregexp1parse_urlparse_url_tuplepercent_rankpercentilepercentile_approxpipmodposexplodepositivepowpowerprintfquarterradiansrandrankreflectreflect2regexpregexp_extractregexp_replacerepeatreverserlikeroundrow_numberrpadrtrimsecondsentencesshasha1sha2shiftleftshiftrightshiftrightunsignedsignsinsizesort_arraysoundexspacesplitsqrtstackstdstddevstddev_popstddev_sampstr_to_mapstring2mapstructsubstrsubstringsubstring_indexsumsysdatetantime2estto_dateto_unix_timestampto_utc_timestamptranslatetrimtruncucaseunbase64unhexunix_timestampuppervar_popvar_sampvarianceweekweekofyearwhenwindowingtablefunctionxpathxpath_booleanxpath_doublexpath_floatxpath_intxpath_longxpath_numberxpath_shortxpath_stringyear|~

阅读全文

'); })();