-
Natural Query Interface API fails to aggregate rdb + hdb results
We have been using Natural Query Interface API quite a lot in our plant.
Users like the flexibility and we like the control we have over what they are doing in our HAPI client.
However, there is an issue we have with it.Link: https://code.kx.com/q/wp/query-interface/
Queries like:
H) select last publishTime from tableName where date within(.z.D-5;.z.D)
Return something like :
publishTime
---------------------
2024.01.14D23:59:59
2024.01.15D16:00:00Query is executed once on the rdb and once on the hdb.
I have tried fixing this in the past, but my fix was also preventing any other duplicates (real duplicates that we were interested in).Has anyone fixed this issue? If yes, what are your suggestions?
Thank you
code.kx.com
An interface similar to q for queries to kdb+ tables distributed across multiple systems, implemented in q, trading some q optimizations for convenience
-
2 Replies
-
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-
This is what I am referring to :
https://code.kx.com/q/wp/query-interface/Sorry for the confusion
code.kx.com
An interface similar to q for queries to kdb+ tables distributed across multiple systems, implemented in q, trading some q optimizations for convenience
-
Log in to reply.