Revision 55878
Added by Alessia Bardi almost 5 years ago
| modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/hbase/queryDatasources.sql | ||
|---|---|---|
| 103 | 103 |
WHEN (d.typology = 'orprepository') THEN 'Repository' |
| 104 | 104 |
ELSE 'Other' |
| 105 | 105 |
END || '@@@dnet:datasource_typologies@@@dnet:datasource_typologies' AS datasourcetype, |
| 106 |
'sysimport:crosswalk:entityregistry@@@sysimport:crosswalk:entityregistry@@@dnet:provenance_actions@@@dnet:provenance_actions' AS provenanceaction |
|
| 106 |
'sysimport:crosswalk:entityregistry@@@sysimport:crosswalk:entityregistry@@@dnet:provenance_actions@@@dnet:provenance_actions' AS provenanceaction, |
|
| 107 |
CONCAT(d.issn, '@@@', d.eissn, '@@@', d.lissn) AS journal |
|
| 107 | 108 |
|
| 108 | 109 |
FROM dsm_datasources d |
| 109 | 110 |
|
| ... | ... | |
| 139 | 140 |
d.pidsystems, |
| 140 | 141 |
d.certificates, |
| 141 | 142 |
dc.id, |
| 142 |
dc.officialname |
|
| 143 |
dc.officialname, |
|
| 144 |
d.issn, |
|
| 145 |
d.eissn, |
|
| 146 |
d.lissn |
|
Also available in: Unified diff
get journal fields from the database