KX Community

Find answers, ask questions, and connect with our KX Community around the world.
KX Community Guidelines

Home Forums kdb+ insert into global table in peach Re: insert into global table in peach

  • sstantoncook

    Member
    September 27, 2021 at 12:00 am

    What is the use case that you want to insert the same data into two different tables?

    I can see the topic names resemble stocks but there is no filter on the data so would appear all records go into each.

    The only use case I can think of having the same schema and upserting to two tables is where you maintain two versions the same schema but one with keyed columns to maintain both the full trail and current “state”.

    E.g. all FX quotes in one table and the other keyed by Currency Pair and LP to display the current quoted depth.

    Cheers,

    Sam