Revision 53455
Added by Claudio Atzori over 5 years ago
queryOrganizations.sql | ||
---|---|---|
23 | 23 |
d.id AS collectedfromid, |
24 | 24 |
d.officialname AS collectedfromname, |
25 | 25 |
|
26 |
o.country || '@@@' || o.country || '@@@dnet:countries@@@dnet:countries' AS country,
|
|
26 |
o.country || '@@@dnet:countries' AS country,
|
|
27 | 27 |
'sysimport:crosswalk:entityregistry@@@sysimport:crosswalk:entityregistry@@@dnet:provenance_actions@@@dnet:provenance_actions' AS provenanceaction, |
28 | 28 |
|
29 | 29 |
ARRAY[]::text[] AS pid |
Also available in: Unified diff
resolve country codes in the mapping towards hbasee