From dev-return-5726-apmail-trafodion-dev-archive=trafodion.apache.org@trafodion.apache.org Sat Oct 13 15:58: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 4D2FD19433 for ; Sat, 13 Oct 2018 15:58:03 +0000 (UTC) Received: (qmail 14788 invoked by uid 500); 13 Oct 2018 15:58:03 -0000 Delivered-To: apmail-trafodion-dev-archive@trafodion.apache.org Received: (qmail 14738 invoked by uid 500); 13 Oct 2018 15:58: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 14727 invoked by uid 99); 13 Oct 2018 15:58:02 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 13 Oct 2018 15:58:02 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 2B90CC0158 for ; Sat, 13 Oct 2018 15:58:02 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.999 X-Spam-Level: * X-Spam-Status: No, score=1.999 tagged_above=-999 required=6.31 tests=[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 Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id qj_he7humPmE for ; Sat, 13 Oct 2018 15:57:58 +0000 (UTC) Received: from cn01-SHA-obe.outbound.protection.partner.outlook.cn (mail-shaon0130.outbound.protection.partner.outlook.cn [42.159.164.130]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id BCD325F11D for ; Sat, 13 Oct 2018 15:57:57 +0000 (UTC) Received: from BJXPR01MB104.CHNPR01.prod.partner.outlook.cn (10.41.51.146) by BJXPR01MB104.CHNPR01.prod.partner.outlook.cn (10.41.51.146) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.1228.23; Sat, 13 Oct 2018 15:57:37 +0000 Received: from BJXPR01MB104.CHNPR01.prod.partner.outlook.cn ([10.41.51.146]) by BJXPR01MB104.CHNPR01.prod.partner.outlook.cn ([10.41.51.146]) with mapi id 15.20.1228.020; Sat, 13 Oct 2018 15:57:37 +0000 From: "Liu, Yuan (Yuan)" To: "dev@trafodion.apache.org" Subject: How to get a sort_groupby plan Thread-Topic: How to get a sort_groupby plan Thread-Index: AdRjDSE8pL+oLD3hRI2Er7qhU8ec0w== Date: Sat, 13 Oct 2018 15:57:37 +0000 Message-ID: Accept-Language: zh-CN, en-US Content-Language: zh-CN X-MS-Has-Attach: yes X-MS-TNEF-Correlator: authentication-results: spf=none (sender IP is ) smtp.mailfrom=yuan.liu@esgyn.cn; x-originating-ip: [106.120.83.138] x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: cfe15d83-bd17-40a5-1b23-08d6312498fd x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:(4600260)(4652040)(97021020)(8989299)(711020)(4620075)(97022020)(4603075)(4627221)(201702281549075)(8990200)(7153060)(7048125)(7027125)(7023125)(4601075);SRVR:BJXPR01MB104; x-ms-traffictypediagnostic: BJXPR01MB104: x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(801108)(851020)(852020)(201703061421075)(944501410)(802075);SRVR:BJXPR01MB104;BCL:0;PCL:0;RULEID:(803075);SRVR:BJXPR01MB104; x-forefront-prvs: 082465FB26 x-forefront-antispam-report: SFV:NSPM;SFS:(10009020)(366004)(346002)(189003)(199004)(328002)(329002)(77096007)(97736004)(26005)(606006)(2501003)(54896002)(186003)(236005)(102836004)(74482002)(7696005)(95416001)(52396003)(59450400001)(71200400001)(81612004)(14454004)(54556002)(71190400001)(6306002)(476003)(55016002)(66066001)(486006)(5640700003)(106356001)(105586002)(99936001)(6916009)(8936002)(9686003)(5660300001)(68736007)(2351001)(508600001)(790700001)(2900100001)(3846002)(8676002)(7736002)(19580385004)(7330300002)(733005)(63696004)(6116002)(16234385003)(861006)(33656002)(1730700003)(81156014)(86362001);DIR:OUT;SFP:1101;SCL:1;SRVR:BJXPR01MB104;H:BJXPR01MB104.CHNPR01.prod.partner.outlook.cn;FPR:;SPF:None;LANG:en;PTR:InfoNoRecords;MX:1;A:1; received-spf: None (protection.outlook.com: esgyn.cn does not designate permitted sender hosts) Content-Type: multipart/related; boundary="_004_BJXPR01MB10447211054A7BA89D2AA6AE2E30BJXPR01MB104CHNPR0_"; type="multipart/alternative" MIME-Version: 1.0 X-OriginatorOrg: esgyn.cn X-MS-Exchange-CrossTenant-Network-Message-Id: cfe15d83-bd17-40a5-1b23-08d6312498fd X-MS-Exchange-CrossTenant-originalarrivaltime: 13 Oct 2018 15:57:37.2155 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 8bf80453-2b55-4b23-a365-dc866d5806aa X-MS-Exchange-Transport-CrossTenantHeadersStamped: BJXPR01MB104 --_004_BJXPR01MB10447211054A7BA89D2AA6AE2E30BJXPR01MB104CHNPR0_ Content-Type: multipart/alternative; boundary="_000_BJXPR01MB10447211054A7BA89D2AA6AE2E30BJXPR01MB104CHNPR0_" --_000_BJXPR01MB10447211054A7BA89D2AA6AE2E30BJXPR01MB104CHNPR0_ Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: base64 SGkgdHJhZm9kaW9uZWVycywNCg0KSSBhbSB0cnlpbmcgdG8gZ2V0IGEgc29ydF9ncm91cGJ5IHF1 ZXJ5IHBsYW4sIGJ1dCBJIGFsd2F5cyBnZXQgaGFzaF9ncm91cGJ5IHBsYW4uDQpEbyB5b3UgaGF2 ZSBhbnkgaWRlYSBhYm91dCBob3cgdG8gZ2V0IGEgc29ydF9ncm91cGJ5IHBsYW4/DQoNCj4+ZXhw bGFpbiBvcHRpb25zICdmJyBzZWxlY3QgYS5JTkRVU1RSWVBIWSxzdW0oYS5SRUdDQVApIGZyb20g RE1BX0VOVFRZUEVfU1RBVCBhIGdyb3VwIGJ5IDEgb3JkZXIgYnkgMjsNCg0KTEMgICBSQyAgIE9Q ICAgT1BFUkFUT1IgICAgICAgICAgICAgIE9QVCAgICAgICBERVNDUklQVElPTiAgICAgICAgICAg Q0FSRA0KLS0tLSAtLS0tIC0tLS0gLS0tLS0tLS0tLS0tLS0tLS0tLS0gIC0tLS0tLS0tICAtLS0t LS0tLS0tLS0tLS0tLS0tLSAgLS0tLS0tLS0tDQoNCjMgICAgLiAgICA0ICAgIHJvb3QgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDIuNTBFKzAwMQ0KMiAg ICAuICAgIDMgICAgc29ydCAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgMi41MEUrMDAxDQoxICAgIC4gICAgMiAgICBoYXNoX2dyb3VwYnkgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAyLjUwRSswMDENCi4gICAgLiAgICAxICAg IHRyYWZvZGlvbl9zY2FuICAgICAgICAgICAgICAgICAgRE1BX0VOVFRZUEVfU1RBVCAgICAgIDUu MDNFKzAwDQoNCg0KDQpCZXN0IHJlZ2FyZHMNCg0KwfXUtKOoWXVhbqOpDQrJz7qj0te+qL3d0MXP ory8yvXT0M/euavLvjxodHRwOi8vd3d3LmVzZ3luLmNuLz4NCrXY1rejusnPuqPK0MbWtqvQwsf4 vfC/xsK3Mjg4ObrFs6TMqbnjs6FB1/k2MDMNCsrWu/qjujEzNjcxOTM1NTQwDQrTys/ko7p5dWFu LmxpdUBlc2d5bi5jbjxtYWlsdG86eXVhbi5saXVAZXNneW4uY24+DQpb0te+qL3dbG9nb9bQzsQg LSC4sbG+XQ0KDQo= --_000_BJXPR01MB10447211054A7BA89D2AA6AE2E30BJXPR01MB104CHNPR0_ Content-Type: text/html; charset="gb2312" Content-Transfer-Encoding: quoted-printable

Hi trafodioneers,

 

I am trying to get a sort_groupby query plan, but I = always get hash_groupby plan.

Do you have any idea about how to get a sort_groupby= plan?

 

>>explain options 'f' select a.INDUSTRYPHY,sum= (a.REGCAP) from DMA_ENTTYPE_STAT a group by 1 order by 2;

 

LC   RC   OP   OPERATO= R            &n= bsp; OPT       DESCRIPTION   &= nbsp;       CARD

---- ---- ---- --------------------  --------&n= bsp; --------------------  ---------

 

3    .    4  = ;  root          &nb= sp;            =             &nb= sp;             = ; 2.50E+001

2    .    3  = ;  sort          &nb= sp;            =             &nb= sp;            =   2.50E+001

1    .    2  = ;  hash_groupby         &= nbsp;           &nbs= p;            &= nbsp;       2.50E+001

.    .    1  = ;  trafodion_scan         = ;         DMA_ENTTYPE_STAT &nb= sp;    5.03E+00

 

 

 =

Best regard= s

 

=C1=F5=D4=B4=A3=A8Yuan=A3=A9

=C9=CF=BA=A3=D2=D7=BE=A8=BD=DD=D0=C5=CF=A2=BC= =BC=CA=F5=D3=D0=CF=DE=B9=AB=CB=BE

=B5=D8=D6=B7=A3=BA=C9=CF=BA=A3=CA=D0=C6=D6=B6=AB= =D0=C2=C7=F8=BD=F0=BF=C6=C2=B72889=BA=C5=B3=A4= =CC=A9=B9=E3=B3=A1A=D7=F9603

=CA=D6=BB=FA=A3=BA13671935540

=D3=CA=CF=E4=A3=BAyuan.liu@esgyn.cn

=3D"=D2=D7=BE=A8=BD=DDlogo=D6=D0=CE=C4

 

--_000_BJXPR01MB10447211054A7BA89D2AA6AE2E30BJXPR01MB104CHNPR0_-- --_004_BJXPR01MB10447211054A7BA89D2AA6AE2E30BJXPR01MB104CHNPR0_--