[
https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13724575#comment-13724575
]
Guilherme Braccialli commented on HIVE-896:
-------------------------------------------
Harish,
I noticed that NPath class is on Hive 0.11 source and it's also a known
function on hive. Is it working? Could you please give us a sample query? I
tried the query below, but its not working.
Thanks.
create external table flights_tiny (ORIGIN_CITY_NAME string, DEST_CITY_NAME
string, YEAR int, MONTH int, DAY_OF_MONTH int, ARR_DELAY float, FL_NUM string)
location '/user/xxxxx';
select npath(
'ONTIME.LATE+',
'LATE', arr_delay > 15,
'EARLY', arr_delay < 0,
'ONTIME', arr_delay >=0 and arr_delay <= 15,
'origin_city_name, fl_num, year, month, day_of_month, size(tpath) as sz, tpath
as tpath'
)
from flights_tiny;
FAILED: NullPointerException null
> 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
> Assignee: Harish Butani
> Priority: Minor
> Fix For: 0.11.0
>
> Attachments: DataStructs.pdf, HIVE-896.1.patch.txt,
> Hive-896.2.patch.txt, hive-896.3.patch.txt, HIVE-896.4.patch,
> HIVE-896.5.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
