We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Create tables partition — Vertica Forum

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