[Invitation] ApacheCon Asia 2021

Dear Calcite community, Thanks for your attention. This is Juan Pan from the ApacheCon Asia 2021 committee. You are surely wondering why this invitation comes. I am glad to give some introduction on this event and do some clarification. As a large and diverse open-source community

Re: [Question] How to leverage Calcite adaptor for federated SQL query without using Calcite parser

[2] https://github.com/apache/shardingsphere/issues/8284 Best, Trista Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 11/24/2020 18:20，Juan Pan wrote： Hi

Re: [Question] How to leverage Calcite adaptor for federated SQL query without using Calcite parser

aybe we need to rewrite a `Calcite connection` to execute the enumerable tree? How about implementing `SqlAbstractParserImpl` and configure it in JDBC props? Thanks for your time. Best wishes, Trista Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSph

Re: [Question] How to leverage Calcite adaptor for federated SQL query without using Calcite parser

Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 11/23/2020 20:10，Michael Mior wrote： There is nothing stopping you from using adapters with SQL queries you have parsed yourself. You simply need to assign the appropr

Re: [Question] How to leverage Calcite adaptor for federated SQL query without using Calcite parser

Hi JiaTao, Very appreciated your iterative responses. Best, Trista Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 11/23/2020 18:17，JiaTao Tao wrote： E, seems we don't have that. Regards! Aron Tao Juan Pa

Re: [Question] How to leverage Calcite adaptor for federated SQL query without using Calcite parser

-party parser? Best wishes, Trista Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 11/23/2020 14:38，JiaTao Tao wrote： Hi Juan Pan As I said, you can archive this by "If you have to do this, you can either generat

Re: [Question] How to leverage Calcite adaptor for federated SQL query without using Calcite parser

://calcite.apache.org/docs/reference.html [2] https://shardingsphere.apache.org/document/current/en/features/sharding/principle/parse Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 11/22/2020 16:17，JiaTao Tao wrote： In fact, parse twi

Re: A question regarding querying Google Cloud BigTable or Spanner through Apache Calcite

there is any possibility to bypass the SQL parsing from Calcite? Best wishes, Trista Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 11/22/2020 16:39，JiaTao Tao wrote： I think you are talking about query federation, yes,

[Question] How to leverage Calcite adaptor for federated SQL query without using Calcite parser

appreciated your any help and reply. Regards, Trista [1] https://github.com/apache/shardingsphere/issues/8284 Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org

Re: Draft board report for January 2020

Totally agree. It deserves praise that rotate chair annually and run Calcite community so active and in order. Juan Pan (Trista) Senior DBA & PPMC of Apache ShardingSphere(Incubating) E-mail: panj...@apache.org On 01/7/2020 04:17，Julian Hyde wrote： Is it w

Re: [QUESTION] How could getTableName(columnIndex) return the correct result?

Thanks your explanation, Julian. Does it mean the optimization of this JDBC interface may be included in next release of Calcite? Juan Pan (Trista) Senior DBA & PPMC of Apache ShardingSphere(Incubating) E-mail: panj...@apache.org On 01/7/2020 11:17，Julian

Re: [QUESTION] How could getTableName(columnIndex) return the correct result?

LException if a database access error occurs */ String getTableName(int column) throws SQLException; Juan Pan (Trista) Senior DBA & PPMC of Apache ShardingSphere(Incubating) E-mail: panj...@apache.org On 01/7/2020 10:56，Juan Pan wrote： Hi Julian, You’re right.

Re: [QUESTION] How could getTableName(columnIndex) return the correct result?

