Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Live aggregate projection




When I am createing LAP for AVG then its showing error


Error: [Vertica][VJDBC](6369) ERROR: Only SUM, MIN, MAX and COUNT are allowed in aggregate projections.



How I can create LAP for AVG ?


  • Hi 


    As it can be clearly seen from the error message that you have received this feature is still not available in HP Vertica.Work is being carried out on this but not sure when it will be available.




    Rahul Choudhary

  •  Live aggregate projection come with the limitation of the msg received. 


  • The best thing to do for now is to put the SUM and COUNT in your Live Aggregate Projection, and then use a VIEW on top of the projection to divide the sum by the count to get the average.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.