Page History

	Version	Published	Changed By	Comment	Actions
	CURRENT (v. 27)	Nov 28, 2017 16:03	Lars Francke	Document skipNulls for FIRST_VALUE and LAST_VALUE
	v. 26	Apr 25, 2017 08:52	Dudu Markovitz	Reverted from v. 24
	v. 25	Apr 25, 2017 06:51	Dudu Markovitz	count(distinct ...) over () does not seem to be supported https://issues.apache.org/jira/browse/HIVE-10141
	v. 24	Apr 25, 2017 06:50	Dudu Markovitz	wrong window specification for LEAD and LAG
	v. 23	Dec 29, 2016 01:28	Lefty Leverenz	add an anchor to bullet "OVER with PARTITION BY and ORDER BY ..." for link from HIVE-15498
	v. 22	Dec 27, 2016 16:32	Aihua Xu
	v. 21	Dec 27, 2016 16:32	Aihua Xu
	v. 20	Dec 22, 2016 14:59	Aihua Xu	Distinct support with ORDER BY and windowing spec
	v. 19	Jul 25, 2016 08:20	Lefty Leverenz	fix Heading 2 for Examples
	v. 18	Jul 25, 2016 08:18	Lefty Leverenz	trivial edit in #5, fix indentations in Examples
	v. 17	Jul 18, 2016 09:18	Jesús Camacho Rodríguez
	v. 16	Jul 07, 2016 21:14	Lefty Leverenz	fix misplaced semicolon in WINDOW clause example (thanks go to Sambodhi Bhattacharyya for pointing this out)
	v. 15	Apr 08, 2016 08:13	Lefty Leverenz	indentation kludge
	v. 14	Apr 08, 2016 07:48	Lefty Leverenz	edit Distinct for HIVE-9534
	v. 13	Apr 07, 2016 13:49	Aihua Xu
	v. 12	Aug 01, 2014 05:31	Lefty Leverenz	Migrated to Confluence 5.3
	v. 11	Aug 01, 2014 05:31	Lefty Leverenz	add line breaks after SELECT in two examples, expand their explanations (HIVE-4933 & -4934)
	v. 10	Jul 31, 2014 08:01	Lars Francke	Both alias forms work
	v. 9	Jul 31, 2014 06:36	Lefty Leverenz	add "AS" for alias b_sum, remove a line break, fix a typo
	v. 8	Jul 30, 2014 08:43	Lars Francke	Fix HIVE-4934 and HIVE-4933
	v. 7	Jun 30, 2014 04:49	Lefty Leverenz	add information from Harish in HIVE-4797
	v. 6	Sep 02, 2013 07:50	Lefty Leverenz	Migrated to Confluence 4.0
	v. 5	Sep 02, 2013 07:50	Lefty Leverenz	add link to WindowingSpecification.pdf (attached to HIVE-4197)
	v. 4	Jun 24, 2013 11:03	Lefty Leverenz	change {code} to {noformat} because {code} macro is broken
	v. 3	Apr 27, 2013 01:43	Lefty Leverenz	Remove ampersand from page title because it causes generic page URL when surfed into from the Language Manual.
	v. 2	Apr 25, 2013 17:16	Lefty Leverenz	Linkable name for inclusion in Language Manual list
	v. 1	Apr 25, 2013 17:06	Lefty Leverenz

Return to Page Information