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.
Soooo....
Even for CREATE TABLE AS SELECT it should be an option to specify PARTITION BY, ORDER BY, SEGMENTED BY.
0
Answers
Have you tried EXPORT_OBJECTS?
You can use EXPORT_OBJECTS to export the table design with projections.
Example:
SELECT EXPORT_OBJECTS( '/home/dbadmin/xtest/sql_objects_all.sql', '', 'true');
Once export done you can modify sql_objects_all.sql.
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.
@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?
Yes, please log internal feature request