update column name in partitioned table - KX Learning Hub

kdb+

update column name in partitioned table

Posted by kb on July 15, 2023 at 12:00 am

I have a partitioned table t with columns date, class, nan. I want to update the column “nan” to “name”.
I am trying this: `date`class`name xcol t

This is not working.

Please help me out here guys:)

kb replied 9 months, 2 weeks ago 2 Members · 1 Reply
1 Reply

cillianreilly

Member
July 15, 2023 at 12:00 am

For operations on partitioned tables, please refer to dbmaint.q. In particular, the rename column should achieve what you’re looking for.

https://github.com/KxSystems/kdb/blob/master/utils/dbmaint.md#renamecol

Log In to Reply

Log in to reply.