calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Albert <zinki...@gmail.com>
Subject Re: [QUESTION] One query executed on two or more different data storages through Calcite
Date Wed, 23 Oct 2019 00:46:46 GMT
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 <panjuan@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
>
>
> panjuan@apache.org
> Juan Pan(Trista), Apache ShardingSphere
>
>
> On 10/22/2019 13:42,Danny Chan<yuzhao.cyz@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 <panjuan@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
>
>
> panjuan@apache.org
> Juan Pan(Trista), Apache ShardingSphere
>
>

-- 
~~~~~~~~~~~~~~~
no mistakes
~~~~~~~~~~~~~~~~~~

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message