Re: Cannot connect to ES

2019-10-07 Thread Andrei Sereda
HTTPS support was added recently (see CALCITE-3335 ). To be released in 1.22 Currently ES configuration expects hostname without schema prefix (eg. https://). On Mon, Oct 7, 2019 at 9:52 PM Danny Chan wrote: > It seems that the host name “

Re: how to return dates in java/enumerable convention?

2019-10-07 Thread Danny Chan
>In most cases the internal representation of date objects in the Enumerable >convention are longs [1]. For the reference you give, date object is Integer internal instead of long. Best, Danny Chan 在 2019年10月6日 +0800 PM2:57,dev@calcite.apache.org,写道: > > In most cases the internal representation

Re: Ignite community is building Calcite-based prototype

2019-10-07 Thread Danny Chan
Denis Welcome to ask questions on the dev list, log JIRA cases if you find them, i will try my best to help(if I have time). Best, Danny Chan 在 2019年10月1日 +0800 AM8:37,dev@calcite.apache.org,写道: > > Ask questions on the dev list, log JIRA cases if you find them, and we’ll do > our best to help.

Re: Cannot connect to ES

2019-10-07 Thread Danny Chan
It seems that the host name “https://.com” can not be resolved by the java net api, do you validate it with java code on your machine ? Best, Danny Chan 在 2019年10月8日 +0800 AM8:13,Badrul Chowdhury ,写道: > Hi, > > I am trying to use the Calcite-ES adapter to connect to a remote ES > instance (lo

Re: Community and News pages "not secure", according to Chrome

2019-10-07 Thread Danny Chan
I don’t encounter this on my laptop, oops. Best, Danny Chan 在 2019年10月8日 +0800 AM3:54,Andrew Pilloud ,写道: > You can debug this through the developer tools console. In the Chrome menu > bar, More tools -> Developer tools. > > The error message is "Mixed Content: The page at '' was loaded over > HTT

Re: Re: [EXT] SqlRexConvertlet that Replicates "IN" Conversion Logic

2019-10-07 Thread Julian Hyde
A SqlCall to $HARD_IN will (by SqlToRelConverter) become a RexCall to $HARD_IN, and then (by RelToSqlConverter) become a SqlCall to $HARD_IN. $HARD_IN(x, v1, v2) would become (by SqlWriter) the SQL "x IN (v1, v2)". At any point in this lifecycle, you could intercept and and simplify. On Mon, Oct

Cannot connect to ES

2019-10-07 Thread Badrul Chowdhury
Hi, I am trying to use the Calcite-ES adapter to connect to a remote ES instance (logs below). I can connect to the endpoint, but I have to use credentials (login/pass). Is there and option in the model definition to include those fields? The documentation does not mention any.. Thoughts? Except

Re: Re: [EXT] SqlRexConvertlet that Replicates "IN" Conversion Logic

2019-10-07 Thread Haisheng Yuan
Will the filter condition with “$HARD_IN” internal function be able to pushed down and be recognized by the source SQL system, like Peter mentioned? If not, we have to translate the internal function back to IN during Rel2Sql phase. Otherwise, the data read from the source table can be much larg

[REPORT] Calcite - October 2019

2019-10-07 Thread Francis Chuang
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. ## Issue

Re: [DISCUSS] Draft board report for October 2019

2019-10-07 Thread Francis Chuang
I think it might be a bit late now, as I've submitted the report to board@ and whimsy. :( I'll get the "state of the project" discussion started very soon. Francis On 8/10/2019 7:13 am, Julian Hyde wrote: Thanks for another excellent report. Perhaps add the upcoming talks at ApacheCon Europe

Re: [EXT] SqlRexConvertlet that Replicates "IN" Conversion Logic

2019-10-07 Thread Julian Hyde
In https://issues.apache.org/jira/browse/CALCITE-2792?focusedCommentId=16946209&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-16946209

Re: [DISCUSS] Draft board report for October 2019

2019-10-07 Thread Julian Hyde
Thanks for another excellent report. Perhaps add the upcoming talks at ApacheCon Europe. I would strike out > We expect further growth in these numbers as Apache Ignite works to > integrate Calcite into their project, resulting in cross-pollination between > the 2 projects. We of course *hope*

Re: Community and News pages "not secure", according to Chrome

2019-10-07 Thread Andrew Pilloud
You can debug this through the developer tools console. In the Chrome menu bar, More tools -> Developer tools. The error message is "Mixed Content: The page at '' was loaded over HTTPS, but requested an insecure image ''. This content should also be served over HTTPS." It appears the github avatar

Re: ApacheCon Europe 2019 talks which are relevant to Apache Calcite

2019-10-07 Thread Julian Hyde
I feel remiss in filling out https://calcite.apache.org/community/#upcoming-talks . I’d be grateful if someone would remove ApacheCon NA and add ApacheCon Europe and log a PR. > On Oct 7, 2019, at 12:15 PM, Chris Baynes wrote: > > Hi! > >

Community and News pages "not secure", according to Chrome

2019-10-07 Thread Julian Hyde
When I open https://calcite.apache.org/news/ or https://calcite.apache.org/community/ pages in Chrome, I get an (i) to the left of the URL bar with the message “Your connection to this site is not fully secure” and a war

Re: ApacheCon Europe 2019 talks which are relevant to Apache Calcite

2019-10-07 Thread Chris Baynes
Hi! I'll be giving a talk on "Fast federated SQL with Apache Calcite". Would be great to meet up with any other Calciters attending! See you there Chris On Mon, Oct 7, 2019 at 4:01 PM Julian Feinauer wrote: > Hi all, > > are there any Calcite related talks in Berlin or any Calciters attending

[jira] [Created] (CALCITE-3390) ITEM expression does not get pushed to the right input of left-outer-join

2019-10-07 Thread Aman Sinha (Jira)
Aman Sinha created CALCITE-3390: --- Summary: ITEM expression does not get pushed to the right input of left-outer-join Key: CALCITE-3390 URL: https://issues.apache.org/jira/browse/CALCITE-3390 Project: Ca

Re: [DISCUSS] Draft board report for October 2019

2019-10-07 Thread Julian Feinauer
Hi Francis, no, it looks excellent, +1. Julian Am 06.10.19, 01:20 schrieb "Francis Chuang" : If there are no objections, I plan to submit the report tomorrow (7 October 2019) as the deadline is on the 9th. On 3/10/2019 4:41 pm, Stamatis Zampetakis wrote: > Looks great, no

Re: ApacheCon Europe 2019 talks which are relevant to Apache Calcite

2019-10-07 Thread Julian Feinauer
Hi all, are there any Calcite related talks in Berlin or any Calciters attending? I will be there. JulianF Am 04.10.19, 19:09 schrieb "my...@apache.org" : Dear Apache Calcite committers, In a little over 2 weeks time, ApacheCon Europe is taking place in Berlin. Join us from O