Revision 29650
Added by Eri Katsari over 10 years ago
| modules/dnet-openaire-stats/trunk/src/main/resources/eu/dnetlib/data/mapreduce/hbase/statsExport/stats_db_schema.sql | ||
|---|---|---|
| 153 | 153 |
(SELECT maxdays FROM "shadow".daysfromend WHERE "shadow".daysfromend.project_results = shadow.project.project_results); |
| 154 | 154 |
|
| 155 | 155 |
|
| 156 |
--drop view shadow.daysfromend;
|
|
| 157 |
--drop view shadow.project_pub_count;
|
|
| 158 |
--drop table shadow.project_results_publication CASCADE ;
|
|
| 156 |
drop view shadow.daysfromend; |
|
| 157 |
drop view shadow.project_pub_count; |
|
| 158 |
drop table shadow.project_results_publication CASCADE ; |
|
| 159 | 159 |
|
| 160 | 160 |
--UPDATE "shadow"."project" SET haspubs='yes' |
| 161 | 161 |
--WHERE id in (select project from shadow.result_projects, |
| ... | ... | |
| 184 | 184 |
--WHERE shadow.result.result_projects = shadow.result_projects.id and |
| 185 | 185 |
--shadow.result.type='publication' and project="shadow"."project".id); |
| 186 | 186 |
-- |
| 187 |
|
|
| 187 |
--THIS IS SUPPOSEDLY DONE ON MR JOB--> CHECK AGAIN |
|
| 188 | 188 |
--shadow.results_publication |
| 189 | 189 |
--UPDATE "shadow"."result" SET delayed = 'yes' WHERE id IN (SELECT id FROM "shadow"."result_projects" WHERE "shadow"."result_projects".id = "shadow"."result".id AND daysfromend > 0); |
| 190 | 190 |
|
Also available in: Unified diff