Live aggregate projection

Hi,

 

 

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 ?

Comments

  • 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.

     

     

    Regards

    Rahul Choudhary

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

    soo...

  • 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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file