Apache Hive
Space shortcuts
Child pages
  • LanguageManual UDF
  Version Published Changed By Comment Actions
CURRENT (v. 216) Dec 30, 2021 14:04
Sankar Hariappan
Migration of unmigrated content due to installation of a new plugin  
v. 215 Dec 30, 2021 14:04
Sankar Hariappan
Updated changes due to introduction of DateTimeFormatter in HIVE-25458
v. 214 May 28, 2019 16:11
Miklos Gergely
v. 213 May 27, 2019 19:59
Miklos Gergely
v. 212 May 27, 2019 19:57
Miklos Gergely
v. 211 Feb 17, 2019 09:56
Mani M
Included quote function
v. 210 Feb 05, 2019 09:46
Mani M
v. 209 Oct 08, 2018 20:59
Zoltan Haindrich
Bharath Krishna
nullif added in 2.3 not 2.2
v. 208 Jun 18, 2018 00:57
Bharath Krishna
add_months update doc to include output_date_format argument
v. 207 Jun 06, 2018 23:33
Lefty Leverenz
edit 2 timestamp descriptions in Date Functions, change signature of 2nd to match 1st (ts, not *)
v. 206 Oct 19, 2017 22:38
Andrew Sherman
v. 205 Jun 07, 2017 22:10
Dudu Markovitz
v. 204 Jun 06, 2017 10:32
Dudu Markovitz
v. 203 Jun 05, 2017 20:17
Dudu Markovitz
v. 202 Jun 05, 2017 20:14
Dudu Markovitz
v. 201 Jun 05, 2017 18:46
Dudu Markovitz
v. 200 Jun 05, 2017 18:27
Dudu Markovitz
v. 199 Jun 05, 2017 18:25
Dudu Markovitz
v. 198 Jun 05, 2017 17:21
Dudu Markovitz
v. 197 Jun 05, 2017 17:20
Dudu Markovitz
v. 196 Jun 05, 2017 17:15
Dudu Markovitz
v. 195 Jun 05, 2017 17:14
Dudu Markovitz
v. 194 Jun 05, 2017 17:12
Dudu Markovitz
v. 193 Jun 05, 2017 15:26
Dudu Markovitz
v. 192 May 19, 2017 15:25
Zoltan Haindrich
search conditions (A IS TRUE)
v. 191 May 07, 2017 18:41
Sahil Takiar
v. 190 Apr 04, 2017 09:50
Dudu Markovitz
v. 189 Mar 23, 2017 12:54
Dudu Markovitz
v. 188 Mar 20, 2017 04:43
Carter Shanklin
Added regr_* from HIVE-15978
v. 187 Mar 20, 2017 04:22
Carter Shanklin
Added info for character_length / octet_length
v. 186 Mar 10, 2017 11:18
Lefty Leverenz
add release & jira link for assert_true (HIVE-2532)
v. 185 Mar 10, 2017 00:05
Lefty Leverenz
move anchors before heading text "Operators Precedences" to improve incoming links
v. 184 Mar 09, 2017 23:59
Lefty Leverenz
fix capitalization of "Operators precedences" section, add anchor for old heading
v. 183 Feb 24, 2017 17:49
Dudu Markovitz
v. 182 Feb 24, 2017 17:37
Dudu Markovitz
v. 181 Feb 22, 2017 04:50
Dudu Markovitz
v. 180 Feb 21, 2017 22:00
Dudu Markovitz
v. 179 Feb 21, 2017 20:43
Dudu Markovitz
v. 178 Feb 18, 2017 18:08
Dudu Markovitz
v. 177 Feb 18, 2017 17:59
Dudu Markovitz
v. 176 Feb 17, 2017 09:08
Dudu Markovitz
v. 175 Feb 09, 2017 13:31
Nanda kumar
Additional details added for lpad and rpad UDFs
v. 174 Feb 02, 2017 23:51
Alexander Pivovarov
fixed default delimiter2 value for str_to_map UDF
v. 173 Oct 28, 2016 05:06
Carter Shanklin
Added extract UDF
v. 172 Oct 24, 2016 12:22
Zoltan Haindrich
v. 171 Oct 24, 2016 11:50
Zoltan Haindrich
add concatenate(||)
v. 170 Oct 24, 2016 11:12
Zoltan Haindrich
remove && / || from logical operators.... they doesnt work that way - AFAIK they never worked like this
v. 169 Oct 04, 2016 18:47
Gopal Vijayaraghavan
v. 168 Oct 04, 2016 06:24
Lefty Leverenz
edit descriptions of current_user() and logged_in_user() for HIVE-14100
v. 167 Oct 03, 2016 11:30
Peter Vary
v. 166 Oct 03, 2016 09:17
Peter Vary
v. 165 Sep 11, 2016 05:52
Lefty Leverenz
trivial edit: remove a space in nullif() description
v. 164 Sep 10, 2016 10:32
Zoltan Haindrich
added doc for nullif function
v. 163 Sep 04, 2016 06:08
Lefty Leverenz
add 1.3.0 for chr() and replace(), minor edits
v. 162 Sep 03, 2016 17:38
Carter Shanklin
Fixed description for chr.
v. 161 Sep 03, 2016 17:37
Carter Shanklin
Added chr and replace
v. 160 Sep 03, 2016 17:20
Carter Shanklin
Added the version misc UDF
v. 159 Aug 31, 2016 15:02
Carter Shanklin
Trivial typo fix
v. 158 Aug 31, 2016 14:59
Carter Shanklin
Incorporated some review comments in the masking section
v. 157 Aug 30, 2016 22:26
Carter Shanklin
Added data masking docs for HIVE-13568. First edit, fixes welcome
v. 156 Jul 07, 2016 00:13
Shannon Ladymon
Minor Edits
v. 155 Jul 07, 2016 00:12
Shannon Ladymon
Minor Edits
v. 154 Jul 07, 2016 00:05
Shannon Ladymon
Updated to_date, date_add, and date_sub with new return type based on HIVE-13248
v. 153 Mar 31, 2016 15:28
Lars Francke
Addendum to last change
v. 152 Mar 31, 2016 15:27
Lars Francke
Fix documentation for shift* UDFs
v. 151 Mar 20, 2016 22:03
Lefty Leverenz
change future to past tense for HIVE-7314 bug fix
v. 150 Mar 14, 2016 22:45
Shannon Ladymon
Added current_database() to Misc UDF functions
v. 149 Dec 13, 2015 01:19
Carl Steinbach
Corrected information about the == operator.
v. 148 Oct 16, 2015 23:03
Szehon Ho
v. 147 Oct 16, 2015 18:50
Szehon Ho
moved greatest/least to "Mathematical UDF" section and updated description based on HIVE-12082
v. 146 Sep 08, 2015 06:53
Lefty Leverenz
trivial edit: remove leading space in aes_decrypt
v. 145 Sep 06, 2015 03:05
Alexander Pivovarov
v. 144 Aug 28, 2015 00:41
Shannon Ladymon
(changed . to ... for UDAF count(Distinct expr[, expr.])
v. 143 Aug 28, 2015 00:29
Shannon Ladymon
(Added link to hive.optimize.distinct.rewrite for UDAF count)
v. 142 Aug 14, 2015 05:27
Lefty Leverenz
monospace font for variables a, d in BROUND descriptions (HIVE-11103)
v. 141 Aug 13, 2015 18:49
Alexander Pivovarov
v. 140 Jun 09, 2015 19:04
Jason Dere
Migrated to Confluence 5.3
v. 139 Jun 09, 2015 19:04
Jason Dere
Update trunc() docs, as format parameter is not currently optional
v. 138 Jun 05, 2015 21:45
Lefty Leverenz
add link to Lateral View in json_tuple section, misc. edits
v. 137 May 31, 2015 05:39
Alexander Pivovarov
v. 136 May 24, 2015 23:10
Gabor Liptak
Change signature as per HIVE-10806
v. 135 May 20, 2015 06:35
Alexander Pivovarov
v. 134 May 15, 2015 23:55
Alexander Pivovarov
v. 133 May 15, 2015 23:50
Alexander Pivovarov
v. 132 May 11, 2015 03:16
Lefty Leverenz
revise quarter() description, trivial edits for md5()
v. 131 May 10, 2015 21:29
Lefty Leverenz
fix typos and capitalization (reverted last fix due to accidental deletion of a table)
v. 130 May 10, 2015 21:16
Lefty Leverenz
Reverted from v. 128
v. 129 May 10, 2015 21:13
Lefty Leverenz
typo & Hive capitalization fixes
v. 128 May 06, 2015 17:33
Alexander Pivovarov
v. 127 May 06, 2015 17:26
Alexander Pivovarov
v. 126 Apr 28, 2015 04:21
Alexander Pivovarov
changed US_ASCII charset to US-ASCII
v. 125 Apr 25, 2015 03:49
Lefty Leverenz
trivial edits of date_format() description
v. 124 Apr 22, 2015 20:53
Alexander Pivovarov
v. 123 Apr 22, 2015 20:49
Alexander Pivovarov
v. 122 Apr 22, 2015 20:47
Alexander Pivovarov
v. 121 Apr 22, 2015 20:43
Alexander Pivovarov
v. 120 Apr 19, 2015 02:55
Lefty Leverenz
add Beeline & links in the introduction
v. 119 Apr 19, 2015 00:12
Douglas Moore
Add version info for NVL per Edward Capriolo.
v. 118 Apr 18, 2015 21:18
Douglas Moore
v. 117 Apr 09, 2015 03:41
Lefty Leverenz
Trivial edits for cast(). By the way, what does "Expected = ..." mean for the Return Type? (It's been there from the start.)
v. 116 Apr 08, 2015 18:12
Alexander Pivovarov
v. 115 Apr 08, 2015 02:57
Alexander Pivovarov
v. 114 Apr 01, 2015 06:56
Lefty Leverenz
trivial formatting in descriptions of shiftleft, shiftright, and shiftrightunsigned
v. 113 Mar 30, 2015 19:57
Alexander Pivovarov
v. 112 Mar 18, 2015 07:10
Lefty Leverenz
trivial edit in trunc() description
v. 111 Mar 18, 2015 04:49
Alexander Pivovarov
v. 110 Mar 17, 2015 00:51
Lefty Leverenz
change font to monospace for a few variables & constants in math UDFs
v. 109 Mar 16, 2015 17:57
Alexander Pivovarov
v. 108 Mar 16, 2015 17:38
Alexander Pivovarov
v. 107 Feb 28, 2015 02:10
Alexander Pivovarov
v. 106 Feb 20, 2015 01:51
Alexander Pivovarov
v. 105 Feb 11, 2015 09:55
Lefty Leverenz
trivial edits in initcap() description
v. 104 Feb 09, 2015 23:56
Alexander Pivovarov
v. 103 Feb 09, 2015 05:34
Alexander Pivovarov
v. 102 Feb 09, 2015 05:28
Alexander Pivovarov
v. 101 Feb 09, 2015 05:22
Alexander Pivovarov
v. 100 Feb 09, 2015 05:16
Alexander Pivovarov
v. 99 Feb 09, 2015 05:05
Alexander Pivovarov
v. 98 Feb 09, 2015 04:57
Alexander Pivovarov
v. 97 Feb 09, 2015 04:48
Alexander Pivovarov
v. 96 Feb 09, 2015 04:42
Alexander Pivovarov
v. 95 Feb 03, 2015 08:55
Lefty Leverenz
add version information to current_date and current_timestamp for HIVE-5472
v. 94 Feb 02, 2015 19:33
Jason Dere
docs for current_date/current_timestamp
v. 93 Dec 29, 2014 09:49
Lefty Leverenz
revise A / B for HIVE-6012 hive.compat
v. 92 Nov 15, 2014 08:59
Lefty Leverenz
finish adding examples for from_utc_timestamp() & to_utc_timestamp() from HIVE-2974 (unwanted save)
v. 91 Nov 15, 2014 08:54
Lefty Leverenz
add examples for from_utc_timestamp() & to_utc_timestamp() from HIVE-2974
v. 90 Nov 12, 2014 08:00
Szehon Ho
Added char/varchar support for translate (HIVE-6622)
v. 89 Nov 11, 2014 07:42
Szehon Ho
Mentioned HIVE-7292 in format_number
v. 88 Oct 26, 2014 23:38
Lefty Leverenz
replace link to Java tutorial SimpleDateFormat.html
v. 87 Oct 04, 2014 03:54
Lefty Leverenz
change line breaks to "
s" for regexp_extract & regexp_replace descriptions
v. 86 Oct 04, 2014 03:36
Lefty Leverenz
fix a typo in description of log(), trivial edits
v. 85 Oct 03, 2014 18:10
Jason Dere
v. 84 Oct 03, 2014 18:06
Jason Dere
v. 83 Jul 21, 2014 03:44
Lefty Leverenz
link reflect() in Misc. Functions to ReflectUDF doc
v. 82 Jul 16, 2014 06:45
Lefty Leverenz
add expression caching bug (HIVE-7314) fixed in 0.14.0
v. 81 Jul 04, 2014 07:02
Lefty Leverenz
mention bug fix for format_number in 0.14 (HIVE-7257)
v. 80 Jun 28, 2014 05:16
Lefty Leverenz
link to "Writing UDTFs"
v. 79 Mar 17, 2014 04:35
Lefty Leverenz
version information for decimal math functions added in HIVE-6327, HIVE-6246, HIVE-6385
v. 78 Feb 26, 2014 10:20
Lars Francke
Document HIVE-6327, HIVE-6246, HIVE-6385
v. 77 Feb 22, 2014 07:17
Lefty Leverenz
link to Hive Plugins doc – Creating Custom UDFs
v. 76 Jan 29, 2014 12:14
Lefty Leverenz
add version & JIRA link for ntile (HIVE-896)
v. 75 Jan 29, 2014 11:22
Lars Francke
Document ntile UDF
v. 74 Jan 28, 2014 08:37
Lefty Leverenz
minor edit: FLOUT -> FLOAT
v. 73 Jan 14, 2014 16:47
Lars Francke
minor clarification
v. 72 Jan 07, 2014 16:09
Lars Francke
Explain syntax of explode for maps
v. 71 Dec 05, 2013 13:29
Nicolas Lalevée
Migrated to Confluence 4.0
v. 70 Dec 05, 2013 13:29
Nicolas Lalevée
Fix mess about unix timestamps and time zones.
v. 69 Nov 29, 2013 10:41
Lars Francke
fixed doc of instr
v. 68 Nov 29, 2013 10:13
Lars Francke
Minor clarification for instr
v. 67 Nov 14, 2013 12:39
Lars Francke
formatting
v. 66 Nov 14, 2013 12:39
Lars Francke
Document subqueries in WHERE
v. 65 Nov 08, 2013 17:38
Eric N. Hanson
v. 64 Nov 04, 2013 17:11
Eric N. Hanson
v. 63 Nov 03, 2013 02:55
Lefty Leverenz
fix column values for explode() and posexplode() examples
v. 62 Oct 25, 2013 08:50
Lars Francke
Document HIVE-4943
v. 61 Sep 24, 2013 09:23
Lefty Leverenz
note case insensitivity of UDF names and other keywords
v. 60 Sep 24, 2013 08:25
Lefty Leverenz
escape brackets in A [NOT] LIKE B; misc. edits; emphasis for A == B
v. 59 Sep 19, 2013 15:45
Lars Francke
Document collect_list
v. 58 Sep 10, 2013 19:02
Mark Grover
v. 57 Aug 24, 2013 23:34
Lars Francke
Refactor UDTF section
v. 56 Aug 24, 2013 23:18
Lars Francke
v. 55 Aug 24, 2013 23:14
Lars Francke
Reformat the math functions to be more consistent
v. 54 Aug 15, 2013 13:48
Lars Francke
Document HIVE-2482
v. 53 Aug 13, 2013 22:08
Lars Francke
v. 52 Aug 13, 2013 22:07
Lars Francke
v. 51 Aug 11, 2013 20:18
Lefty Leverenz
fix description of RLIKE (thanks Darren Yin, Sergey Shelukhin, and Dean Wampler)
v. 50 Jul 15, 2013 08:00
Lefty Leverenz
change "operations" to "operators" in datatypes section
v. 49 Jul 15, 2013 07:57
Lefty Leverenz
add section on decimal types with link to Types doc
v. 48 Jul 06, 2013 21:05
Lefty Leverenz
add "(UDFs)" to title for easy recognition; also add "Operators and" for completeness
v. 47 Jul 04, 2013 00:24
Siyang Chen
v. 46 Apr 30, 2013 12:17
Matt Tucker
Added Hash() function definition
v. 45 Mar 07, 2013 14:58
Siyang Chen
v. 44 Feb 28, 2013 13:35
Sean Busbey
Noting that named_struct isn't in pre 0.8.0 releases.
v. 43 Dec 07, 2012 10:40
Matt Tucker
Added overloaded CONV definition
v. 42 Oct 12, 2012 11:44
Matt Tucker
v. 41 Aug 02, 2012 08:44
Lars Francke
formatting
v. 40 Aug 02, 2012 05:43
Lars Francke
Document HIVE-3238
v. 39 Jun 28, 2012 13:53
Mark Grover
v. 38 Jun 28, 2012 13:49
Mark Grover
v. 37 Jun 26, 2012 18:03
Lars Francke
Document create_union
v. 36 Jun 26, 2012 17:19
Lars Francke
Document binary UDFs
v. 35 Jun 13, 2012 18:20
Lars Francke
Document format_number UDF from HIVE-2694
v. 34 Jun 12, 2012 19:39
Lars Francke
document timestamp UDFs
v. 33 Jun 07, 2012 11:16
Lars Francke
Document HIVE-2418
v. 32 May 31, 2012 15:06
Lars Francke
Document second form of HIVE-2203
v. 31 May 31, 2012 14:58
Lars Francke
Document reflect and java_method UDFs
v. 30 May 31, 2012 14:22
Lars Francke
Ordered the string functions alphabetically
v. 29 May 31, 2012 14:14
Lars Francke
Document printf UDF
v. 28 May 30, 2012 19:29
Lars Francke
Document the sort_array UDF
v. 27 May 30, 2012 19:24
Lars Francke
Document the BETWEEN operator
v. 26 May 30, 2012 16:39
Lars Francke
Document the null-safe-equals operator <=>
v. 25 Apr 23, 2012 23:52
Mark Grover
v. 24 Apr 23, 2012 23:51
Mark Grover
v. 23 Apr 23, 2012 23:48
Mark Grover
v. 22 Jan 24, 2012 16:34
Matt Tucker
v. 21 Jan 24, 2012 16:03
Matt Tucker
Added Mathematical UDFs that are in 0.7.1 that were not previously listed.
v. 20 Dec 09, 2011 18:27
Unknown User (akramer@fb.com)
v. 19 Nov 29, 2011 20:07
Jonathan Chang
v. 18 Nov 18, 2011 14:41
Unknown User (akramer@fb.com)
v. 17 Nov 17, 2011 11:57
Unknown User (ruakh)
fix subscripts and superscripts
v. 16 Nov 16, 2011 20:08
Unknown User (akramer@fb.com)
v. 15 Nov 10, 2011 18:53
Jonathan Chang
v. 14 Oct 25, 2011 16:51
Jonathan Chang
v. 13 Oct 25, 2011 16:50
Jonathan Chang
v. 12 Aug 08, 2011 19:47
Travis Powell
v. 11 Aug 08, 2011 19:46
Travis Powell
v. 10 Aug 08, 2011 18:24
Travis Powell
v. 9 Aug 08, 2011 15:01
Travis Powell
Fixed links and escaped [ characters
v. 8 Jul 22, 2011 21:26
Carl Steinbach
v. 7 Jun 29, 2011 19:26
Ashoat Tevosyan
v. 6 Jun 29, 2011 19:19
Ashoat Tevosyan
v. 5 Jun 27, 2011 14:32
Unknown User (ruakh)
escape some more things
v. 4 Jun 27, 2011 14:30
Unknown User (ruakh)
use backslash-escapes rather than numeric character references
v. 3 Jun 27, 2011 09:46
Unknown User (ruakh)
fix some hyperlink URLs that got broken in the transition (solidi got converted to hyphen-minuses)
v. 2 Jun 27, 2011 09:42
Unknown User (ruakh)
some syntax-fixes: use numeric character references rather than literal pipes and curly brackets
v. 1 Jun 24, 2011 22:24
Confluence Administrator

Return to Page Information