RE: Using hiveSQL to find content
You are viewing a single comment's thread:
I really ought to play with this. I have done plenty of SQL in the past, so I should be able to get into it.
0
0
0.000
You are viewing a single comment's thread:
I really ought to play with this. I have done plenty of SQL in the past, so I should be able to get into it.
Nice, then it's just a matter of getting used to the views and what data is where :)
I've logged into the database, but don't see the Hive stuff, just those that define the standard system. I am more used to Oracle than SQL Server, but the principles should be the same.
I'm using a thing called DBeaver on Linux.
Update: Aha! Needed to specify the schema
Glad you found it cause I wouldn't be able to help much i think!
I've not used this tool before. For my Brit List I used Python and beem. SQL may be better for some other things. It's certainly quick. Need to think about what queries I can use. Could investigate some abusers. There's one I know of who is creating lots of accounts. Could check if any have rewards.