Skip to content
Skip to breadcrumbs
Skip to header menu
Skip to action menu
Skip to quick search
Linked Applications
Loading...
Apache Software Foundation
Spaces
Hit enter to search
Help
Online Help
Keyboard Shortcuts
Feed Builder
What’s new
What’s new
Available Gadgets
About Confluence
Log in
Sign up
Apache Hive
Pages
Blog
Space shortcuts
How-to articles
Child pages
Pages
LanguageManual UDF
Browse pages
Configure
Space tools
View Page
A
t
tachments (0)
Page History
Page Information
View in Hierarchy
View Source
Delete comments
Export to PDF
Export to EPUB
Export to Word
Export to Markdown
Copy Page Tree
Pages
LanguageManual UDF
Page History
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
Overview
Content Tools
Apps
{"serverDuration": 177, "requestCorrelationId": "e4ce12c701e58557"}