call some jdbc interfaces, like getTableName(columnIndex). As a result, when they call getTableName(columnIndex), the null result from calcite makes them throw NPE, but empty string from DBs avoid this case. Julian, very appreciated your help. :-) Best wishes, Trista Juan Pan (Trista

[QUESTION] How could getTableName(columnIndex) return the correct result?

, however the result of which is null. I traced the process and found that if !(selectItem instanceof SqlIdentifier) then return null in `SqlValidatorImpl.java`. Is there any way to get the real table name, i.e, test? Thanks in advance, Trista Juan Pan (Trista

Re: Quicksql

Thanks Gelbana, Very appreciated your explanation, which sheds me some light on exploring Calcite. :) Best wishes, Trista Juan Pan (Trista) Senior DBA & PPMC of Apache ShardingSphere(Incubating) E-mail: panj...@apache.org On 12/22/2019 05:58，Muhammad Gel

Re: Quicksql

it copies many classes from Calcite, the idea of QuickSQL seems some of interests, and code is succinct. Best, Trista Juan Pan (Trista) Senior DBA & PPMC of Apache ShardingSphere(Incubating) E-mail: panj...@apache.org On 12/13/2019 17:16，Juan Pan wrote： Yes, in

Re: Quicksql

the final result? Juan Pan (Trista) Senior DBA & PPMC of Apache ShardingSphere(Incubating) E-mail: panj...@apache.org On 12/12/2019 11:05，Haisheng Yuan wrote： Nope, it doesn't use any adapters. It just submits partial SQL query to different engines. If q

Re: Quicksql

Yes, indeed. Juan Pan (Trista) Senior DBA & PPMC of Apache ShardingSphere(Incubating) E-mail: panj...@apache.org On 12/12/2019 18:00，Alessandro Solimando wrote： Adapters must be needed by data sources not supporting SQL, I think this is what Juan Pan was as

Re: Quicksql

erable) could be used to create a virtual query engine. Basically, i like and agree with Julian’s statement. It is a great idea which personally hope Calcite move towards. Give my best wishes to Calcite community. Thanks, Trista Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphe

Re: [QUESTION] Build Calcite using Gradle

Hi Vladimir, Super thanks for your suggestion! All the issues disappeared after upgrading IDEA. This is very important and first step for me to continue exploring Calcite. :) Thanks Cheng and Rui as well to help me look for issue cause. :-) Juan Pan panj...@apache.org Juan Pan(Trista

Re: [QUESTION] Build Calcite using Gradle

Sure, feedback will come after upgrading. Thanks Vladimir. Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere On 11/26/2019 19:20, Vladimir Sitnikov wrote: >IntelliJ IDEA 2017.3.5 (Ultimate Edition) Could you please upgrade to 2019.3? Vladimir

Re: [QUESTION] Build Calcite using Gradle

Hello Vladimir, Thanks, here is version of IDEA: IntelliJ IDEA 2017.3.5 (Ultimate Edition) Build #IU-173.4674.33, built on March 6, 2018 Licensed to The Apache Software Foundation / juan pan Subscription is active until February 29, 2020 JRE: 1.8.0_152-release-1024-b15 x86_64 JVM: OpenJDK 64

Re: [QUESTION] Build Calcite using Gradle

got the bad result: `calcite: sync failed.—> Failed to notify build listener.` after 2h 18m 986ms passed… Oh dear! Very appreciated if you could give me some idea. :) [1] https://calcite.apache.org/docs/howto.html#building-from-git Juan Pan panj...@apache.org Juan Pan(Trista),

Re: [QUESTION] Build Calcite using Gradle

Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere On 11/26/2019 15:59，Shuo Cheng wrote： First make sure the URLs in `FileReaderTest`, e.g , en.wikipedia.org/wiki/List_of_states_and_territories_of_the_United_States, can be accessed from your machine. On Tue, Nov 26, 2019 at 3:49

[QUESTION] Build Calcite using Gradle

4.0sec, 31 completed, 1 failed, 3 skipped, Gradle Test Run :file:test 31 tests completed, 1 failed, 3 skipped > Task :file:test FAILED Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere

Re: [DISCUSS] State of the project 2019

