Changes between Version 29 and Version 30 of CookBook join ROE_RHT

Timestamp:

Nov 3, 2011 10:57:09 AM (13 years ago)

Author:

celine

Comment:

--

CookBook join ROE_RHT

@@ -215 +215 @@
 create table rht.rht_bdcarthage_roev2_nbdams as
 select id_drain, count(nbdams) as nbdams from rht.rht_bdcarthage_roev2 as r group by id_drain;
-}}}
+
+alter table rht.rht_bdcarthage_roev2_nbdams add column c_height integer;
+alter table rht.rht_bdcarthage_roev2_nbdams add column c_score integer;
+update rht.rht_bdcarthage_roev2_nbdams set c_height=1;
+update rht.rht_bdcarthage_roev2_nbdams set c_score=1;
+}}}