Can you check if count (*) without predicates returns anything? Also if this is hybrid table, can you explicitly query offline table? Also select dt column and check what values are stored, pick one of them and query