Sorry to disturb others. @Danny Chan Hi, i have not received your personal mail, and i sent you email(yuzhao@gmail.com?) as well, but no reply. :( So i have to ping you in this way, please excuse me. Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere On 10/25

Re: [DISCUSS] State of the project 2019

Hi Danny, I am interested in your coming talk in Beijing China. How to take part in it, can you give me more detail? Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere On 10/23/2019 18:23，Danny Chan wrote： I gave a talk last year in a university in France, and nobody

Re: [DISCUSS] State of the project 2019

gives me some new ideas for our incubator project. As of now, i am exploring Calcite, so if possible, i want to do some contributions to it as well. Hope Apache Calcite better and better in future. Best wishes, Trista Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere

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

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

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

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

and thoughts. Best wishes, Trista Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere

Re: Ignite community is building Calcite-based prototype

"pay good for good”, so cool! Calcite is great, which our project is using. And now i become interested in Ignite. Best wishes. Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere On 10/2/2019 06:43，Denis Magda wrote： Hi Julian, Nice to e-meet you and thanks for

Re: How to get columnName as `COUNT(*)` , not `EXPR$0`

Sorry, It is CALCITE-3261. Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere On 09/29/2019 16:29，Juan Pan wrote： Thanks Danny, Got it. I will watch CALCITE-326. Regards, Trista Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere On 09/29/2019 16:15

Re: How to get columnName as `COUNT(*)` , not `EXPR$0`

Thanks Danny, Got it. I will watch CALCITE-326. Regards, Trista Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere On 09/29/2019 16:15，Danny Chan wrote： No worries, Juan Pan, welcome to contribute to Apache Calcite. Calcite always put the JIRA issues in the first place

Re: How to get columnName as `COUNT(*)` , not `EXPR$0`

to Calcite community if i can. But.. for a new one, it seems difficult. Regard, Trista Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere On 09/29/2019 14:48，Danny Chan wrote： There is already a JIRA issue to trace this problem[1], maybe we can move the discussion to there. [1

Re: How to get columnName as `COUNT(*)` , not `EXPR$0`

Hi XING, I appreciate your kindness. :-D Your detailed and prompt replies really helped me a lot. I will review the java doc you mentioned. Best wishes, Trista Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere On 09/29/2019 13:58，XING JIN wrote： You can check the below

Re: How to get columnName as `COUNT(*)` , not `EXPR$0`

That means Calcite can only return real columnName or columnLabel from simple column or alias. And any aggregate function, or calculate expression without alias, parsing expression, i.e, `EXPR$0` will be returned? Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere On 09

Re: How to get columnName as `COUNT(*)` , not `EXPR$0`

Thank for your reply. It is a indirect way to get columnName. Calcite can not return the real columnName from SQL, is it right? Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere On 09/29/2019 12:21，XING JIN wrote： You can try to give an alias for the selected column

How to get columnName as `COUNT(*)` , not `EXPR$0`

Hi everyone, I executed SQL `select count(*) from tb1` through Calcite and resultSet.getMetaData().getColumnName(i) in my project. But the result is `EXPR$0` not `COUNT(*)`. Is there any way to get real columnName? Thanks for your attention. Regard, Trista Juan Pan panj

Re: How to modify data for custom tables through Calcite.

Thanks, Danny I will have a try, but it seems challenging, i thought… Regards, Trista Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere On 09/26/2019 14:19，Danny Chan wrote： The ElasticsearchTableScan is a good start to show how it transfers the elastic nodes from

Re: How to modify data for custom tables through Calcite.

@Danny Chan Thanks Danny, is there any document or test for me to learn `specific convention` more? Regards, Trista Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere On 09/26/2019 12:02，Danny Chan wrote： @Rui Wang, Yes, I wrote the Flink-sql-parser module it did

How to modify data for custom tables through Calcite.

elete` SQL through Calcite on custom tables. Can anyone give me some ideas? Really thanks for your help. Regards, Trista Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere

Re: Is it possible that unquoted identifiers are not implicitly converted to upper case

isted of a set of distributed database middleware solutions. | | Juan Pan | | panj...@apache.org Juan Pan(Trista), Apache ShardingSphere | On 09/12/2019 17:32，Feng Zhu wrote： Hi, Juan Pan: You may find the logic in *UnregisterDriver#connect(String url, Properties info)* It just parses the key-value

Re: Is it possible that unquoted identifiers are not implicitly converted to upper case

tion.createStatement()) { // do some things } Thanks again for your kindness, and waiting for u. :) Regards, Trista | | Juan Pan | | panj...@apache.org Juan Pan(Trista), Apache ShardingSphere | On 09/11/2019 20:23，Feng Zhu wrote： Hi, JuanPan, You can refer to Lex, which decides how id

Is it possible that unquoted identifiers are not implicitly converted to upper case

help. Regards, Trista --- Email：panj...@apache.org Juan Pan(Trista) Apache ShardingSphere