You are viewing a single comment's thread from:

RE: Calculating Hive Curation Rewards Using HiveSQL

in LeoFinance2 months ago (edited)

Geez those nested queries :)
There is probably some tiny inconsistency on a yearly basis, because of the vest to hive ratio, that is changing all the time.

Great job!

Sort:  

I wasn't expecting sql pros to see this. :)
I was testing queries as I was writing the post and didn't get a chance optimize it. :)
Normally I would have less nested queries and do more computation in python, I just wanted to make sure these work without python as well.

Good point, I didn't even consider how vest to hive ration changes.

Thank You @dalz!

No wories just trying to contribute to your hard work.... also far from sql pro :)