Hi team I have hybrid table and met a problem like this. For example, Let's say that there is a row with pk '1'.

select * from A_OFFLINE where pk='1' --data displays
select * from A where pk='1' --data doesn't display
select * from A --data with pk 1 displays

Is this behavior expected thing?

First two queries can happen if the row for pk=1 is in offline table with a time stamp later than time boundary, however, it is not there in realtime (which is a data issue).

@Mayank thanks for reply, could you let me know which endpoint should I request?

You can check the max of time in offline and min of time in RT

i got these timestamps offline min : 1.615240358431E12 offline max : 1.641862665244E12 realtime min : 1.641247645587E12 realtime max : 1.642479897215E12

what is the time for rows where pk=1?

• actually when I was writing, offline max was UTC 12/31/2021 23:54, and maybe realtime min around UTC 1/1/2022 00:09, so no overlay between those. • i didn't detect until few minutes ago. but before i wrote this, but there was a connection problem between broker and servers with offline data. when I restarted those, all problems are gone.

ok cool

when I executed 'select * from A' broker didnt respond when it scheduled query to servers which both have offline and online