Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
what is wrong with below script?
Load
country,
sum(sales)
from sales.qvd;
Missing group by. Try like:
Load
country,
sum(sales)
from sales.qvd group by country;
Group By is missing
Load
country,
sum(sales)
from sales.qvd
Group By
country;
Regards
Anand
When using aggregation functions (count, sum, min, max, avg, ...) in a load (or select), you have to include ALL fields without aggregation function in the group by clause.
hope this helps
regards
Marco