https://learninghub.kx.com/forums/topic/error-with-sum
I’m trying aggregate the consumption values which are of type long int, by the meter id which I’ve stored as int too. But I’m getting an empty table when I run the command in the screenshot. Any idea on how I can fix this?
You are awesome!
Thank you!
Hi, i think it is because of the value column which is a keyword in q.. I just renamed v in uppercase(V) and it is working. After aggregation i think you can rename it again with value using xcol.
Hi navdithya,
Your query is selecting the value (.:) function by mid. You need to apply sum on a column by mid to get an aggregation e.g.
show t:select sum column by mid from readings
Kind regards,
David