Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Warning: Using PARTITION expression that returns a Numeric value

 

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?

Comments

  •  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.

     

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.