Unable to query data on a distributed table after a limit

[niknikhil025]

I have a table where I am trying to query data I am able to query upto a certain limit. example i am able to query upto limit 641 but if i query with limit 642 the console gets stuck and i don't get anything and this number keeps decreasing. earlier it was upto 1100 morning it was 700 and now it is 640. I can query with limit 640 and get the data but now with 641.

This is happening for a specific table (it is a distributed table). The cluster has 5 nodes.

Is there a way to recover from this problem as it gets stuck for some of the rows in the table if i try to update them.

I already tried removing and re adding nodes from the cluster.

[JelteF]

That seems very strange. Are there any errors in the logs of the machines in your cluster?