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.
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.
User | Count |
---|---|
36 | |
31 | |
28 | |
23 | |
18 |