This Confluence has been LDAP enabled, if you are an ASF Committer, please use your LDAP Credentials to login. Any problems file an INFRA jira ticket please.

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

Return to Page Information