Revision 52443
Added by Claudio Atzori almost 6 years ago
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
we don't need anymore prepareQueryDatasources.sql