dnet40/modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/hbase/prepareQueryDatasources.sql @ 39849
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 from apicollections WHERE param = 'overriding_compliance') |
9 |
UNION SELECT |
10 |
a.id as api, |
11 |
ac.original as compliance |
12 |
FROM
|
13 |
api a LEFT OUTER JOIN apicollections ac ON (ac.api = a.id) |
14 |
WHERE
|
15 |
ac.param = 'overriding_compliance'; |