How to add more hdb data?

Community Support
1

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?

2

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