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 07A03200CCA for ; Wed, 19 Jul 2017 15:02:14 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 05E74168EE9; Wed, 19 Jul 2017 13:02:14 +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 4C2B2168EE8 for ; Wed, 19 Jul 2017 15:02:13 +0200 (CEST) Received: (qmail 60519 invoked by uid 500); 19 Jul 2017 13:02:12 -0000 Mailing-List: contact user-help@ignite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ignite.apache.org Delivered-To: mailing list user@ignite.apache.org Received: (qmail 60504 invoked by uid 99); 19 Jul 2017 13:02:12 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 19 Jul 2017 13:02:12 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 909B5180157 for ; Wed, 19 Jul 2017 13:02:11 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 0.203 X-Spam-Level: X-Spam-Status: No, score=0.203 tagged_above=-999 required=6.31 tests=[HTML_FONT_LOW_CONTRAST=0.001, HTML_MESSAGE=2, KAM_LAZY_DOMAIN_SECURITY=1, MIME_BASE64_TEXT=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-2.8, UNPARSEABLE_RELAY=0.001] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id 5P6PEcBZKmwo for ; Wed, 19 Jul 2017 13:02:08 +0000 (UTC) Received: from out28-121.mail.aliyun.com (out28-121.mail.aliyun.com [115.124.28.121]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id C4E765FDCB for ; Wed, 19 Jul 2017 13:02:07 +0000 (UTC) X-Alimail-AntiSpam: AC=CONTINUE;BC=0.4502074|-1;FP=0|0|0|0|0|-1|-1|-1;HT=e02c03297;MF=aaron@tophold.com;NM=1;PH=DS;RN=1;RT=1;SR=0;TI=SMTPD_---.8RjDTzd_1500469319; Received: from Aaron(mailfrom:aaron@tophold.com ip:117.144.23.106) by smtp.aliyun-inc.com(10.147.42.198); Wed, 19 Jul 2017 21:01:59 +0800 Date: Wed, 19 Jul 2017 21:02:00 +0800 From: "aaron@tophold.com" To: user Subject: Did Ignite query support embed DML ? X-Priority: 3 X-Has-Attach: no X-Mailer: Foxmail 7, 2, 7, 174[cn] Mime-Version: 1.0 Message-ID: <2017071921020028201918@tophold.com> Content-Type: multipart/alternative; boundary="----=_001_NextPart572415572466_=----" archived-at: Wed, 19 Jul 2017 13:02:14 -0000 This is a multi-part message in MIME format. ------=_001_NextPart572415572466_=---- Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: base64 aGkgQWxsLCANCg0KV2lsbCBJZ25pdGUgc3VwcG9ydCBFbWJlZCBTVU0gRE1MIExpa2UgdGhpcyBT UUwgdXBkYXRlczoNCg0KVVBEQVRFIEEgYQ0KU0VUIGEudG90YWw9KA0KICAgIFNFTEVDVCBTVU0o Yi5jbnQpDQogICAgRlJPTSBCIGINCiAgICBXSEVSRSBiLmlkID0gYS5pZA0KKQ0KDQoNCkFsd2F5 cyB0aHJvdyBhIGZhaWwgdG8gcGFyc2UgU1FMIHF1ZXJ5IGV4Y2VwdGlvbiAuIA0KDQoNCg0KDQph YXJvbkB0b3Bob2xkLmNvbQ0K ------=_001_NextPart572415572466_=---- Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <= body>=0A

hi All,

Will Igni= te support Embed SUM DML Like this SQL updates:

<= span style=3D"color: rgb(0, 0, 0); background-color: rgba(0, 0, 0, 0);">UP= DATE A a
SET a.total=3D(
  SELECT SUM(b.cnt)
  FROM B = b
  WHERE b.id =3D a.id
= )

Always throw = a fail to parse SQL query exception .

=0A<= div>

=0A

aaron@tophold.com

<= /div>=0A ------=_001_NextPart572415572466_=------