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!
You are viewing a single comment's thread from:
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!
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 :)