search

ripple / rippled-historical-database

SQL database as a canonical source of historical data
99 stars 68 forks source link

Can't combine filters when querying payments #157

Closed software-programmer closed 6 years ago

software-programmer commented 6 years ago

I can Filter Payments that are Type = Received

and I can Filter Payments by Descending = True

but I can't Filter Payments that are Type = Received and Descending = True

Seems a little odd to me and the documentation doesn't seem to state I can't do this.

shekenahglory commented 6 years ago

This has to do with a bug in hbase on reverse scans. it can happen any time its reversed, but will occur more frequently when filters are used. its best to avoid the reversed scan if you can.

software-programmer commented 6 years ago

If I need to find the latest 5 received transactions, do I have to page through them all until I get to the end?

shekenahglory commented 6 years ago

yes, unfortunately. the issue occurs more on accounts like this with a large number of TX - and if you can limit the date range that is helpful. Probably the next version of API will have descending only to address the issue, but this version won't be fixed unless we upgrade to a version of hbase that has addressed the issue.