You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ignite.apache.org by sb...@apache.org on 2015/04/07 17:02:27 UTC

[3/3] incubator-ignite git commit: ignite-437: merge

ignite-437: merge


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

Branch: refs/heads/ignite-437-sqltests-p2
Commit: 5a9a3f55f3bb75500d314e75d5eb90e1cff263da
Parents: 7b5109e
Author: Artem Shutak <as...@gridgain.com>
Authored: Tue Apr 7 18:02:21 2015 +0300
Committer: Artem Shutak <as...@gridgain.com>
Committed: Tue Apr 7 18:02:21 2015 +0300

----------------------------------------------------------------------
 .../indexing/src/test/resources/bigQuery.sql    | 55 --------------------
 1 file changed, 55 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-ignite/blob/5a9a3f55/modules/indexing/src/test/resources/bigQuery.sql
----------------------------------------------------------------------
diff --git a/modules/indexing/src/test/resources/bigQuery.sql b/modules/indexing/src/test/resources/bigQuery.sql
deleted file mode 100644
index 93b62eb..0000000
--- a/modules/indexing/src/test/resources/bigQuery.sql
+++ /dev/null
@@ -1,55 +0,0 @@
---
--- Licensed to the Apache Software Foundation (ASF) under one or more
--- contributor license agreements.  See the NOTICE file distributed with
--- this work for additional information regarding copyright ownership.
--- The ASF licenses this file to You under the Apache License, Version 2.0
--- (the "License"); you may not use this file except in compliance with
--- the License.  You may obtain a copy of the License at
---
---      http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing, software
--- distributed under the License is distributed on an "AS IS" BASIS,
--- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--- See the License for the specific language governing permissions and
--- limitations under the License.
---
-
-select *
-from (
-  select rootOrderId as custOrderId, co.date, co.orderId, replace(co.alias,'_ALGO','') as alias, op.parentAlgo
-  from (
-	select  date, orderId, rootOrderId, origOrderId, archSeq, alias 
-	from "part".CustOrder where alias='CUSTOM'
-	
-	union all
-	
-	select  date, orderId, refOrderId as origOrderId, rootOrderId, archSeq, alias 
-	from "part".ReplaceOrder where alias='CUSTOM'
-  ) co, "part".OrderParams op
-  where co.date = op.date and co.orderId = op.orderId and co.archSeq = -- TODO: replace with 'dateToLong(co.date)+archSeq'.
-	(
-	  select max(archSeq) -- TODO: replace with 'dateToLong(co.date)+archSeq'.
-	  from (
-		  select  date, orderId, rootOrderId, origOrderId, archSeq, alias 
-		  from "part".CustOrder where alias='CUSTOM'
-		  
-		  union all
-		  
-		  select  date, orderId, refOrderId as origOrderId, rootOrderId, archSeq, alias 
-		  from "part".ReplaceOrder where alias='CUSTOM'
-	  ) 
-	  where origOrderId = co.origOrderId and date = co.date
-	) and co.alias='CUSTOM'
-) cop 
-inner join (
-  select e.date, e.rootOrderId as eRootOrderId, e.rootOrderId, sum(e.execShares) as execShares, 
-	sum(e.execShares*e.price)/sum(e.execShares) as price,
-	case when min(e.lastMkt) = max(e.lastMkt) then min(e.lastMkt) else min('XOFF') end as execMeet
-  from "repl".Exec e
-  group by e.date, e.rootOrderId
-) oep on (cop.date = oep.date and cop.custOrderId = oep.eRootOrderId)
-left outer join (
-  select top 1 refOrderId, date from "part".Cancel
-) cc on (cc.refOrderId = cop.orderId and cc.date = cop.date)
-where cop.alias='CUSTOM'