...
Here the country partition will be dynamically created by the last column from the SELECT clause (i.e. pvs.cnt). Note that the name is not used. In nonstrict mode the dt partition could also be dynamically created.
...
Additional Documentation
...
Writing data into the filesystem from queries
...