Re: [QUESTION] One query executed on two or more different data storages through Calcite

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 ，写道： > Hi everyone, > > > Thanks for your attention. I can not get a clear result after read most of

Re: [QUESTION] One query executed on two or more different data storages through Calcite

Thanks for your rely. `SELECT * FROM tb WHERE id = 1` can be converted into `UNION ALL`, but i am worried how to handle some aggregation SQLs, e.g `SELECT AVG(NUM) FROM tb`. Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere On 10/22/2019 11:04，Julian Hyde wrote： Not

Re: Apache Calcite meetup group

Best thing would be for you and Jesus to collaborate. Feel free to do it on this list, or back-channel. I don’t think it matters who is formally the organizer as long as someone is organizing events. > On Oct 21, 2019, at 7:58 PM, Denis Magda wrote: > > Julian, > > Exactly, any meetup group

Re: [QUESTION] One query executed on two or more different data storages through Calcite

Not currently, but it wouldn’t be too much work. Consider a similar query: SELECT * FROM mysqlTable UNION ALL SELECT * FROM cassandraTable This would convert into an EnumerableUnion which would send sub-queries to the two back ends and combine the results. You’d need a new relational operator

Re: Apache Calcite meetup group

Julian, Exactly, any meetup group member can take over a group after organizer(s) step down. I decided to take control after receiving a second notification threatening to shut the group down in the nearest time. Came across this discussion afterwards. As of now, I don’t mind to step down as a

[QUESTION] One query executed on two or more different data storages through Calcite

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

Re: [DISCUSS] State of the project 2019

I agree that we’ve made good progress on last year’s big problem, pull requests languishing for too long. The situation has been better, because a few people are putting in considerable effort reviewing. We still have some ways to go, so let’s keep up the good work. One of the successes of the

Re: [DISCUSSION] Extension of Metadata Query

Yes, the division of labor between MetadataFactory and RelMetadataQuery is a good one, and we should keep them intact. One provides the raw metadata, and the other provides a typed interface and transactions/caching. It might be allowable for a user to create their own sub-class of

Re: Apache Calcite meetup group

Thank you, Denis! I notice that it is fairly easy for someone to take control over a meetup group, so let me say something about governance. To be clear, I have no indications that anyone has anything but the best intentions for this group, so this is just me worrying about a hypothetical

Re: Apache Calcite meetup group

Hi Jesús, I've paid for the next 6 months and made you a co-organizer. Let's work together and arrange a local meetup in the Bay Area. - Denis > > Am 18.10.19, 19:53 schrieb "Jesus Camacho Rodriguez" >: > > It seems someone else (Denis Magda) paid the fees in the meantime. > > -Jesús

Re: [DISCUSS] Towards Avatica 1.16.0

Francis>files updated to switch over to using a Gradle docker container to run Francis>the build/release steps as well. Docker does unify the environment, however, I'm not sure it is good to make Docker the only option for the release. Gradle enables single-command "build+test+publish to

Re: Apache Calcite meetup group

Hi, A meetup at Stuttgart (or nearby) sounds like a good idea, potentially I would be able to attend. I am taking advantage of this thread to ask if there are also people interested for a meetup in Paris, France. If yes, please do say so to see if it is worth organising something there or in the

Re: [DISCUSS] Towards Avatica 1.16.0

I am happy to build the next release using Gradle (eventually we'll have to do it anyway if we are moving to Gradle). I've previously committed a docker-compose file and shell script to automate the release: - https://github.com/apache/calcite-avatica/blob/master/docker-compose.yml -

Re: [DISCUSS] Towards Avatica 1.16.0

I think [CALCITE-3158] would be the main highlight of the next release. I really like the feeling of Gradle and the idea of the mock ASF environment. >From my tests so far everything seems good; I would like to verify that the structure of the artifacts is good and then I think it can be merged.

Re: [DISCUSS] Make Avatica more discoverable

To be pedantic, a TLP (top-level project) is a project that reports directly to the Board and therefore is exactly the same as a PMC. It seems that suggestion that Avatica have a domain https://avatica.apache.org and be referred to as “Apache Avatica”, while

[jira] [Created] (CALCITE-3436) CalciteConnectionConfigImpl.set obliterates previous property values

Ryan Fu created CALCITE-3436: Summary: CalciteConnectionConfigImpl.set obliterates previous property values Key: CALCITE-3436 URL: https://issues.apache.org/jira/browse/CALCITE-3436 Project: Calcite

Re: [DISCUSS] Make Avatica more discoverable

Hi, I agree with Julians view. And I also agree with initially starting with Avatica as separate TLP but not as a separate PMC (there are multiple Examples of PMCs that govern multiple Projects, like pointed out from Julian). JulianF Am 21.10.19, 03:19 schrieb "Julian Hyde" : In Apache,

Re: Apache Calcite meetup group

Hi, I would love to attend a Caclite meetup but as we are from Germany I'm unsure about the community here. But what about a "virtual meetup" via Hangout or something as "addition". But of course, if people from Germany are interested we would be honored to host a Meetup near Stuttgart.

[jira] [Created] (CALCITE-3435) floor(mod(33.5,7)) wrongly returns 5.5

jiezouSH created CALCITE-3435: - Summary: floor(mod(33.5,7)) wrongly returns 5.5 Key: CALCITE-3435 URL: https://issues.apache.org/jira/browse/CALCITE-3435 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-3434) elasticsearch adapter can not init rest client with "pathPrefix"

Jeffery Zhang created CALCITE-3434: -- Summary: elasticsearch adapter can not init rest client with "pathPrefix" Key: CALCITE-3434 URL: https://issues.apache.org/jira/browse/CALCITE-3434 Project: