Search code examples
kdb

Can I set column attributes for a kdb partitioned table?

Is it possible to set column attributes for a partitioned table?

q)h "update `g#ticker from `pmd"
'par
q)h "update `s#ts from `pmd"
'par
q)

Should I set the attributes on the memory table, before I run the partitioning? Will the attributes be preserved after the partitioning?

Solution

  • Take a look at the setattrcol in dbmaint.q. This script is very very useful when working with partitioned databases.