Warning: Using PARTITION expression that returns a Numeric value

David_P_1

 

https://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/AdministratorsGuide/Partitions/DefiningPartitions.htm%3FTocPath%3DAdministrator's%2520Guide%7CUsing%2520Table%2520Partitions%7C_____2

 

 

CREATE TABLE trade (
    tdate DATE NOT NULL, 
    tsymbol VARCHAR(8) NOT NULL,
    ttime TIME) 
PARTITION BY EXTRACT (year FROM tdate);

 

---

Warnings: --->

   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?

Adrian_Oprea_1

 Hi,

 

that is fine , i get that all the time.

Your expresion will always return a distinct year value so you don1t have to worry.