https://learninghub.kx.com/forums/topic/q-chk-cannot-work
I added another two new columns to the existing kdb table and use Q chk to back fill the HDB. But somehow, no data was back filled and still got error when query HDB.
how to fix this?
https://learninghub.kx.com/forums/topic/q-chk-cannot-work
I added another two new columns to the existing kdb table and use Q chk to back fill the HDB. But somehow, no data was back filled and still got error when query HDB.
how to fix this?
.Q.chk
adds missing tables, not missing columns.
https://code.kx.com/q/ref/dotq/#chk-fill-hdb
Use addcol
in kdb/utils/dbmaint.md to add columns.
Note: this will write to all partitions so ensure you do not overwrite valid data.
https://github.com/KxSystems/kdb/blob/f06c97784b0859517a8461d76607c07a47458ae5/utils/dbmaint.q#L11
add1col
can be used instead to choose which partitions to write to.
Do you see the files for the new columns on disk?
Did you make sure to reload the database with l after the .Q.chk is done?
Yes, I added new columns yesterday and can see it RDB. Today, I can see new data in yesterday HDB. But can not get HDB back fill using Q chk.
any suggest?
Thanks for your reply:
I did have new table added at the same time. it seems the new table can be back-filled;
addcol works for that, but each time only add one column. do you know how to add multiple columns one time?