Hi Mich, Phoenix doesn't support OVER clause(PHOENIX-154) yet. Analytics function supported are listed under "Aggregate Functions" on below page. https://phoenix.apache.org/language/functions.html For eg:- https://phoenix.apache.org/language/functions.html#percentile_cont
And, I think query with OVER clause can be re-written by using SELF JOINs in many cases. Regards, Ankit Singhal On Sun, Oct 23, 2016 at 3:11 PM, Mich Talebzadeh <mich.talebza...@gmail.com> wrote: > Hi, > > I was wondering whether analytic functions work in Phoenix. For example > something equivalent to below in Hive or Spark SQL > > select distinct * > from > ( > select substr(timecreated,1,10) as Date, ticker as Ticker, > avg(CAST(price AS FLOAT)) OVER (PARTITION BY (substr(timecreated,1,10))) > AS AveragePrice > from marketdatahbase > ) tmp > ORDER BY ticker, Date > > Thanks > > Dr Mich Talebzadeh > > > > LinkedIn * > https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* > > > > http://talebzadehmich.wordpress.com > > > *Disclaimer:* Use it at your own risk. Any and all responsibility for any > loss, damage or destruction of data or any other property which may arise > from relying on this email's technical content is explicitly disclaimed. > The author will in no case be liable for any monetary damages arising from > such loss, damage or destruction. > > >
