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!

Dropping partitions

I facing a problem where my partition for tables are inactive i have set activepartitioncount=2 at my DB but still seeing the old partition for all nodes, ideally it should be current and last month partition keys. how can i dropped the old partition and set new partition key automatically also if there is any impact on dropping the old partition.
v_ossa_node0001 201904 0 1
v_ossa_node0001 201903 0 1
v_ossa_node0001 201905 0 1
v_ossa_node0001 201904 0 1
v_ossa_node0002 201905 0 1
v_ossa_node0002 201903 0 1
v_ossa_node0002 201903 0 1
v_ossa_node0002 201904 0 1
v_ossa_node0003 201903 0 1
v_ossa_node0003 201904 0 1


  • marcothesanemarcothesane - Select Field - Administrator

    Can you share the output of the command: SELECT EXPORT_OBJECTS('','<your_schema>.<your_table>',FALSE); ?
    Based on that, I can put together the right command.
    Your output shows : the node name, probably the year-month value of the date that determines the partition, a '0' that I don't know where it comes from , and a '1' that I don't know where it comes from .
    Can you elabourate?

Leave a Comment

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