AnsweredAssumed Answered

Apache drill - window functions

Question asked by Lokesh on Sep 5, 2017
Latest reply on Sep 11, 2017 by maprcommunity

Hi All,

 

I was reading into apache drill window functions in document DA4000_SlideGuide.pdf, training material for drill on demand course.

I found one query example used for explaining Window Functions

select distinct `month` , AVG(order_total) over(PARTITION by `month`) as avg_month_total from ORDERS;

how is the above query different from below?

select month, avg(order_total) from ORDERS group by month;

 

I am a bit confused understaind drill window functions. Thanks in advance.

 

Also is apache drill case-sensitive? I feel it is not as document says drill ansi-sql compliant hence it must not be case-sensitive. Please confirm.

Outcomes