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 8FF3F11C77 for ; Mon, 7 Jul 2014 20:01:45 +0000 (UTC) Received: (qmail 1951 invoked by uid 500); 7 Jul 2014 20:01:43 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 1882 invoked by uid 500); 7 Jul 2014 20:01:43 -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 1871 invoked by uid 99); 7 Jul 2014 20:01:43 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 Jul 2014 20:01:43 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of Bhuvana.Bellala@cormac-corp.com designates 207.46.163.241 as permitted sender) Received: from [207.46.163.241] (HELO na01-by2-obe.outbound.protection.outlook.com) (207.46.163.241) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 Jul 2014 20:01:39 +0000 Received: from SN2PR0701MB816.namprd07.prod.outlook.com (25.160.16.15) by SN2PR0701MB816.namprd07.prod.outlook.com (25.160.16.15) with Microsoft SMTP Server (TLS) id 15.0.980.8; Mon, 7 Jul 2014 20:01:11 +0000 Received: from SN2PR0701MB816.namprd07.prod.outlook.com ([25.160.16.15]) by SN2PR0701MB816.namprd07.prod.outlook.com ([25.160.16.15]) with mapi id 15.00.0980.000; Mon, 7 Jul 2014 20:01:11 +0000 From: Bhuvana Bellala To: "user@hive.apache.org" Subject: Querying a time stamp Thread-Topic: Querying a time stamp Thread-Index: Ac+aHadGduKJYzUKSnmRbJhK1baWbw== Date: Mon, 7 Jul 2014 20:01:09 +0000 Message-ID: <25d4772d1a2d43798325f07de5162cde@SN2PR0701MB816.namprd07.prod.outlook.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: yes X-MS-TNEF-Correlator: x-originating-ip: [74.106.235.62] x-microsoft-antispam: BCL:0;PCL:0;RULEID: x-forefront-prvs: 02652BD10A x-forefront-antispam-report: SFV:NSPM;SFS:(189002)(199002)(377424004)(40124003)(50986999)(99286002)(99936001)(4396001)(95666004)(2656002)(92566001)(19300405004)(86362001)(229853001)(19609705001)(33646001)(107046002)(105586002)(2351001)(110136001)(20776003)(107886001)(19580405001)(83322001)(64706001)(19580395003)(77982001)(106356001)(15202345003)(85852003)(54356999)(83072002)(79102001)(16236675004)(17760045003)(46102001)(74662001)(31966008)(18206015023)(81342001)(81542001)(87936001)(85306003)(76576001)(15975445006)(66066001)(77096002)(99396002)(74316001)(19625215002)(21056001)(101416001)(108616002)(24736002);DIR:OUT;SFP:;SCL:1;SRVR:SN2PR0701MB816;H:SN2PR0701MB816.namprd07.prod.outlook.com;FPR:;MLV:sfv;PTR:InfoNoRecords;MX:1;LANG:en; Content-Type: multipart/related; boundary="_004_25d4772d1a2d43798325f07de5162cdeSN2PR0701MB816namprd07p_"; type="multipart/alternative" MIME-Version: 1.0 X-OriginatorOrg: cormac-corp.com X-Virus-Checked: Checked by ClamAV on apache.org --_004_25d4772d1a2d43798325f07de5162cdeSN2PR0701MB816namprd07p_ Content-Type: multipart/alternative; boundary="_000_25d4772d1a2d43798325f07de5162cdeSN2PR0701MB816namprd07p_" --_000_25d4772d1a2d43798325f07de5162cdeSN2PR0701MB816namprd07p_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, I have a column called dateofbirth in my hive table and the date of birth i= s stored as a BigInt (Unix_timestamp). Now I want to query this table using= this query SELECT * FROM mytable WHERE dataofbirth=3Dunix_timestamp('2011-10-08'); However, this query is returning 0 results but I know there are 11 entries = whose date of birth is 2011-10-08. Is there any way I can query hive for th= is information? [Cormac_logo] Bhuvana Bellala| Intern ________________________________ 13921 Park Center Road, Suite 180, Herndon VA 20171| CMMI Maturity Level 3 Rated| GSA Schedule 70| SBA SDB, 8(a)| www.cormac-corp.com This email and any files transmitted with it are confidential and intended = solely for the use of the individual or entity to whom they are addressed. = If you are not the named addressee you should not disseminate, distribute = or copy this e-mail. Please notify the sender immediately by e-mail if you = have received this e-mail by mistake and delete this e-mail from your syste= m. If you are not the intended recipient you are notified that disclosing, = copying, distributing or taking any action in reliance on the contents of t= his information is strictly prohibited. --_000_25d4772d1a2d43798325f07de5162cdeSN2PR0701MB816namprd07p_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

 

I have a column called dateofbirth in my hive table = and the date of birth is stored as a BigInt (Unix_timestamp). Now I want to= query this table using this query

 

SELECT = * FROM mytable WHERE dataofbirth=3Dunix_timestamp(‘2011-10-08’)= ;

 

However, this query is returning 0 results but I kno= w there are 11 entries whose date of birth is 2011-10-08. Is there any way = I can query hive for this information?

 

3D"Cormac_logo"

 

Bhuvana Bell= ala| Intern

