RE: Update On My Experimental App - Hive Librarian

avatar

You are viewing a single comment's thread:

How cool this App! I suppose I need to connect with you more. Apparently, I only send you a chat 13 times (not counting this one), and you send me a message 9 times. Though I've seen your votes on my posts (much) more often than that. Thanks btw :)

Not too long ago, I got myself a HIVESQL account as well. Not into Python and all, but trying to make some queries using Excel and its SQL feature. Last weeks I put all of this aside, but when I find the time again, I wonder if I can reach out to you to understand a bit better what parameters we have in SQL database. For one, I like to get stats on how many of my comments get a response. How many users write a response and more of these type of charts.

Posted Using LeoFinance Beta



0
0
0.000
2 comments
avatar

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.

0
0
0.000
avatar

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!

0
0
0.000