Revision 48310
Added by Tsampikos Livisianos almost 7 years ago
| modules/dnet-openaire-stats/trunk/src/main/resources/eu/dnetlib/data/mapreduce/hbase/statsExport/stats_db_schema.sql | ||
|---|---|---|
| 974 | 974 |
|
| 975 | 975 |
CREATE TABLE "shadow".rd_distinct AS SELECT DISTINCT * FROM "shadow".result_datasources; |
| 976 | 976 |
TRUNCATE "shadow".result_datasources; |
| 977 |
INSERT INTO "shadow".result_datasources SELECT * FROM "shadow".rd_distinct; |
|
| 977 |
INSERT INTO "shadow".result_datasources SELECT * FROM "shadow".rd_distinct ORDER BY datasource;
|
|
| 978 | 978 |
DROP TABLE "shadow".rd_distinct; |
| 979 | 979 |
|
| 980 | 980 |
|
Also available in: Unified diff
make result_datasource table ordered by datasource