Analytic Queries in Vertica

Moderator: NorbertKrupa

Post Reply
User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1778
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Analytic Queries in Vertica

Post by JimKnicely » Mon Oct 02, 2017 6:22 pm

Great blog post "Analytic Queries in Vertica"!

Analytic functions handle complex analysis and reporting tasks. Here are some example use cases for Vertica analytic functions:
  • Rank the longest standing customers in a particular state
  • Calculate the moving average of retail volume over a specific time
  • Find the highest score among all students in the same class
Check it out here:
https://my.vertica.com/blog/analytic-qu ... _p=5065791
Jim Knicely

Image

Note: I work for HPE. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Links”