Revision 29682
Added by Eri Katsari almost 10 years ago
| modules/dnet-openaire-stats/trunk/src/main/resources/eu/dnetlib/data/mapreduce/hbase/statsExport/stats_db_schema.sql | ||
|---|---|---|
| 139 | 139 |
--HAS PUBS |
| 140 | 140 |
UPDATE "shadow"."project" SET haspubs='yes' WHERE project_results in (select project_results from shadow.project_results_publication ); |
| 141 | 141 |
|
| 142 |
--COUNT PUBS
|
|
| 142 |
--COUNT PUBS |
|
| 143 | 143 |
|
| 144 | 144 |
|
| 145 |
UPDATE "shadow"."project" SET numpubs=(SELECT count from shadow.project_pub_count WHERE shadow.project_pub_count.project_results = shadow.project.project_results ); |
|
| 145 |
UPDATE "shadow"."project" SET numpubs=(SELECT count from shadow.project_pub_count |
|
| 146 |
WHERE shadow.project_pub_count.project_results = shadow.project.project_results ) |
|
| 147 |
where "shadow"."project".project_results in ( SELECT "shadow".project_results_publication.project_results FROM shadow.project_results_publication ); |
|
| 146 | 148 |
|
| 147 | 149 |
--delayedpubs PUBS |
| 148 | 150 |
|
| 149 | 151 |
UPDATE "shadow"."project" SET delayedpubs = ( SELECT count from shadow.daysfromend |
| 150 |
WHERE shadow.daysfromend.project_results = shadow.project.project_results) where "shadow"."project".project_results in ( SELECT "shadow".project_results_publication.project_results FROM shadow.project_results_publication ); |
|
| 152 |
WHERE shadow.daysfromend.project_results = shadow.project.project_results) |
|
| 153 |
where "shadow"."project".project_results in ( SELECT "shadow".project_results_publication.project_results FROM shadow.project_results_publication ); |
|
| 151 | 154 |
|
| 152 | 155 |
UPDATE "shadow"."project" SET daysforlastpub = |
| 153 | 156 |
(SELECT maxdays FROM "shadow".daysfromend WHERE "shadow".daysfromend.project_results = shadow.project.project_results) |
Also available in: Unified diff