From dev-return-30298-archive-asf-public=cust-asf.ponee.io@ignite.apache.org Tue Jan 23 09:39:33 2018 Return-Path: X-Original-To: archive-asf-public@eu.ponee.io Delivered-To: archive-asf-public@eu.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by mx-eu-01.ponee.io (Postfix) with ESMTP id 9CD54180621 for ; Tue, 23 Jan 2018 09:39:33 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 8C4F9160C39; Tue, 23 Jan 2018 08:39:33 +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 D0A44160C17 for ; Tue, 23 Jan 2018 09:39:32 +0100 (CET) Received: (qmail 31522 invoked by uid 500); 23 Jan 2018 08:39:31 -0000 Mailing-List: contact dev-help@ignite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@ignite.apache.org Delivered-To: mailing list dev@ignite.apache.org Received: (qmail 31510 invoked by uid 99); 23 Jan 2018 08:39:31 -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; Tue, 23 Jan 2018 08:39:31 +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 82B6F180162 for ; Tue, 23 Jan 2018 08:39:30 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.192 X-Spam-Level: * X-Spam-Status: No, score=1.192 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001, URI_HEX=1.313] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com 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 vhS9ynRizaxy for ; Tue, 23 Jan 2018 08:39:27 +0000 (UTC) Received: from mail-lf0-f52.google.com (mail-lf0-f52.google.com [209.85.215.52]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 3D35A5FC75 for ; Tue, 23 Jan 2018 08:39:26 +0000 (UTC) Received: by mail-lf0-f52.google.com with SMTP id k19so14023054lfj.1 for ; Tue, 23 Jan 2018 00:39:26 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:message-id:subject:to:date:in-reply-to:references:mime-version :content-transfer-encoding; bh=jthPQXdHoX78sBzsfG52rKXcacvUMqf4c0DiFY+XsiQ=; b=a9zwyYt/imwoCMnE3gxMVSZxpq6ZO+hUtVEqMJ0+dMqiwEgH6yoicZZXzKHi91DkQq 88flJ6MK9x+FYCMeKlnVYoUOb+73CtSZHDay4BAs+c0EUgtow8Lcg/ebJiBjeamI3L5l Wxnw6dfM/7HtK7gRn9sAUmdySVKA/DxornnwjbmO6gOLowm/Mv84GVL5zHWPudkSzTOo NvwEy5RPDwZFN1w8geTDjxa9mLcw+bzTXnT6dxamUFI0yj2UrjghyIgD7Mm4OcR21PC5 zCcynuV2Jp7MsSMGCmSU0ZzB/Cj+rXwmvGqcsN7YfdCKzXPU8W7P8GOiVT+MVgYR1/4k YC3A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:message-id:subject:to:date:in-reply-to :references:mime-version:content-transfer-encoding; bh=jthPQXdHoX78sBzsfG52rKXcacvUMqf4c0DiFY+XsiQ=; b=eFprCP2Czz/CPsxvWeeE7q9StcZmvbOazsoJ69I3rUSo/q8X5NpueuAh4+LEHrKftX LUlN3u0Vakhey6eN8gZGDFlBYaYqZzxKNB34AzenHETj6fCmH77Gyynaqg4eawDwX1kU khuq4DY3+w41hLv+guE/RC8/c9xOSy5c0g4jK9A7pER7jq0Tfqkkcl66wVkgLP8phDk5 n2lBPgZXez69RmXMfGHRYhrzV4TxwwHq6dEWyFnLfgtVg6yYCj9J89RFKw/trwRK4B/7 /GUd678OYH50facCcXLXsNiQ8a3agZ432mvNX4i+LQ/MCCGX6eom1w3InZaI7Zd50Gac +XGg== X-Gm-Message-State: AKwxytfdaHgDkyLkz/wdNavW2z0zB2T9n/VnLI/LQad8cwJUiOUYOfjU 6J/3xj2t3ThQf9ZUYNf5bHOMhIHH X-Google-Smtp-Source: AH8x224odKmWCemyVrZz+uv28r40P/h7TDGgiXYreagBCsbBjBkyW4kMGpnv94NckvY0CkHuVbSfKg== X-Received: by 10.25.203.195 with SMTP id b186mr915537lfg.76.1516696764793; Tue, 23 Jan 2018 00:39:24 -0800 (PST) Received: from newDragon ([194.186.207.245]) by smtp.googlemail.com with ESMTPSA id w143sm2813763lff.52.2018.01.23.00.39.23 (version=TLS1_2 cipher=ECDHE-RSA-CHACHA20-POLY1305 bits=256/256); Tue, 23 Jan 2018 00:39:23 -0800 (PST) From: Nikolay Izhikov X-Google-Original-From: Nikolay Izhikov Message-ID: <1516696763.19714.20.camel@gmail.com> Subject: Re: [SparkDataFrame] Query Optimization. Prototype To: dev@ignite.apache.org, "vozerov@gridgain.com" Date: Tue, 23 Jan 2018 11:39:23 +0300 In-Reply-To: <1516694756635-0.post@n4.nabble.com> References: <1516358652.21113.22.camel@gmail.com> <1516594787.19714.11.camel@gmail.com> <1516694756635-0.post@n4.nabble.com> Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.26.1-1 Mime-Version: 1.0 Content-Transfer-Encoding: 8bit Serge, thank you! Vladimir, guys, can you take a look at another questions: * Can I know scale and precision of DECIMAL column? Example - [3] * Ignite have some limitation for a *distributed* join. For example, we can execute join only for indexed columns. Example - [4]. * Do we have documentation for all limitations of distributed join implementation? * How can I know whether concrete syntactically correct SQL query with join can be executed by Ignite or not? [3] https://gist.github.com/nizhikov/2d67ed68afd473d7251dab7d79135513 [4] https://gist.github.com/nizhikov/a4389fd78636869dd38c13920b5baf2b В Вт, 23/01/2018 в 01:05 -0700, Serge Puchnin пишет: > yes, the Cust function is supporting both Ignite and H2. > > I've updated the documentation for next system functions: > CASEWHEN Function, CAST, CONVERT, TABLE > > https://apacheignite-sql.readme.io/docs/system-functions > > And for my mind, next functions aren't applicable for Ignite: > ARRAY_GET, ARRAY_LENGTH, ARRAY_CONTAINS, CSVREAD, CSVWRITE, DATABASE, > DATABASE_PATH, DISK_SPACE_USED, FILE_READ, FILE_WRITE, LINK_SCHEMA, > MEMORY_FREE, MEMORY_USED, LOCK_MODE, LOCK_TIMEOUT, READONLY, CURRVAL, > AUTOCOMMIT, CANCEL_SESSION, IDENTITY, NEXTVAL, ROWNUM, SCHEMA, > SCOPE_IDENTITY, SESSION_ID, SET, TRANSACTION_ID, TRUNCATE_VALUE, USER, > H2VERSION > > Also an issue was created for review current documentation: > https://issues.apache.org/jira/browse/IGNITE-7496 > > -- > BR, > Serge > > > > -- > Sent from: http://apache-ignite-developers.2346864.n4.nabble.com/