You are viewing a single comment's thread from:

RE: Update On My Experimental App - Hive Librarian

in LeoFinance3 years ago

Yes, feel free to ask. You could do something like this:

SELECT COUNT(author), COUNT(DISTINCT author)
FROM Comments
WHERE parent_author = 'edje'
AND author != 'edje'

The result will be, you received 9739 of total responses from 2450 unique users. (if above query is correct).
However, this query gets responses to all of your posts and comments.

Sort:  

I immediately tried, but seem to have problems with connecting to the HIVESQL. Recently I upgrade my Excel to the latest version. Since then I seem to have problems. Though the result I get seems to be more on the HIVESQL side. Though your service works... Puzzled! Guess I need to reach out to the owner of HIVESQL.

Yeah, I'll like to get the these figures for a specific timeframe, between date x and date y. But, first I'll need to fix the HIVESQL connection so I can run queries again :)

Thanks for your help! Much appreciated!