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 E284F200BE7 for ; Tue, 20 Dec 2016 15:44:56 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id E1054160B29; Tue, 20 Dec 2016 14:44:56 +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 34FF4160B1B for ; Tue, 20 Dec 2016 15:44:56 +0100 (CET) Received: (qmail 60195 invoked by uid 500); 20 Dec 2016 14:44:54 -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 60185 invoked by uid 99); 20 Dec 2016 14:44:54 -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; Tue, 20 Dec 2016 14:44:54 +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 6FE67C00A6 for ; Tue, 20 Dec 2016 14:44:54 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.13 X-Spam-Level: ** X-Spam-Status: No, score=2.13 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id 9Fmq94uYBgeD for ; Tue, 20 Dec 2016 14:44:53 +0000 (UTC) Received: from mail-vk0-f52.google.com (mail-vk0-f52.google.com [209.85.213.52]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 3CFC95F254 for ; Tue, 20 Dec 2016 14:44:53 +0000 (UTC) Received: by mail-vk0-f52.google.com with SMTP id w194so135353317vkw.2 for ; Tue, 20 Dec 2016 06:44:53 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=0ZvTkIMMyAWP4lJoPHdKKE2hMFgVFh1orhafo8Z/ytA=; b=bhPYBUQjduw/9LXfI6Zdqix9sW6Ikp1RMx+PVnXVVkUY1ruA2e2919PraRGmO0oaru JyKNQtYAQxfcUNEHHJbBxh9i6wFNBbbjmkKLa1/mHMaKv+ZAUsc+ffiExDaEMDiv97B8 JuvRDSR+UOI1JMInHYQjEiSKnjnv37nFoqd8iTaCv2oW6XYxD7RCVZUlE7QTwDD+tOnM wGrXBBwEp52D6nB/bfYnCNm76UPaIIzfoj+gWng+oEzHkVVHQs2gT919zSY2RwNXPmln PPpEM56pLVPAj6k/h2IGXdJzp5U7vE0SfQhaHpledz1ZD/+L8AqvApmwJ9n6v/YmR2os 1rsg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=0ZvTkIMMyAWP4lJoPHdKKE2hMFgVFh1orhafo8Z/ytA=; b=H5eKhfIT9/MJh70mtMrE9d5X+Df/brpG5/p5PdJXk3ezNeLfIvc1Di4sJ8RA93+KsD afE9kGqad0MTxecs+UA6NCFcvLblrn/HzW8FLOFw6WBgLvuEExWvSxeI+tJ8pg5XbZMs jCwe7edsW6LVqq+g83bo2Lsj4nNYRGVurqFXnTvVJ/PELdqBTxbPlTkep2nyfLNAlaVl t1WKZrq50tDRwNVBRDh4fYH2/Mpf1LeEzMUl0pjtVXm9vE1Q2T/69Ewv30d6IVvuN779 VAlzivWpgFJO0++dQA8nvadMQIG1fX7do3MZQnRKhxJqtt+gSrTeLPwPHN0ycL9S5UNA FsuA== X-Gm-Message-State: AIkVDXJLAzT+qZFZpGP+k0hLVD7IPY3ioPdPRc7NbjpB3be2B7yWaZk8FSv3BSIrZMyi+Cga2zYnO4jUUgZ3IQ== X-Received: by 10.31.75.198 with SMTP id y189mr6855445vka.51.1482245026799; Tue, 20 Dec 2016 06:43:46 -0800 (PST) MIME-Version: 1.0 Received: by 10.176.5.99 with HTTP; Tue, 20 Dec 2016 06:43:26 -0800 (PST) In-Reply-To: <152D51CC-C82D-4F74-8F6A-D066783D4776@outlook.com> References: <152D51CC-C82D-4F74-8F6A-D066783D4776@outlook.com> From: Dhaval Modi Date: Tue, 20 Dec 2016 15:43:26 +0100 Message-ID: Subject: Re: hive 2.1.0 Comparison of timestamp fails if empty string is provided. To: user@hive.apache.org Content-Type: multipart/alternative; boundary=001a114db4524ae6420544181035 archived-at: Tue, 20 Dec 2016 14:44:57 -0000 --001a114db4524ae6420544181035 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi Xupeng, You need to check for NULL for 'cast("2016-12-31 12:00:00" as timestamp)'. Regards, Dhaval Modi dhavalmodi24@gmail.com On 20 December 2016 at 07:08, =E5=BE=90 =E9=B9=8F = wrote: > Dear all: > version :2.1.0 (fixed issue:HIVE-15291) > query:select cast("2016-12-31 12:00:00" as timestamp) <> =E2=80= =98' > expected result:true > actual result:NULL > > > > > > --001a114db4524ae6420544181035 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Xupeng,

You need to check for = NULL for=C2=A0'cast("2016-12-31 12:00:00" as timestamp)'.

Re= gards,
Dhaval Modi
dhavalmodi24@gmail.com

On 20 December 2016 at 07:08, =E5=BE=90 =E9= =B9=8F <xupeng1226@outlook.com> wrote:
Dear all:
=C2=A0 =C2=A0 =C2=A0 =C2=A0 version :2.1.0 (fixed issue:HIVE-15291)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 query:select cast("2016-12-31 12:00:00&quo= t; as timestamp) <> =E2=80=98'
=C2=A0 =C2=A0 =C2=A0 =C2=A0 expected result:true
=C2=A0 =C2=A0 =C2=A0 =C2=A0 actual result:NULL






--001a114db4524ae6420544181035--