Skip to main content

Live aggregate projection

  • June 23, 2015
  • 3 replies
  • 14 views
deb0687
Forum|alt.badge.img+1

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 ?

    3 replies

    Rahul_Choudhary
    Forum|alt.badge.img
    • Rahul_Choudhary
    • Participating Frequently
    • July 3, 2015

    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

    Adrian_Oprea_1
    Forum|alt.badge.img+1
    • Adrian_Oprea_1
    • Participating Frequently
    • July 3, 2015

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

    soo...

    Forum|alt.badge.img+2
    • Anonymous
    • Participating Frequently
    • July 7, 2015

    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.

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement