cancel
Showing results for 
Search instead for 
Did you mean: 

How to add more hdb data?

Isaac
New Contributor
Hi,
    For now,my kdb instance already has hdb files for 20 days. Then I got more 100 hdb files from others, How can I merge them to my hdb data folder?
1 REPLY 1

manni_patel
New Contributor
it would be easy if they all shared the same sym enumeration (in which case you can just copy over so long as the names of tables aren't duplicate) - but I'm guessing that's not the case.

You could just run a script in a separate q process on the same machine as you destination hdb, something like this (not tested):

h:hopen `:sourcehost:port;
// time xasc is not actually necessary
getTable:{[t;d]
 `time xasc `time`sym xcols delete date from select from t where date=d
 }

// this can be eached for date/tables
{[t;d]
 @[`.;t;:;h(getTable;t;d)];
 .Q.dpft[`:destination;d;`sym;t]


.Q.chk `:destination //for completeness