-
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?
-
4 Replies
-
.Q.chkadds missing tables, not missing columns.https://code.kx.com/q/ref/dotq/#chk-fill-hdb
Use
addcolin 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
add1colcan 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:
1. I did have new table added at the same time. it seems the new table can be back-filled;
2. addcol works for that, but each time only add one column. do you know how to add multiple columns one time?
Log in to reply.