Revision 50433
Added by Claudio Atzori about 6 years ago
modules/dnet-openaireplus-workflows/branches/dsm/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/hbase/queryOrganizations.sql | ||
---|---|---|
96 | 96 |
o.country || '@@@' || o.country || '@@@dnet:countries@@@dnet:countries' AS country, |
97 | 97 |
'sysimport:crosswalk:entityregistry@@@sysimport:crosswalk:entityregistry@@@dnet:provenance_actions@@@dnet:provenance_actions' AS provenanceaction, |
98 | 98 |
|
99 |
'{NULL}'::text[] AS pid
|
|
99 |
ARRAY[]::text[] AS pid
|
|
100 | 100 |
FROM dsm_organizations o |
101 | 101 |
LEFT OUTER JOIN dsm_datasources d ON (d.id = o.collectedfrom); |
102 | 102 |
|
Also available in: Unified diff
updated sql query used to map organizations to HBase