Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-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 0D3AE10582 for ; Tue, 4 Mar 2014 07:54:05 +0000 (UTC) Received: (qmail 53104 invoked by uid 500); 4 Mar 2014 07:54:04 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 52146 invoked by uid 500); 4 Mar 2014 07:54:02 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 52118 invoked by uid 99); 4 Mar 2014 07:53:59 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Mar 2014 07:53:59 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW X-Spam-Check-By: apache.org Received-SPF: unknown (nike.apache.org: error in processing during lookup of jone.lura@ecc.no) Received: from [209.85.217.169] (HELO mail-lb0-f169.google.com) (209.85.217.169) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Mar 2014 07:53:52 +0000 Received: by mail-lb0-f169.google.com with SMTP id l4so4602034lbv.28 for ; Mon, 03 Mar 2014 23:53:31 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:content-type:mime-version:subject:from :in-reply-to:date:content-transfer-encoding:message-id:references:to; bh=vkCvLbbwxCNlBHA3E7Oi0fnFV/c8Nd7/l/2E+KT/YRQ=; b=JkHvcTg2hhR24FJ27cw+r7iaRVmZ3SNPhyzzE2DWLNSUVzTZd5zHj7+kcFaUOv6A1k pU0MKxq4oTi8mxdf3wKfhDFNYLbyg+JILz6fQnF/mAaTxvcH8wzsOQ33IslWldNr/+fW o29rueFIqaaOIeCyxIqjKy+z7Qs06r2eJS5cy65Bq/xRdi6BgSsah5MdDe1v5KByxwNL VyCW3e8NJFPhFc1KB1/wAPTO4j4+UUU6ikDIFe9YJEw27F5nrraFtEhKua/3zmyuitcf z63sHzlsdO+ZU5xPsguELbPIU4U/d9IjtuXNC4L9g6reqKnp6mJ+IMry2aWkyOAtdTJN B7EA== X-Gm-Message-State: ALoCoQmnlJUN7c9MXNPBrAz21Liq14OX2GaDjkTLsGrg1D8kEzjjNK955FsTmz3VWFVxylCBBrZm X-Received: by 10.112.57.80 with SMTP id g16mr25110917lbq.26.1393919611547; Mon, 03 Mar 2014 23:53:31 -0800 (PST) Received: from [10.20.30.182] (rec.ecc.as. [213.236.218.162]) by mx.google.com with ESMTPSA id o10sm33978157laj.2.2014.03.03.23.53.28 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Mon, 03 Mar 2014 23:53:29 -0800 (PST) Content-Type: text/plain; charset=iso-8859-1 Mime-Version: 1.0 (Mac OS X Mail 7.0 \(1822\)) Subject: Re: hive load data from remote system From: Jone Lura In-Reply-To: Date: Tue, 4 Mar 2014 08:53:28 +0100 Content-Transfer-Encoding: quoted-printable Message-Id: References: To: user@hive.apache.org X-Mailer: Apple Mail (2.1822) X-Virus-Checked: Checked by ClamAV on apache.org Hi Vishnu, I have a similar scenario, and I came over the webhdfs project that is a = REST service interface to the Hadoop File system. http://hadoop.apache.org/docs/r1.2.1/webhdfs.html Im not sure if this makes it simpler than using FTP, but it is an = alternative which may be considered. Best regards, Jone On 04 Mar 2014, at 06:03, Vishnu Viswanath = wrote: > Hi All, >=20 > I have a scenario where i have to load data into a hive table from a = csv file. > But the csv file is in a remote system.=20 >=20 > I am planning to use ftp to transfer the file to the system where hive = is running and load the data into the table. Is there any better way of = doing this? >=20 > Regards=20