Warning: Using PARTITION expression that returns a Numeric value
CREATE TABLE trade (
tdate DATE NOT NULL,
tsymbol VARCHAR(8) NOT NULL,
PARTITION BY EXTRACT (year FROM tdate);
W (1): Using PARTITION expression that returns a Numeric value
Hint: This PARTITION expression may cause too many data partitions. Use of an expression that returns a more accurate value, such as a regular VARCHAR or INT, is encouraged
I am following the directions from the official documentation, should I not expect that to have examples with no errors?