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
- is related to
-
HIVE-5087 Rename npath UDF to matchpath
-
- Closed
-
- relates to
-
HIVE-4197 Bring windowing support inline with SQL Standard
-
- Closed
-
-
HIVE-1304 add row_sequence UDF
-
- Closed
-
- requires
-
HIVE-4037 Merge a PTFOp for PTF invocation and a PTFOp for Windowing if possible
-
- Open
-
-
HIVE-3984 Maintain a clear separation between Windowing & PTF at the specification level.
-
- Closed
-
-
HIVE-3985 Update new UDAFs introduced for Windowing to work with new Decimal Type
-
- Closed
-
-
HIVE-3986 Fix select expr processing in PTF Operator
-
- Closed
-
-
HIVE-3987 Update PTF invocation and windowing grammar
-
- Closed
-
-
HIVE-4028 Bring paranthesis handling in windowing specification in compliance with sql standard
-
- Closed
-
-
HIVE-4030 Name windowing function in consistence with sql standard
-
- Closed
-
-
HIVE-4034 Should be able to specify windowing spec without needing Between
-
- Closed
-
-
HIVE-4035 Column Pruner for PTF Op
-
- Closed
-
-
HIVE-4036 remove use of FunctionRegistry during PTF Op initialization
-
- Closed
-
-
HIVE-4041 Support multiple partitionings in a single Query
-
- Closed
-
-
HIVE-4052 Disallow partition/sort and distribute/order combinations in windowing and partitioning spec
-
- Closed
-
-
HIVE-4080 Add Lead & Lag UDAFs
-
- Closed
-
-
HIVE-4081 allow expressions with over clause
-
- Closed
-
-
HIVE-4040 fix ptf negative tests
-
- Closed
-
-
HIVE-4019 Ability to create and drop temporary partition function
-
- Closed
-
-
HIVE-4048 Allow partition by/order by in partitioning spec in over clause and partition function
-
- Closed
-
-
HIVE-3981 Split up tests in ptf_general_queries.q
-
- Closed
-
-
HIVE-3982 Merge PTFDesc and PTFDef classes
-
- Closed
-
-
HIVE-4031 Add apache headers in new files
-
- Closed
-
- supercedes
-
HIVE-952 Support analytic NTILE function
-
- Resolved
-