From user-return-3162-apmail-sqoop-user-archive=sqoop.apache.org@sqoop.apache.org Fri Apr 17 15:28:01 2015 Return-Path: X-Original-To: apmail-sqoop-user-archive@www.apache.org Delivered-To: apmail-sqoop-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 3751D17BB4 for ; Fri, 17 Apr 2015 15:28:01 +0000 (UTC) Received: (qmail 3740 invoked by uid 500); 17 Apr 2015 15:28:01 -0000 Delivered-To: apmail-sqoop-user-archive@sqoop.apache.org Received: (qmail 3711 invoked by uid 500); 17 Apr 2015 15:28:00 -0000 Mailing-List: contact user-help@sqoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@sqoop.apache.org Delivered-To: mailing list user@sqoop.apache.org Received: (qmail 3701 invoked by uid 99); 17 Apr 2015 15:28:00 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 17 Apr 2015 15:28:00 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of gshapira@cloudera.com designates 209.85.212.180 as permitted sender) Received: from [209.85.212.180] (HELO mail-wi0-f180.google.com) (209.85.212.180) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 17 Apr 2015 15:27:55 +0000 Received: by wizk4 with SMTP id k4so26049495wiz.1 for ; Fri, 17 Apr 2015 08:27:34 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=0QRtjS7100TdZjqh9+2KITzfaNKatfi68r1DVYPs1Vw=; b=YGeIxXN9TKic/sGl83SfnrSZ//PJkWIVww5RSgVPv/T3wOn96WrVZP7iecmtFN9sNr 4lxF2IAlTlXS3AEgq6uiijMFHi3wYdL8rocONfjvsqYIehcnyclKvT2CrKQS4DI1LkwO mVnaVCQYllXL6/3b9CTQuIu0jUfkLTW/5r9snkFIgnao5qbsVqqrXkBs17LpYEScF/lg VcpBSjJK90wKB9oz229HB8eWpesyZjvI5z/AxpT34HkeHgeXbB2JI20E9+D5UPLzIMfB 0TWozWPHusEQM1eBMyjggnKqxxUnxM5vxBCuWRvDQiu+L9WEtkC6pdk4tCPNHEC+qX25 THMQ== X-Gm-Message-State: ALoCoQnpk4ZOChi7Pg08bfTKPuBcfu/hw6GTLWkdIFVGOPCf2OYtFfSYZhiE37lTsF3g0Nrp3/ql MIME-Version: 1.0 X-Received: by 10.195.11.73 with SMTP id eg9mr6979479wjd.62.1429284454728; Fri, 17 Apr 2015 08:27:34 -0700 (PDT) Received: by 10.27.139.212 with HTTP; Fri, 17 Apr 2015 08:27:34 -0700 (PDT) In-Reply-To: References: Date: Fri, 17 Apr 2015 08:27:34 -0700 Message-ID: Subject: Re: External IP address From: Gwen Shapira To: "user@sqoop.apache.org" Content-Type: text/plain; charset=UTF-8 X-Virus-Checked: Checked by ClamAV on apache.org As long as all data nodes can reach your database, Sqoop will work. Difference in performance depends on: * Bandwidth for the connection on each IP * Whether there are other applications sharing the bandwidth. Chat with your network admin to find out. Gwen On Thu, Apr 16, 2015 at 11:52 PM, Jagat Singh wrote: > Hello everyone, > > I was under impression sqoop needs data nodes to have external IP address > for data transfer. > > We are using Sqoop 1.4.5 > > Today I tried the job in cluster which has all internal ip for datanodes and > it worked. > > So I have question to clarify if I am correct about working of sqoop. > > For each map there is direct connection between datanode and the database. > > Does it hurt anyway the performance to have external or internal IP for > datanodes. > > Thanks,