Vertica should have ability to create partitioned table with CREATE TABLE AS SELECT...

Yes I know it is not easy to implement... but Vertica developers are not looking for easy life.
My users are lazy, and I have tables with bad default order by and segmentation, and no partitioning, created by users, all the time.
Even for CREATE TABLE AS SELECT it should be an option to specify PARTITION BY, ORDER BY, SEGMENTED BY.


  • Options
    Nimmi_guptaNimmi_gupta - Select Field - Employee

    Have you tried EXPORT_OBJECTS?
    You can use EXPORT_OBJECTS to export the table design with projections.
    SELECT EXPORT_OBJECTS( '/home/dbadmin/xtest/sql_objects_all.sql', '', 'true');
    Once export done you can modify sql_objects_all.sql.

  • Options

    Yes, I can do everything, export etc and even more..... but users are lazy and not doing it. What I am asking is to add feature for users to have ability to casually create well-defined table with partitioining, segmentation, and order by, when users are doing CREATE TABLE ... AS SELECT.

  • Options
    Nimmi_guptaNimmi_gupta - Select Field - Employee

    @Sergey_Cherepan_1 we can log a enhancement request for this.
    What's your company name? Would it be possible for you to log a support case for this?

  • Options

    Yes, please log internal feature request

Leave a Comment

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