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.

Page History

Version	Published	Changed By	Comment
CURRENT (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	Kirk Kosinski 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	Kirk Kosinski	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	Kirk Kosinski
v. 171	Oct 24, 2016 11:50	Kirk Kosinski	add concatenate(\|\|)
v. 170	Oct 24, 2016 11:12	Kirk Kosinski	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	Kirk Kosinski	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

Space shortcuts

Child pages