Once I figure out how to connect to HiveSQL, then I need to figure out which tables have the info I need to create the queries which can answer questions we care about such as these:
At what date/time did we reach 100M posts?
What was post count at the moment a new edition of DCMLB was posted?
What is the difference in post count between today and yesterday? This is what we've been trying to figure out, and all "posts" I've made here have been approximations
What is the difference in post count between today and last week? 2 weeks ago? 1 month ago? etc.
Based on any 2 dates, what was the MAX difference? MIN difference?
It's not difficult to make the queries once the HiveSQL syntax is understood, but sometimes the info isn't where we think it is; or we get the logic wrong in forming the query.
Until I can get these questions and figured out, I'll keep putting up the screen captures.
The count is going up. Gaining on the next 500K.
Posted Using LeoFinance Beta
Every day we can track the growth happening in form of posts getting created.
Posted Using LeoFinance Beta
Once I figure out how to connect to HiveSQL, then I need to figure out which tables have the info I need to create the queries which can answer questions we care about such as these:
It's not difficult to make the queries once the HiveSQL syntax is understood, but sometimes the info isn't where we think it is; or we get the logic wrong in forming the query.
Until I can get these questions and figured out, I'll keep putting up the screen captures.
Posted Using LeoFinance Beta
Actually HAF might help you with that. It is something that, from what I understand, is going to make database creation much easier.
Posted Using LeoFinance Beta
Good luck with finding out, for me I still have to connect to HiveSQL, let's see if I can do it
Posted Using LeoFinance Beta
For what we're both trying to do, this may be the best post for us:
Additional help may be available here:
Posted Using LeoFinance Beta
It is what we need to concentrate upon. Daily growth will add up over time.
Each comment is adding to the size of the ecosystem. It is a slow process but it does grow over time.
Posted Using LeoFinance Beta
Yes, and that's why I try to comment on posts with no comments so that we can get some meaningful conversation.
Posted Using LeoFinance Beta