From dev-return-5728-apmail-trafodion-dev-archive=trafodion.apache.org@trafodion.apache.org Sat Oct 13 16:35:36 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 6D312196C8 for ; Sat, 13 Oct 2018 16:35:36 +0000 (UTC) Received: (qmail 43912 invoked by uid 500); 13 Oct 2018 16:35:36 -0000 Delivered-To: apmail-trafodion-dev-archive@trafodion.apache.org Received: (qmail 43864 invoked by uid 500); 13 Oct 2018 16:35:36 -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 43852 invoked by uid 99); 13 Oct 2018 16:35:35 -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; Sat, 13 Oct 2018 16:35:35 +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 17BD2C240B for ; Sat, 13 Oct 2018 16:35:35 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.998 X-Spam-Level: * X-Spam-Status: No, score=1.998 tagged_above=-999 required=6.31 tests=[DKIMWL_WL_MED=-0.001, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=2, HTML_OBFUSCATE_05_10=0.001, 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-us.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id a2jFY99b2cod for ; Sat, 13 Oct 2018 16:35:33 +0000 (UTC) Received: from NAM04-BN3-obe.outbound.protection.outlook.com (mail-eopbgr680097.outbound.protection.outlook.com [40.107.68.97]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 28CD25F3EA for ; Sat, 13 Oct 2018 16:35:33 +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=1amjeR1HlWcDSmo6U1VdsXmngYfhgayeGJDk+hs1Mjc=; b=M6ZllIo7IG1CsIX2ZaL2qOrcObHmyBjHe+RIH/YoewD556ng0xzClkptPSU/S9fEjmFwY3y5++19K9/9kgQqaPm+zVJTZ4v3moKbxmKb1YvqGzPZ4jnIuJJlgNRrOuja498cW/aQpZrDlNYDaLDOFdg9GNbBrvJBfj67xEqJ/Rk= Received: from BN7PR10MB2579.namprd10.prod.outlook.com (20.176.19.159) by BN7PR10MB2722.namprd10.prod.outlook.com (20.176.21.11) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.1228.26; Sat, 13 Oct 2018 16:35:22 +0000 Received: from BN7PR10MB2579.namprd10.prod.outlook.com ([fe80::35eb:c451:b6a0:805]) by BN7PR10MB2579.namprd10.prod.outlook.com ([fe80::35eb:c451:b6a0:805%3]) with mapi id 15.20.1228.020; Sat, 13 Oct 2018 16:35:22 +0000 From: Qifan Chen 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+oLD3hRI2Er7qhU8ec0wABONk9 Date: Sat, 13 Oct 2018 16:35:22 +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=qifan.chen@esgyn.com; x-originating-ip: [50.115.67.10] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;BN7PR10MB2722;6:N5keeQZoXsJBsB0p/C7tLx20mix/4PPe8J8I515xsvKQ12/eH3iy70bUV0WvMw0hNv4h8kctbjgomtsyAxkOxJKRjXxQABjq0ce9AwDbYKzPi371eKB1MPiSKhiGphgwsQJm+tBtpR4nSJCSFBDgIwU7eJ4FU8K11hHIVNlin6TFT22x8AT8Ksv/O+E2El7r5iknc41RtZEQoWFkRXGPDLabNMQT+aKan4kSfGDbqcHnRII+2VR9N+j7PIfPieTvFsU0TPOw3XNs3r1ZyewKsntc3/fRK86W2dnh3fB3hk/pOqLtIh1Zd8cZWOuNldUKclusyueZ1Hpo3ZsIQdIp+eYCLVPzeELMyZ7bPSBxsjfv63IfsGcgVy4iBmqTbxb0yiB3eq53jTrx1OUlfKESg+iv5CVj2HER2uJcJuPXQtCUopccl8kpoAcEe/COI9N5xp/d0HJ+620L8XH0Diy9Ng==;5:umx9l5hXHDdRxWAx+Tm4lWi9grHAucshop13mf+WShxPCryqGw8jaROtcw7pzazK5pr8DbSy4XkGvzUaQrn3zbb4/ryQf15BjHruZXaPQykm050C33IsqNH7a65hu6lymi8Z4yl4nlhf5ZCD0OaN20Ngp67qZDRrgVUKS9i3gO4=;7:b+fkGfVAv2YQOF4Xf/vaDlFnUHyCrlVkYehIH8S7+k3RxByRY0U/mm+YCnFXkgjYXNfquzf+9P5RTbK9g//FL+GbDvOX1DiYuvQ2v04L89/ojIO37XgnAD7tKQ1larI4/BBQk9mC0twvu/boDo+dcUEACtPQ2mfNeQ1EGnVpv0riMwPzbdDPLAnjWTgVGg7qRKAbgCNydBXmhPUvo2XsAnnXOUhoU1mYmXk/7MDVkTzwkd1QRvexUfYOQw2J7M9G x-ms-exchange-antispam-srfa-diagnostics: SOS; x-ms-office365-filtering-correlation-id: 0e7d16c9-c29f-4376-a59b-08d63129df1d x-microsoft-antispam: BCL:0;PCL:0;RULEID:(7020095)(4652040)(7021145)(8989299)(4534185)(7022145)(4603075)(4627221)(201702281549075)(8990200)(7048125)(7024125)(7027125)(7023125)(5600074)(711020)(2017052603328)(7153060)(7193020);SRVR:BN7PR10MB2722; x-ms-traffictypediagnostic: BN7PR10MB2722: 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)(3231355)(944501410)(52105095)(3002001)(10201501046)(93006095)(93001095)(149066)(150057)(6041310)(2016111802025)(20161123560045)(20161123558120)(20161123562045)(20161123564045)(6043046)(201708071742011)(7699051)(76991067);SRVR:BN7PR10MB2722;BCL:0;PCL:0;RULEID:;SRVR:BN7PR10MB2722; x-forefront-prvs: 082465FB26 x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(366004)(136003)(39830400003)(376002)(346002)(396003)(199004)(189003)(26005)(486006)(229853002)(14454004)(186003)(2351001)(105586002)(106356001)(55016002)(68736007)(102836004)(5640700003)(476003)(508600001)(11346002)(446003)(33656002)(44832011)(7736002)(733005)(6436002)(606006)(19627235002)(236005)(86362001)(53936002)(316002)(14444005)(6306002)(256004)(9686003)(54556002)(16234385003)(54896002)(74316002)(97736004)(71190400001)(71200400001)(3846002)(2501003)(66066001)(6116002)(19627405001)(2900100001)(6606003)(6506007)(8676002)(6916009)(6246003)(81166006)(81156014)(1730700003)(5660300001)(25786009)(53546011)(5250100002)(8936002)(2906002)(99286004)(76176011)(7696005);DIR:OUT;SFP:1102;SCL:1;SRVR:BN7PR10MB2722;H:BN7PR10MB2579.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: mwpaFsZNpCqP1qHGcJuc5214eC1KGdmrGANxGkNRHoDiC+vS2FQv7LOpSWvxBtOkfT/Khiw7wf2FDN6nbQIG0tTY/eGrNQ6iS4mwY5PTfZhwDlADR9LoLwgvxKR+APhLBhGWp9V5DGz6nwHBPwUL1sOpJwI2iKCPdTAXthOl9KXIs0XC9Kk1443quMLU0Eby2fAkS6msV4/yHSK9yiCWBnAwmNNQq1iaL1E08Dr0sdd12f9WPzGcaDiWFRLQr4Lm/OQ7TA6yCgV2dPdkQyWHXSLm4RFqOf74tOlsRTpqLLU+jL9SBr6NCPnA4zXo+CxiHuUvMAe2rmfYEzwGoNqOuQRpmg8YM0ybLvBuk+UGuLg= spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: multipart/alternative; boundary="_000_BN7PR10MB257901A9BDFDE7EC60272E978CE30BN7PR10MB2579namp_" MIME-Version: 1.0 X-OriginatorOrg: esgyn.com X-MS-Exchange-CrossTenant-Network-Message-Id: 0e7d16c9-c29f-4376-a59b-08d63129df1d X-MS-Exchange-CrossTenant-originalarrivaltime: 13 Oct 2018 16:35:22.5075 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: e30b8da4-8f20-405e-9a9d-c9a4cd2c3a27 X-MS-Exchange-Transport-CrossTenantHeadersStamped: BN7PR10MB2722 --_000_BN7PR10MB257901A9BDFDE7EC60272E978CE30BN7PR10MB2579namp_ Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: base64 SGkgWXVhbiwNCg0KDQpJbiB0aGlzIHBsYW4sIEkgdGhpbmsgdGhlIGNvbXBpbGVzIGRvZXMgdGhl IHJpZ2h0IHRoaW5nIGluIHNlbGVjdGluZyB0aGUgaGFzaF9ncm91cGJ5IGJlY2F1c2UgYSBzb3J0 IGdyb3VwYnkgd291bGQgYmUgbW9yZSBleHBlbnNpdmUgYW5kIHRoZSBzb3J0aW5nIHdvcmsgKG9u IDEpIGRvZXMgbm90IGhlbHAgdGhlIGZpbmFsIHNvcnQgKG9uIDIpLg0KDQoNCk5ldmVydGhsZXNz LCB5b3UgY2FuIHVzZSBhICJjb250cm9sIHF1ZXJ5IHNoYXBlIiBzdGF0bWVudCB0byBmb3JjZSB0 aGUgc29ydCBncm91cGJ5Lg0KDQoNCmNvbnRyb2wgcXVlcnkgc2hhcGUgc29ydChzb3J0X2dyb3Vw YnkoY3V0KSk7DQoNCjxjb21waWxlIHRoZSBxdWVyeT47DQoNCg0KVGhhbmtzIC0tUWlmYW4NCg0K X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18NCkZyb206IExpdSwgWXVhbiAoWXVhbikg PHl1YW4ubGl1QGVzZ3luLmNuPg0KU2VudDogU2F0dXJkYXksIE9jdG9iZXIgMTMsIDIwMTggMTA6 NTc6MzcgQU0NClRvOiBkZXZAdHJhZm9kaW9uLmFwYWNoZS5vcmcNClN1YmplY3Q6IEhvdyB0byBn ZXQgYSBzb3J0X2dyb3VwYnkgcGxhbg0KDQoNCkhpIHRyYWZvZGlvbmVlcnMsDQoNCg0KDQpJIGFt IHRyeWluZyB0byBnZXQgYSBzb3J0X2dyb3VwYnkgcXVlcnkgcGxhbiwgYnV0IEkgYWx3YXlzIGdl dCBoYXNoX2dyb3VwYnkgcGxhbi4NCg0KRG8geW91IGhhdmUgYW55IGlkZWEgYWJvdXQgaG93IHRv IGdldCBhIHNvcnRfZ3JvdXBieSBwbGFuPw0KDQoNCg0KPj5leHBsYWluIG9wdGlvbnMgJ2YnIHNl bGVjdCBhLklORFVTVFJZUEhZLHN1bShhLlJFR0NBUCkgZnJvbSBETUFfRU5UVFlQRV9TVEFUIGEg Z3JvdXAgYnkgMSBvcmRlciBieSAyOw0KDQoNCg0KTEMgICBSQyAgIE9QICAgT1BFUkFUT1IgICAg ICAgICAgICAgIE9QVCAgICAgICBERVNDUklQVElPTiAgICAgICAgICAgQ0FSRA0KDQotLS0tIC0t LS0gLS0tLSAtLS0tLS0tLS0tLS0tLS0tLS0tLSAgLS0tLS0tLS0gIC0tLS0tLS0tLS0tLS0tLS0t LS0tICAtLS0tLS0tLS0NCg0KDQoNCjMgICAgLiAgICA0ICAgIHJvb3QgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDIuNTBFKzAwMQ0KDQoyICAgIC4gICAg MyAgICBzb3J0ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAyLjUwRSswMDENCg0KMSAgICAuICAgIDIgICAgaGFzaF9ncm91cGJ5ICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgMi41MEUrMDAxDQoNCi4gICAgLiAgICAxICAgIHRy YWZvZGlvbl9zY2FuICAgICAgICAgICAgICAgICAgRE1BX0VOVFRZUEVfU1RBVCAgICAgIDUuMDNF KzAwDQoNCg0KDQoNCg0KDQoNCkJlc3QgcmVnYXJkcw0KDQoNCg0KwfXUtKOoWXVhbqOpDQoNCsnP uqPS176ovd3Qxc+ivLzK9dPQz965q8u+PGh0dHA6Ly93d3cuZXNneW4uY24vPg0KDQq12Na3o7rJ z7qjytDG1rar0MLH+L3wv8bCtzI4ODm6xbOkzKm547OhQdf5NjAzDQoNCsrWu/qjujEzNjcxOTM1 NTQwDQoNCtPKz+Sjunl1YW4ubGl1QGVzZ3luLmNuPG1haWx0bzp5dWFuLmxpdUBlc2d5bi5jbj4N Cg0KW9LXvqi93WxvZ2/W0M7EIC0guLGxvl0NCg0KDQo= --_000_BN7PR10MB257901A9BDFDE7EC60272E978CE30BN7PR10MB2579namp_--