phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mich Talebzadeh <mich.talebza...@gmail.com>
Subject Re: Analytic functions in Phoenix
Date Sun, 23 Oct 2016 13:08:42 GMT
You are correct Ankit.

However, I can use Spark SQL on Hbase table directly  or Hive table built
on Hbase

regards,

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.



On 23 October 2016 at 13:49, Ankit Singhal <ankitsinghal59@gmail.com> wrote:

> 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.talebzadeh@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.
>>
>>
>>
>
>

Mime
View raw message