Return-Path: X-Original-To: apmail-drill-dev-archive@www.apache.org Delivered-To: apmail-drill-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 0201618939 for ; Mon, 10 Aug 2015 19:17:48 +0000 (UTC) Received: (qmail 33508 invoked by uid 500); 10 Aug 2015 19:17:47 -0000 Delivered-To: apmail-drill-dev-archive@drill.apache.org Received: (qmail 33464 invoked by uid 500); 10 Aug 2015 19:17:47 -0000 Mailing-List: contact dev-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list dev@drill.apache.org Received: (qmail 33237 invoked by uid 99); 10 Aug 2015 19:17:47 -0000 Received: from Unknown (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 10 Aug 2015 19:17:47 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id E1BFB1A9C56 for ; Mon, 10 Aug 2015 19:17:46 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.921 X-Spam-Level: ** X-Spam-Status: No, score=2.921 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_IMAGE_ONLY_32=0.001, HTML_MESSAGE=3, SPF_PASS=-0.001, T_KAM_HTML_FONT_INVALID=0.01, T_REMOTE_IMAGE=0.01, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=maprtech.com Received: from mx1-eu-west.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id rPJW1CfFghYq for ; Mon, 10 Aug 2015 19:17:39 +0000 (UTC) Received: from mail-yk0-f173.google.com (mail-yk0-f173.google.com [209.85.160.173]) by mx1-eu-west.apache.org (ASF Mail Server at mx1-eu-west.apache.org) with ESMTPS id 66FE620647 for ; Mon, 10 Aug 2015 19:17:38 +0000 (UTC) Received: by ykaz130 with SMTP id z130so40668835yka.0 for ; Mon, 10 Aug 2015 12:17:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=maprtech.com; s=google; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=uTidmTUgiHXfdlZ6xNUib1BAjJ8Zx8Ujfw7wSlWSVag=; b=ogwf0Iha8HRJ8fUJrZJV7FngQ6lEdqk+CbcwFpIk2Pvl1vHwrUFfh9QUHgzc4Ez6/f A9fTQKZcgPVBX1R/MjdFzfgaM8Yhw6N54Jz3MH2rw0paZp0OZsFeA8DeK29FNrXFDFK2 QlgxOdK5DWgXsV6KbpvQGY72LHvja3Bi7XKvU= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=uTidmTUgiHXfdlZ6xNUib1BAjJ8Zx8Ujfw7wSlWSVag=; b=eyRUQBKxYi28CSIGz7EK+k4HCV42tGVzJQZMvHarnNmQ5pMLI4u2xr6oIYtqsCpgA4 N1l36xcBvcxyR7gLaDTgmxKbIUnJAglYvxEQtP8jPCxfLjXKI4aThSZ3omGEuSOe68ff lAUvUMBzr+KlL62wZWlxnA2J7fSKCqlSCAIJsDLrbFv1hUXBu+lipC85JE8ihuXMXDuF 3OfTdTEeaWOVOl5M8xaTjKVOgrWWbNdFJIzEoaH+WjSEGLENpXs1bvRT23vsbmaHET9x pO3ZLCz54DkdVCR82a7Ihg4Mgfxa7B9ebg0aYtSHO1+sIjPcJ2/rQlAxE26H/8z/+SzJ 6+BA== X-Gm-Message-State: ALoCoQmwSriQ5ZQ6B7xmVjHopjq/mFn7/55rWlbTd1bKIv4kCOaG3CDpss/hjTG3WxuobZYJvr8h MIME-Version: 1.0 X-Received: by 10.129.106.194 with SMTP id f185mr15351523ywc.32.1439234257305; Mon, 10 Aug 2015 12:17:37 -0700 (PDT) Received: by 10.13.226.214 with HTTP; Mon, 10 Aug 2015 12:17:37 -0700 (PDT) In-Reply-To: References: Date: Mon, 10 Aug 2015 12:17:37 -0700 Message-ID: Subject: Re: [jira] [Created] (DRILL-3619) Add support for NTILE window function From: Abdel Hakim Deneche To: "dev@drill.apache.org" Content-Type: multipart/alternative; boundary=001a11473c18a7f5ca051cf9d6e9 --001a11473c18a7f5ca051cf9d6e9 Content-Type: text/plain; charset=UTF-8 I got a "basic" implementation running, but it's still in testing. It's seems to be giving correct results, but it's tied to Drill's Window operator because it still need to compute all window functions if necessary. All suggestions are welcome, it's always interesting to learn about alternative ways to implement the same feature. Thanks On Mon, Aug 10, 2015 at 11:15 AM, Ted Dunning wrote: > Let me know if you want some suggestions for approximate ntile > implementations. > > On Mon, Aug 10, 2015 at 10:42 AM, Deneche A. Hakim (JIRA) > > wrote: > > > Deneche A. Hakim created DRILL-3619: > > --------------------------------------- > > > > Summary: Add support for NTILE window function > > Key: DRILL-3619 > > URL: https://issues.apache.org/jira/browse/DRILL-3619 > > Project: Apache Drill > > Issue Type: Sub-task > > Reporter: Deneche A. Hakim > > Assignee: Deneche A. Hakim > > > > > > > > > > > > > > -- > > This message was sent by Atlassian JIRA > > (v6.3.4#6332) > > > -- Abdelhakim Deneche Software Engineer Now Available - Free Hadoop On-Demand Training --001a11473c18a7f5ca051cf9d6e9--