Project

General

Profile

« Previous | Next » 

Revision 57392

Added by Michele Artini almost 5 years ago

temporary test

View differences:

modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/hbase/queryOrganizationsFromOpenOrgsDB.sql
13 13 
	'OpenOrgs Database'                                                                                                           AS collectedfromname,
14 14 
	o.country || '@@@dnet:countries'                                                                                              AS country,
15 15 
	'sysimport:crosswalk:entityregistry@@@sysimport:crosswalk:entityregistry@@@dnet:provenance_actions@@@dnet:provenance_actions' AS provenanceaction,
16 
	array_agg(DISTINCT i.otherid || '###' || i.type)                                                                              AS pid
16 
	--array_agg(DISTINCT i.otherid || '###' || i.type)                                                                              AS pid
17 
	ARRAY[]::text[]                                           AS pid
17 18 
FROM organizations o
18 19 
	LEFT OUTER JOIN acronyms a    ON (a.id = o.id)
19 20 
	LEFT OUTER JOIN urls u        ON (u.id = o.id)

Also available in: Unified diff