create table like another including segmentation

Moderator: NorbertKrupa

Post Reply
l_monato
Newbie
Newbie
Posts: 1
Joined: Tue May 03, 2016 4:32 am

create table like another including segmentation

Post by l_monato » Tue May 03, 2016 4:44 am

EDIT -- This feature is actually working fine. Apologies for the wasted post. Moderator, feel free to delete. ---

create table <new_table> like <old_table> including projections...
https://my.vertica.com/docs/7.1.x/HTML/ ... nother.htm

Does a nice job of creating a copy of another table, and optionally the projections as well. But the segmentation is still the default; it consists of all columns, hashed.

Is there any chance of implementing an "including segmentation" clause as well?

Thank you.

Post Reply

Return to “New to Vertica SQL”