sql scripts for 1.1

sql scripts for 1.1

Demonstrate that the number of network paths between any two datacenters is finite. The finite number of network paths can be demonstrated via analysis of the frequency of observing new paths between any 2 sampled endpoints (i.e., source and destination datacenters). This study expected to confirm existing work that demonstrates that path popularity is heavily skewed towards a few paths that are used predominantly and extend this earlier work by demonstrating that the same holds true for the private network of a cloud provider.
Answer the following questions: For a given pair of source and destination datacenters, how often do we observe a new path that was not seen previously? What can we say about the probability of observing a new path, after considering measurements over 1 hour, 1 day, and 1 week? Are newly encountered paths used frequently?
BUG=

[Wei Wang, 2017-10-15 22:24:45]

https://codereview.appspot.com/331000043/diff/20001/task1_2.sql
File task1_2.sql (right):

https://codereview.appspot.com/331000043/diff/20001/task1_2.sql#newcode16
task1_2.sql:16: create table t12 as select e1.id, e1.idPath, e1.idPath src,
e2.idPath dst, e1.time from_time, e2.time to_time, (e2.time -e1.time) as
duration from Table12 e1 INNER JOIN Table12 e2 on e2.id =e1.id +1;
What does "e1" means here? Another table?

[manu_chaud, 2017-10-15 22:31:42]

https://codereview.appspot.com/331000043/diff/20001/task1_1.sql
File task1_1.sql (right):

https://codereview.appspot.com/331000043/diff/20001/task1_1.sql#newcode14
task1_1.sql:14: drop procedure if exists wk;
afaik, no need to indent the last two lines?

https://codereview.appspot.com/331000043/diff/20001/task1_1.sql#newcode23
task1_1.sql:23: end $$
indentation doesn't seem even -- this corresponds to the begin statement, I
guess

https://codereview.appspot.com/331000043/diff/20001/task1_2.sql
File task1_2.sql (right):

https://codereview.appspot.com/331000043/diff/20001/task1_2.sql#newcode16
task1_2.sql:16: create table t12 as select e1.id, e1.idPath, e1.idPath src,
e2.idPath dst, e1.time from_time, e2.time to_time, (e2.time -e1.time) as
duration from Table12 e1 INNER JOIN Table12 e2 on e2.id =e1.id +1;
On 2017/10/15 22:24:44, Wei Wang wrote:
> What does "e1" means here? Another table?

This is just an alias for the table named Table12