Re: Does Calcite hold all records output from a node before passing them to a higher node ?

2018-05-29 Thread Julian Hyde
Arrow adapter code. > > Thanks, > Gelbana > > On Tue, May 29, 2018 at 5:50 PM, Julian Hyde wrote: > >> I believe that scan, filter, project do not buffer; aggregate, join and >> sort do buffer; join perhaps buffers a little more than it should. >> >>

Re: Does Calcite hold all records output from a node before passing them to a higher node ?

2018-05-30 Thread Julian Hyde
he sending one ? In other words, an node acting as an > input to another one should always send an enumerable and the > receiving\parent node is free to buffer the obtained rows or process them > right away. > > Thanks, > Gelbana > > On Wed, May 30, 2018 at 12:37 AM, Julian Hyd

Re: Datetime_Plus and TimestampAdd operators

2018-05-30 Thread Julian Hyde
imestampAdd. This looks odd in generated SQL, and if you >>> were >>>> go to back to timestampadd, the original intent wouldn't be clear. >>>> - There are a few units in timestampadd that are not directly supported >>> by >>>> intervals (we

Re: Datetime_Plus and TimestampAdd operators

2018-05-30 Thread Julian Hyde
. It would be useful to have Rex utilities to convert from each form to the other form. Julian > On May 30, 2018, at 3:12 PM, Julian Hyde wrote: > > I have logged https://issues.apache.org/jira/browse/CALCITE-2339 > <https://issues.apache.org/jira/browse/CALCITE-2339&g

Re: [DISCUSS] Towards Calcite 1.17.0

2018-05-30 Thread Julian Hyde
I’d appreciate if Kevin could finish https://issues.apache.org/jira/browse/CALCITE-2259 but I can’t ask you to hold the release because Kevin owns his own time. > On May 30, 2018, at 5:20 AM, Volodymyr Vysotskyi wrote: > > Sorry, for some r

Re: calcite-avatica git commit: CALCITE-2294 Allow customization for AvaticaServerConfiguration for plugging new authentication mechanisms

2018-05-30 Thread Julian Hyde
Josh, per our guidelines, comment should be > [CALCITE-2294] Allow customization for AvaticaServerConfiguration for > plugging new authentication mechanisms (Karan Mehta) Can you force-push to fix please. > On May 30, 2018, at 4:07 PM, els...@apache.org wrote: > > Repository: calcite-avatica

Re: Suitability of RelJson format for long-term storage

2018-05-31 Thread Julian Hyde
I support the idea of making it stable. It will take some work: at a minimum, documentation and a version id, then later some transformers to convert version X to version Y. > On May 31, 2018, at 8:16 AM, Michael Mior wrote: > > AFAIK, no one is using this for long-term storage and no one is e

Re: Check those commit messages please!

2018-06-01 Thread Julian Hyde
Maybe I'm more pedantic than most, but I believe that a clean, clear consistent commit log is an indication of a high-quality project. It's also a great tool for users and maintainers alike. The commit log becomes the release notes, which is the main way that people find out what features are in o

Re: Status of Stream-SQL-TCK

2018-06-01 Thread Julian Hyde
I wrote and submitted one PR [1], and never completed the second [2]. net.hydromatic is a domain I own. It has the advantage that (1) it is not org.apache (the consensus was that this effort should happen outside any extant Apache project) and (2) I have rights to push artifacts of this groupId to

Re: [DISCUSS] Towards Avatica 1.12.0

2018-06-02 Thread Julian Hyde
That checkbox only exists when you are using Jira’s “bulk change” functionality. Julian > On Jun 2, 2018, at 03:00, Francis Chuang wrote: > > This is my summary for the week ending 1 June 2018: > - Many thanks to Julian, Josh, Karan, Sergey and Haohui for contributing, > reviewing and mergin

Re: Suitability of RelJson format for long-term storage

2018-06-04 Thread Julian Hyde
baked in, but please let me know if I am > missing some option for encoding the column references by name rather than > index. > > -Marc > > >> On May 31, 2018, at 11:50, Julian Hyde wrote: >> >> I support the idea of making it stable. It will take

[ANNOUNCE] Alan Gates has gone emeritus

2018-06-05 Thread Julian Hyde
Alan Gates has resigned from the Calcite PMC, and is now an Emeritus PMC member. “Emeritus" is an unofficial designation for former project members (PMC or committers) that allows us to recognize their past efforts[1]. I have created a new section on the web site[2] for such emeritus members. A

Re: [2/2] calcite-avatica git commit: [CALCITE-2330] Release Avatica 1.12

2018-06-05 Thread Julian Hyde
> > +## href="https://github.com/apache/calcite-avatica/releases/tag/calcite-avatica-1.11.0";>1.12.0 > / 2018-06-15 > +{: #v1-12-0} Should be href="https://github.com/apache/calcite-avatica/releases/tag/calcite-avatica-1.12.0"; > +Apache Calcite Avatica 1.12.0 includes fixes for more than

