Return-Path: 
 <user-return-14393-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 6EE7710DDA
	for <apmail-hive-user-archive@www.apache.org>;
 Thu, 26 Sep 2013 18:34:34 +0000 (UTC)
Received: (qmail 52918 invoked by uid 500); 26 Sep 2013 18:34:31 -0000
Delivered-To: apmail-hive-user-archive@hive.apache.org
Received: (qmail 52699 invoked by uid 500); 26 Sep 2013 18:34:30 -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 52689 invoked by uid 99); 26 Sep 2013 18:34:30 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 26 Sep 2013 18:34:30 +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 (nike.apache.org: domain of garyzhao@gmail.com designates
 209.85.220.41 as permitted sender)
Received: from [209.85.220.41] (HELO mail-pa0-f41.google.com) (209.85.220.41)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 26 Sep 2013 18:34:23 +0000
Received: by mail-pa0-f41.google.com with SMTP id bj1so1691962pad.0
        for <user@hive.apache.org>; Thu, 26 Sep 2013 11:34:02 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:date:message-id:subject:from:to:content-type;
        bh=HrWEbN2Xkx8NStFXF3zpGyvuGbTRu0DIbcjhrFjftso=;
        b=CRMJpGqbFkMkX/R/0Hj1LgbBtIsaYt5U2UTArbW8iBj5/IFhJK/Uave1YLHA+35zEd
         J2ygzvx99Mr8LdNgoEKyxh85JJ4UUhSE03ZmN1y2hKGTidvz/whDwGLHrj00X/g0w+UD
         GO/+6vXw/ImoJajeBZK76XclhGF0lwm7KsC/mkvOZrrCZR/7stsnupKMb4wYxDOp2/h9
         wA691mEeKAk9AnPwsSNKk1Y01OwuTtT6RUT22bQ7mmgaZ7eObkvDG574fmSW4XDPn8is
         wBteqDN+R4GjrQCskC5p3xw0M6UP65yGFUXLO1H7MI83q4ABEC9FR+e51gLnwoKldLQK
         HuMw==
MIME-Version: 1.0
X-Received: by 10.68.229.2 with SMTP id sm2mr2849744pbc.68.1380220442738; Thu,
 26 Sep 2013 11:34:02 -0700 (PDT)
Received: by 10.70.62.97 with HTTP; Thu, 26 Sep 2013 11:34:02 -0700 (PDT)
Date: Thu, 26 Sep 2013 11:34:02 -0700
Message-ID: 
 <CAHX5kXiyb8=1Qu7Yd7bWpXJ3Wk2ONH5rXUhBG-sOhu9FwWy5Yg@mail.gmail.com>
Subject: Why "<" doesn't work?
From: Gary Zhao <garyzhao@gmail.com>
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=047d7b162fd7338adc04e74d9d45
X-Virus-Checked: Checked by ClamAV on apache.org

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

Hello

I found something strange. I tried a few queries, in WHERE

1. ">" works, returns expected results
2. ">" and "<" doesn't work, returns 0 result
3. "<" doesn't work, return 0 result
4. BETWEEN, syntax error

Basically, I want to find records between to time stamps that are epoch
unix timestamps. Is there anything I did wrong?

Thanks
Gary

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

<div dir=3D"ltr"><div><div><div><div><div><div><div><div>Hello<br><br></div=
>I found something strange. I tried a few queries, in WHERE<br><br></div>1.=
 &quot;&gt;&quot; works, returns expected results<br></div>2. &quot;&gt;&qu=
ot; and &quot;&lt;&quot; doesn&#39;t work, returns 0 result<br>
</div>3. &quot;&lt;&quot; doesn&#39;t work, return 0 result<br></div>4. BET=
WEEN, syntax error <br><br></div>Basically, I want to find records between =
to time stamps that are epoch unix timestamps. Is there anything I did wron=
g?<br>
<br></div>Thanks<br></div>Gary<br><div><div><div><div><div><div><div><div><=
div><br></div></div></div></div></div></div></div></div></div></div>

--047d7b162fd7338adc04e74d9d45--