From dev-return-6039-archive-asf-public=cust-asf.ponee.io@airflow.incubator.apache.org Tue Aug 7 19:04:36 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 872A5180657 for ; Tue, 7 Aug 2018 19:04:35 +0200 (CEST) Received: (qmail 85222 invoked by uid 500); 7 Aug 2018 17:04:29 -0000 Mailing-List: contact dev-help@airflow.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@airflow.incubator.apache.org Delivered-To: mailing list dev@airflow.incubator.apache.org Received: (qmail 85210 invoked by uid 99); 7 Aug 2018 17:04:28 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Aug 2018 17:04:28 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 85FDA1A2C43 for ; Tue, 7 Aug 2018 17:04:28 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.97 X-Spam-Level: * X-Spam-Status: No, score=1.97 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, T_DKIMWL_WL_MED=-0.01] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=infoworks-io.20150623.gappssmtp.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id Qj0tk10W7Ocw for ; Tue, 7 Aug 2018 17:04:27 +0000 (UTC) Received: from mail-qt0-f175.google.com (mail-qt0-f175.google.com [209.85.216.175]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 4704C5F3EC for ; Tue, 7 Aug 2018 17:04:27 +0000 (UTC) Received: by mail-qt0-f175.google.com with SMTP id f18-v6so18624489qtp.10 for ; Tue, 07 Aug 2018 10:04:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=infoworks-io.20150623.gappssmtp.com; s=20150623; h=from:mime-version:subject:message-id:date:to; bh=iRqLstlQnP/5su2BAGcU1gayEQDgb3f73fx0LJYxWI4=; b=cdM5pXOodiw24sysdtTGGGycnH1FLA7LC5/654NJLy5YQcFUOh7ya0QsZ5uiOyf3gO EzQjUbTJUrestY+5SuJMnc0/4+Grr/lVLU28aD/xNrHGTeFjKVdhrPjG+SoX52lub28N mDeGa8RQqSeLxQ7W6AcUArf7/pSfiqau1ACzyJPEzMzZe37M6ei8N6kp+nTLK+URJfBy ugpJDLaafAKW4ll/fWagulgog/j5wCkyye/NMeVk+shNm0NDVdVwlXfSM0qFWBcP3APO y2d/a5P9bPQI0fag24NH8TS1P2m9G6TrmGVmJP59M4sBe0KwlMnoOgRff/rs44DiF/91 F7Sw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:mime-version:subject:message-id:date:to; bh=iRqLstlQnP/5su2BAGcU1gayEQDgb3f73fx0LJYxWI4=; b=cvoj/tmgX+H3E5KwICC7bthMZQUyUBw+lXSdxYCw8L3h2FDFksSmydXET1hNf2i2O7 Lwfk5rZ1NBkS1kZKlJ7kAZ6UXzj9G4/lBendJhqhNlW/61/fCL74fpiIzJaGNGcN9Lu2 JxAoywve5NKlYv7FM8bP67yJhOBTzWzIGPTND/tmCeenBlmlYZxK3ac/Q7KJg19o8Puw /bLod9RDelA/dmki34riFd/ncywYOdjlQRmUxrjIMf7alPdiQbXol80pCVlLpkc5xe+E bfQVteBGuDs3DZhc4oRhJSdkA5He3PFtFmpM2Fu+SHRtHE/+ddRBi9SnrMROWZU3ZVaB eTDQ== X-Gm-Message-State: AOUpUlH5I9+bCt1sWq1/QSOqNC4FrUOnot8hFIIf9ZBjhlviAKjmLR/K KDCIkkJEBfFhweuO5sr8svRrVze6kT27Ow== X-Google-Smtp-Source: AAOMgpfB1N4o8pY58IXi4fNTpNWvaIX9vSZj4DC9Z8/4IDEKb3BuauxldNxNvnhAzRJJa/AYgW13kg== X-Received: by 2002:a0c:c3c6:: with SMTP id p6-v6mr17694175qvi.146.1533661466524; Tue, 07 Aug 2018 10:04:26 -0700 (PDT) Received: from [10.0.1.212] ([64.20.52.219]) by smtp.gmail.com with ESMTPSA id i68-v6sm1125839qkf.87.2018.08.07.10.04.24 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 07 Aug 2018 10:04:25 -0700 (PDT) From: Abhishek Sinha Content-Type: multipart/alternative; boundary="Apple-Mail=_74884B0D-EFA4-4033-8504-3B4141419157" Mime-Version: 1.0 (Mac OS X Mail 11.5 \(3445.9.1\)) Subject: Using environment connection URL in operators Message-Id: <63E44B8D-ADFC-4CAA-990D-38E8E6ECC490@infoworks.io> Date: Tue, 7 Aug 2018 22:34:21 +0530 To: dev@airflow.incubator.apache.org X-Mailer: Apple Mail (2.3445.9.1) --Apple-Mail=_74884B0D-EFA4-4033-8504-3B4141419157 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii I am trying to use: MySqlToHiveTransfer Operator. =46rom the base_hook code, I see that there is a way to pass connection = URL via environment variables. The variable needs to be pre-fixed with: = AIRFLOW_CONN_ followed by the connection ID. I have tried exporting this variable but the behaviour seems to be = random. In some instances of the DAG Run, the variable is present in = os.environ but in some of the runs it is not. Is this an issue? We are on version 1.8.2 with Celery Executor. Regards, Abhishek --Apple-Mail=_74884B0D-EFA4-4033-8504-3B4141419157--