arcange
@arcangeWitness - Creator of HiveBuzz, HiveSQL, HiveAuth, Engage, Hive.NET, Hive Recovery, Hive Autoclaim, Xfer
Resource Credits
Available
Used
RE: HiveSQL - Querying Json_metadata with App = "Ecency" - Figuring Out Active Users Number by Post & Comment Numbers....
Interesting post. Glad to see you enjoy playing with HiveSQL. Here are a few tips to improve your queries performance: WHERE parent_author = '' -- Selecting only post not comments Use the depth column