From dev-return-13589-apmail-calcite-dev-archive=calcite.apache.org@calcite.apache.org Tue Oct 8 02:38:08 2019 Return-Path: X-Original-To: apmail-calcite-dev-archive@www.apache.org Delivered-To: apmail-calcite-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by minotaur.apache.org (Postfix) with SMTP id E5DF010EB5 for ; Tue, 8 Oct 2019 02:38:07 +0000 (UTC) Received: (qmail 38177 invoked by uid 500); 8 Oct 2019 02:38:06 -0000 Delivered-To: apmail-calcite-dev-archive@calcite.apache.org Received: (qmail 38060 invoked by uid 500); 8 Oct 2019 02:38:05 -0000 Mailing-List: contact dev-help@calcite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@calcite.apache.org Delivered-To: mailing list dev@calcite.apache.org Received: (qmail 37943 invoked by uid 99); 8 Oct 2019 02:38:04 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 08 Oct 2019 02:38:04 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 61563C23B4 for ; Tue, 8 Oct 2019 02:38:04 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.249 X-Spam-Level: ** X-Spam-Status: No, score=2.249 tagged_above=-999 required=6.31 tests=[HEADER_FROM_DIFFERENT_DOMAINS=0.249, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Received: from mx1-he-de.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id y7QpKGB1Sn4R for ; Tue, 8 Oct 2019 02:38:02 +0000 (UTC) Received-SPF: Pass (mailfrom) identity=mailfrom; client-ip=209.85.217.50; helo=mail-vs1-f50.google.com; envelope-from=asereda@gmail.com; receiver= Received: from mail-vs1-f50.google.com (mail-vs1-f50.google.com [209.85.217.50]) by mx1-he-de.apache.org (ASF Mail Server at mx1-he-de.apache.org) with ESMTPS id C639D7E1CD for ; Tue, 8 Oct 2019 02:38:01 +0000 (UTC) Received: by mail-vs1-f50.google.com with SMTP id d3so10359406vsr.1 for ; Mon, 07 Oct 2019 19:38:01 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=rzRzAT5Dccv3WPY5uXqdVllScZnhJxEtz0KD/+uWnKI=; b=QpkHffm6gMroi+Nor6DhWf5TBYOh3SzdlpYApEpcH+6YuQ3PPEPJr4frYapC8rnL71 oj/7+cyMGp3OQtRDtVhl/ql8SFKsoA9SLtcHSIaxva5JmYEXtClLADVviMYvl6Fe0pd6 cnBoa+QtYXkhSwWvUJWdN5UpPHrd/TJFqK4sBEwkJWZRWpVFJNRU3FktbNP5wmBY8gY8 fn0DVyIUnc+sGdYlg/rYxsI1j3pGXIs8+kDtLb6bxzmxuM10xIWHSqRxdHfHCcPYvj6f XbcUlIc+s3x5DGy9HHNgtVC8YcZhh3fyeP/pAitBP5Q7KHl5eUnIr1ac1Vt/KPOwLDDr ehpQ== X-Gm-Message-State: APjAAAWNA5FpALUa+VEqOL9Gt2SzgQiKmEjSPQeeOdxloK88xqpzg+P2 wWF+NWM9lLorof9ydoUtbGahEDHr+GC0JEEDKzVU4iQO X-Google-Smtp-Source: APXvYqx9pKtvsfASAfgUi9wxOIrKW4clS9d+2NtH5FPS9IrojxBjgQdIru7Es3Omu2pQdyAJNOj/Ud9ZJBm++IanVv0= X-Received: by 2002:a67:ee02:: with SMTP id f2mr16971786vsp.220.1570502274659; Mon, 07 Oct 2019 19:37:54 -0700 (PDT) MIME-Version: 1.0 References: <15447892-49dc-42fb-be58-883688bb32dd@Spark> In-Reply-To: <15447892-49dc-42fb-be58-883688bb32dd@Spark> From: Andrei Sereda Date: Mon, 7 Oct 2019 22:37:42 -0400 Message-ID: Subject: Re: Cannot connect to ES To: dev@calcite.apache.org Content-Type: multipart/alternative; boundary="000000000000333a1d05945d0ee8" --000000000000333a1d05945d0ee8 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 =E2=80=9Chttps://****.com=E2=80=9D can not be= resolved by the > java net api, do you validate it with java code on your machine ? > > Best, > Danny Chan > =E5=9C=A8 2019=E5=B9=B410=E6=9C=888=E6=97=A5 +0800 AM8:13=EF=BC=8CBadrul = Chowdhury >=EF=BC=8C=E5=86=99=E9=81=93=EF=BC=9A > > 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 t= o > > include those fields? The documentation does not mention any.. > > > > Thoughts? > > > > Exception: > > [..] > > > > *Caused by: java.net.UnknownHostException: https://****.com: nodename > nor > > servname provided, or not known* at > > java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method) > > at java.net.InetAddress$2.lookupAllHostAddr(InetAddress.java:929) > > at > java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1324) > > at java.net.InetAddress.getAllByName0(InetAddress.java:1277) > > at java.net.InetAddress.getAllByName(InetAddress.java:1193) > > at java.net.InetAddress.getAllByName(InetAddress.java:1127) > > at > > > org.apache.http.impl.conn.SystemDefaultDnsResolver.resolve(SystemDefaultD= nsResolver.java:45) > > [..] > > > > Model file: > > { > > "version": "1.0", > > "defaultSchema": "elasticsearch", > > "schemas": [ > > { > > "type": "custom", > > "name": "elasticsearch", > > "factory": > > "org.apache.calcite.adapter.elasticsearch.ElasticsearchSchemaFactory", > > "operand": { > > "coordinates": "{'https://****.com': 9200}" > > // "coordinates": "{'127.0.0.1': 9200}" > > } > > } > > ] > > } > > -- > > > > Cheers, > > Badrul > --000000000000333a1d05945d0ee8--