Issue with tokens_ethereum.balances_daily table

Trivial queries against tokens_ethereum.balances_daily run for 30 mins and fail with an “memory” error on the backend. For example, would expect that the query:

SELECT * FROM tokens_ethereum.balances_daily LIMIT 100

should come back rather quickly. However will run for 30mins and fail. Adjusting this query with a WHERE to reduce the dataset will also fail. So seems like this is something pathological about this table in particular.

We are querying other large tables such as {chain}.transactions without any problems.

Please authenticate to join the conversation.

Upvoters
Status

Open

Board

Bugs

Date

About 1 year ago

Author

Jonathan Shore

Subscribe to post

Get notified by email when there are changes.