Re: Issues with LAST_VALUE aggregation UDF

2018-09-11 Thread Abhishek Gupta
Thank you so much for the response Josh. Will check on 4.14 and get back to you with the results. Thanks On Tue, Sep 11, 2018 at 8:45 PM Josh Elser wrote: > The versions you provided in the description make it sound like you're > actually using HDP's distribution of Apache Phoenix, not an offi

Re: Issues with LAST_VALUE aggregation UDF

2018-09-11 Thread Josh Elser
The versions you provided in the description make it sound like you're actually using HDP's distribution of Apache Phoenix, not an official Apache Phoenix release. Please test against an Apache Phoenix release or contact Hortonworks for support. It would not be unheard of that this issue has a

Issues with LAST_VALUE aggregation UDF

2018-09-11 Thread Abhishek Gupta
Hi, We are trying to use the LAST_VALUE aggregation UDF in our Phoenix SQL queries that serve REST APIs over analytics data. However we are seeing a number of issues/limitations in this function. First, there seems to be a bug where it fails for sparse columns that have NULLs. Have created a JIRA