Query from user is not returning the entire dataset

1

I have 3 different users querying Dremio with the same simple select:

SELECT *
FROM TABLE
ORDER BY DATE COLUMN DESC
LIMIT 10

The Dremio datasource is a Postgres DB. The problem is that one of the users does not get current data as results and the other 2 get current data. Is there some caching problem going on?

We queried the underlying Postgres DB and can see the current data. And 2 users can also see it via Dremio. If this is a caching problem how do we resolve it. There aren’t any views involved in this query. Just querying Postgres directly from Dremio.

2

Probably a stupid question but is one of the users hitting the Preview button instead of the Run button?

1 Like
3

Unfortunately not a stupid question. That is exactly what happened. He was using keyboard shortcuts and instead of Cntrl Shift Enter he used Cntrl Enter which is preview and actually a bit counter intuitive.