• kdb+

  Querying HDB database after schema update.

  Posted by leahs on October 1, 2021 at 12:00 am

  Hello Community,

  I am helping a client who cannot query the HDB database after a schema update.

  A new column ”source” was added and now when they query the table, the following error that the directory cannot be found is generated:

  ./2021.07.23/bondsMarketDataDepth/source. OS reports: No such file or directory

  What is the possible cause of the issue and how can this issue be resolved?

  Looking forward to your feedback.

  Kind regards,

  Leah

  leahs replied 8 months ago 2 Members · 2 Replies
• 2 Replies

• 

  shane_lawless

  Member

  October 1, 2021 at 12:00 am

  Hi Leah,
  This error occurs as kdb expects the table to have the same columns across the different partitions being queried. The fixtable function from the dbmaint.q script should add the source column to the table in all partitions where it is missing and fix this issue.
  https://github.com/KxSystems/kdb/blob/master/utils/dbmaint.md#fixtable

• 

  leahs

  Member

  October 1, 2021 at 12:00 am

  Hi Shane,

  That’s exactly what I was looking for!

  Thanks very much for sharing the documentation, appreciate the help.

  Have a great day,

  Leah

Log In to Reply