Loading
SHOW FUNCTIONS
SHOW FUNCTIONS [LIKE pattern]?- SQL match pattern
Description: List all the SQL functions and their type. TheLIKE clause can be used to restrict the list of names to the given pattern.
SHOW FUNCTIONS; name | type-----------------+---------------AVG |AGGREGATECOUNT |AGGREGATEFIRST |AGGREGATEFIRST_VALUE |AGGREGATELAST |AGGREGATELAST_VALUE |AGGREGATEMAX |AGGREGATEMIN |AGGREGATESUM |AGGREGATEKURTOSIS |AGGREGATEMAD |AGGREGATEPERCENTILE |AGGREGATEPERCENTILE_RANK |AGGREGATESKEWNESS |AGGREGATESTDDEV_POP |AGGREGATESTDDEV_SAMP |AGGREGATESUM_OF_SQUARES |AGGREGATEVAR_POP |AGGREGATEVAR_SAMP |AGGREGATEHISTOGRAM |GROUPINGCASE |CONDITIONALCOALESCE |CONDITIONALGREATEST |CONDITIONALIFNULL |CONDITIONALIIF |CONDITIONALISNULL |CONDITIONALLEAST |CONDITIONALNULLIF |CONDITIONALNVL |CONDITIONALCURDATE |SCALARCURRENT_DATE |SCALARCURRENT_TIME |SCALARCURRENT_TIMESTAMP|SCALARCURTIME |SCALARDATEADD |SCALARDATEDIFF |SCALARDATEPART |SCALARDATETIME_FORMAT |SCALARDATETIME_PARSE |SCALARDATETRUNC |SCALARDATE_ADD |SCALARDATE_DIFF |SCALARDATE_FORMAT |SCALARDATE_PARSE |SCALARDATE_PART |SCALARDATE_TRUNC |SCALARDAY |SCALARDAYNAME |SCALARDAYOFMONTH |SCALARDAYOFWEEK |SCALARDAYOFYEAR |SCALARDAY_NAME |SCALARDAY_OF_MONTH |SCALARDAY_OF_WEEK |SCALARDAY_OF_YEAR |SCALARDOM |SCALARDOW |SCALARDOY |SCALARFORMAT |SCALARHOUR |SCALARHOUR_OF_DAY |SCALARIDOW |SCALARISODAYOFWEEK |SCALARISODOW |SCALARISOWEEK |SCALARISOWEEKOFYEAR |SCALARISO_DAY_OF_WEEK |SCALARISO_WEEK_OF_YEAR |SCALARIW |SCALARIWOY |SCALARMINUTE |SCALARMINUTE_OF_DAY |SCALARMINUTE_OF_HOUR |SCALARMONTH |SCALARMONTHNAME |SCALARMONTH_NAME |SCALARMONTH_OF_YEAR |SCALARNOW |SCALARQUARTER |SCALARSECOND |SCALARSECOND_OF_MINUTE |SCALARTIMESTAMPADD |SCALARTIMESTAMPDIFF |SCALARTIMESTAMP_ADD |SCALARTIMESTAMP_DIFF |SCALARTIME_PARSE |SCALARTODAY |SCALARTO_CHAR |SCALARWEEK |SCALARWEEK_OF_YEAR |SCALARYEAR |SCALARABS |SCALARACOS |SCALARASIN |SCALARATAN |SCALARATAN2 |SCALARCBRT |SCALARCEIL |SCALARCEILING |SCALARCOS |SCALARCOSH |SCALARCOT |SCALARDEGREES |SCALARE |SCALAREXP |SCALAREXPM1 |SCALARFLOOR |SCALARLOG |SCALARLOG10 |SCALARMOD |SCALARPI |SCALARPOWER |SCALARRADIANS |SCALARRAND |SCALARRANDOM |SCALARROUND |SCALARSIGN |SCALARSIGNUM |SCALARSIN |SCALARSINH |SCALARSQRT |SCALARTAN |SCALARTRUNC |SCALARTRUNCATE |SCALARASCII |SCALARBIT_LENGTH |SCALARCHAR |SCALARCHARACTER_LENGTH |SCALARCHAR_LENGTH |SCALARCONCAT |SCALARINSERT |SCALARLCASE |SCALARLEFT |SCALARLENGTH |SCALARLOCATE |SCALARLTRIM |SCALAROCTET_LENGTH |SCALARPOSITION |SCALARREPEAT |SCALARREPLACE |SCALARRIGHT |SCALARRTRIM |SCALARSPACE |SCALARSTARTS_WITH |SCALARSUBSTRING |SCALARTRIM |SCALARUCASE |SCALARCAST |SCALARCONVERT |SCALARDATABASE |SCALARUSER |SCALARST_ASTEXT |SCALARST_ASWKT |SCALARST_DISTANCE |SCALARST_GEOMETRYTYPE |SCALARST_GEOMFROMTEXT |SCALARST_WKTTOSQL |SCALARST_X |SCALARST_Y |SCALARST_Z |SCALARSCORE |SCOREThe list of functions returned can be customized based on the pattern.
It can be an exact match:
SHOW FUNCTIONS LIKE 'ABS'; name | type---------------+---------------ABS |SCALARA wildcard for exactly one character:
SHOW FUNCTIONS LIKE 'A__'; name | type---------------+---------------AVG |AGGREGATEABS |SCALARA wildcard matching zero or more characters:
SHOW FUNCTIONS LIKE 'A%'; name | type---------------+---------------AVG |AGGREGATEABS |SCALARACOS |SCALARASIN |SCALARATAN |SCALARATAN2 |SCALARASCII |SCALAROr of course, a variation of the above:
SHOW FUNCTIONS LIKE '%DAY%'; name | type---------------+---------------DAY |SCALARDAYNAME |SCALARDAYOFMONTH |SCALARDAYOFWEEK |SCALARDAYOFYEAR |SCALARDAY_NAME |SCALARDAY_OF_MONTH |SCALARDAY_OF_WEEK |SCALARDAY_OF_YEAR |SCALARHOUR_OF_DAY |SCALARISODAYOFWEEK |SCALARISO_DAY_OF_WEEK|SCALARMINUTE_OF_DAY |SCALARTODAY |SCALAR