Project

General

Profile

« Previous | Next » 

Revision 52443

we don't need anymore prepareQueryDatasources.sql

View differences:

modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/test/profiles/openaireplus/workflows/hbase/db2hbase.xml
15 15
				<DESCRIPTION>start</DESCRIPTION>
16 16
				<PARAMETERS/>
17 17
				<ARCS>
18
					<ARC to="prepareQueryDatasources"/>
19
				</ARCS>
20
			</NODE>
21
			<NODE name="prepareQueryDatasources" type="ExecuteSql">
22
				<DESCRIPTION>query Datasources</DESCRIPTION>
23
				<PARAMETERS>
24
					<PARAM managedBy="system" name="dbProperty" required="true" type="string">dnet.openaire.db.name</PARAM>
25
					<PARAM managedBy="system" name="sql" required="true" type="string">
26
						/eu/dnetlib/msro/openaireplus/workflows/hbase/prepareQueryDatasources.sql
27
					</PARAM>
28
				</PARAMETERS>
29
				<ARCS>
30 18
					<ARC to="queryDatasources"/>
31 19
				</ARCS>
32 20
			</NODE>
modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/hbase/prepareQueryDatasources.sql
1
CREATE OR REPLACE VIEW temp_compliances AS
2
	SELECT
3
		a.id                 AS api,
4
		a.compatibilityclass AS compliance
5
	FROM
6
		api a
7
	WHERE
8
		a.id NOT IN (SELECT api
9
		             FROM apicollections
10
		             WHERE param = 'overriding_compliance')
11
	UNION SELECT
12
		      a.id        AS api,
13
		      ac.original AS compliance
14
	      FROM
15
		      api a LEFT OUTER JOIN apicollections ac ON (ac.api = a.id)
16
	      WHERE
17
		      ac.param = 'overriding_compliance';

Also available in: Unified diff