Error with sum

[nvadithya]

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!

[Denakaran]

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. 

[davidcrossey]

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