Re: Elasticsearch integration test failures

2018-06-07 Thread Julian Hyde
Unfortunately, I don’t know. We don’t run the integration tests as often as we should. > On Jun 7, 2018, at 10:20 AM, Vova Vysotskyi wrote: > > Hi all, > > I tried to run Elasticsearch integration tests for the current master, and > many tests failed. > > Is it a known problem, or just an iss

Re: Oracle ROWNUM

2018-06-08 Thread Julian Hyde
I’m curious how you represented ROWNUM. Did you make it a hidden field in your table? That approach has problems, because in, say, a join query, ROWNUM is a property of the row, not of either of the source tables. I think I would represent it as a zero-argument function (like CURRENT_DATE) and

Re: calcite-avatica git commit: [CALCITE-2352] Fix missing suppressions.xml change

2018-06-09 Thread Julian Hyde
Why add a suppression? Was it not possible to fix the problem? On Sat, Jun 9, 2018 at 11:41 AM, wrote: > Repository: calcite-avatica > Updated Branches: > refs/heads/master acb675de9 -> 4c6b55e08 > > > [CALCITE-2352] Fix missing suppressions.xml change > > Add change to suppressions.xml for ge

Re: calcite support bit operation

2018-06-09 Thread Julian Hyde
BIt operations are not standard SQL. Are there any databases that support them? (I’m guessing MySQL, which at one point seemed to have a mission to convert SQL into C, even down to using int instead of boolean.) We could perhaps add support for bit operations, but I would not like to add an ‘&

Re: calcite support bit operation

2018-06-09 Thread Julian Hyde
PS Can you see what support for bit operations is in other databases? It would be quite straightforward to add new functions, less easy to add “&” or “|” or “~”. > On Jun 9, 2018, at 6:47 PM, Julian Hyde wrote: > > BIt operations are not standard SQL. > > Are there any dat

Re: Ask for permission to contribute

2018-06-09 Thread Julian Hyde
You don’t need permission to contribute. If you wish to contribute code, submit a pull request to https://github.com/apache/calcite/pulls . A committer will review the change, perhaps ask for modifications, and commit it to the git master branch. If it’s

Re: Calcite travis jdk11 failed while compilation of calcite-elasticsearch2 on travis

2018-06-12 Thread Julian Hyde
What would be the command-line arguments to achieve this? I will add them to my nightly build scripts. I already skip certain Guava versions based on JDK. Julian > On Jun 12, 2018, at 12:42 PM, Kevin Risden wrote: > > We might want to skip JDK11 with ES 2.x. 2.x is EOL from Elastic. I can >

Re: Calcite travis jdk11 failed while compilation of calcite-elasticsearch2 on travis

2018-06-12 Thread Julian Hyde
PS Can someone please log a JIRA case for this. At the very least we need to modify HISTORY.md to say which ES versions are supported with each JDK. If we can make a code fix, even better. > On Jun 12, 2018, at 3:14 PM, Julian Hyde wrote: > > What would be the command-line arg

Re: Oracle ROWNUM

2018-06-12 Thread Julian Hyde
I recommend that you make ROWNUM a 0-parameter function. Then write a planner rule to handle it. I strongly recommend that you do not apply the rule during parsing or validation. Let’s have further conversation on a JIRA case. > On Jun 12, 2018, at 3:46 AM, Kiril Menshikov wrote: > > Yes, tha

Re: calcite git commit: [CALCITE-2358] use null literal instead of empty string. (b-slim)

2018-06-14 Thread Julian Hyde
In commit comment: please start with capital letter, no closing period, and don’t include contributor name if the contributor is a committer. Sorry to nit-pick. I sent out guidelines about this a week or so ago. And most importantly, make it clear which sub-system this applies to. This change o

Re: [2/2] calcite git commit: [CALCITE-2345] Running Unit tests with Fongo and integration tests with real mongo instance (Andrei Sereda)

2018-06-14 Thread Julian Hyde
This change introduces a javadoc error: [ERROR] /home/jhyde/regress/calcite/mongodb/src/test/java/org/apache/calcite/test/MongoAdapterIT.java:35: error: unexpected end tag: [ERROR] * Please fix ASAP. > On Jun 13, 2018, at 6:00 PM, mm...@apache.org wrote: > > [CALCITE-2345] Running Unit te

SIGMOD and out

2018-06-15 Thread Julian Hyde
I'm back from the SIGMOD conference in Houston, where Edmon and I received an excellent audience for our talk. (See my tweet [1] with a picture and slides attached.) I did a straw poll of the audience at the start of the talk, and only about 15% had heard of Calcite. "I wish I'd known about Calcit

Re: calcite-avatica git commit: CALCITE-2285 Support client cert keystore for Avatica Client

