From user-return-475-apmail-phoenix-user-archive=phoenix.apache.org@phoenix.incubator.apache.org Sat Apr 5 17:43:10 2014 Return-Path: X-Original-To: apmail-phoenix-user-archive@minotaur.apache.org Delivered-To: apmail-phoenix-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id C2B9C11B54 for ; Sat, 5 Apr 2014 17:43:10 +0000 (UTC) Received: (qmail 37211 invoked by uid 500); 5 Apr 2014 17:43:09 -0000 Delivered-To: apmail-phoenix-user-archive@phoenix.apache.org Received: (qmail 36997 invoked by uid 500); 5 Apr 2014 17:43:05 -0000 Mailing-List: contact user-help@phoenix.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@phoenix.incubator.apache.org Delivered-To: mailing list user@phoenix.incubator.apache.org Received: (qmail 36984 invoked by uid 99); 5 Apr 2014 17:43:03 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 05 Apr 2014 17:43:03 +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 vladrodionov@gmail.com designates 74.125.82.47 as permitted sender) Received: from [74.125.82.47] (HELO mail-wg0-f47.google.com) (74.125.82.47) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 05 Apr 2014 17:42:57 +0000 Received: by mail-wg0-f47.google.com with SMTP id x12so4943882wgg.30 for ; Sat, 05 Apr 2014 10:42:35 -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=DSRDbMyDu1Z2idIXwGBBql8n0LJzhfpkZXcQoWR7lI4=; b=J6rXlg3dJTjVFXPEuUImvDsOemiCh6xZcE/aVCiwwP68MwMqFPMA5QFVDgV+jVZr0A y2ub/md0Hi97PnzoWDaZo84LtsqDk+SQiVdXlYXUNuRVIxQ3cdSFvPSKLYJjfAWTtVBC qSxxgjIK2qE1sKMoKX4h8Su0fBalFcfKAjW6yTdEO713cZD2dN+A/ZcZvKgL4asbU9lN li8OQsZFG+klZyfLJ3Z8kxd4xml7zpPsjY0OceJOEKapDJEnzBGce/kdxhRvWdb4IdY5 fl+gqeP4aAnmi1EUC59FSVxsPUTTADkHEt3AwY10enBy1lliGa5R5ejIa14jpLBYY8Sd Ag8w== MIME-Version: 1.0 X-Received: by 10.180.96.66 with SMTP id dq2mr13274238wib.54.1396719755416; Sat, 05 Apr 2014 10:42:35 -0700 (PDT) Received: by 10.216.62.10 with HTTP; Sat, 5 Apr 2014 10:42:35 -0700 (PDT) Date: Sat, 5 Apr 2014 10:42:35 -0700 Message-ID: Subject: RFE: using native HBase timestamp(version) to optimize date range queries in Phoenix From: Vladimir Rodionov To: user@phoenix.incubator.apache.org Content-Type: multipart/alternative; boundary=f46d04448061df5dd804f64f2824 X-Virus-Checked: Checked by ClamAV on apache.org --f46d04448061df5dd804f64f2824 Content-Type: text/plain; charset=ISO-8859-1 I am not sure it was implemented already, or it was not ... It would be nice to have a way to tell Phoenix which column is naturally mapped to HBase timestamp. This will greatly improve range queries on this column by utilizing internal HBase optimizations (skipping store files, which are completely out of the specified timestamp range). -Vladimir Rodionov --f46d04448061df5dd804f64f2824 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
I am not sure it was implemented already, o= r it was not=A0 ...
It would be nice to have a way to tell Phoenix= which column is naturally mapped to HBase timestamp. This will greatly imp= rove range queries on
this column by utilizing internal HBase optimizations (skipping store= files, which are completely out of the specified timestamp range).

=
-Vladimir Rodionov
--f46d04448061df5dd804f64f2824--