...
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
...