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 ?
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.
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.
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.