Are SQL queries applicable to the data swapped to disk when
data set exceeds the limits of on-heap and off-heap memory?
SQL query can read the data that is in swap space, but keep in mind that it will have to unswap it (i.e., move into memory). Thus, if the result set is large, the node can run out of memory. In general, you should avoid using swap space because in many cases it's eliminating advantages of in-memory processing. Is there any particular reason for having it in your case?