Querying HDB database after schema update.

[LeahS]

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 

[Shane_Lawless · Accepted solution]

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]

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