From user-zh-return-951-archive-asf-public=cust-asf.ponee.io@flink.apache.org Tue Aug 27 03:37:51 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id 63FDB180645 for ; Tue, 27 Aug 2019 05:37:51 +0200 (CEST) Received: (qmail 41993 invoked by uid 500); 27 Aug 2019 03:37:48 -0000 Mailing-List: contact user-zh-help@flink.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-zh@flink.apache.org Delivered-To: mailing list user-zh@flink.apache.org Received: (qmail 41981 invoked by uid 99); 27 Aug 2019 03:37:47 -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; Tue, 27 Aug 2019 03:37:47 +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 82CC1C0327 for ; Tue, 27 Aug 2019 03:37:46 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 0.051 X-Spam-Level: X-Spam-Status: No, score=0.051 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=qq.com Received: from mx1-he-de.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id q4E60HK0g1LQ for ; Tue, 27 Aug 2019 03:37:44 +0000 (UTC) Received-SPF: Pass (mailfrom) identity=mailfrom; client-ip=52.59.177.22; helo=smtpbgeu1.qq.com; envelope-from=3149768603@qq.com; receiver= Received: from smtpbgeu1.qq.com (smtpbgeu1.qq.com [52.59.177.22]) by mx1-he-de.apache.org (ASF Mail Server at mx1-he-de.apache.org) with ESMTPS id BCA5F7DD51 for ; Tue, 27 Aug 2019 03:37:42 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=qq.com; s=s201512; t=1566877059; bh=DExH7o8Icr8UwxrslxNcLR1f8eL/Ggs0FeQfYRzTUsY=; h=From:Mime-Version:Subject:Message-Id:Date:To; b=UujmQJVf9Wm9xpN9HrZR3s8IN0unmgpPt5P5rh+fKZVSVYdd0JyNJsQThvWW7kAdo MdS6atgjIYPNlCrPV0uyTNgt77hfaVYf+fDl6TDEX8bhjfhol9HmYdV9lhK92hZnQN ZjKpTFRRwYnQvalZ6s6mmBuDO49fC6Jy1KILOhEU= X-QQ-mid: esmtp7t1566877058t7ik13pol Received: from [192.168.131.40] (unknown [202.106.149.212]) by esmtp4.qq.com (ESMTP) with SMTP id 0 for ; Tue, 27 Aug 2019 11:37:37 +0800 (CST) X-QQ-SSF: 0000000000000010E61200000000002 X-QQ-FEAT: Wjunm3IyNsFjj07nlsCO61DPaX1V1SkqlMF1NJDvLKY+w35kMpASEh8WspSwN IYu6G82s98UZhM1lS4lwIhwyS+jpyvIqZHyf81uc3o6VJe+m2+QbWom7FBF8DhQrXVgCoeK R0wQ9eHxSZZW+MJyNT6ykJWYfCrnzHnJo1+LuXNrRjh/IqeAxwCvmagRhesujI70JKTeJjP YDjO1eONmrAguDI26scrYBHhTjAzt+mtdyPD/XzjdNZ5NCnSV8w7B44wSii+71YBD2fMfF5 MwHA== X-QQ-GoodBg: 0 From: ddwcg <3149768603@qq.com> Content-Type: text/plain; charset=gb2312 Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Mac OS X Mail 11.2 \(3445.5.20\)) Subject: =?gb2312?B?yrXKsbzGy+PVvLHItcTOyszi?= Message-Id: Date: Tue, 27 Aug 2019 11:37:36 +0800 To: user-zh@flink.apache.org X-Mailer: Apple Mail (2.3445.5.20) X-QQ-SENDSIZE: 520 Feedback-ID: esmtp:qq.com:bgforeign:bgforeign2 X-QQ-Bgrelay: 1 =D2= =BB=D5=C5=B1=ED=D7=F6=D7=D4=B9=D8=C1=AA=A3=AC=C8=BB=BA=F3=C7=F3=C1=BD=B8=F6= =C1=A3=B6=C8=B5=C4=D5=BC=B1=C8=A3=BB=B1=C8=C8=E7=CF=C2=C3=E6=C7=F3=D4=C2=CF= =FA=CA=FD=B6=EE=D5=BC=C4=EA=CF=FA=CA=DB=B6=EE=B5=C4=B1=C8=C0=FD=A3=ACappen= dTable=CA=C7=B4=D3=C9=CF=D3=CE=D3=C3=B9=F6=B6=AF=B4=B0=BF=DA=BC=C6=CB=E3=B5= =C4=C1=F7=D7=A2=B2=E1=B5=C4=A3=ACtumble_end_time=CA=C7=C4=B3=B8=F6=B4=B0=BF= =DA=B5=C4=BD=E1=CA=F8=CA=B1=BC=E4=A3=AC=C7=EB=CE=CA=D5=E2=D1=F9inner = join =BB=E1=B6=AA=CA=FD=BE=DD=C2=F0=A3=BF=D3=D0=B8=FC=BA=C3=B5=C4=B7=BD=B7= =A8=BC=C6=CB=E3=D5=BC=B1=C8=C2=F0=A3=BF select months,monthAmount/yearAmount as amountRate from (select months,years,amount as monthAmount,tumble_end_time from = appendTable) a join (select years,tumble_end_time,sum(amount) as yearAmount from appendTable = group by years,tumble_end_time)b on a.years=3Db.years and a.tumble_end_time=3Db.tumble_end_time ;