[
https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13563594#comment-13563594
]
Harish Butani commented on HIVE-896:
------------------------------------
Hi,
Just posted a second preliminary patch. This has:
- support for multiple inserts
- Finished all the cleanup
- Added the NPath Table Function
- Added more tests, now there are around 70 tests.
- Many bug fixes and minor enhancements, to list a few : don't interfere with
GBys with no Group By clause; support for multiple invocations of same UDAF on
diff wdws; allow aliases to be optional in wdw clauses; fix issues with default
wdw specification and inheriting partitioning; enhance the PTF ifc to specify
output col names; fix bugs in value based wdws; fix issues when mixing distinct
and wdwing clauses.
- made sure all the ql tests pass ( though this is a moving target; we
apologize if failures have crept in since we checked yesterday)
We now:
- plan to make the changes listed in the comments to Alan; so there is a clean
separation between Windowing & PTFs at the specification level.
- In parallel we have started a functions branch, where we are testing more
PTFs. See out github repo for details.
> Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.
> ---------------------------------------------------------------
>
> Key: HIVE-896
> URL: https://issues.apache.org/jira/browse/HIVE-896
> Project: Hive
> Issue Type: New Feature
> Components: OLAP, UDF
> Reporter: Amr Awadallah
> Priority: Minor
> Attachments: DataStructs.pdf, HIVE-896.1.patch.txt,
> Hive-896.2.patch.txt
>
>
> Windowing functions are very useful for click stream processing and similar
> time-series/sliding-window analytics.
> More details at:
> http://download-west.oracle.com/docs/cd/B13789_01/server.101/b10736/analysis.htm#i1006709
> http://download-west.oracle.com/docs/cd/B13789_01/server.101/b10736/analysis.htm#i1007059
> http://download-west.oracle.com/docs/cd/B13789_01/server.101/b10736/analysis.htm#i1007032
> -- amr
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
