How to instantly recognize schemas added to Ticker in HDB

https://learninghub.kx.com/forums/topic/how-to-instantly-recognize-schemas-added-to-ticker-in-hdb

A new table has been added to the KDB Ticker for new functionality in the system.

However, HDB cannot know information about the new table unless RDB saves memory data as an End of Day file.

Is there a good way?

If you only have partitioned tables in your HDB you could load in the ticker schema file followed by reloading the HDB. Any existing tables in the HDB will be reloaded as normal and for your remaining in memory only tables loaded from the schema file you can add a dummy date column as a placeholder.

 

\l sym.q l /path/to/HDB {update date:.z.d from x} each tables where not tables in .Q.pt

 

Really in practice I would avoid this.

 

The best way is to just add empty tables for the new table to the DB and then call l again as normal

https://github.com/KxSystems/kdb/blob/master/utils/dbmaint.md#addtable

You will want this anyway long term to prevent queries failing if older partitions are missing.