Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 2B71E200BD1 for ; Mon, 28 Nov 2016 20:15:44 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 2A376160B0D; Mon, 28 Nov 2016 19:15:44 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 71CC9160B00 for ; Mon, 28 Nov 2016 20:15:43 +0100 (CET) Received: (qmail 81881 invoked by uid 500); 28 Nov 2016 19:15:42 -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 81871 invoked by uid 99); 28 Nov 2016 19:15:42 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 28 Nov 2016 19:15:42 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id C663FC0040 for ; Mon, 28 Nov 2016 19:15:41 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.779 X-Spam-Level: ** X-Spam-Status: No, score=2.779 tagged_above=-999 required=6.31 tests=[FSL_HELO_BARE_IP_2=1.499, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id J30Gm-vZCgrl for ; Mon, 28 Nov 2016 19:15:38 +0000 (UTC) Received: from relayvx11c.securemail.intermedia.net (relayvx11c.securemail.intermedia.net [64.78.52.185]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 5B0E65FB64 for ; Mon, 28 Nov 2016 19:15:37 +0000 (UTC) Received: from emg-ca-1-1.securemail.intermedia.net (localhost [127.0.0.1]) (using TLSv1 with cipher AES256-SHA (256/256 bits)) (No client certificate requested) by emg-ca-1-1.localdomain (Postfix) with ESMTPS id 7519153EFA for ; Mon, 28 Nov 2016 11:15:21 -0800 (PST) Subject: Re: hive2.1.0 timestamp MIME-Version: 1.0 x-echoworx-msg-id: 57622374-0f45-4bb8-9220-94391e2ca2f4 x-echoworx-emg-received: Mon, 28 Nov 2016 11:15:21.404 -0800 x-echoworx-message-code-hashed: ac5ff57387c3c922ba40d4902f1a0095913bf4b09c03482632a95318b03a1bc9 x-echoworx-action: delivered Received: from 10.254.155.15 ([10.254.155.15]) by emg-ca-1-1 (JAMES SMTP Server 2.3.2) with SMTP ID 941 for ; Mon, 28 Nov 2016 11:15:21 -0800 (PST) Received: from MBX080-W4-CO-1.exch080.serverpod.net (unknown [10.224.117.101]) (using TLSv1 with cipher AES256-SHA (256/256 bits)) (No client certificate requested) by emg-ca-1-1.localdomain (Postfix) with ESMTPS id 34DE053EF7 for ; Mon, 28 Nov 2016 11:15:21 -0800 (PST) Received: from MBX080-W4-CO-1.exch080.serverpod.net (10.224.117.101) by MBX080-W4-CO-1.exch080.serverpod.net (10.224.117.101) with Microsoft SMTP Server (TLS) id 15.0.1178.4; Mon, 28 Nov 2016 11:15:20 -0800 Received: from MBX080-W4-CO-1.exch080.serverpod.net ([10.224.117.101]) by mbx080-w4-co-1.exch080.serverpod.net ([10.224.117.101]) with mapi id 15.00.1178.000; Mon, 28 Nov 2016 11:15:20 -0800 From: Jason Dere To: "user@hive.apache.org" Thread-Topic: hive2.1.0 timestamp Thread-Index: AQHSRf7QJ1HoM1Ftg0y5b1rMMP5BCKDuyysb Date: Mon, 28 Nov 2016 19:15:19 +0000 Message-ID: <1480360520397.22992@hortonworks.com> References: <6E4075A5-6A83-4A0C-81AF-8C2A472EB104@outlook.com> In-Reply-To: <6E4075A5-6A83-4A0C-81AF-8C2A472EB104@outlook.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [192.175.27.10] x-source-routing-agent: Processed Content-Type: multipart/alternative; boundary="_000_148036052039722992hortonworkscom_" archived-at: Mon, 28 Nov 2016 19:15:44 -0000 --_000_148036052039722992hortonworkscom_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Looks like this might be HIVE-15291. ________________________________ From: ? ? Sent: Wednesday, November 23, 2016 6:59 PM To: user@hive.apache.org Subject: hive2.1.0 timestamp Hi: I am using hive2.1 and hava a problem.I have a table 'xp' which contains = a timestamp field 'createdate'.When I query "createdate>'2016-11-22'" ,I ge= t empty.I explained the hql,the predicate was createdate>null. --_000_148036052039722992hortonworkscom_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Looks like this might be HIVE-15291.


From: 徐 鹏 <= ;xupeng1226@outlook.com>
Sent: Wednesday, November 23, 2016 6:59 PM
To: user@hive.apache.org
Subject: hive2.1.0 timestamp
 

Hi:
I  am using hive2.1 and  hava a problem.I have a table ̵= 6;xp' which contains a timestamp field ’createdate'.When I query R= 20;createdate>’2016-11-22’” ,I get empty.I explained t= he hql,the predicate was  createdate>null.
         
--_000_148036052039722992hortonworkscom_--