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 6B69811968 for ; Wed, 25 Jun 2014 21:28:20 +0000 (UTC) Received: (qmail 87400 invoked by uid 500); 25 Jun 2014 21:28:18 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 87338 invoked by uid 500); 25 Jun 2014 21:28:18 -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 87327 invoked by uid 99); 25 Jun 2014 21:28:18 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Jun 2014 21:28:18 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,HTML_OBFUSCATE_05_10,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.220.169 as permitted sender) Received: from [209.85.220.169] (HELO mail-vc0-f169.google.com) (209.85.220.169) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Jun 2014 21:28:14 +0000 Received: by mail-vc0-f169.google.com with SMTP id la4so2630828vcb.0 for ; Wed, 25 Jun 2014 14:27:53 -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:from:date :message-id:subject:to:content-type; bh=OIffmM2aGm69HsZ9R3wMfqlHOzz2hqtFbt8A5GAGICU=; b=YWCFwnBRN8o5Erlfgz+xdVyI3yUjx++iYmJPbf99sUWzf/URF3bFDk6PwY02ZyiHFO 6RUbOzc5oQ41+8diGlat2ADDQ00WGlRqMAB5xUwC+AKy3N2fdn88UjB7BlEgxh0+hfrq JWV6mBMarUQQ0JAV9ITrRIBbWOTt1+HLhbpJoGA109Bu58e/xu6liH4k9d5bJEzmpGh4 JH6cfRgcUfra1wK9lNi6cuQvIYN9gPPud7UU/vuGkS/8A1VDe5iD22gK8/M1Zo0spKgx UpmlruBXiKO/GkVtV0ZKLuLsodd3sF1UoFb+JPAYrm2hRaGfQHnDrs+045mcN2d/IgDJ S5VA== X-Gm-Message-State: ALoCoQmC1QBK7ErIvozSlTHB0E37Hk2PuDEil9RuIXLkbYv2YCDKw/xipsZ6N+RTI8qgEXeU65Hs X-Received: by 10.220.69.72 with SMTP id y8mr9240342vci.21.1403731673267; Wed, 25 Jun 2014 14:27:53 -0700 (PDT) MIME-Version: 1.0 Received: by 10.221.57.72 with HTTP; Wed, 25 Jun 2014 14:27:33 -0700 (PDT) In-Reply-To: References: From: Matouk IFTISSEN Date: Wed, 25 Jun 2014 23:27:33 +0200 Message-ID: Subject: Re: hive date format To: user@hive.apache.org Content-Type: multipart/alternative; boundary=047d7b3a9250bed55404fcafbf1d X-Virus-Checked: Checked by ClamAV on apache.org --047d7b3a9250bed55404fcafbf1d Content-Type: text/plain; charset=UTF-8 use ; unix_timestamp(field_date,'DD-MMM-YYYY') 2014-06-25 23:20 GMT+02:00 rpriaadaa@gmail.com : > Hi, > > Please can someone tell me how to change the date format in hive. > I need it in the format '25-JUN-2014' > > -- > Regards, > riad > -- *Matouk IFTISSEN | Consultant BI & Big Data [image: http://www.ysance.com] * 24 rue du sentier - 75002 Paris - www.ysance.com Fax : +33 1 73 72 97 26 *Ysance sur* :*Twitter* * | Facebook | Google+ | LinkedIn | Newsletter * *Nos autres sites* : *ys4you* * | labdecisionnel | decrypt * --047d7b3a9250bed55404fcafbf1d Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
use ;=C2=A0unix_timestamp(fie= ld_date,'DD-MMM-YYYY')



2014-06-25 23:20 GMT+02:00 rpriaadaa@gmail.com <rpriaadaa@gmail.com>:
Hi,

Plea= se can someone tell me how to change the date format in hive.
I n= eed it in the format =C2=A0'25-JUN-2014'

--
Regards,
riad



--
Matouk IFTISSE= N | Consultant BI & Big Data
3D"http://www.ysance.com"=C2=A0
24 rue du sentier - 7= 5002 Paris -=C2=A0www.ysance.com
Fax :=C2=A0+33= 1 73 72 97 26=C2= =A0
Ysance sur= =C2=A0:Twitter=C2=A0|=C2= =A0Face= book=C2=A0|=C2=A0Google+=C2=A0|=C2=A0LinkedIn=C2=A0|=C2=A0<= a href=3D"http://www.ysance.com/nous-contacter.html" style=3D"color:rgb(173= ,40,50);text-decoration:none;border-bottom-width:1px;border-bottom-color:rg= b(51,51,51);border-bottom-style:dotted" target=3D"_blank">Newsletter
Nos autres sites=C2=A0:=C2=A0ys4= you=C2= =A0|=C2=A0labdecisionnel=C2=A0|=C2=A0decrypt
--047d7b3a9250bed55404fcafbf1d--