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