2018-06-15 Thread Julian Hyde
Josh, Please remember to use brackets about the JIRA case number in the commit. Not "CALCITE-2285" but "[CALCITE-2285]". You write great code and great commit comments, but I'd just like to keep the commit format consistent across all committers. Julian On Thu, Jun 14, 2018 at 9:41 AM, wrote

Re: SIGMOD and out

2018-06-15 Thread Julian Hyde
, Jun 15, 2018 at 2:57 PM, Julian Hyde wrote: > I'm back from the SIGMOD conference in Houston, where Edmon and I > received an excellent audience for our talk. (See my tweet [1] with a > picture and slides attached.) > > I did a straw poll of the audience at the start of the

Re: Calcite - RelMetadataTest.testPullUpPredicatesForExprsItr - 20 second timeout

2018-06-21 Thread Julian Hyde
I noticed this test slow down about a month ago. I hit the timeouts but I assumed at the time that I was running on an underpowered/overtaxed machine. Can you log a JIRA case please, Kevin? It would be useful if someone could do some experiments to find out whether this test was faster 6 months

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

2018-06-21 Thread Julian Hyde
+1 Downloaded, checked digests, built and ran tests (“mvn install”) on macOS under JDK 9, ran apache-rat. Big thanks to Francis for being release manager, and to the many — more than usual! — folks who contributed to this release. Comments: I was not able to obtain Francis’ key from a public k

Re: Creating filter expressions with java predicates

2018-06-21 Thread Julian Hyde
Regardless of how you create it, it’s difficult to pass arbitrary objects into a plan. It you can ensure that each predicate has a public no-arguments constructor, you could pass the predicate’s class name. Then your custom operator can instantiate the predicate. One option is to create a user-

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

2018-06-21 Thread Julian Hyde
-stopper, but we try to suppress or fix these. Let’s do it soon after the release. Julian > On Jun 21, 2018, at 5:41 PM, Julian Hyde wrote: > > +1 > > Downloaded, checked digests, built and ran tests (“mvn install”) on macOS > under JDK 9, ran apache-rat. > > Big tha

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

2018-06-21 Thread Julian Hyde
n release mode, can we punt that to the next release? > > Re the missing names in the release history, my apologies for the oversight. > I will add them in once after the release. > > Francis > > On 22/06/2018 10:41 AM, Julian Hyde wrote: >> +1 >> >> Do

Gandiva

