Re: how to validate a sql is optimize

2018-08-30 Thread Michael Mior
Unfortunately, I can't parse the question you're asking. You'll have to provide more details to receive a useful response. -- Michael Mior mm...@apache.org Le mer. 29 août 2018 à 03:01, 毛秀庆 a écrit : > > > when input a SQL, then output what is optimized by calcite ? > > how the code write

Re: JSON support

2018-08-30 Thread Michael Mior
Thanks for the clarification :) -- Michael Mior mm...@apache.org Le mer. 29 août 2018 à 19:28, Julian Hyde a écrit : > The rules for Parser.jj are a little different. JavaCC needs to parse the > Java fragments inside rules and sometimes it can’t handle modern Java > syntax such as “new

identifying original SQL functions after rewrites (in adapters)

2018-08-30 Thread Andrei Sereda
Hello, I’m trying to implement COALESCE for elastic adapter and would like to know what is recommended approach to identify original function (after possible rewrites). Let me give an example. Currently calcite converts COALESCE(attr, 'foo') into CASE(IS NOT NULL(attr), attr, 'foo'). So in

Re: [VOTE] Release calcite-avatica-go-3.1.0 (release candidate 0)

2018-08-30 Thread Michael Mior
Thanks Francis. I thought I recalled Docker being an option but I missed in the documentation. I get the failure message below. Other than that, tests pass. calcite-avatica-go_1 | --- FAIL: TestPhoenixOptimisticConcurrency (46.12s) calcite-avatica-go_1 | driver_test.go:95: error on exec CREATE

Re: [VOTE] Release calcite-avatica-go-3.1.0 (release candidate 0)

2018-08-30 Thread Josh Elser
That looks like an issue with Phoenix+Tephra rather than with the Go driver. The latest release of Tephra (going through IPMC vote now) should be fixing that. Essentially, Tephra had an issue where it was trying to get a random port and then bind it in two separate steps. Sometimes, some

Re: [VOTE] Release calcite-avatica-go-3.1.0 (release candidate 0)

2018-08-30 Thread Michael Mior
Yeah, I assumed it probably wasn't an Avatica issue. I maintain my +1. -- Michael Mior mm...@apache.org Le jeu. 30 août 2018 à 11:54, Josh Elser a écrit : > That looks like an issue with Phoenix+Tephra rather than with the Go > driver. The latest release of Tephra (going through IPMC vote

Re: [VOTE] Release calcite-avatica-go-3.1.0 (release candidate 0)

2018-08-30 Thread Francis Chuang
Thanks for testing Michael! I just tried testing using docker on a VM with a lot of RAM and was not able to reproduce the issue. The Phoenix image I am using is boostport/hbase-phoenix-all-in-one:2.0-5.0. I am going to cancel the vote and roll a new RC as I neglected to update the dockerfile

Re: Maven wrapper

2018-08-30 Thread Julian Hyde
Please review https://github.com/julianhyde/calcite/tree/2112-mvnw , and give it a try in your own sandbox. I have built on the original patch. We no longer need to include a .jar or .java. And I’ve updated the documentation to use ‘./mvnw’

[VOTE] Release calcite-avatica-go-3.1.0 (release candidate 1)

2018-08-30 Thread Francis Chuang
Hi all, I have created a release for Apache Calcite Avatica Go 3.1.0, release candidate 1. The release notes are available here: https://github.com/apache/calcite-avatica-go/blob/master/site/_docs/go_history.md The commit to be voted on:

[CANCEL][VOTE] Release calcite-avatica-go-3.1.0 (release candidate 0)

2018-08-30 Thread Francis Chuang
The vote for Apache Calcite Avatica Go 3.1.0, release candidate 0 has been cancelled. A new release will be tagged as 3.1.0-rc1 and will be available for voting soon. Francis

[jira] [Created] (CALCITE-2513) Fix dockerfile for running tests using docker-compose to work with Go modules

2018-08-30 Thread Francis Chuang (JIRA)
Francis Chuang created CALCITE-2513: --- Summary: Fix dockerfile for running tests using docker-compose to work with Go modules Key: CALCITE-2513 URL: https://issues.apache.org/jira/browse/CALCITE-2513

Re: joins and low selectivity optimization

2018-08-30 Thread Vineet Garg
Hive actually does this optimization (it is called semi-join reduction) by generating bloom-filters on one side and passing it on to the other side. This is not a rewrite but instead a physical implementation. Vineet On Aug 29, 2018, at 10:34 AM, Vladimir Sitnikov

[jira] [Created] (CALCITE-2510) CHR support

2018-08-30 Thread Sergey Tsvetkov (JIRA)
Sergey Tsvetkov created CALCITE-2510: Summary: CHR support Key: CALCITE-2510 URL: https://issues.apache.org/jira/browse/CALCITE-2510 Project: Calcite Issue Type: Task

[jira] [Created] (CALCITE-2511) Possible bug in parsing implementation of rown_num select

2018-08-30 Thread Piotr Bojko (JIRA)
Piotr Bojko created CALCITE-2511: Summary: Possible bug in parsing implementation of rown_num select Key: CALCITE-2511 URL: https://issues.apache.org/jira/browse/CALCITE-2511 Project: Calcite

[jira] [Created] (CALCITE-2512) StreamTest#testStreamCancel fails in a flaky way

2018-08-30 Thread Sergey Nuyanzin (JIRA)
Sergey Nuyanzin created CALCITE-2512: Summary: StreamTest#testStreamCancel fails in a flaky way Key: CALCITE-2512 URL: https://issues.apache.org/jira/browse/CALCITE-2512 Project: Calcite