Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id AFC68200C16 for ; Thu, 26 Jan 2017 07:07:22 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id AE1B0160B5A; Thu, 26 Jan 2017 06:07:22 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id CC911160B4E for ; Thu, 26 Jan 2017 07:07:21 +0100 (CET) Received: (qmail 58199 invoked by uid 500); 26 Jan 2017 06:07:16 -0000 Mailing-List: contact dev-help@flink.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@flink.apache.org Delivered-To: mailing list dev@flink.apache.org Received: (qmail 58187 invoked by uid 99); 26 Jan 2017 06:07:15 -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; Thu, 26 Jan 2017 06:07:15 +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 282EDC88E3 for ; Thu, 26 Jan 2017 06:07:15 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3 X-Spam-Level: *** X-Spam-Status: No, score=3 tagged_above=-999 required=6.31 tests=[RDNS_NONE=3, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id Uxy7tyLhBmcE for ; Thu, 26 Jan 2017 06:07:12 +0000 (UTC) Received: from dggrg01-dlp.huawei.com (unknown [45.249.212.187]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 403075F2F1 for ; Thu, 26 Jan 2017 06:07:11 +0000 (UTC) Received: from 172.30.72.53 (EHLO DGGEMM402-HUB.china.huawei.com) ([172.30.72.53]) by dggrg01-dlp.huawei.com (MOS 4.4.6-GA FastPath queued) with ESMTP id AIE96547; Thu, 26 Jan 2017 14:06:59 +0800 (CST) Received: from DGGEMM506-MBX.china.huawei.com ([169.254.3.117]) by DGGEMM402-HUB.china.huawei.com ([10.3.20.210]) with mapi id 14.03.0301.000; Thu, 26 Jan 2017 14:06:57 +0800 From: Zhangrucong To: "dev@flink.apache.org" CC: "wshaoxuan@gmail.com" Subject: re: STREAM SQL inner queries Thread-Topic: STREAM SQL inner queries Thread-Index: AQHSd4VKBmYE8Bli20apEGPTPT+Hi6FKP3FQ Date: Thu, 26 Jan 2017 06:06:57 +0000 Message-ID: References: <8B754047F81D6B4290B9F4CE928333A517BF18B0@lhreml503-mbx> In-Reply-To: Accept-Language: zh-CN, en-US Content-Language: zh-CN X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.177.17.163] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-CFilter-Loop: Reflected X-Mirapoint-Virus-RAPID-Raw: score=unknown(0), refid=str=0001.0A090204.58899203.009B,ss=1,re=0.000,recu=0.000,reip=0.000,cl=1,cld=1,fgs=0, ip=169.254.3.117, so=2014-11-16 11:51:01, dmn=2013-03-21 17:37:32 X-Mirapoint-Loop-Id: e04c0e5921bbc4eb9af9475465888e0b archived-at: Thu, 26 Jan 2017 06:07:22 -0000 SGk6DQogICBUaGUgZm9sbG93aW5nIHN5bnRheCwgSSB0aGluayBpdCBpcyBzdWIgcXVlcnkuIElu IHRoZSBjYWxjaXRlLCBpdCBpcyBvcHRpbWFsIHRvIHNlbWktam9pbi4NClNFTEVDVCBTVFJFQU0g YW1vdW50LA0KKFNFTEVDVCBpZCBGUk9NICBpbnB1dHN0cmVhbTEpIEFTIGZpZWxkMSBGUk9NIGlu cHV0c3RyZWFtMg0KDQogICBJbiBteSBvcGluaW9uLCBJZiB0aGUgdW5ib3VuZGVkIHN0cmVhbSBq b2luIHRoZSB1bmJvdW5kZWQgc3RyZWFtLCB0aGVyZSBpcyBubyByZXN1bHQuIFRoZSBzdHJlYW0g bWF5IGpvaW4gd2l0aCBzdHJlYW0gd2hvIGhhcyBhIHdpbmRvdyBvciB0aGUgc3RyZWFtIGNhbiBq b2luIHdpdGggYSBzdGF0aWMgdGFibGUuDQogICBCeSB0aGUgd2F5LCBzaGFveHVhbiwgeW91IHNh aWQgeW91IGFuZCBGYWJpYW4gYXJlIGRlc2lnbmluZyBkeW5hbWljIHRhYmxlLiBJdCBpcyBzb3Vu ZHMgaW50ZXJlc3RpbmcsIEkgd2lsbCBsb29rIGF0IGl0LiBLYWZrYSBzdHJlYW0gYWxzbyBwcm9w b3NlIHRoaXMgaWRlYS4gDQoNCkJlc3Qgd2lzaGVz77yBDQoNCi0tLS0t6YKu5Lu25Y6f5Lu2LS0t LS0NCuWPkeS7tuS6ujogU2hhb3h1YW4gV2FuZyBbbWFpbHRvOndzaGFveHVhbkBnbWFpbC5jb21d IA0K5Y+R6YCB5pe26Ze0OiAyMDE35bm0MeaciDI25pelIDExOjM2DQrmlLbku7bkuro6IGRldkBm bGluay5hcGFjaGUub3JnDQrkuLvpopg6IFJlOiBTVFJFQU0gU1FMIGlubmVyIHF1ZXJpZXMNCg0K IEhpIFJhZHUsDQpTaW1pbGFyIGFzIHRoZSBzdHJlYW0tc3RyZWFtIGpvaW4sIHRoaXMgc3RyZWFt LXN0cmVhbSBpbm5lciBxdWVyeSBkb2VzIG5vdCBzZWVtIHRvIGJlIHdlbGwgZGVmaW5lZC4gSXQg bmVlZHMgcHJvdmlkZSBhdCBsZWFzdCBzb21lIGtpbmQgb2Ygd2luZG93IGJvdW5kcyB0byBjb21w bGV0ZSB0aGUgc3RyZWFtaW5nIFNRTCBzZW1hbnRpY3MuIElmIHRoaXMgaXMgYW4gdW5ib3VuZGVk IGpvaW4vc2VsZWN0LCBhIG1lY2hhbmlzbSBvZiBob3cgdG8gc3RvcmUgdGhlIGluZmluaXRlIGRh dGUgaGFzIHRvIGJlIGNvbnNpZGVyZWQuIEkgbWF5IG5vdCBmdWxseSB1bmRlcnN0YW5kIHlvdXIg cHJvcG9zYWwuIENvdWxkIHlvdSBwbGVhc2UgcHJvdmlkZSBtb3JlIGRldGFpbHMgYWJvdXQgdGhp cyBpbm5lciBxdWVyeSwgc2F5IGdpdmluZyBzb21lIGV4YW1wbGVzIG9mIGlucHV0IGFuZCBvdXRw dXQuIEl0IHdvdWxkIGJlIGFsc28gZ3JlYXQgaWYgeW91IGNhbiBleHBsYWluIHRoZSB1c2UgY2Fz ZSBvZiB0aGlzIGlubmVyIHF1ZXJ5LiBUaGlzIGhlbHBzIHVzIHRvIHVuZGVyc3RhbmQgdGhlIHNl bWFudGljcy4NCg0KSXQgc2hvdWxkIGFsc28gYmUgbm90ZWQgdGhhdCwgd2UgaGF2ZSByZWNlbnRs eSBkZWNpZGVkIHRvIHVuaWZ5IHN0cmVhbSBhbmQgYmF0Y2ggcXVlcnkgd2l0aCB0aGUgc2FtZSBy ZWd1bGFyIChiYXRjaCkgU1FMLiBUaGVyZWZvcmUgd2UgaGF2ZSByZW1vdmVkIHRoZSBzdXBwb3J0 IGZvciBTVFJFQU0ga2V5d29yZCBpbiBmbGluayBTdHJlYW1pbmcgU1FMLiBJbiB0aGUgcGFzdCBz ZXZlcmFsIG1vbnRocywgRmFiaWFuIGFuZCBYaWFvd2VpIEppYW5nIGhhdmUgc3RhcnRlZCB0byB3 b3JrIG9uIHRoZSBmdXR1cmUgUmVsYXRpb25hbCBRdWVyaWVzIG9uIGZsaW5rIHN0cmVhbWluZy4g RmFiaWFuIGhhcyBkcmFmdGVkIGEgdmVyeSBnb29kIGRlc2lnbiBkb2MsIGh0dHBzOi8vZ29vLmds L20zMWtrRS4gVGhlIGRlc2lnbiBpcyBiYXNlZCBvbiBhIG5ldyBjb25jZXB0IG9mIGR5bmFtaWMg dGFibGUgd2hvc2UgY29udGVudCBjaGFuZ2VzIG92ZXIgdGltZSwgdGhlcmVieSBjYW4gYmUgZGVy aXZlZCBmcm9tIHN0cmVhbXMuIFdpdGggdGhpcyBkeW5hbWljIHRhYmxlLCBzdHJlYW0gcXVlcnkg Y2FuIGJlIGRvbmUgdmlhIHJlZ3VsYXINCihiYXRjaCkgU1FMLiBCZXNpZGVzIHNvbWUgc3ludGF4 IHN1Z2FyLCB0aGVyZSBpcyBub3QgdG9vIG11Y2ggZGlmZmVyZW5jZSBiZXR3ZWVuIGJhdGNoIHF1 ZXJ5IGFuZCBzdHJlYW0gcXVlcnkgKGluIHRlcm1zIG9mIHdoYXQgYW5kIHdoZXJlIG9mIGEgcXVl cnkgaXMgZXhlY3V0ZWQpLiBTdHJlYW0gcXVlcnkgaGFzIGFkZGl0aW9uIGNoYXJhY3RlcnMgaW4g dGhlIG1hbm5lcnMgb2Ygd2hlbiB0byBlbWl0IGEgcmVzdWx0IGFuZCBob3cgdG8gcmVmaW5lIHRo ZSByZXN1bHQgY29uc2lkZXJpbmcgdGhlIHJldHJhY3Rpb24uDQoNCkhvcGUgdGhpcyBoZWxwcyBh bmQgbG9vayBmb3J3YXJkIHRvIHdvcmtpbmcgd2l0aCB5b3Ugb24gc3RyZWFtaW5nIFNRTC4NCg0K UmVnYXJkcywNClNoYW94dWFuDQoNCg0KT24gV2VkLCBKYW4gMjUsIDIwMTcgYXQgOTo0OSBQTSwg UmFkdSBUdWRvcmFuIDxyYWR1LnR1ZG9yYW5AaHVhd2VpLmNvbT4NCndyb3RlOg0KDQo+IEhpIGFs bCwNCj4NCj4gSSB3b3VsZCBsaWtlIHRvIG9wZW4gYSBqaXJhIGlzc3VlIChhbmQgdGhlbiBwcm92 aWRlIHRoZSANCj4gaW1wbGVtZW50YXRpb24pIGZvciBzdXBwb3J0aW5nIGlubmVyIHF1ZXJpZXMu IFRoZSBpZGVhIGlzIHRvIGJlIGFibGUgDQo+IHRvIHN1cHBvcnQgU1FMIHF1ZXJpZXMgYXMgdGhl IG9uZXMgcHJlc2VudGVkIGluIHRoZSBzY2VuYXJpb3MgYmVsb3cuIA0KPiBUaGUga2V5IGlkZWEg aXMgdGhhdCBzdXBwb3J0aW5nIGlubmVyIHF1ZXJpZXMgd291bGQgcmVxdWlyZSB0byBoYXZlIHRo ZSBpbXBsZW1lbnRhdGlvbiBmb3I6DQo+DQo+IMOoIEpPSU4gKHR5cGUgPSBsZWZ0IGFuZCBjb25k aXRpb24gPSB0cnVlKSAtIEJhc2ljYWxseSB0aGlzIGlzIGEgc2ltcGxlIA0KPiBpbXBsZW1lbnRh dGlvbiBmb3IgYSBqb2luIGZ1bmN0aW9uIGJldHdlZW4gMiBzdHJlYW1zIHRoYXQgZG9lcyBub3Qg DQo+IHJlcXVpcmUgYW55IHdpbmRvdyBzdXBwb3J0IGJlaGluZCB0aGUgc2NlbmVzIGFzIHRoZXJl IGlzIG5vIGNvbmRpdGlvbiANCj4gb24gd2hpY2ggdG8gcGVyZm9ybSB0aGUgam9pbg0KPg0KPiDD qCBTSU5HTEVfVkFMVUUgLSB0aGlzIG9wZXJhdG9yIHdvdWxkIHJlcXVpcmUgdG8gcHJvdmlkZSBv bmUgdmFsdWUgdG8gDQo+IGJlIGZ1cnRoZXJlZCBqb2luZWQuIEluIHRoZSBjb250ZXh0IG9mIHN0 cmVhbWluZyB0aGlzIHZhbHVlIHNob3VsZCANCj4gYmFzaWNhbGx5IGV2b2x2ZSB3aXRoIHRoZSBj b250ZW50cyBvZiB0aGUgd2luZG93LiBUaGlzIGNvdWxkIGJlIA0KPiBpbXBsZW1lbnRlZCB3aXRo IGEgZmxhdG1hcCBmdW5jdGlvbiBhcyBsZWZ0IGpvaW5zIHdvdWxkIGFsbG93IGFsc28gdG8gDQo+ IGRvIHRoZSBtYXBwaW5nIHdpdGggbnVsbCB2YWx1ZXMNCj4NCj4gV2UgY2FuIHRoZW4gZXh0ZW5k IHRoaXMgaW5pdGlhbCBhbmQgc2ltcGxlIGltcGxlbWVudGF0aW9uIHRvIHByb3ZpZGUgDQo+IHN1 cHBvcnQgZm9yIGpvaW5zIGluIGdlbmVyYWwgKGNvbmRpdGlvbmFsIGpvaW5zLCByaWdodCBqb2lu cy4uKSBvciB3ZSANCj4gY2FuIGlzb2xhdGUgdGhpcyBpbXBsZW1lbnRhdGlvbiBmb3IgdGhpcyBz cGVjaWZpYyBjYXNlIG9mIGlubmVyIA0KPiBxdWVyaWVzIGFuZCBnbyB3aXRoIGEgdG90YWxseSBu ZXcgZGVzaWduIGZvciBzdHJlYW0gdG8gc3RyZWFtIGpvaW5zIA0KPiAobWlnaHQgYmUgbmVlZGVk IGRlcGVuZGluZyBvbiB3aGF0IGlzIHRoZSBkZWNpc2lvbiBiZWhpbmQgb24gaG93IHRvIA0KPiBz dXBwb3J0IHRoZSBjb25kaXRpb25hbA0KPiBtYXBwaW5nKQ0KPg0KPiBXaGF0IGRvIHlvdSB0aGlu ayBhYm91dCB0aGlzPw0KPg0KPiBFeGFtcGxlcyBvZiBzY2VuYXJpb3MgdG8gYXBwbHkNCj4NCj4g U0VMRUNUIFNUUkVBTSBhbW91bnQsDQo+IChTRUxFQ1QgaWQgRlJPTSAgaW5wdXRzdHJlYW0xKSBB UyBmaWVsZDEgRlJPTSBpbnB1dHN0cmVhbTINCj4NCj4gVHJhbnNsYXRlZCB0bw0KPiBMb2dpY2Fs UHJvamVjdChhbW91bnQ9WyQxXSwgYz1bJDRdKQ0KPiAgICAgTG9naWNhbEpvaW4oY29uZGl0aW9u PVt0cnVlXSwgam9pblR5cGU9W2xlZnRdKQ0KPiAgICAgICBMb2dpY2FsVGFibGVTY2FuKHRhYmxl PVtbaW5wdXRzdHJlYW0xXV0pDQo+ICAgICAgIExvZ2ljYWxBZ2dyZWdhdGUoZ3JvdXA9W3t9XSwg YWdnIzA9W1NJTkdMRV9WQUxVRSgkMCldKQ0KPiAgICAgICAgIExvZ2ljYWxQcm9qZWN0KHVzZXJf aWQ9WyQwXSkNCj4gICAgICAgICAgIExvZ2ljYWxUYWJsZVNjYW4odGFibGU9W1tpbnB1dHN0cmVh bTJdXSkNCj4NCj4gT3IgZnJvbSB0aGUgc2FtZSBzdHJlYW0gLSBwZXJoYXBzIGludGVyZXN0aW5n IGZvciBhcHBseWluZyBzb21lIG1vcmUgDQo+IGNvbXBsZXggb3BlcmF0aW9ucyB3aXRoaW4gdGhl IGlubmVyIHF1ZXJ5IFNFTEVDVCBTVFJFQU0gYW1vdW50LCANCj4gKFNFTEVDVCBpZCBGUk9NICBp bnB1dHN0cmVhbTEpIEFTIGZpZWxkMSBGUk9NIGlucHV0c3RyZWFtMQ0KPg0KPiBUcmFuc2xhdGVk IHRvDQo+IExvZ2ljYWxQcm9qZWN0KGFtb3VudD1bJDFdLCBjPVskNF0pDQo+ICAgICBMb2dpY2Fs Sm9pbihjb25kaXRpb249W3RydWVdLCBqb2luVHlwZT1bbGVmdF0pDQo+ICAgICAgIExvZ2ljYWxU YWJsZVNjYW4odGFibGU9W1tpbnB1dHN0cmVhbTFdXSkNCj4gICAgICAgTG9naWNhbEFnZ3JlZ2F0 ZShncm91cD1be31dLCBhZ2cjMD1bU0lOR0xFX1ZBTFVFKCQwKV0pDQo+ICAgICAgICAgTG9naWNh bFByb2plY3QodXNlcl9pZD1bJDBdKQ0KPiAgICAgICAgICAgTG9naWNhbFRhYmxlU2Nhbih0YWJs ZT1bW2lucHV0c3RyZWFtMV1dKQ0KPg0KPiBPciB1c2VkIHRvIGRvIHRoZSBwcm9qZWN0aW9uDQo+ IFNFTEVDVCBTVFJFQU0gYW1vdW50LCBjICBGUk9NIChTRUxFQ1QgKixpZCBBUyBjIEZST00gaW5w dXRzdHJlYW0xKQ0KPg0KPiBUcmFuc2xhdGVkIHRvDQo+ICAgTG9naWNhbFByb2plY3QoYW1vdW50 PVskMV0sIGM9WyQ1XSkNCj4gICAgIExvZ2ljYWxQcm9qZWN0KHRpbWU9WyQwXSwgYW1vdW50ID1b JDFdLCBkYXRlPVskMl0sIGlkID1bJDRdLCBjPVskNV0pDQo+ICAgICAgIExvZ2ljYWxUYWJsZVNj YW4odGFibGU9W1tpbnB1dHN0cmVhbTFdXSkNCj4NCj4NCj4gT3IgaW4gdGhlIGZ1dHVyZSBldmVu DQo+IFNFTEVDVCBTVFJFQU0gYW1vdW50LCBteWFnZyBGUk9NICAoU0VMRUNUIFNUUkVBTSAqLCBT VU0oYW1vdW50KSBPVkVSIA0KPiB3aW5kb3cgQVMgbXlhZ2cgRlJPTSBpbnB1dHN0cmVhbTEpKSAu Li4NCj4NCj4NCj4NCj4NCg==