cancel
Showing results for 
Search instead for 
Did you mean: 

Querying HDB database after schema update.

leah_marie_s
Moderator Moderator
Moderator

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 

1 ACCEPTED SOLUTION

Shane_Lawless
New Contributor

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

View solution in original post

2 REPLIES 2

Shane_Lawless
New Contributor

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

View solution in original post

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