Return-Path: 
 <user-return-13424-apmail-hive-user-archive=hive.apache.org@hive.apache.org>
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 86CA2CD69
	for <apmail-hive-user-archive@www.apache.org>;
 Thu,  4 Jul 2013 09:43:12 +0000 (UTC)
Received: (qmail 46453 invoked by uid 500); 4 Jul 2013 09:43:10 -0000
Delivered-To: apmail-hive-user-archive@hive.apache.org
Received: (qmail 46295 invoked by uid 500); 4 Jul 2013 09:43:09 -0000
Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@hive.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@hive.apache.org>
List-Post: <mailto:user@hive.apache.org>
List-Id: <user.hive.apache.org>
Reply-To: user@hive.apache.org
Delivered-To: mailing list user@hive.apache.org
Received: (qmail 46286 invoked by uid 99); 4 Jul 2013 09:43:08 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Jul 2013 09:43:08 +0000
X-ASF-Spam-Status: No, hits=1.5 required=5.0
	tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of matouk.iftissen@ysance.com
 designates 209.85.212.53 as permitted sender)
Received: from [209.85.212.53] (HELO mail-vb0-f53.google.com) (209.85.212.53)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Jul 2013 09:43:03 +0000
Received: by mail-vb0-f53.google.com with SMTP id p12so825114vbe.12
        for <user@hive.apache.org>; Thu, 04 Jul 2013 02:42:42 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=google.com; s=20120113;
        h=mime-version:date:message-id:subject:from:to:content-type
         :x-gm-message-state;
        bh=Kdqm1YdmPX4gydX2p7vFwZrZWoLgoLYvNnbTDw0e9Cc=;
        b=PvUnNRbLKpXvOPOcLD0GyH6xzzSvQsD4nW+phoaSHZhZUQyf5Ei+ncwmVin7WV9ptn
         +vNqhUWk1l+996mR29PnjzBUYofESrj7To+CuUnwwAjGtVY6WtMwa+MIa3dk58QKeHjq
         ugMsZoL4CAslVbAwHygPyByyCITSCPR6Cl/2IKWoEqKU7fDgHudK7jQC+kUxV4zTdz/W
         PL1z5DOWrzhz6s0F2PIS7wF8NuWLT0DOIhAtWltNbD+dU9fwushXDmjPiKDAH+JzS5bz
         v3NAaefZAf6fjuWgkaVwoSEgFA1+dMukyrukbLdrJuPOq0sOuZ/9MFhwCbR3ByspiD8D
         elvA==
MIME-Version: 1.0
X-Received: by 10.58.155.37 with SMTP id vt5mr2398327veb.41.1372930961960;
 Thu, 04 Jul 2013 02:42:41 -0700 (PDT)
Received: by 10.220.192.138 with HTTP; Thu, 4 Jul 2013 02:42:41 -0700 (PDT)
Date: Thu, 4 Jul 2013 11:42:41 +0200
Message-ID: 
 <CA+pqXLZcQJzNDAzJNCPyNA9Pwmfos=KnUJPwR+2qrY_4Mq5nKQ@mail.gmail.com>
Subject: How Can I store the Hive query result in one file ?
From: Matouk IFTISSEN <matouk.iftissen@ysance.com>
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=047d7b67239a4a090304e0ac6671
X-Gm-Message-State: 
 ALoCoQl/IpRjXGPPQv8xvByStdMf0EOybk2akQZjAN7UVM4SZwmzJpnGe2tp2tuYqzHCFY7nXFNP
X-Virus-Checked: Checked by ClamAV on apache.org

--047d7b67239a4a090304e0ac6671
Content-Type: text/plain; charset=ISO-8859-1

Hello Hive users,
Is there a manner to store the Hive  query result (SELECT *.....) in a
specfique and alone file (given the file name) like (INSERT OVERWRITE LOCAL
DIRECTORY '/directory_path_name/')?
Thanks for your answers

--047d7b67239a4a090304e0ac6671
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div>Hello Hive users,<br></div>Is there a manner to =
store the Hive=A0 query result (SELECT *.....) in a specfique  and alone fi=
le (given the file name) like (INSERT OVERWRITE LOCAL DIRECTORY &#39;/direc=
tory_path_name/&#39;)?<br>
</div>Thanks for your answers<br><div><br></div></div>

--047d7b67239a4a090304e0ac6671--