Revision 50431
Added by Claudio Atzori about 6 years ago
queryDatasources.sql | ||
---|---|---|
1 |
EXPLAIN SELECT
|
|
1 |
SELECT |
|
2 | 2 |
d.id AS datasourceid, |
3 | 3 |
d.id || array_agg(di.pid) AS identities, |
4 | 4 |
d.officialname AS officialname, |
... | ... | |
65 | 65 |
d.qualitymanagementkind AS qualitymanagementkind, |
66 | 66 |
d.pidsystems AS pidsystems, |
67 | 67 |
d.certificates AS certificates, |
68 |
'{}'::text[] AS policies,
|
|
68 |
ARRAY[]::text[] AS policies,
|
|
69 | 69 |
dc.id AS collectedfromid, |
70 | 70 |
dc.officialname AS collectedfromname, |
71 | 71 |
d.typology || '@@@' || d.typology || '@@@dnet:datasource_typologies@@@dnet:datasource_typologies' AS datasourcetype, |
Also available in: Unified diff
updated sql queries used to map datasources and organizations to HBase