Is there a default partition?

When using table partitioning, does a partition need to be explicitly defined for every possible result of the Partition Expression--or, if the result of the Partition Expression doesn't match any value in the in list of Partitions, does the app default to the data source defined in the table's Storage properties?

I don't find any documentation on this point.

dbaum_0-1665973240006.png

 

0 2 83
2 REPLIES 2

I think they expect you to write the expression needed even for the "default" partition. You should try.
There is no need to check the "Partitioned across many files/sources?" if you are not going to set it up

To be clear: I am indeed trying to set it up. My screenshot just didn't happen to include the partition expression or the partitions I am defining.

I did try, and promptly encountered a potentially unrelated issue. I haven't yet set up a test to isolate for the implicit/explicit default behavior.

Top Labels in this Space