In this case, you could rewrite your query to include a UNION and select data from the two sources together. That would likely be the easiest path forward. -- Michael Mior mm...@apache.org
Le lun. 21 oct. 2019 à 22:36, Juan Pan <panj...@apache.org> a écrit : > > Hi everyone, > > > Thanks for your attention. I can not get a clear result after read most of > Calcite document. So i send this email for your suggestion. > > > Suppose there are two data storages, e.g, MySQL and Cassandra behind Calcite, > and data is separately stored in two of them, can i execute a query, e.g > `SELECT * FROM tb WHERE id = 1` simultaneously on two of data storages > through Calcite? In other words, i want to get the final combined result from > MySQL and Cassandra, which store part of data in different forms separately > through Calcite. > > > Looking forward to your suggestions and thoughts. > > > Best wishes, > Trista > > > Juan Pan > > > panj...@apache.org > Juan Pan(Trista), Apache ShardingSphere >
