dnet40/modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/hbase/prepareQueryDatasources.sql @ 31240
| 1 | 29934 | michele.ar | 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'; |