Project

General

Profile

Download (534 Bytes) Statistics
| Revision:

dnet45/modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/hbase/querySimilarityFromOpenOrgsDB.sql @ 57437

1 
SELECT local_id AS id1, oa_original_id AS id2 FROM openaire_simrels WHERE reltype = 'is_similar'
2 

    		
  

  

    
      3
    
    
      
UNION ALL


    		
  

  

    
      4
    
    
      

    		
  

  

    
      5
    
    
      
SELECT


    		
  

  

    
      6
    
    
      
	o.id                                                     AS id1,


    		
  

  

    
      7
    
    
      
	'openorgsmesh'||substring(o.id, 13)||'-'||md5(a.acronym) AS id2


    		
  

  

    
      8
    
    
      
FROM acronyms a


    		
  

  

    
      9
    
    
      
	LEFT OUTER JOIN organizations o ON (a.id = o.id)


    		
  

  

    
      10
    
    
      

    		
  

  

    
      11
    
    
      
UNION ALL


    		
  

  

    
      12
    
    
      
		


    		
  

  

    
      13
    
    
      
SELECT


    		
  

  

    
      14
    
    
      
	o.id                                                     AS id1,


    		
  

  

    
      15
    
    
      
	'openorgsmesh'||substring(o.id, 13)||'-'||md5(n.name)    AS id2


    		
  

  

    
      16
    
    
      
FROM other_names n


    		
  

  

    
      17
    
    
      
	LEFT OUTER JOIN organizations o ON (n.id = o.id)


    		
  









  (11-11/11)