Apache Hive
Space shortcuts
Child pages
  • LanguageManual UDF
ConfigureSpace tools
  Version Date Changed By
CURRENT (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 V
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