Page History

	Version	Published	Changed By	Comment	Actions
	CURRENT (v. 218)	Sep 15, 2023 09:27	Stamatis Zampetakis	HIVE-27673: Update date_format description to account for the new configuration property
	v. 217	Aug 21, 2023 10:50	Stamatis Zampetakis	HIVE-25576: Update unix_timestamp, from_unixtime description with new property/behavior
	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