Sort:  
  • Trending
    • [-]
     2 years ago  

    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.

    Posted Using LeoFinance Beta

    $0.04
    • Past Payouts $0.04
    • - Author $0.02
    • - Curators $0.02
    1 vote
    Reply
    [-]
     2 years ago  

    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

    $0.00
      Reply
      [-]
       2 years ago  

      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

      $0.00
        Reply
        [-]
         2 years ago  

        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

        $0.00
          Reply
          [-]
           2 years ago  

          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

          $0.00
            Reply
            [-]
             2 years ago  

            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

            $0.00
              Reply