create table like another including segmentation
Posted: 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.
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.