Warning: Using PARTITION expression that returns a Numeric value

David_P_1 · November 2016

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 · November 2016

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.

We're Moving!

Create My New Community Account Now

Warning: Using PARTITION expression that returns a Numeric value

Comments

Leave a Comment