Hello Everyone, I have following requirement. I have 2 kdb+ databases, lets call them db1 anddb2. There is a table(say T) in both databases. Table T in db1contains data from 2007, 2008,2009 and 2010 year. Table T in db2contains data for 2011 year. I want to write a Q-Sql query which canfetch results across both databases. In relational databases, I couldhave accomplished this using UNION clause like this: select * from db1.t UNION select * from db2.t Is there a way of doing this in kdb using Q-Sql.Please suggest.-Satish
a common solution is to have a gateway process that connects to several kdb+ processes.
on the gateway process, issue the query to the hdb processes, and join the results
e.g.
raze handles@:query
gateways can become very advanced, with intelligent distribution of queries and async comms for parallel processing.