Re: [luciddb-users] Adding columns to existing table

[John V. S. <js...@gm...>]

Vassil Kovatchev wrote:
> Hi All,
> 
> I think I've read somewhere something about adding columns to 
> pre-existing tables in LucidDb, but of course now I cannot find it.
> I tried the standard ALTER TABLE SQL statement, but that failed, so I 
> think there was something special about the way columns were added to a 
> table - LucidDb being a columns-store RDBMS and all.
> Anyone know how to do this without dropping and recreating the table?

ALTER TABLE ADD COLUMN is one of the standard features which remains to 
be implemented (see the Roadmap link from the LucidDB home page).

So for now it is necessary to create a new table, move data, and then 
drop the old one.  Unfortunately this also requires dropping and 
recreating dependent objects such as views.

It is true that column store makes possible a very efficient ADD COLUMN 
(create a new column cluster without touching the existing ones); we 
just haven't gotten to it yet.

JVS