Hm that's the question I am trying to find answer too. I would love to work with HiveSQL itself because via API it takes a lot of time.
Posted Using LeoFinance Beta
You are viewing a single comment's thread from:
Hm that's the question I am trying to find answer too. I would love to work with HiveSQL itself because via API it takes a lot of time.
Posted Using LeoFinance Beta
I don’t know if this will help, but one idea is to collect all transaction_ids where logs show ‘error’ from hive-engine api. Then use this list to exclude in HiveSQL query.
For sure that can be done but as far as I have explored till now , you can get the logs data only by going through all the blocks one by one.
Using a for loop , right now it's fetching 1000 blocks in 4 minutes so yeah it takes a long time again.