Analytic Queries in Vertica
Posted: 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:
https://my.vertica.com/blog/analytic-qu ... _p=5065791
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
https://my.vertica.com/blog/analytic-qu ... _p=5065791