schema change - adding a new column to existing large table

Sam11 · January 30, 2013, 5:20am

How do I add a new column to an existing table on disk in KDB? Is there a standard way of doing this?

thanks,

Sam

pauljloughran · January 30, 2013, 5:30am

Hi Sam,

If the table is splayed, you could try looking at this link;

If the table is partitioned, there is a script called dbmaint.q which has a variety of useful functions, one of which is addcol.?

Regards,
Paul

Topic		Replies	Views
adding new column to schema Community Support kdb-and-q	1	0	September 16, 2011
how to append a new column to hdb file? Community Support kdb-and-q	2	0	January 5, 2016
How to add a column to the Partition table? Community Support imported , kdb-and-q	1	5	June 17, 2023
How to add a column to the Partition table? Community Support kdb-and-q	4	0	June 18, 2023
update splayed table on disk Community Support kdb-and-q	2	0	February 26, 2018