CMMI Maturity Level 3 Rated| GSA Schedule 70| SBA SDB, 8(a)= |

www.co= rmac-corp.com

 

= This email and any files transmitted with it are confidential and intended = solely for the use of the individual or entity to whom they are addressed.  If you are not the named addressee you should not dis= seminate, distribute or copy this e-mail. Please notify the sender immediat= ely by e-mail if you have received this e-mail by mistake and delete this e= -mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distribu= ting or taking any action in reliance on the contents of this information i= s strictly prohibited.

 

 

--_000_25d4772d1a2d43798325f07de5162cdeSN2PR0701MB816namprd07p_-- --_004_25d4772d1a2d43798325f07de5162cdeSN2PR0701MB816namprd07p_ Content-Type: image/jpeg; name="image001.jpg" Content-Description: image001.jpg Content-Disposition: inline; filename="image001.jpg"; size=1777; creation-date="Mon, 07 Jul 2014 20:01:08 GMT"; modification-date="Mon, 07 Jul 2014 20:01:08 GMT" Content-ID: Content-Transfer-Encoding: base64 /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAoHBwkHBgoJCAkLCwoMDxkQDw4ODx4WFxIZJCAmJSMg IyIoLTkwKCo2KyIjMkQyNjs9QEBAJjBGS0U+Sjk/QD3/2wBDAQsLCw8NDx0QEB09KSMpPT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT3/wAARCAA1AFkDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2Wloo oAKazBRk8CnVR1eb7PYmbnETLI3+6GBP6ZpSdlccVzNItSozphZGQ+oAP86ybrUL3TJkF35TwSMF SbG1cnorf3SegPI+lbIIIBByD3FRXVrFe2sttcIHhlUo6nuDVK3UiSb2G2l5HeIxUMrodskbcMh9 DViuS0i5lhWzmmctNDcPpl0x/wCWmCQjH36f99Gus3AkjPIpO6bi+goS5kLRRRQWFFFFABRRRQAV DcoHiIKhgOqn+Idx+VTUlTKPMrDTs7mBBftoCrb3299P6W92AWCL2ST0x0B6VsRX9pNF5kVzC8eM 7lkBFR3LRWwZzMkYP3lbkN+FctqOnWuryCOHSoY4ScyPHFtlmH91Rj5Ae7Njjp61nBzjpJaf1t/k aznTkrvfy/r+uxXsb+O8s1Frtnub3U3vBErfdjDcFj24UfnXbWkTxw5lbfK53O3bPt7VUsNKht2W cwRxShNqxx/djHoP6mtGrTlOTm1a5ilGKtEWiiirAKKKKAM/WNZttEtFnudzF2EccaDLSOegAqjP r2oWkUU9xoziB3VWZJwzJk4yRj37VneNlNtqOhanMCbO1uCJz2TcAAx9uOvvXRXeq2VpaLcTTxmJ yAhU7t5J4AHetOVJJ2vci921cov4hae+uLTSrNryS2O2Z94RFb+7nnJpkHihZ4L1fsUsd/ZLumtJ GAbb1yp6EY6GszwO6WE2qaVdMEvY7p5NrHBkRjkMPUc1X1CRLrxnqN1bFTb22mNDPKD8pf5jjPqM ir5FdojndkzTtPGUcyWE9zYT29rfkJDOWVhuPQNjkZxVzxB4gTw5HBNcWrvayyCNpUYfuye5HpXE 2O+DRvDl1qswm0RSMhFx9nl/hZ/Ucke1dZ4lNrqFzpVhM0ckN1K+4Bhyuwj+tOUIqS001CMm4vXU 19R1SDTNJm1CY5hij8z5eregH1qPQ9VOtabHefZngSQZQMwJI9eK4i2ku7zS7nRL/O3Ro5fOkbpI Qp8r9Dn8q1dH1ddN+GtnOrp57QiOFS3WQ8D9Tn8KmVKyt1uNVLvysbuk+IrXWL+/tIAyyWcmwk9H H94e2c1E3iL7RqU9jpdo15JbnbNJvCRo393Pc1zMFrdeFNe0i6vZrb7Pcp9icxgrz95S2TyevNaH giRLC51bTLpwl6t28uGODIjHIYeo5pyppJyQlN3sze0rVpr65ura6sntJrcrkFw6sCMggitOqlvq Frc3s9tBIrzQAeZt5C57Z9fb3q3WL3NUNeNJY2SRVZGGCrDIIrNg8NaRbzrNDp8COpypC9D7UUUX aHYnv9HsNTKNe2kUzJ91mXkfjSjSbFbM2gtYfs56x7Rg0UUXYrIINJsba2kt4bWJIJPvxhflb6io P+Ec0nCD+z7f5Pu/J936UUUXYWRal060nWVZraJxNjzAy5346Zqr/wAI3pHlhP7OttgOQNgwDRRR dhZE1zpFheRxx3VpDMsQwgdc7R7Uy50LTbyKKO4soZFiGI8ryo9AaKKLsLImsdNtNNjMdnbpCpOS EGMmrVFFIZ//2Q== --_004_25d4772d1a2d43798325f07de5162cdeSN2PR0701MB816namprd07p_--