From dev-return-5734-apmail-trafodion-dev-archive=trafodion.apache.org@trafodion.apache.org Mon Oct 15 16:40:03 2018 Return-Path: X-Original-To: apmail-trafodion-dev-archive@minotaur.apache.org Delivered-To: apmail-trafodion-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 8F181190F3 for ; Mon, 15 Oct 2018 16:40:03 +0000 (UTC) Received: (qmail 70342 invoked by uid 500); 15 Oct 2018 16:40:03 -0000 Delivered-To: apmail-trafodion-dev-archive@trafodion.apache.org Received: (qmail 70297 invoked by uid 500); 15 Oct 2018 16:40:03 -0000 Mailing-List: contact dev-help@trafodion.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@trafodion.apache.org Delivered-To: mailing list dev@trafodion.apache.org Received: (qmail 70282 invoked by uid 99); 15 Oct 2018 16:40:02 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 15 Oct 2018 16:40:02 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 5B283C588D for ; Mon, 15 Oct 2018 16:40:02 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.003 X-Spam-Level: X-Spam-Status: No, score=-0.003 tagged_above=-999 required=6.31 tests=[DKIMWL_WL_MED=-0.001, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=esgyn.onmicrosoft.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id xwCfDSCnKQVj for ; Mon, 15 Oct 2018 16:40:01 +0000 (UTC) Received: from NAM03-CO1-obe.outbound.protection.outlook.com (mail-co1nam03on0091.outbound.protection.outlook.com [104.47.40.91]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 42A385F19C for ; Mon, 15 Oct 2018 16:40:00 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=esgyn.onmicrosoft.com; s=selector1-esgyn-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=PLPahpVEURurjJwihmg4/bxQyf08tuDQrAB3v0YLDOk=; b=SXxBHM8EIqhbNsgPc8ZLrIbMoL/gHPX8p1Fr2I3ampRb8UwVCefM44qImO/oYq8vLAlv5SYv8TMS/8kkoviEXoACkKZEiHZdTRuGK7s3xcPqITeqVTq5xOmpj4KhRjVSNSMdCEXYTv+CTBHILu6fnacykh/dtNd98HHlEd+CtTU= Received: from CO2PR10MB0038.namprd10.prod.outlook.com (10.160.8.152) by CO2PR10MB0103.namprd10.prod.outlook.com (10.160.8.28) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.1228.31; Mon, 15 Oct 2018 16:39:50 +0000 Received: from CO2PR10MB0038.namprd10.prod.outlook.com ([fe80::538:e0c:6b07:32d3]) by CO2PR10MB0038.namprd10.prod.outlook.com ([fe80::538:e0c:6b07:32d3%6]) with mapi id 15.20.1228.020; Mon, 15 Oct 2018 16:39:50 +0000 From: Dave Birdsall To: "dev@trafodion.apache.org" Subject: RE: How to get a sort_groupby plan Thread-Topic: How to get a sort_groupby plan Thread-Index: AdRjDSE8pL+oLD3hRI2Er7qhU8ec0wABONk9AGTa15A= Date: Mon, 15 Oct 2018 16:39:49 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: spf=none (sender IP is ) smtp.mailfrom=dave.birdsall@esgyn.com; x-originating-ip: [50.115.67.10] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;CO2PR10MB0103;6:2YCYqEGVbxyccSPDeOl8inmK8/vhnkzqChZRyFGF3B1K/OlbivQrRW3WI91TMPYbe7O9cYKf86siGjmzpZiq9/33k6GhBS9EzWc6iZgn40NRs+rSkEaPhb8ZKRO36TlVMzk++sS7zzwL9BMgc4iKvxGC2/u2kwzQ4YVNBfHBCrSuQL4U548WT08MgAJqfT0ThCoztnH5ozEWjv9rKKvDbWtd6gJQuiQrzoO+Eb++quSV0N4AvTL8BxJ+fwiy5Xv5jEWlbaZ3+1+vUeySQ64cpv4t8uHVEEwf1sQkfWULHq51kiXEr9/9xOxJ9BHZ4NNeHGP2r0uwVJpp8UQaZJ2o3xLBzShCwoXWXN6UaxHIAKmFTYsxPtr03g75q6xEU1QEBUntPsobPNtLE9DnjFNemLTHlYBNWtwIaxnNEoSayVWtAaQ9OVcPbqFS7nhopMhS0DXw6zuiU2SUWAzu1b6dQw==;5:RJRhRX3m/Crx/iZsaJrK727OctDPvgzlNCInvOiTkjJ564BMe2RIkcBD0qhCTBJQUO4xFyweAnDxUEyotdC3A3t+QiuNZLEKNLGRByQqPjCZSjLfqxsJnk/t1QVFmDM4CtWrNpWyhlqP0XBhzN+m4SC76I5kYffOfw7tgHg1XpQ=;7:rzJNbycmYrWuFSKormbj3SJQjN36lOPCC3tnziH5t//M/QhEH3bi4UIFqRBM1mgFGfCx7YTgAQM1Qxv2tsrrxyMN7r5jlU5sDG5yv4h0OSoxAqWT9GImADvvkoGh+x2od/PYluQPEiA0aIRR0nB/TxAwDXM3LEjWRFsreGLse9wqApmPBVfAFEnIIyWzOTAd7bsj7atSQHCPRJ9DYzSewr5En454mJtygO/3D57RVaFBsOL3v8Li5I19j8zQaww/ x-ms-exchange-antispam-srfa-diagnostics: SOS; x-ms-office365-filtering-correlation-id: 66ed26da-2892-460d-566a-08d632bcd365 x-microsoft-antispam: BCL:0;PCL:0;RULEID:(7020095)(4652040)(7021145)(8989299)(5600074)(711020)(4534185)(7022145)(4603075)(4627221)(201702281549075)(8990200)(7048125)(7024125)(7027125)(7023125)(2017052603328)(7153060)(7193020);SRVR:CO2PR10MB0103; x-ms-traffictypediagnostic: CO2PR10MB0103: x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:; x-ms-exchange-senderadcheck: 1 x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(6040522)(2401047)(8121501046)(5005006)(3002001)(3231355)(944501410)(52105095)(10201501046)(93006095)(93001095)(149066)(150057)(6041310)(2016111802025)(20161123558120)(20161123562045)(20161123564045)(20161123560045)(6043046)(201708071742011)(7699051);SRVR:CO2PR10MB0103;BCL:0;PCL:0;RULEID:;SRVR:CO2PR10MB0103; x-forefront-prvs: 0826B2F01B x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(396003)(39840400004)(346002)(136003)(366004)(376002)(199004)(189003)(13464003)(446003)(486006)(9686003)(2900100001)(44832011)(53936002)(55016002)(5640700003)(476003)(71200400001)(71190400001)(25786009)(97736004)(2501003)(5250100002)(33656002)(76176011)(7696005)(6436002)(6306002)(99286004)(11346002)(6506007)(53546011)(229853002)(7736002)(102836004)(305945005)(86362001)(74316002)(105586002)(106356001)(2351001)(316002)(14444005)(2906002)(6116002)(256004)(66066001)(6246003)(81156014)(186003)(1730700003)(26005)(8676002)(6916009)(68736007)(81166006)(508600001)(8936002)(14454004)(3846002)(5660300001);DIR:OUT;SFP:1102;SCL:1;SRVR:CO2PR10MB0103;H:CO2PR10MB0038.namprd10.prod.outlook.com;FPR:;SPF:None;LANG:en;PTR:InfoNoRecords;A:1;MX:1; received-spf: None (protection.outlook.com: esgyn.com does not designate permitted sender hosts) x-microsoft-antispam-message-info: jZ9FLeX/GtZo0xyFzZNfH5pJrbKl0mHQb2TSDBTsiQ0Vem9cxQcr4O0oIXvVH8qtOOAshKY3iycyesRYkfxoz5WFeHPUnU4lCYIHG9w5OY15+0ia3zkWj/tSI0lpzK7key9+9lCGaA0hVQCDLwXEqmTWfloBhLc4yDIhjFbqly5jXGv+DuylzIQk3vD0KbJOpMigFW8rqiqYU+zehUBTxpGqPL9uEXXMxzRDCvRQNtdtexZ7LhnzosiSUykTfknQACCJrkH9c1W2ZB2jIeylxR3z6qk42mf7MHmo3HxqCD4MsOulLykoRRU0yez3+7U/8WOMui1NHDTeKuRN0xTHrhQ4q5xaU3LZMBK5QXKhu30= spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: esgyn.com X-MS-Exchange-CrossTenant-Network-Message-Id: 66ed26da-2892-460d-566a-08d632bcd365 X-MS-Exchange-CrossTenant-originalarrivaltime: 15 Oct 2018 16:39:50.0128 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: e30b8da4-8f20-405e-9a9d-c9a4cd2c3a27 X-MS-Exchange-Transport-CrossTenantHeadersStamped: CO2PR10MB0103 SGksDQoNCklmIHRoZSBkYXRhIGlzIGFscmVhZHkgaW4gc29ydGVkIG9yZGVyLCB5b3UgbWlnaHQg Z2V0IGEgc29ydCBncm91cCBieSBwbGFuLg0KDQpGb3IgZXhhbXBsZToNCg0KQ3JlYXRlIHRhYmxl IHQxIChhIGludCBub3QgbnVsbCwgYiBpbnQpOw0KDQpJbnNlcnQgYSBtaWxsaW9uIHJvd3MgaW50 byB0MQ0KDQpQcmVwYXJlIHNlbGVjdCBhLGNvdW50KCopIGZyb20gdDEgZ3JvdXAgYnkgYTsNCg0K WW91IGFyZSBsaWtlbHkgdG8gZ2V0IGEgc29ydCBncm91cCBieSBwbGFuIGZvciB0aGlzLCBzaW5j ZSB0aGUgZGF0YSBpcyBhbHJlYWR5IG9yZGVyZWQgYnkgYS4NCg0KSWYgdGhlIHRhYmxlIGlzIHBh cnRpdGlvbmVkLCB5b3UgbWlnaHQgc3RpbGwgZ2V0IGEgaGFzaCBncm91cCBieSBwbGFuIHRob3Vn aC4NCg0KRGF2ZQ0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogUWlmYW4gQ2hl biA8cWlmYW4uY2hlbkBlc2d5bi5jb20+IA0KU2VudDogU2F0dXJkYXksIE9jdG9iZXIgMTMsIDIw MTggOTozNSBBTQ0KVG86IGRldkB0cmFmb2Rpb24uYXBhY2hlLm9yZw0KU3ViamVjdDogUmU6IEhv dyB0byBnZXQgYSBzb3J0X2dyb3VwYnkgcGxhbg0KDQpFeHRlcm5hbA0KDQpIaSBZdWFuLA0KDQoN CkluIHRoaXMgcGxhbiwgSSB0aGluayB0aGUgY29tcGlsZXMgZG9lcyB0aGUgcmlnaHQgdGhpbmcg aW4gc2VsZWN0aW5nIHRoZSBoYXNoX2dyb3VwYnkgYmVjYXVzZSBhIHNvcnQgZ3JvdXBieSB3b3Vs ZCBiZSBtb3JlIGV4cGVuc2l2ZSBhbmQgdGhlIHNvcnRpbmcgd29yayAob24gMSkgZG9lcyBub3Qg aGVscCB0aGUgZmluYWwgc29ydCAob24gMikuDQoNCg0KTmV2ZXJ0aGxlc3MsIHlvdSBjYW4gdXNl IGEgImNvbnRyb2wgcXVlcnkgc2hhcGUiIHN0YXRtZW50IHRvIGZvcmNlIHRoZSBzb3J0IGdyb3Vw YnkuDQoNCg0KY29udHJvbCBxdWVyeSBzaGFwZSBzb3J0KHNvcnRfZ3JvdXBieShjdXQpKTsNCg0K PGNvbXBpbGUgdGhlIHF1ZXJ5PjsNCg0KDQpUaGFua3MgLS1RaWZhbg0KDQpfX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fXw0KRnJvbTogTGl1LCBZdWFuIChZdWFuKSA8eXVhbi5saXVAZXNn eW4uY24+DQpTZW50OiBTYXR1cmRheSwgT2N0b2JlciAxMywgMjAxOCAxMDo1NzozNyBBTQ0KVG86 IGRldkB0cmFmb2Rpb24uYXBhY2hlLm9yZw0KU3ViamVjdDogSG93IHRvIGdldCBhIHNvcnRfZ3Jv dXBieSBwbGFuDQoNCg0KSGkgdHJhZm9kaW9uZWVycywNCg0KDQoNCkkgYW0gdHJ5aW5nIHRvIGdl dCBhIHNvcnRfZ3JvdXBieSBxdWVyeSBwbGFuLCBidXQgSSBhbHdheXMgZ2V0IGhhc2hfZ3JvdXBi eSBwbGFuLg0KDQpEbyB5b3UgaGF2ZSBhbnkgaWRlYSBhYm91dCBob3cgdG8gZ2V0IGEgc29ydF9n cm91cGJ5IHBsYW4/DQoNCg0KDQo+PmV4cGxhaW4gb3B0aW9ucyAnZicgc2VsZWN0IGEuSU5EVVNU UllQSFksc3VtKGEuUkVHQ0FQKSBmcm9tIERNQV9FTlRUWVBFX1NUQVQgYSBncm91cCBieSAxIG9y ZGVyIGJ5IDI7DQoNCg0KDQpMQyAgIFJDICAgT1AgICBPUEVSQVRPUiAgICAgICAgICAgICAgT1BU ICAgICAgIERFU0NSSVBUSU9OICAgICAgICAgICBDQVJEDQoNCi0tLS0gLS0tLSAtLS0tIC0tLS0t LS0tLS0tLS0tLS0tLS0tICAtLS0tLS0tLSAgLS0tLS0tLS0tLS0tLS0tLS0tLS0gIC0tLS0tLS0t LQ0KDQoNCg0KMyAgICAuICAgIDQgICAgcm9vdCAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgMi41MEUrMDAxDQoNCjIgICAgLiAgICAzICAgIHNvcnQgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDIuNTBFKzAwMQ0K DQoxICAgIC4gICAgMiAgICBoYXNoX2dyb3VwYnkgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAyLjUwRSswMDENCg0KLiAgICAuICAgIDEgICAgdHJhZm9kaW9uX3NjYW4g ICAgICAgICAgICAgICAgICBETUFfRU5UVFlQRV9TVEFUICAgICAgNS4wM0UrMDANCg0KDQoNCg0K DQoNCg0KQmVzdCByZWdhcmRzDQoNCg0KDQrliJjmupDvvIhZdWFu77yJDQoNCuS4iua1t+aYk+my uOaNt+S/oeaBr+aKgOacr+aciemZkOWFrOWPuDxodHRwOi8vd3d3LmVzZ3luLmNuLz4NCg0K5Zyw 5Z2A77ya5LiK5rW35biC5rWm5Lic5paw5Yy66YeR56eR6LevMjg4OeWPt+mVv+azsOW5v+WcukHl uqc2MDMNCg0K5omL5py677yaMTM2NzE5MzU1NDANCg0K6YKu566x77yaeXVhbi5saXVAZXNneW4u Y248bWFpbHRvOnl1YW4ubGl1QGVzZ3luLmNuPg0KDQpb5piT6bK45o23bG9nb+S4reaWhyAtIOWJ r+acrF0NCg0KDQo=