Apache Hive
Space shortcuts
Child pages
  • LanguageManual UDF
  Version Published Changed By Comment Actions
CURRENT (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 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