I am looking for examples of SELECT on partitioned tables. Does the SELECT reference the master or the actual partition? In the latter case, queries have to be specifically designed to hit a specific table based on date range partitioning, for example.

Appreciate any input on this.