The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Create tables partition

Sophie_bdSophie_bd Community Edition User
in General Discussion

Hello,
I have searched for some ways to optimize request-response.
After creating Projection I think to create Partition on my FACT tables, on one functional column that contains data it can be partitioned.
My configuration is one database on 3 nodes.

Best regards,
Sophie

Tagged:

Answers

  • Jim_KnicelyJim_Knicely - Select Field - Administrator
    edited December 2021

    @Sophie_bd - Is there a question in your post? :) Are you asking why a column can't be partitioned?

    If so, read through the "Partitioning Requirements and Restrictions" section of the doc here: Partition Clause.

    If you have any questions, let us know!

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...