-
What is Holistic API? You may be using an internal tool which we can not answer questions on.
Standard kdb will not behave as you have outlined:
q)`:testHDB/2024.04.16/tableName/ set ([] publishTime:asc 100?.z.t;otherCol:100?100.0)
`:testHDB/2024.04.16/tableName/
q)`:testHDB/2024.04.15/tableName/ set ([] publishTime:asc 100?.z.t;otherCol:100?100.0)
`:testHDB/2024.04.15/tableName/
q)\l testHDB
q)select last publishTime from tableName where date within(.z.D-5;.z.D)
publishTime
------------
09:12:36.839