Skip to main content

Warning: Using PARTITION expression that returns a Numeric value

  • November 13, 2016
  • 1 reply
  • 10 views

David_P_1
Forum|alt.badge.img+2

 

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?

1 reply

Adrian_Oprea_1
Forum|alt.badge.img+1
  • Participating Frequently
  • November 13, 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.