my intuition is leave the plans alone. when actually execute the TABLESCAN PLAN, send it to two targets. refer to the csv example.
On Tue, Oct 22, 2019 at 9:26 PM Juan Pan <panj...@apache.org> wrote: > Hi Danny and Julian > > > Thanks, i did some researches after listened to your suggestions. It seems > not an easy thing for me, but i will learn Calcite and Flink more and think > about your thoughts. > > > Best wishes, > Trista > > > Juan Pan > > > panj...@apache.org > Juan Pan(Trista), Apache ShardingSphere > > > On 10/22/2019 13:42,Danny Chan<yuzhao....@gmail.com> wrote: > You may need a computation framework like Apache Flink. Use MySQL and > Cassandra as connector/dataSource and write the results to your sink. > > Best, > Danny Chan > 在 2019年10月22日 +0800 AM10:36,Juan Pan <panj...@apache.org>,写道: > 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 > > -- ~~~~~~~~~~~~~~~ no mistakes ~~~~~~~~~~~~~~~~~~