Re: Is there any way to view the physical SQLs executed by Calcite JDBC?

Hi Vladimir, I raised a ticket before but it is only about "viewing the SQLs". I received several replies of solution recently but haven't got time to try them. Will try them and file the ticket if needed. Thanks! Vladimir Sitnikov

Re: Is there any way to view the physical SQLs executed by Calcite JDBC?

>get the SQLs without set the breakpoint +1 Explain should include relevant downstream SQL. Yang, can you please file a JIRA ticket? Vladimir

Re: [DISCUSS] Towards Calcite 1.22

Sure, we can do a switch. My next release is 1.24 Best, Danny Chan 在 2020年2月12日 +0800 AM1:09，Andrei Sereda ，写道： > Thanks for stepping in Danny. Can I take your release ? > > On Mon, Feb 10, 2020 at 2:34 PM Julian Hyde wrote: > > > It would be helpful for us to test third-party projects. > > > >

Re: Support unnest multiple array columns

I haven't tried it, but I'd guess that you join to each separately, i.e. take the cartesian product: SELECT numbers, animals, n, a FROM ( VALUES (ARRAY[2, 5], ARRAY['dog', 'cat', 'bird']), (ARRAY[7, 8, 9], ARRAY['cow', 'pig']) ) AS x (numbers, animals) CROSS JOIN UNNEST (numbers) AS t1

Support unnest multiple array columns

Hi Calcite experts: In Presto, multiple array columns could be flattened "together", as Presto docs shows: SELECT numbers, animals, n, aFROM ( > VALUES > (ARRAY[2, 5], ARRAY['dog', 'cat', 'bird']), > (ARRAY[7, 8, 9], ARRAY['cow',

Re: Is there any way to view the physical SQLs executed by Calcite JDBC?

Thanks for the reply @Danny and @Amir, let me see if I can get the SQLs generated without set the breakpoint. I am building a data service, and want to show the real SQLs executed. Thanks! Amir Gajst 于2020年2月12日周三 下午2:53写道： > Set a breakpoint at

Re: Is there any way to view the physical SQLs executed by Calcite JDBC?

Set a breakpoint at *JdbcToEnumerableConverter.generateSql(SqlDialect dialect)* Best Amir On Wed, Feb 12, 2020 at 7:35 AM Danny Chan wrote: > You can set a debug break point in the RelToSqlConverter I think. > > Best, > Danny Chan > 在 2020年2月11日 +0800 AM3:51，Yang Liu ，写道： > > Hi there,

Re: Is there any way to view the physical SQLs executed by Calcite JDBC?

You can set a debug break point in the RelToSqlConverter I think. Best, Danny Chan 在 2020年2月11日 +0800 AM3:51，Yang Liu ，写道： > Hi there, recently I am studying Apache Calcite, by now I can use explain > plan for via JDBC to view the logical plan, and I am wondering how can I > view the physical sql

Build failed in Jenkins: Calcite-Snapshots #112

See Changes: [yuzhao.cyz] [CALCITE-3781] HintStrategy can specify excluded rules for planner -- [...truncated 111.86 KB...] > Configure project :example:csv Evaluating

[jira] [Created] (CALCITE-3785) HepPlanner.belongToDag() doesn't have to use mapDigestToVertex

Xiening Dai created CALCITE-3785: Summary: HepPlanner.belongToDag() doesn't have to use mapDigestToVertex Key: CALCITE-3785 URL: https://issues.apache.org/jira/browse/CALCITE-3785 Project: Calcite

Re: [DISCUSS] Towards Calcite 1.22

Thanks for stepping in Danny. Can I take your release ? On Mon, Feb 10, 2020 at 2:34 PM Julian Hyde wrote: > It would be helpful for us to test third-party projects. > > But equally, it is useful for third-party projects to test against us. > (Especially non-open-source ones, which we cannot

[jira] [Created] (CALCITE-3784) RexCall toString digest gives OOM while huge expression is evaluated

Ravi Kapoor created CALCITE-3784: Summary: RexCall toString digest gives OOM while huge expression is evaluated Key: CALCITE-3784 URL: https://issues.apache.org/jira/browse/CALCITE-3784 Project:

Re: Stuck on 'HOWTO - Setting up IntelliJ IDEA'

Thanks for your feedback! Stamatis Zampetakis 于2020年2月11日周二 下午6:45写道： > Hi Yushan, > > The instructions currently on the website are for the master (not yet > released). If you want to work with release 1.21.0 check the instructions > here [1]. > > Best, > Stamatis > > [1] > >

Re: Stuck on 'HOWTO - Setting up IntelliJ IDEA'

Hi Yushan, The instructions currently on the website are for the master (not yet released). If you want to work with release 1.21.0 check the instructions here [1]. Best, Stamatis [1] https://github.com/apache/calcite/blob/calcite-1.21.0/site/_docs/howto.md#setting-up-intellij-idea On Tue, Feb

[jira] [Created] (CALCITE-3783) Rule to remove Join on top of empty Values

Ruben Q L created CALCITE-3783: -- Summary: Rule to remove Join on top of empty Values Key: CALCITE-3783 URL: https://issues.apache.org/jira/browse/CALCITE-3783 Project: Calcite Issue Type:

Stuck on 'HOWTO - Setting up IntelliJ IDEA'

Hi all, I follow the docs here https://calcite.apache.org/docs/howto.html#setting-up-intellij-idea. However, I got stuck on the first step. I cannot find 'gradle' inside the folder. I tried both the release 1.21.0 with tar and the released version on GitHub. (but, the 'gradle' binary is

[jira] [Created] (CALCITE-3782) Bitwise operator Bit_And, Bit_OR and Bit_XOR support binary and varbinary type

hailong wang created CALCITE-3782: - Summary: Bitwise operator Bit_And, Bit_OR and Bit_XOR support binary and varbinary type Key: CALCITE-3782 URL: https://issues.apache.org/jira/browse/CALCITE-3782