ignite-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From voze...@apache.org
Subject [6/7] ignite git commit: WIP
Date Thu, 24 Aug 2017 14:57:40 GMT
WIP


Project: http://git-wip-us.apache.org/repos/asf/ignite/repo
Commit: http://git-wip-us.apache.org/repos/asf/ignite/commit/a90b0592
Tree: http://git-wip-us.apache.org/repos/asf/ignite/tree/a90b0592
Diff: http://git-wip-us.apache.org/repos/asf/ignite/diff/a90b0592

Branch: refs/heads/alpha_long_ids
Commit: a90b05925995ade0bb792903783e17ab6479570c
Parents: 543b1c8
Author: devozerov <vozerov@gridgain.com>
Authored: Thu Aug 24 17:29:25 2017 +0300
Committer: devozerov <vozerov@gridgain.com>
Committed: Thu Aug 24 17:29:25 2017 +0300

----------------------------------------------------------------------
 examples/src/main/java/alpha/sql_03.txt | 25 -------------------------
 1 file changed, 25 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/ignite/blob/a90b0592/examples/src/main/java/alpha/sql_03.txt
----------------------------------------------------------------------
diff --git a/examples/src/main/java/alpha/sql_03.txt b/examples/src/main/java/alpha/sql_03.txt
deleted file mode 100644
index 51ea4ea..0000000
--- a/examples/src/main/java/alpha/sql_03.txt
+++ /dev/null
@@ -1,25 +0,0 @@
-SELECT
-    TRADER,
-
-	CASE CUR_NO
-        WHEN 1 THEN CURRENCY1
-        WHEN 2 THEN CURRENCY2
-    END AS CURRENCY,
-
-    DEAL_TYPE,
-    FAR_LEG,
-    SUM(ABS(CUR1_AMOUNT))
-
-FROM OrderPojo
-    INNER JOIN CONTRACTORS.Contractor as contractors ON (OrderPojo.BUYER_LEGAL_ENTITY = contractors.ID_LE
OR OrderPojo.SELLER_LEGAL_ENTITY = contractors.ID_LE)
-    CROSS JOIN (SELECT C1 CUR_NO FROM (VALUES (1), (2)) AS V) AS CURS
-
-GROUP BY
-    TRADER,
-    CASE CUR_NO
-        WHEN 1 THEN CURRENCY1
-        WHEN 2 THEN CURRENCY2
-	END,
-
-	DEAL_TYPE,
-    FAR_LEG
\ No newline at end of file


Mime
View raw message