2018-06-22 Thread Julian Hyde
There is a discussion on dev@arrow about Gandiva, a kernel for Arrow[1]. I think it would be an interesting library on which to build our Arrow engine. (Without a kernel, Arrow is just a data format, but with Gandiva it becomes an engine upon which we can implement all relational operations, alb

Re: Gandiva

2018-06-22 Thread Julian Hyde
with it. To me Gandiva > is on execution side, in which scenarios a query planner would need a arrow > engine? I read the original Jira about implementing file enumerator, but the > intent is still not clear to me. Would appreciate if you can elaborate. > Thanks. > > >> On

Re: [2/2] calcite git commit: [CALCITE-2347] running ElasticSearch in embedded mode for unit tests of ES adapter (Andrei Sereda)

2018-06-22 Thread Julian Hyde
Looks like this change broke “mvn site” (perhaps also “mvn javadoc:test-javadoc”). [ERROR] Failed to execute goal org.apache.maven.plugins:maven-site-plugin:3.7:site (default-site) on project calcite: Error generating maven-javadoc-plugin:3.0.1:test-aggregate report: [ERROR] Exit code: 1 - /h

Re: [2/2] calcite git commit: [CALCITE-2347] running ElasticSearch in embedded mode for unit tests of ES adapter (Andrei Sereda)

2018-06-22 Thread Julian Hyde
t; > > Le ven. 22 juin 2018 à 17:12, Julian Hyde a écrit : > >> Looks like this change broke “mvn site” (perhaps also “mvn >> javadoc:test-javadoc”). >> >> [ERROR] Failed to execute goal >> org.apache.maven.plugins:maven-site-plugin:3.7:site (default-s

Re: [2/2] calcite git commit: [CALCITE-2347] running ElasticSearch in embedded mode for unit tests of ES adapter (Andrei Sereda)

2018-06-22 Thread Julian Hyde
aster and c12cb4b0de work for me. Perhaps the issue is JDK 8 vs > 9 ? > > # JDK8 (oracle) / macOS > $ mvn clean -DskipTests site > > On Fri, Jun 22, 2018 at 5:56 PM Julian Hyde wrote: > >> I just tried it again. The following fails for me (jdk9, ubuntu): >> &

Re: [2/2] calcite git commit: [CALCITE-2347] running ElasticSearch in embedded mode for unit tests of ES adapter (Andrei Sereda)

2018-06-22 Thread Julian Hyde
Same failure for me on JDK 8/macOS. The most likely other variable is maven: I have 3.5.2 on macOS, 3.5.3 on ubuntu. I’m mystified why no one else is seeing javadoc failures on macOS. Julian > On Jun 22, 2018, at 4:35 PM, Julian Hyde wrote: > > On JDK 8/ubuntu, “mvn clean -DskipT

Re: [2/2] calcite git commit: [CALCITE-2347] running ElasticSearch in embedded mode for unit tests of ES adapter (Andrei Sereda)

2018-06-25 Thread Julian Hyde
;>> I have also checked "mvn javadoc:javadoc javadoc:test-javadoc" on my >>> machine (Ubuntu, JDK 8, Maven 3.3.9) and it fails on elasticsearch2 >> module >>> (didn't check this problem for the next modules). >>> >>> "mvn clean

Re: [2/2] calcite git commit: [CALCITE-2347] running ElasticSearch in embedded mode for unit tests of ES adapter (Andrei Sereda)

2018-06-25 Thread Julian Hyde
> On Jun 25, 2018, at 11:11 AM, Andrei Sereda wrote: > > Would you consider merging this partial javadoc fix (PR 741 > ) as precursor for CALCITE-2376 ? > Former PR has also fixes javadoc issues for mongo adapter. No. I have 5 commits that I would lik

Re: calcite git commit: [CALCITE-2358] use null literal instead of empty string. (b-slim)

2018-06-25 Thread Julian Hyde
e very likely to assume that we are doing the same.) Could you please rename it to DRUID_NULL_EQUAL_TO_EMPTY or DRUID_NULL_IS_EMPTY? Julian > On Jun 14, 2018, at 7:36 AM, Julian Hyde wrote: > > In commit comment: please start with capital letter, no closing period, and > don’t i

Re: Improving the developer experience for releasing

2018-06-25 Thread Julian Hyde
Thanks for starting off this discussion. I presume you’re mainly thinking of the Avatica process but all except 4 also apply to Calcite. I’ve not personally run into 1, 2 or 3 but I can see how other people might. Feel free to update HOWTO if that would solve the problem. (Blame me for 2, espec

Re: Improving the developer experience for releasing

2018-06-25 Thread Julian Hyde
By the way, thank you for being release manager, Francis. It is of the fastest and most complex Avatica release I can remember. Thank you for making it run so smoothly. Julian > On Jun 25, 2018, at 4:47 PM, Francis Chuang wrote: > > I'd like to open up some discussion regarding the developer

Re: [2/2] calcite git commit: [CALCITE-2347] running ElasticSearch in embedded mode for unit tests of ES adapter (Andrei Sereda)

2018-06-25 Thread Julian Hyde
and ES5) has been agreed upon with Christian and >> Michael. Once implemented, it should automatically fix current classpath >> issue in javadoc. >> >> >> On Mon, Jun 25, 2018 at 2:23 PM Andrei Sereda wrote: >> >>> OK. I'm working on it. >&g

Re: Calcite - RelMetadataTest.testPullUpPredicatesForExprsItr - 20 second timeout

2018-06-26 Thread Julian Hyde
apache.org > > > > Le jeu. 21 juin 2018 à 19:43, Julian Hyde a écrit : > >> I noticed this test slow down about a month ago. I hit the timeouts but I >> assumed at the time that I was running on an underpowered/overtaxed machine. >> >> Can you log a JIRA c

Re: [DISCUSS] Towards Calcite 1.17.0

2018-06-28 Thread Julian Hyde
To answer Michael's question: I don't think we should delay the report, nor should we hurry the release. It's fair to say that 1.17 is in its final stages. There was a lot of activity on avatica-1.12 from a lot of individuals, and the community is in great shape. Here are the cases listed by Volod

Re: [DISCUSS] Draft board report for July 2018

2018-06-28 Thread Julian Hyde
+1 Consider adding a mention of the paper Edmon and I presented at SIGMOD 2 weeks ago, and even include a link: https://arxiv.org/abs/1802.10233. It is a major milestone for the project. I agree that community activity is very healthy right now. I was very pleased at the number of people who cont

Re: Elasticsearch Adapter. Removal of Mapping Types (by vendor). Index == Table

2018-06-29 Thread Julian Hyde
Andrei, I'm not an ES user so I don't fully understand this issue, but my two cents anyway... Can you show how those examples affect SQL against the ES adapter and/or how they affect JSON models? You seem to be using '_' as a separator character. Are we sure that people will never use it in inde

Re: Gandiva

2018-06-29 Thread Julian Hyde
l SQL built-in >> functions and basic relational operators. Building on top of Gandiva we >> could save a lot of this effort. >> >> I will start to build Gandiva development environment and try to >> consider a way to incorporate. >> >> thanks. >>

Re: [DISCUSS] Towards Calcite 1.17.0

2018-06-29 Thread Julian Hyde
18 3:54 AM, Michael Mior wrote: >> >>> I'll add CALCITE-2331 as at least a nice-to-have. I believe Andrei is >>> working on a PR and this would be a good bug to have fixed. >>> >>> * https://issues.apache.org/jira/browse/CALCITE-2331 evaluation of >

Re: Elasticsearch Adapter. Removal of Mapping Types (by vendor). Index == Table

2018-06-29 Thread Julian Hyde
haracter. Are we sure that >> people will never use it in index or type name? Separator characters >> often cause problems. > In elastic (index/type) pair is guaranteed to be unique therefore > "${index}_${type}" will be also unique (as string). This is only necessary >

Re: Elasticsearch Adapter. Removal of Mapping Types (by vendor). Index == Table

2018-06-29 Thread Julian Hyde
llision strategy ? User defined pattern like above or > failure or auto generated name ? > > On Fri, Jun 29, 2018, 19:14 Julian Hyde wrote: > >>> In elastic (index/type) pair is guaranteed to be unique therefore >>> "${index}_${type}" will be also unique (a

Re: [DISCUSS] Towards Calcite 1.17.0

2018-06-30 Thread Julian Hyde
llowing PRs can be closed? > https://github.com/apache/calcite/pull/180 > https://github.com/apache/calcite/pull/17 > https://github.com/apache/calcite/pull/422 > > If so, I'll open a case with INFRA to close them. > > Francis > >> On 30/06/2018 7:14 AM, Julian H

Re: [jira] [Created] (CALCITE-2390) Remove uses of X509CertificateObject, deprecated in current bouncycastle

2018-06-30 Thread Julian Hyde
Kevin or Josh, can you fix this ASAP? We regard uses of deprecated APIs as a broken build. > On Jun 30, 2018, at 9:15 AM, Julian Hyde (JIRA) wrote: > > Julian Hyde created CALCITE-2390: > > > Summary: Remove uses of X50

Re: [DISCUSS] Towards Calcite 1.17.0

2018-07-01 Thread Julian Hyde
e 17 and 180 given how old they are. If anything that old is >> important, it can always be reopened or a new PR created. I don't know the >> context for 422. >> >> -- >> Michael Mior >> mm...@apache.org >> >> >> >> Le sam. 30

Re: [DISCUSS] Towards Calcite 1.17.0

2018-07-02 Thread Julian Hyde
> On Jun 29, 2018, at 7:29 PM, Francis Chuang wrote: > > Can someone please confirm that the following PRs can be closed? > https://github.com/apache/calcite/pull/180 > > https://github.com/apache/calcite/pull/17 > <

Re: [DISCUSS] Towards Calcite 1.17.0

2018-07-02 Thread Julian Hyde
on't know the complexity of these issues and > current status for CALCITE-2384 > <https://issues.apache.org/jira/browse/CALCITE-2384>. > > Kind regards, > Volodymyr Vysotskyi > > > пн, 2 лип. 2018 о 20:42 Julian Hyde пише: > >>> On Jun 29, 2018, at 7:29

Re: Supporting SELECT xxx FROM TABLE FOR UPDATE

2018-07-03 Thread Julian Hyde
Let’s discuss at the JIRA case. > On Jul 3, 2018, at 2:28 AM, Enrico Olivelli wrote: > > Hi, > My need is to support 'FOR UPDATE' syntax, I am using Calcite SQL Parser > and Planner only. > > > I will try to work on this case, it is not blocker for me, I would like to > provide an implementati

Re: [DISCUSS] Towards Calcite 1.17.0

2018-07-03 Thread Julian Hyde
> On 07/02/2018 09:13 PM, Volodymyr Vysotskyi wrote: >> I think I can finish CALCITE-2392 on Wed or Thursday. >> Kind regards, >> Volodymyr Vysotskyi >> пн, 2 лип. 2018 о 21:22 Julian Hyde пише: >>> OK, so 2384 and 2392 are the critical path. >>> >

Reviews please

2018-07-07 Thread Julian Hyde
I have two major changes ready to check in. Can someone please review them? * https://issues.apache.org/jira/browse/CALCITE-2280 Babel SQL parser * https://issues.apache.org/jira/browse/CALCITE-2259 Java 8 syntax Both are staged in the same branch - https://github.com/julianhyde/calcite/commits/2

Re: Reviews please

2018-07-08 Thread Julian Hyde
On Sun, Jul 8, 2018 at 5:42 AM, Enrico Olivelli wrote: > I am sorry I have not much time to try out the branch and do some of the > implementations on Babel before 1.17 release (which I am assuming it to be > immediate after merging this feature branch) No worries - this is just a start. > Most

Re: Reviews please

2018-07-08 Thread Julian Hyde
On Sat, Jul 7, 2018 at 3:56 PM, Michael Mior wrote: > I've done a scan of the code and it looks great to me. Also compiled > and ran tests on my machine just in case. I love commits that delete > more code than they add (over 2,600 deleted lines!) I had no idea I'd net-deleted code. A nice side

Re: Reviews please

2018-07-09 Thread Julian Hyde
I just merged both commits (and quite a few commits by other contributors) to master. > On Jul 8, 2018, at 3:44 PM, Julian Hyde wrote: > > On Sat, Jul 7, 2018 at 3:56 PM, Michael Mior wrote: > >> I've done a scan of the code and it looks great to me. Also compiled

Re: [ANNOUNCE] Volodymyr Vysotskyi joins Calcite PMC

2018-07-09 Thread Julian Hyde
Well deserved. Thanks for all your work making the project great, Volodymyr! > On Jul 9, 2018, at 7:36 AM, Aman Sinha wrote: > > Congratulations Volodymyr ! > > > On Mon, Jul 9, 2018 at 7:09 AM Arina Yelchiyeva > wrote: > >> Congratulations Vova! >> >> Kind regards, >> Arina >> >> On Mon,

Re: [DISCUSS] Towards Calcite 1.17.0

2018-07-11 Thread Julian Hyde
, >>>> Volodymyr Vysotskyi >>>> >>>> >>>> пт, 6 лип. 2018 о 17:58 Andrei Sereda пише: >>>> >>>>> I have created PR-753 <https://github.com/apache/calcite/pull/753> >> for >>>>> CALCITE-2331. Please note it fixes o

Re: Avatica/Calcite tests against Windows

2018-07-11 Thread Julian Hyde
To answer Sergey’s original question: there are no plans. I try to build and test on Windows before each release. If you can do more that would be great. > On Jul 11, 2018, at 9:22 AM, Michael Mior wrote: > > If you have an Appveyor setup that works, I don't see an obvious > reason why we could

Re: Stream-stream joins

2018-07-11 Thread Julian Hyde
Just to clarify the subject. We’re not talking about stream-to-stream joins but stream joining to a temporal table. It’s not an equi-join: when an order occurs, we look for the applicable rate for that order. If I am mistaken in this, please let me know. All 3 syntaxes look reasonable in princi

Re: calcite git commit: Add Kevin to PMC

2018-07-12 Thread Julian Hyde
Michael, When you update the site, rather than making the changes on the “master” branch, please make the changes on the “site” branch and then cherry-pick those changes to the “master" branch. The goal is that the “site” branch is always in sync with the currently published site. At some tim

Re: calcite git commit: Add Kevin to PMC

2018-07-12 Thread Julian Hyde
g this in > the future of course :) > > -- > Michael Mior > mm...@apache.org > Le jeu. 12 juil. 2018 à 17:53, Julian Hyde a écrit : >> >> Michael, >> >> When you update the site, rather than making the changes on the “master” >> branch, please make

Re: Trigger a Coverity scan

2018-07-14 Thread Julian Hyde
On Sat, Jul 14, 2018 at 7:56 AM, Volodymyr Vysotskyi wrote: > Hello Julian, > > Sorry for bothering in non-working hours. No worries! Work never stops. Thanks for working during your weekend, also. I replied to the dev list, since this concerns the release and development. (Usually I don't reply

Re: Trigger a Coverity scan

2018-07-15 Thread Julian Hyde
d be great. On Sun, Jul 15, 2018 at 3:20 AM, Volodymyr Vysotskyi wrote: > Thanks for merging the PR and for clarifying. > > I agree that it is useful to forward this question to dev list to avoid > similar questions in future. > > Kind regards, > Volodymyr Vysotskyi > &

Re: Stream-stream joins

2018-07-15 Thread Julian Hyde
> inner join with a join condition is equivalent to cross join followed by a > filter with join condition, regardless of whether relations that we are > joining are “temporal tables”, plane “tables” or subqueries. > > Piotrek > > On 2018/07/11 19:13:36, Julian Hyde wrote: >

Re: [VOTE] Release apache-calcite-1.17.0 (release candidate 0)

2018-07-16 Thread Julian Hyde
+1 (binding) Downloaded; checked hashes; checked LICENSE, NOTICE, README; ran RAT; built and ran tests under JDK 9 on macOS; read release notes. I also built and ran tests on Windows Server 2012. Volodymyr, Thanks being release manager. You made this run very smoothly! Before we announce the

Virtual key signing party

2018-07-17 Thread Julian Hyde
fingerprint before the meeting. (Use ‘gpg --fingerprint’.) Here’s mine: pub rsa4096/DDB6E9812AD3FAE3 2014-07-24 [SC] Key fingerprint = DD31 4F5E 1773 7D76 A554 DCE8 DDB6 E981 2AD3 FAE3 uid [ unknown] Julian Hyde (CODE SIGNING KEY) sub rsa4096/7A6BF54DB9E5F68D 2014-07-24 [E

Re: Virtual key signing party

2018-07-17 Thread Julian Hyde
PS Also bring government-issued ID (e.g. driver’s license or passport) to prove you are who you say you are. All are welcome - not just committers and PMC members. If you can’t make this time, let us know, and we will schedule another one soon. > On Jul 17, 2018, at 2:04 PM, Julian H

Re: Virtual key signing party

2018-07-17 Thread Julian Hyde
t; 0900 Pacific is 2:00 AM Friday in Melbourne, Australia. Is there a chance we > can organize an earlier time? > > Francis > > On 18/07/2018 7:07 AM, Julian Hyde wrote: >> PS Also bring government-issued ID (e.g. driver’s license or passport) to >> prove you are who you

Re: Virtual key signing party

2018-07-18 Thread Julian Hyde
;>> >>> Here's my fingerprint: >>> >>> pub 4096R/3A970AB7 2018-04-16 >>> Key fingerprint = 6356 65E0 BE3F 7255 2910 CB74 BBE4 4E92 3A97 >> 0AB7 >>> uid Francis Chuang >>> sub 4096R/34BCCFB3 2018-04-16

Re: Virtual key signing party

2018-07-18 Thread Julian Hyde
+3ExXjcAgVCN8VuB7MPm7CzeZIBneyfHZQT9+WukvHwA8Bt5UsWuMqonyc2tAM cnjRsT5Ti4vgUbR2wK7heHcBHAhMcFEPzwEdvPXBiT5Yj2ZFRw3JKKjFQ2X1s3Rz MV0q =M398 -END PGP PUBLIC KEY BLOCK- > On Jul 18, 2018, at 9:03 AM, Julian Hyde wrote: > > I am on Skype right now. Also at http://meet.hydromatic.net > <http://meet

Re: Virtual key signing party

2018-07-18 Thread Julian Hyde
Sergey, here is your signed key. pub 4096R/0xCE6BFE3E25872748 2018-07-17 uidSergey Nuyanzin sig 30xCE6BFE3E25872748 2018-07-17 Sergey Nuyanzin sig 0xDDB6E9812AD3FAE3 2018-07-18 Julian Hyde (CODE SIGNING KEY) sub 4096R/0xEF7BEE17A576AC66 2018

Re: [jira] [Created] (CALCITE-2420) Aggregate functions MIN/MAX does not work for Timestamp

2018-07-18 Thread Julian Hyde
owse/CALCITE-2420 >> Project: Calcite >> Issue Type: Bug >> Components: core >>Affects Versions: 1.17.0 >>Reporter: Piotr Bojko >>Assignee: Julian Hyde >> >> >> >> >> >> >> -- >> This message was sent by Atlassian JIRA >> (v7.6.3#76005) >> > > > -- > Piotr Bojko > http://about.me/ptr.bojko

Re: Virtual key signing party

2018-07-18 Thread Julian Hyde
18) > 19/7/2018: 3:00 PM to 4:00 AM (the next day (20/7/2018) > > Francis > > On 19/07/2018 2:58 AM, Julian Hyde wrote: >> Sergey, here is your signed key. >> >> pub 4096R/0xCE6BFE3E25872748 2018-07-17 >> uidSergey Nuyanzin &g

Re: [VOTE] Apache Hive 3.1.0 Release Candidate 0

2018-07-18 Thread Julian Hyde
Vineet, I think you meant to send this to dev@hive, not dev@calcite. (Can you send a [CANCEL], please!) > On Jul 18, 2018, at 5:25 PM, Vineet Garg wrote: > > Apache Hive 3.1.0 Release Candidate 0 is available here: > > http://people.apache.org/~vgarg/apache-hive-3.1.0-rc-0 > > Maven artifact

Re: User defined functions

2018-07-20 Thread Julian Hyde
Someone would need to modify the JDBC adapter so that if it connects to Oracle it would interrogate Oracle’s catalog to find the UDFs in Oracle. I don’t know if there’s a way to find UDFs generically (i.e. that relies only on JDBC, not knowing what flavor of database you are connecting to). > O

Re: Several pages at calcite.apache.org are unavailable

2018-07-20 Thread Julian Hyde
When I push the site I have to remember to do adds and deletes (e.g. javadoc for classes that have been moved or renamed). I execute ‘svn status’ and look for lines starting ‘?’. > On Jul 20, 2018, at 10:46 AM, Michael Mior wrote: > > Interesting. I pushed my update to the site and everything

Re: Calcite adapter for Cosmos DB ...

2018-07-20 Thread Julian Hyde
Rohit, You sent one message at midnight, and another at 8am. Please be a bit more patient. There is no 24x7 platinum support for this project, and please remember that the support engineers earn $0 per hour. Also, you should subscribe to the dev list. Your messages were sitting awaiting moder

Site branch merge

2018-07-20 Thread Julian Hyde
Michael, I saw you merged the site branch. I had been thinking of instead doing a rebase. I did a test rebase a few days ago and was pleased to see that it went smoothly — meaning that every commit in “site” had also been made to “master” — and it ended up pointing to the same commit as master.

Re: Site branch merge

2018-07-20 Thread Julian Hyde
<mailto:mm...@apache.org> > > Le ven. 20 juil. 2018 à 14:38, Julian Hyde <mailto:jh...@apache.org>> a écrit : > > > > Michael, > > > > I saw you merged the site branch. I had been thinking of instead doing a > > rebase. > > > > I did

[ANNOUNCE] New committer: Sergey Nuyanzin

2018-07-20 Thread Julian Hyde
The PMC has just invited Sergey Nuyanzin to be a committer, and he has accepted. Over the past few months, Sergey has made several contributions toe Avatica, to Calcite's built-in functions, and to the JDBC adapter. Sergey, welcome! Feel free to tell us a little about yourself. Julian

Re: [ANNOUNCE] Apache Calcite 1.17.0 released

2018-07-21 Thread Julian Hyde
Enrico, I agree. This release had so much good stuff that we were bound to miss some. For example Shuyi’s work on CREATE TYPE, and my work on the Babel SQL parser. One remedy is news articles (basically blog posts on the calcite site). You could write one paragraph, or ten paragraphs with a di

Re: [ANNOUNCE] Apache Calcite 1.17.0 released

2018-07-21 Thread Julian Hyde
n prepare breaking changes paragraph for ES > adapter. > >> On Sat, Jul 21, 2018 at 1:17 PM Enrico Olivelli wrote: >> >> Il sab 21 lug 2018, 18:25 Julian Hyde ha scritto: >> >>> Enrico, >>> >>> I agree. This release had so much good stuf

MATCH_RECOGNIZE

2018-07-23 Thread Julian Hyde
For quite a while we have had partial support for MATCH_RECOGNIZE. We support it in the parser and validator, but there is no runtime implementation. It’s a shame, because MATCH_RECOGNIZE is an incredibly powerful SQL feature for both traditional SQL (it’s in Oracle 12c) and for continuous query

Re: Site branch merge

2018-07-23 Thread Julian Hyde
). I'm happy with whatever direction > others want to take. > > -- > Michael Mior > mm...@apache.org > Le ven. 20 juil. 2018 à 18:32, Julian Hyde a écrit : >> >> Thanks for the tip, Andrew. I’ll give that a try. I may yet come to love >> merge commits! &

Re: Virtual key signing party

2018-07-23 Thread Julian Hyde
ne that has had their key signed? > > Francis > > On 19/07/2018 8:35 AM, Julian Hyde wrote: >> By the way, I’m not the only person who can do this. >> >>> On Jul 18, 2018, at 3:32 PM, Francis Chuang >>> wrote: >>> >>> Hey Julian, >&

Re: Virtual key signing party

2018-07-23 Thread Julian Hyde
(26/7/2018 9AM AEST) works great for me. Thank you > for organizing this! :) > > I have government issued ID and a printed copy of the output of `gpg > --fingerprint`. Is there anything else I should prepare before hand? > > Francis > >> On 24/07/2018 11:01 AM,

Re: Virtual key signing party

2018-07-24 Thread Julian Hyde
> > Thanks, > Jungtaek Lim (HeartSaVioR) > > 2018년 7월 24일 (화) 오후 4:52, Francis Chuang 님이 작성: > >> Thanks, Julian. >> >> Here's my key: >> pub 4096R/3A970AB7 2018-04-16 >> Key fingerprint = 6356 65E0 BE3F 7255 2910 CB74 BBE4 4E92 3A9

Re: Unparsing only a SqlNode sub-tree

2018-07-25 Thread Julian Hyde
In https://github.com/julianhyde/calcite/commit/35d7187803e59fe76ab56cf4ced91cf88f71d4af (not yet merged to master) I made it easier to convert a SqlNode to a SQL string. See class SimpleContext. > On Ju

Re: Virtual key signing party

2018-07-25 Thread Julian Hyde
27;s keys. >> >> Jungtaek, can you sign mine and Julian's keys and push it to the key >> server? >> >> Francis >> >> On 25/07/2018 4:16 AM, Julian Hyde wrote: >>> Jungtaek, Yes, please join us. Passport would be better, but we’ll make >

Re: Virtual key signing party

2018-07-26 Thread Julian Hyde
t; >> The Ubuntu server does not appear to update immediately, so I will check >> it again later today. >> >> I will now update my key in the KEYS file. >> >> Francis >> >> On 26/07/2018 9:58 AM, Julian Hyde wrote: >> >>> I have been

Re: SQL Query Set Analyzer

2018-07-26 Thread Julian Hyde
There are many possible analyzers, but Lattice Suggester is one that I am working on and is relatively mature. It looks at lots of queries and builds lattices (star schemas with measures) from those queries. It finds commonality by “growing” lattices - adding measures, adding derived expressions

Re: SQL Query Set Analyzer

2018-07-26 Thread Julian Hyde
gebra does not support a feature, but the algebra is still useful. > On Jul 26, 2018, at 11:25 AM, Julian Hyde wrote: > > There are many possible analyzers, but Lattice Suggester is one that I am > working on and is relatively mature. It looks at lots of queries and builds > la

<    2   3   4   5   6   7   8   9   10   11   >