5 | | * care dintre motivele de fault apare cel mai des in event-uri event_trace.event_end_reason - claudiu |
6 | | * care este durata medie a event-urilor - cristina |
7 | | * MapReduce DONE |
8 | | * Pig DONE |
9 | | * ce componenta apare cel mai des in fault event-uri component.component_type code - claudiu |
10 | | * avand event-urile impartite pe categorii dupa durata, care este cauza de fault cea mai intalnita pe fiecare categ event_trace.event_end_reason - cristina [-> sch in enumerarea pe fiecare categ a numarului de joburi terminate din fiecare cauza frecventa (>1000 failed)] |
11 | | * MapReduce DONE |
12 | | * Pig DONE |
13 | | * pt fiecare categ din event_trace.event_end_reason code ranges, care dintre event_trace.event_end_reason code definitions apare cel mai des (numarul de dati cat apare fiecare..) - claudiu |
14 | | * in ce locatie geografica sunt nodurile pe care se inregistreaza cele mai multe failure-uri (node_location luat uitandu-ne dupa node_id din event_trace) - cristina |
15 | | * MapReduce DONE |
16 | | * Pig DONE |
| 5 | |
| 6 | Below there is a short description of each application: |
| 7 | a. Which one of the fault reasons is the most frequent? This application uses the event_trace table, looking at event_end_reason column |
| 8 | b. Which is the medium duration for events? This application uses the event_trace table, looking at event_start_time and event_end_time columns |
| 9 | c. Which component is the most frequent as a fault cause? This application uses the event_trace table, using the component_id column and also the table component table, looking at component_type column |
| 10 | d. Having a classification for job duration as short, medium and long, find out the most frequent (>1000) causes of failures for each of these categories. It uses event_trace table, looking at event_start_time and event_end_time columns and also event_trace.event_end_reason code table. |
| 11 | e. For each category from event_trace.event_end_reason code ranges, which of event_trace.event_end_reason code definitions is the most frequent? |
| 12 | f. Number of failures for each geographical location. This application uses |
| 13 | |
| 14 | |
| 15 | |
| 16 | and the approach used for each of the three mediums. |
| 17 | |
| 18 | |
| 19 | |