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.