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 26BE4195AE for ; Mon, 14 Mar 2016 05:54:37 +0000 (UTC) Received: (qmail 29929 invoked by uid 500); 14 Mar 2016 05:54:36 -0000 Delivered-To: apmail-drill-dev-archive@drill.apache.org Received: (qmail 29877 invoked by uid 500); 14 Mar 2016 05:54:36 -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 29865 invoked by uid 99); 14 Mar 2016 05:54:36 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 14 Mar 2016 05:54:36 +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 0AAB21A0053 for ; Mon, 14 Mar 2016 05:54:36 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.299 X-Spam-Level: * X-Spam-Status: No, score=1.299 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=dremio-com.20150623.gappssmtp.com Received: from mx2-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id qRvrQeuSXvQ7 for ; Mon, 14 Mar 2016 05:54:33 +0000 (UTC) Received: from mail-lb0-f172.google.com (mail-lb0-f172.google.com [209.85.217.172]) by mx2-lw-us.apache.org (ASF Mail Server at mx2-lw-us.apache.org) with ESMTPS id 1243D5FAE7 for ; Mon, 14 Mar 2016 05:54:33 +0000 (UTC) Received: by mail-lb0-f172.google.com with SMTP id bc4so224445853lbc.2 for ; Sun, 13 Mar 2016 22:54:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dremio-com.20150623.gappssmtp.com; s=20150623; h=mime-version:date:message-id:subject:from:to; bh=IawUPPr/TqegZWwAc0DvOHJhlXZ9y3BI8qEdvjkVn0k=; b=QhO0iHVRV9fWWFrr3OGCvOgX4b9if6K+LZujqFuAWbhtw90lOZuOhEm49MH6z0kCMV 9q2F4ip2m6nuAyzko3h2qVRywYiTpyEV23RCQE5rEEC0F8135HtIDqpYaojVoY+MzaSe a5C1Xx2+vKkcZ7glZ4B2ZA1YZV6D4QyZ9Rz6g1ZHAB8Mo579zkGvcAqF4sTYhpFMMQkb JIMPpF4nN0hLyNjRCfUvNbIJkh2BoRqoP4nFrH0s4xrXRrTOB9PUW4WIyQOFaH3FCtFW NJwK6AfWytljO7tVYH3Rdnci7mf5jVKzoVly/GHRPpKEGLhAzvqawLJutEK4Ic+zu1Di tKQg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:date:message-id:subject:from:to; bh=IawUPPr/TqegZWwAc0DvOHJhlXZ9y3BI8qEdvjkVn0k=; b=NmV7/2+3/IadNnfNgvuaGwUQVV+Vwjqtv3kc1OHRSklypGvgEk3mzU5pNk8E5YtIkA i6flPJXzDBQ9MUcsMStI1KSlVG4Eaa9kprI9WXblnbqiH+F+eM0yrXk81AhM12rDp6aQ 9kpVl7Bpcrb1uQpbNGmYdbRQQDvp/zSUdlxTUixqMIAhnHIGq8PJY6q2Z7WXMsRduWtH PUi6R99SRix2PMLCqph2N+eFIGkywhGLx7il0LVFkX+KiZHidIIc/sDMkae79e39Bn2m IV7jbgEJZiGI8yJEYrgDaUBdbtG0D/Pcj94LkqlA0JPdHkmEa8E6A7VDfaOON971IFSl eDcA== X-Gm-Message-State: AD7BkJLOnKQZdOHEHMnW25l06iKoOzWIF+842ivnpa053Z07B7aYQD7SlqpPD5zXlqDu3i5Hz1yLfd1hokqZ2g== MIME-Version: 1.0 X-Received: by 10.112.46.136 with SMTP id v8mr5474618lbm.38.1457934866653; Sun, 13 Mar 2016 22:54:26 -0700 (PDT) Received: by 10.25.216.8 with HTTP; Sun, 13 Mar 2016 22:54:26 -0700 (PDT) Date: Sun, 13 Mar 2016 22:54:26 -0700 Message-ID: Subject: Getting back on Calcite master: only a few steps left From: Jacques Nadeau To: dev Content-Type: multipart/alternative; boundary=001a11346194d52e53052dfbe93f --001a11346194d52e53052dfbe93f Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hey All, I've been working on rebasing and tracking all the necessary commits that are on the Drill Calcite fork so that we can get back onto master. The current working branch is here: [1]. It includes the following commits [CALCITE-1148] Fix RelTrait conversion (e.g. distribution, collation), added test cases. (Minji Kim) #77def4a [CALCITE-991] Create separate FunctionCategories for table functions and macros (Julien Le Dem) #b1c203d [CALCITE-1149] Derive AVG=E2=80=99s return type by a customizable policy (S= udheesh Katkam) #18882cd [CALCITE-1151] Overriding the SqlSpecialOperator#createCall method given the usage by CompoundIdentifierConverter (Sudheesh Katkam) #2320c7f [CALCITE-1108] Don't use 'SumEmptyIsZero' (SUM0) window aggregate until CALCITE-777 is fixed. (Aman Sinha) #13466fa [CALCITE-1107] Make SqlSumEmptyIsZeroAggFunction constructor public. (Jinfeng Ni) #b6c3178 [CALCITE-1106] Expose Constructor for ProjectJoinTransposeRule. (Aman Sinha) #d169c37 [CALCITE-1105] Add return type-inference strategy for arithmetic operators when one of the arguments is ANY type. (Aman Sinha) #df818c9 [CALCITE-1150] Add DynamicRecordType and the concept of unresolved star (Jinfeng Ni) #29c7771 [CALCITE-1152] Small ANY type fixes (Mehant Baid) #31efdda [CALCITE-528] Ensure uniquification is done in a case aware way according to type system and catalog policies. (Jacques Nadeau) #5a3d854 Many commits, listed below, don't have tests right now so I'd like to get people to raise their hand and work on tests for each of the commits. [CALCITE-991] Create separate FunctionCategories for table functions and macros (Julien Le Dem) #b1c203d [CALCITE-1149] Derive AVG=E2=80=99s return type by a customizable policy (S= udheesh Katkam) #18882cd [CALCITE-1151] Overriding the SqlSpecialOperator#createCall method given the usage by CompoundIdentifierConverter (Sudheesh Katkam) #2320c7f [CALCITE-1108] Don't use 'SumEmptyIsZero' (SUM0) window aggregate until CALCITE-777 is fixed. (Aman Sinha) #13466fa [CALCITE-1105] Add return type-inference strategy for arithmetic operators when one of the arguments is ANY type. (Aman Sinha) #df818c9 [CALCITE-1150] Add DynamicRecordType and the concept of unresolved star (Jinfeng Ni) #29c7771 [CALCITE-1152] Small ANY type fixes (Mehant Baid) #31efdda [CALCITE-528] Ensure uniquification is done in a case aware way according to type system and catalog policies. (Jacques Nadeau) #5a3d854 Also note that there are currently 15 tests failing in this Calcite branch that I haven't yet tracked down. org.apache.calcite.test.SqlToRelConverterTest (10 tests) org.apache.calcite.test.JdbcTest (2 tests) org.apache.calcite.test.RelOptRulesTest.txt (1 test) org.apache.calcite.test.SqlValidatorTest.txt (1 test) org.apache.calcite.rel.rel2sql.RelToSqlConverterTest (1 test) Note that I also reworked the Schema changes items so that they don't have any impact on code paths unless the system returns a DynamicRecordType. Once we get these changes looking good, we can move to making small modifications in the Drill codebase to use this new record type. Can people raise their hands to confirm they will be able to write tests cases for issues they own? thanks, Jacques [1] https://github.com/jacques-n/incubator-calcite/tree/calcite-drill-2 -- Jacques Nadeau CTO and Co-Founder, Dremio --001a11346194d52e53052dfbe93f--