I am not sure if it is actually a bug or not. H-E itself works fine, just some transactions are recorded twice on Hive for some reason. I think it may be possible to use both HiveSQL and the H-E Api for more efficiency. But I haven't used the api yet. So not sure.
I use SQL within my python scripts. Here are couple posts on how to get started with HiveSQL in python.
https://hive.blog/hive-167922/@geekgirl/using-hivesql-with-python-on-mac
https://hive.blog/hive-167922/@geekgirl/hivesql-with-python-tables-and-columns
I think for what you are trying to do, you will be using two HiveSQL tables - Comments and TxVotes.
I used to use those when I was active curating for Curie.
Posted Using LeoFinance Beta