LEI'S DESIGN SERVICES

EXPERIENCED IN CHIP DESIGN VERIFICATION

Chapter 5:  MapReduce Summary of Data Analysis Reports Using Java

 

 Figure 3   Mega Millions Data Extraction MapReduce Diagram

 

5.1 Dataset

Source: 360 total test analysis reports located in this HDFS path: /output/Samplingperiod_AnalysisTypeAnalysis/part-r-00000 since there are 36 test analysis reports for each sampling period, and there are 10 sampling periods.  In addition, /input/megamillionAnalysisType.txt will list the 36 test analysis types while /input/megamillionPeriod.txt will list the 10 sampling periods where Samplingperiods are 2005to2005, 2006to2005, 2007to2005, 2008to2005, 2009to2005, 2010to2005, 2011to2005, 2012to2005, 2013to2005, and 2014to2005.

Analysis types are listed in megamillionAnalysisType.txt are are listed as follow below:

 

top6  1

top5Nmega   2

top5numsNmega       3

individualtop5Nmega 4

top62            5

top5Nmega2 6

top5numsNmega2     7

individualtop5Nmega2           8

top63            9

top5Nmega3 10

top5numsNmega3     11

individualtop5Nmega3           12

top6R            13

top5NmegaR 14

top5numsNmegaR     15

individualtop5NmegaR           16

top62R          17

top5Nmega2R           18

top5numsNmega2R   19

individualtop5Nmega2R         20

top63R          21

top5Nmega3R           22

top5numsNmega3R   23

individualtop5Nmega3R         24

individualtop5NmegaSL1       25

individualtop5NmegaSL2       26

individualtop5NmegaSL3       27

individualtop5NmegaSL4       28

all6med         29

all6avg           30

bottomall6     31

individualbottomall6   32

all6medR       33

all6avgR        34

bottomall6R   35

individualbottomall6R 36

 

5.2 Problem Statement

Extract the 360 test analysis report into one summary report.  To extract the data, I need Java programs.  The summary report can be exported to MYSQL from HDFS using Sqoop.

 

5.3 Approach

Need Java programs to extract all the test analysis reports into one summarize report.  There are 1 main, 2 mapper, and 1 reducer classes as shown in Figure 3 above.  The main class is megamillionDataExtraction.java.  The mapper classes are analysisTypeMapper.java  and periodMapper.java.  The reducer class is megamillionDataExtractionReducer.java.  To run the Java hadoop jar file, need a linux script.  The name of jar file is megamillionDataExtraction.jar, and the name  of unix shell script file is runmegamillionAnalysis.

 

5.4 Code

Java main class file name:  megamillionDataExtraction.java

Code content:

package com.analysis;

 

import org.apache.hadoop.conf.Configuration;

import org.apache.hadoop.conf.Configured;

import org.apache.hadoop.fs.Path;

import org.apache.hadoop.io.IntWritable;

import org.apache.hadoop.io.NullWritable;

import org.apache.hadoop.io.Text;

import org.apache.hadoop.mapreduce.lib.input.TextInputFormat;

import org.apache.hadoop.mapreduce.Job;

import org.apache.hadoop.mapreduce.lib.input.FileInputFormat;

 

import org.apache.hadoop.mapreduce.lib.input.MultipleInputs;

import org.apache.hadoop.mapreduce.lib.output.FileOutputFormat;

import org.apache.hadoop.mapreduce.lib.output.MultipleOutputs;

import org.apache.hadoop.mapreduce.lib.output.TextOutputFormat;

import org.apache.hadoop.util.GenericOptionsParser;

import org.apache.hadoop.util.Tool;

import org.apache.hadoop.util.ToolRunner;

 

         //Driver code for winning number analysis

         public class megamillionDataExtraction  extends Configured implements Tool{

          

                  public int run(String[] args) throws Exception

                  {

                     Configuration conf = new Configuration();

                     String[] otherArgs = new GenericOptionsParser(conf, args).get

RemainingArgs();

                    

                     if (args.length != 3) {

                              System.err.println("Usage:  hadoop jar megamillionDataExtraction.jar com.analysis.megamillionDataExtraction <input path1> <input path 2> <output path1>");

                              System.err.printf("Argument length: %d", args.length);         

                             

                              System.exit(-1);

                     }

                    

                     Job job = new Job(conf, "megamillionDataExtraction");

                    

                     job.setJarByClass(megamillionDataExtraction.class);

                     job.setReducerClass(megamillionDataExtractionReducer.class);

                    

                     job.setMapOutputKeyClass(Text.class);

                     job.setMapOutputValueClass(Text.class);

                    

                     job.setOutputKeyClass(Text.class);

                     job.setOutputValueClass(Text.class);

                    

                           MultipleInputs.addInputPath(job,new Path(args[0]),TextInputFormat.class, analysisTypeMapper.class);

 

                     MultipleInputs.addInputPath(job,new Path(args[1]),TextInputFormat.class, periodMapper.class);

                    FileOutputFormat.setOutputPath(job,  new Path(otherArgs[2]));

 

                     MultipleOutputs.addNamedOutput(job, "Period", TextOutputFormat.class, NullWritable.class, Text.class);

 

                     System.exit(job.waitForCompletion(true) ? 0 : 1);

                     boolean success = job.waitForCompletion(true);

                     return success ? 0 : 1;

                    

         }

          public static void main(String[] args) throws Exception {

              megamillionDataExtraction driver = new megamillionDataExtraction();

              int exitCode = ToolRunner.run(driver, args);

              System.exit(exitCode);   

              }

      }

 

Java mapper 1 class file name:  analysisTypeMapper.java

Code content:

package com.analysis;

 

import org.apache.hadoop.io.LongWritable;

import org.apache.hadoop.io.Text;

import org.apache.hadoop.mapreduce.Mapper;

import java.io.IOException;

 

public class analysisTypeMapper extends Mapper<LongWritable, Text, Text, Text> {

         private Text typ = new Text();

         public void map(LongWritable key, Text value, Context context) throws

            IOException, InterruptedException {

                     String line = value.toString();

 

                     String[] array = line.split("\t");

                     typ = new Text(array[0]);     

                     context.write(new Text("AnalysisType"),  typ);

         }

}  //end of analysisTypeMapper class

 

 

 

 Java mapper 2 class file name:  periodMapper.java

Code content:

package com.analysis;

import org.apache.hadoop.io.LongWritable;

import org.apache.hadoop.io.Text;

import org.apache.hadoop.mapreduce.Mapper;

import org.apache.hadoop.mapreduce.lib.output.MultipleOutputs;

 

import java.io.IOException;

 

public class periodMapper extends Mapper<LongWritable, Text, Text, Text> {

            private Text per = new Text();

               public void map(LongWritable key, Text value, Context context) throws

                  IOException, InterruptedException {

                           String line = value.toString();

 

                           String[] array = line.split("\t");

                           per = new Text(array[0]);

 

                           context.write(new Text("Period"),  per);

);

                                       }

}  //end of periodMapper class

 

Java reducer class file name:  megamillionDataExtractionReducer.java

Code content:

package com.analysis;

 

import org.apache.hadoop.fs.FileSystem;

import org.apache.hadoop.fs.Path;

import org.apache.hadoop.io.NullWritable;

import org.apache.hadoop.io.Text;

import org.apache.hadoop.mapreduce.Reducer;

import org.apache.hadoop.mapreduce.lib.output.MultipleOutputs;

 

import java.io.BufferedReader;

import java.io.FileReader;

import java.io.IOException;

import java.io.InputStreamReader;

import java.util.Scanner;

 

public class megamillionDataExtractionReducer extends Reducer<Text, Text, Text, Text> {

   private MultipleOutputs<Text, Text> mos;

    public void setup(Context context) {

               mos = new MultipleOutputs(context);

    }

   

   String line = null;

 

    String[] typ = new String[36];

    String[] per = new String[11];

    String[] data = new String[6];

    String temp = null;

         String[] temp2 = new String[2];;

         String hdfscmd =  null;

   

    String grep6nums = null;

    String grep5nums = null;

    String grep4numsNmega = null;

    String grep4nums = null;

    String grep3numsNmega = null;

    String grep3nums = null;

    String grep2numsNmega = null;

    String grep1numNmega = null;

    String grepmega =   null;

    String grepprofit = null;

    String grepwinning = null; 

    int i = 0;

    int j = 0;

    int k = 0;

    int m = 0;

    int n = 0;   

    int winNumCount = 0; //5 winning number comparison count against 6

   comparison numbers

    int megaCount = 0; //mega number comparison count against 6 comparison numbers

    int win6nums = 0; //any 6 numbers

    int win5nums = 0; //any 5 numbers

    int win4numsNmega = 0; //any 4 numbers and 1 mega number

    int win4nums = 0; //any 4 numbers

    int win3numsNmega = 0; //any 3 numbers and 1 mega number

    int win3nums = 0; //any 3 numbers

    int win2numsNmega = 0; //any 2 numbers and 1 mega number

    int win2nums = 0; //any 2 numbers

    int win1numNmega = 0; //any 1 number and 1 mega number

    int win1num = 0; //any 1 number

    int winmeganum = 0; //1 mega number

    int winNonum = 0; //no number

    int profit = 0; //profit or loss

    int statTotal = 0;

    int statwin6nums = 0;

    int statwin5nums = 0;

    int statwin4numsNmega = 0;

     int statwin4nums = 0;

 

    int statwin3numsNmega = 0;

    int statwin3nums = 0;

    int statwin2numsNmega = 0;

    int statwin2nums = 0;

    int statwin1numNmega = 0;

    int statwin1num = 0;

    int statwinmeganum = 0;

    int statwinNonum = 0;

    int winpercent = 0;

 

     public void reduce(Text key, Iterable<Text> values, Context context)  

      throws IOException, InterruptedException {                

 

                      for (Text text : values) {

                          line = text.toString();

                          context.write(key, new Text(line));

                          if (key.equals(new Text("AnalysisType"))) {

                                                          

                                         if (i < 36) {

                                    typ[i] = line;

                                    

                                            i++;

                                         }

                                         else i = 0;

                          }

                 
                   else if (key.equals(new Text("Period"))) {

                                              
                           if (j < 10) {
                               per[j] = line;
                               j++;    
                           }
                           else if (j == 10) {           
    for (m = 0; m < 10; m++) {
        //System.out.printf("printout period[%d]: %s.\n", m, per[m]);
        
        for (k = 0; k < 36; k++) {
                               //from HDFS extract the data using unix commands
                    hdfscmd =  "hdfs:///output/" + per[m] + "_"  + typ[k] + "Analysis/part-r-00000";
                    //Process phdfscmd = Runtime.getRuntime().exec(hdfscmd);

             grep6nums = "Any 6 numbers:                    ";
            grep5nums = "Any 5 numbers:                    ";
              grep4numsNmega = "Any 4 numbers and 1 mega number:  ";
              grep4nums = "Any 4 numbers:                    ";
              grep3numsNmega = "Any 3 numbers and 1 mega number:  ";
              grep3nums = "Any 3 numbers:                    ";
              grep2numsNmega = "Any 2 numbers and 1 mega number:  ";
              grep1numNmega = "Any 1 number and 1 mega number:   ";

                   grep1numNmega = "Any 1 number and 1 mega number:   ";

                   grepmega =   "1 mega number:                    ";

                   grepprofit = "Profit or loss:                   ";

                   grepwinning = "Winning Percentage:               ";

                   

     Path pt=new Path(hdfscmd); //"part-r-00000");

     FileSystem fs = FileSystem.get(context.getConfiguration());

              

    // Read part-r-00000

        try {

                  BufferedReader in=new BufferedReader(new InputStreamReader(fs.open(pt)));

            System.out.printf("I am reading %s.\n", hdfscmd);

                  String line;

                 line = in.readLine();

                 while (line != null){

    

           data = line.split("\t");

           if (data[0].equals(grep6nums)) {

                  temp = data[2].replace("is", "");

                  temp = temp.replace("% of total # of tickets sold", "");

                  temp2 = temp.split(" ");

                  win6nums = Integer.parseInt(temp2[0]);

                  System.out.printf("Winning 6 numbers: %d.\n", win6nums);

                      }

           else if (data[0].equals(grep5nums)) {

                  temp = data[2].replace("is", "");

                  temp = temp.replace("% of total # of tickets sold", "");

                  temp2 = temp.split(" ");

                  win5nums   = Integer.parseInt(temp2[0]);

 

                  System.out.printf("Winning 5 numbers: %d.\n", win5nums);

                   }

           else if (data[0].equals(grep4numsNmega)) {

 

                  temp = data[2].replace("is", "");

                  temp = temp.replace("% of total # of tickets sold", "");

                  temp2 = temp.split(" ");

                  win4numsNmega = Integer.parseInt(temp2[0]);

                  System.out.printf("Winning 4 numbers and mega number: %d.\n",

 win4numsNmega);

                   

                   }

          else if (data[0].equals(grep4nums )) {

 

                 temp = data[2].replace("is", "");

               temp = temp.replace("% of total # of tickets sold", "");

 

               temp2 = temp.split(" ");

              win4nums            = Integer.parseInt(temp2[0]);

               System.out.printf("Winning 4 numbers: %d.\n", win4nums);

                

                            }

         else if (data[0].equals(grep3numsNmega)) {

 

             temp = data[2].replace("is", "");

               temp = temp.replace("% of total # of tickets sold", "");

               temp2 = temp.split(" ");

             win3numsNmega            = Integer.parseInt(temp2[0]);

               System.out.printf("Winning 3 numbers and mega number: %d.\n",

win3numsNmega);

                

                            }

        else if (data[0].equals(grep3nums)) {

 

                    temp = data[2].replace("is", "");

               temp = temp.replace("% of total # of tickets sold", "");

               temp2 = temp.split(" ");

                    win3nums = Integer.parseInt(temp2[0]);

               System.out.printf("Winning 3 numbers: %d.\n", win3nums);

                

                            }

       else if (data[0].equals(grep2numsNmega)) {

 

               temp = data[2].replace("is", "");

               temp = temp.replace("% of total # of tickets sold", "");

               temp2 = temp.split(" ");

 

               win2numsNmega            = Integer.parseInt(temp2[0]);

               System.out.printf("Winning 2 numbers and mega number: %d.\n", win2numsNmega);

                             

                            }

      else if (data[0].equals(grep1numNmega)) {

 

              temp = data[2].replace("is", "");

               temp = temp.replace("% of total # of tickets sold", "");

               temp2 = temp.split(" ");

              win1numNmega            = Integer.parseInt(temp2[0]);

               System.out.printf("Winning 1 number and mega number: %d.\n", win1numNmega);

 

                }

     else if (data[0].equals(grepmega)) {

 

          temp = data[2].replace("is", "");

            temp = temp.replace("% of total # of tickets sold", "");

            temp2 = temp.split(" ");

          winmeganum         = Integer.parseInt(temp2[0]);

            System.out.printf("Winning mega number: %d.\n", winmeganum);

              

             }

    else if (data[0].equals(grepprofit)) {

 

             temp = data[2].replace("$", "");

             profit         = Integer.parseInt(temp);

            System.out.printf("Profit or loss: %d.\n", profit);

             

             }

   else if (data[0].equals(grepwinning)) {

 

            temp = data[2].replace("%", "");

            winpercent         = Integer.parseInt(temp);

            System.out.printf("Winning Percentage: %d.\n", winpercent);

  }         

           line = in.readLine();

           //System.out.printf("Line2: %s\n", line);              

  }

           mos.write("Period", NullWritable.get(), new Text(per[m] + typ[k] + ","

 + per[m] + "," + typ[k] + "," +

                    Integer.toString(win6nums) + "," + Integer.toString(

win5nums) + ","

                    + Integer.toString(win4numsNmega) + "," +

Integer.toString(win4nums) + "," +

                Integer.toString(win3numsNmega) + "," + Integer.toString(win3nums)

 

+

 "," + Integer.toString(win2numsNmega) + "," +

                               Integer.toString(win1numNmega) + "," + Integer.toString(

winmeganum) + "," +

                                   Integer.toString(profit) + "," + Integer.toString(winpercent)));

 

            in.close();

            }

            catch (IOException e) {}

 

             } //end of for k loop

 

  }

 

         j = 0; //if j == 11 reset j = 0

 } //end of if (j == 11) loop

 

                                }       //end of if ("Period") loop             

  

                            } // end of for (text: text Value) loop

 

           }

           

} //end of megamillionDataExtractionReducer class

 

 

File name:  runmegamillionAnalysis

Command: ./ runmegamillionAnalysis

Code content:

hdfs dfs -rmr /output/megamillionDataExtraction

hadoop jar megamillionDataExtraction.jar com.analysis.megamillionDataExtraction

/input/megamillionAnalysisType.txt /input/megamillionPeriod.txt /output/megamillionDataExtraction

 

5.5 Execution

Output summary report file name: /output/megamillionDataExtraction/Period-r-00000

Where the cloumns are separated by a ‘,’. 

The columns are ID, Period, AnalysisType, Win6nums, Win5nums, Win4numsNmega , Win4nums, Win3numsNmega,  Win3nums, Win2numsNmega, Win1numNmega , Winmega, Profit, and WinPercent in sequential order where ID = Period and AnalysisType columns are concatenated, Period=sampling period, AnalysisType = Testing Analysis Type, Win6nums=Winning 6 numbers, Win5nums=Winning 5 numbers, Win4numsNmega=Winning 4 numbers and a mega number, Win4nums=Winning 4 numbers, Win3numsNmega=Winning 3 numbers and a mega number,  Win3nums=Winning 3 numbers, Win2numsNmega=Winning 2 numbers and a mega number, Win1numNmega=Winning 1 number and a mega number,

Winmega=Winning a mega number, Profit=profit or losss, and WinPercent=Winning Percentage.

 

 

Command:

 hdfs dfs -cat /output/megamillionDataExtraction/Period-r-00000

 

Code content:

OpenJDK Server VM warning: You have loaded library /home/notroot/lab/software/hadoop-2.6.0/lib/native/libhadoop.so.1.0.0 which might have disabled stack guard. The VM will try to fix the stack guard now.

It's highly recommended that you fix the library with 'execstack -c <libfile>', or link it with '-z noexecstack'.

15/09/08 18:49:28 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable

2014to2005individualbottomall6R,2014to2005,individualbottomall6R,0,0,0,0,0,0,0,0,0,-53,0

2014to2005bottomall6R,2014to2005,bottomall6R,0,0,0,0,0,0,0,0,0,-53,0

2014to2005all6avgR,2014to2005,all6avgR,0,0,0,0,0,0,0,0,0,-53,0

2014to2005all6medR,2014to2005,all6medR,0,0,0,0,0,0,0,0,0,-53,0

2014to2005individualbottomall6,2014to2005,individualbottomall6,0,0,0,0,0,0,0,0,0,-53,0

2014to2005bottomall6,2014to2005,bottomall6,0,0,0,0,0,0,0,0,0,-53,0

2014to2005all6avg,2014to2005,all6avg,0,0,0,0,0,0,0,0,0,-53,0

2014to2005all6med,2014to2005,all6med,0,0,0,0,0,0,0,0,0,-53,0

2014to2005individualtop5NmegaSL4,2014to2005,individualtop5NmegaSL4,0,0,0,0,0,0,0,0,0,-53,0

2014to2005individualtop5NmegaSL3,2014to2005,individualtop5NmegaSL3,0,0,0,0,0,0,0,0,0,-53,0

2014to2005individualtop5NmegaSL2,2014to2005,individualtop5NmegaSL2,0,0,0,0,0,0,0,0,0,-53,0

2014to2005individualtop5NmegaSL1,2014to2005,individualtop5NmegaSL1,0,0,0,0,0,0,0,2,2,-47,8

2014to2005individualtop5Nmega3R,2014to2005,individualtop5Nmega3R,0,0,0,0,0,0,0,0,2,-51,4

2014to2005top5numsNmega3R,2014to2005,top5numsNmega3R,0,0,0,0,0,0,0,0,2,-51,4

2014to2005top5Nmega3R,2014to2005,top5Nmega3R,0,0,0,0,0,0,0,0,3,-50,6

2014to2005top63R,2014to2005,top63R,0,0,0,0,0,0,0,0,0,-53,0

2014to2005individualtop5Nmega2R,2014to2005,individualtop5Nmega2R,0,0,0,0,0,0,0,2,1,-48,6

2014to2005top5numsNmega2R,2014to2005,top5numsNmega2R,0,0,0,0,0,0,0,2,1,-48,6

2014to2005top5Nmega2R,2014to2005,top5Nmega2R,0,0,0,0,0,0,0,1,2,-49,6

2014to2005top62R,2014to2005,top62R,0,0,0,0,0,0,0,0,0,-53,0

2014to2005individualtop5NmegaR,2014to2005,individualtop5NmegaR,0,0,0,0,0,0,0,1,5,-46,11

2014to2005top5numsNmegaR,2014to2005,top5numsNmegaR,0,0,0,0,0,0,0,2,4,-45,12

2014to2005top5NmegaR,2014to2005,top5NmegaR,0,0,0,0,0,0,0,2,5,-44,13

2014to2005top6R,2014to2005,top6R,0,0,0,0,0,0,0,0,0,-53,0

2014to2005individualtop5Nmega3,2014to2005,individualtop5Nmega3,0,0,0,0,0,0,0,0,1,-52,2

2014to2005top5numsNmega3,2014to2005,top5numsNmega3,0,0,0,0,0,0,0,0,0,-53,0

2014to2005top5Nmega3,2014to2005,top5Nmega3,0,0,0,0,0,0,0,0,3,-50,6

2014to2005top63,2014to2005,top63,0,0,0,0,0,0,0,0,3,-50,6

2014to2005individualtop5Nmega2,2014to2005,individualtop5Nmega2,0,0,0,0,0,1,0,1,6,-36,15

2014to2005top5numsNmega2,2014to2005,top5numsNmega2,0,0,0,0,0,0,0,0,0,-53,0

2014to2005top5Nmega2,2014to2005,top5Nmega2,0,0,0,0,0,0,0,2,2,-47,8

2014to2005top62,2014to2005,top62,0,0,0,0,0,0,0,0,0,-53,0

2014to2005individualtop5Nmega,2014to2005,individualtop5Nmega,0,0,0,0,0,0,0,2,3,-46,10

2014to2005top5numsNmega,2014to2005,top5numsNmega,0,0,0,0,0,0,0,0,0,-53,0

2014to2005top5Nmega,2014to2005,top5Nmega,0,0,0,0,0,0,1,2,2,-41,10

2014to2005top6,2014to2005,top6,0,0,0,0,0,0,0,0,0,-53,0

 2013to2005individualbottomall6R,2013to2005,individualbottomall6R,0,0,0,0,0,0,0,0,0,-157,0

2013to2005bottomall6R,2013to2005,bottomall6R,0,0,0,0,0,0,0,0,0,-157,0

2013to2005all6avgR,2013to2005,all6avgR,0,0,0,0,0,0,0,0,0,-157,0

2013to2005all6medR,2013to2005,all6medR,0,0,0,0,0,0,0,0,0,-157,0

2013to2005individualbottomall6,2013to2005,individualbottomall6,0,0,0,0,0,0,0,0,0,-157,0

2013to2005bottomall6,2013to2005,bottomall6,0,0,0,0,0,0,0,0,0,-157,0

2013to2005all6avg,2013to2005,all6avg,0,0,0,0,0,0,0,0,0,-157,0

2013to2005all6med,2013to2005,all6med,0,0,0,0,0,0,0,0,0,-157,0

2013to2005individualtop5NmegaSL4,2013to2005,individualtop5NmegaSL4,0,0,0,0,0,0,0,0,0,-157,0

2013to2005individualtop5NmegaSL3,2013to2005,individualtop5NmegaSL3,0,0,0,0,0,0,0,0,0,-157,0

2013to2005individualtop5NmegaSL2,2013to2005,individualtop5NmegaSL2,0,0,0,0,0,0,0,0,0,-157,0

2013to2005individualtop5NmegaSL1,2013to2005,individualtop5NmegaSL1,0,0,0,0,0,0,0,5,6,-141,7

2013to2005individualtop5Nmega3R,2013to2005,individualtop5Nmega3R,0,0,0,0,0,0,0,0,0,-157,0

2013to2005top5numsNmega3R,2013to2005,top5numsNmega3R,0,0,0,0,0,0,0,0,0,-157,0

2013to2005top5Nmega3R,2013to2005,top5Nmega3R,0,0,0,0,0,0,0,7,8,-135,9

2013to2005top63R,2013to2005,top63R,0,0,0,0,0,0,0,0,0,-157,0

2013to2005individualtop5Nmega2R,2013to2005,individualtop5Nmega2R,0,0,0,0,0,0,0,0,0,-157,0

2013to2005top5numsNmega2R,2013to2005,top5numsNmega2R,0,0,0,0,0,0,0,0,0,-157,0

2013to2005top5Nmega2R,2013to2005,top5Nmega2R,0,0,0,0,0,0,0,0,0,-157,0

2013to2005top62R,2013to2005,top62R,0,0,0,0,0,1,0,4,3,-137,6

2013to2005individualtop5NmegaR,2013to2005,individualtop5NmegaR,0,0,0,0,0,0,0,0,0,-157,0

2013to2005top5numsNmegaR,2013to2005,top5numsNmegaR,0,0,0,0,0,0,0,0,0,-157,0

2013to2005top5NmegaR,2013to2005,top5NmegaR,0,0,0,0,0,1,0,0,0,-148,1

2013to2005top6R,2013to2005,top6R,0,0,0,0,0,0,0,2,6,-147,5

2013to2005individualtop5Nmega3,2013to2005,individualtop5Nmega3,0,0,0,0,0,0,0,3,8,-143,7

2013to2005top5numsNmega3,2013to2005,top5numsNmega3,0,0,0,0,0,0,0,2,5,-148,4

2013to2005top5Nmega3,2013to2005,top5Nmega3,0,0,0,0,0,0,0,0,0,-157,0

2013to2005top63,2013to2005,top63,0,0,0,0,0,0,1,1,5,-144,5

2013to2005individualtop5Nmega2,2013to2005,individualtop5Nmega2,0,0,0,0,0,0,0,2,13,-140,9

2013to2005top5numsNmega2,2013to2005,top5numsNmega2,0,0,0,0,0,0,0,0,11,-146,7

 2013to2005top5Nmega2,2013to2005,top5Nmega2,0,0,0,0,0,0,0,0,0,-157,0

2013to2005top62,2013to2005,top62,0,0,0,0,0,0,0,1,7,-148,5

2013to2005individualtop5Nmega,2013to2005,individualtop5Nmega,0,0,0,0,0,0,0,5,6,-141,7

2013to2005top5numsNmega,2013to2005,top5numsNmega,0,0,0,0,0,0,0,0,0,-157,0

2013to2005top5Nmega,2013to2005,top5Nmega,0,0,0,0,0,2,0,0,0,-139,1

2013to2005top6,2013to2005,top6,0,0,0,0,0,1,0,0,0,-148,1

2012to2005individualbottomall6R,2012to2005,individualbottomall6R,0,0,0,0,1,0,0,4,2,-198,3

2012to2005bottomall6R,2012to2005,bottomall6R,0,0,0,0,0,0,0,0,0,-262,0

2012to2005all6avgR,2012to2005,all6avgR,0,0,0,0,0,0,0,0,0,-262,0

2012to2005all6medR,2012to2005,all6medR,0,0,0,0,0,0,0,0,0,-262,0

2012to2005individualbottomall6,2012to2005,individualbottomall6,0,0,0,1,0,0,0,1,1,459,0

2012to2005bottomall6,2012to2005,bottomall6,0,0,0,0,0,1,0,0,0,-253,0

2012to2005all6avg,2012to2005,all6avg,0,0,0,0,0,2,0,0,2,-242,2

2012to2005all6med,2012to2005,all6med,0,0,0,0,0,2,0,0,2,-242,2

2012to2005individualtop5NmegaSL4,2012to2005,individualtop5NmegaSL4,0,0,0,1,0,1,0,0,0,465,0

2012to2005individualtop5NmegaSL3,2012to2005,individualtop5NmegaSL3,0,0,0,0,0,1,1,0,4,-243,2

2012to2005individualtop5NmegaSL2,2012to2005,individualtop5NmegaSL2,0,0,0,0,0,1,1,0,0,-247,0

2012to2005individualtop5NmegaSL1,2012to2005,individualtop5NmegaSL1,0,0,0,0,0,2,0,5,5,-229,5

2012to2005individualtop5Nmega3R,2012to2005,individualtop5Nmega3R,0,0,0,0,0,0,2,3,14,-230,7

2012to2005top5numsNmega3R,2012to2005,top5numsNmega3R,0,0,0,0,0,0,2,3,14,-230,7

2012to2005top5Nmega3R,2012to2005,top5Nmega3R,0,0,0,0,1,0,1,6,5,-185,4

2012to2005top63R,2012to2005,top63R,0,0,0,0,0,0,0,0,0,-262,0

2012to2005individualtop5Nmega2R,2012to2005,individualtop5Nmega2R,0,0,0,0,0,0,0,3,8,-248,4

2012to2005top5numsNmega2R,2012to2005,top5numsNmega2R,0,0,0,0,0,0,3,4,12,-224,8

2012to2005top5Nmega2R,2012to2005,top5Nmega2R,0,0,0,0,0,1,0,0,1,-252,0

2012to2005top62R,2012to2005,top62R,0,0,0,0,0,0,0,2,9,-249,4

2012to2005individualtop5NmegaR,2012to2005,individualtop5NmegaR,0,0,0,0,0,2,0,0,1,-243,1

2012to2005top5numsNmegaR,2012to2005,top5numsNmegaR,0,0,0,0,0,0,0,0,1,-261,0

2012to2005top5NmegaR,2012to2005,top5NmegaR,0,0,0,0,0,1,0,2,1,-248,1

2012to2005top6R,2012to2005,top6R,0,0,0,0,0,1,0,0,0,-253,0

2012to2005individualtop5Nmega3,2012to2005,individualtop5Nmega3,0,0,0,0,0,1,2,4,11,-222,7

2012to2005top5numsNmega3,2012to2005,top5numsNmega3,0,0,0,0,0,0,0,4,8,-246,5

2012to2005top5Nmega3,2012to2005,top5Nmega3,0,0,0,0,0,1,0,1,2,-249,1

2012to2005top63,2012to2005,top63,0,0,0,0,1,2,0,1,7,-181,4

2012to2005individualtop5Nmega2,2012to2005,individualtop5Nmega2,0,0,0,0,0,0,0,5,14,-238,7

2012to2005top5numsNmega2,2012to2005,top5numsNmega2,0,0,0,0,0,1,0,0,0,-253,0

2012to2005top5Nmega2,2012to2005,top5Nmega2,0,0,0,0,0,0,0,0,3,-259,1

2012to2005top62,2012to2005,top62,0,0,0,0,0,0,0,0,0,-262,0

2012to2005individualtop5Nmega,2012to2005,individualtop5Nmega,0,0,0,1,0,0,1,5,8,480,5

2012to2005top5numsNmega,2012to2005,top5numsNmega,0,0,0,0,0,2,0,0,0,-244,1

2012to2005top5Nmega,2012to2005,top5Nmega,0,0,0,0,0,2,0,0,1,-243,1

2012to2005top6,2012to2005,top6,0,0,0,0,0,2,0,0,0,-244,1

2011to2005individualbottomall6R,2011to2005,individualbottomall6R,0,0,0,0,0,0,0,1,7,-357,2

2011to2005bottomall6R,2011to2005,bottomall6R,0,0,0,0,0,0,0,5,3,-353,2

2011to2005all6avgR,2011to2005,all6avgR,0,0,0,0,0,2,0,3,1,-341,2

2011to2005all6medR,2011to2005,all6medR,0,0,0,0,0,3,0,2,1,-334,2

2011to2005individualbottomall6,2011to2005,individualbottomall6,0,0,0,0,0,0,0,2,4,-358,2

2011to2005bottomall6,2011to2005,bottomall6,0,0,0,0,0,1,0,0,0,-357,0

2011to2005all6avg,2011to2005,all6avg,0,0,0,0,0,5,0,1,4,-315,2

2011to2005all6med,2011to2005,all6med,0,0,0,0,0,2,0,0,0,-348,1

2011to2005individualtop5NmegaSL4,2011to2005,individualtop5NmegaSL4,0,0,0,0,0,2,0,0,0,-348,1

2011to2005individualtop5NmegaSL3,2011to2005,individualtop5NmegaSL3,0,0,0,0,0,1,0,0,0,-357,0

2011to2005individualtop5NmegaSL2,2011to2005,individualtop5NmegaSL2,0,0,0,0,0,1,0,2,1,-352,1

2011to2005individualtop5NmegaSL1,2011to2005,individualtop5NmegaSL1,0,0,0,0,0,1,0,5,7,-340,3

2011to2005individualtop5Nmega3R,2011to2005,individualtop5Nmega3R,0,0,0,0,1,0,0,6,14,-286,6

2011to2005top5numsNmega3R,2011to2005,top5numsNmega3R,0,0,0,0,0,3,3,6,12,-297,7

2011to2005top5Nmega3R,2011to2005,top5Nmega3R,0,0,0,0,0,5,0,1,3,-316,2

2011to2005top63R,2011to2005,top63R,0,0,0,0,0,1,0,2,1,-352,1

2011to2005individualtop5Nmega2R,2011to2005,individualtop5Nmega2R,0,0,0,0,0,1,0,6,7,-338,4

2011to2005top5numsNmega2R,2011to2005,top5numsNmega2R,0,0,0,0,0,2,0,2,11,-333,5

2011to2005top5Nmega2R,2011to2005,top5Nmega2R,0,0,0,0,0,2,0,4,8,-332,4

2011to2005top62R,2011to2005,top62R,0,0,0,0,0,1,0,2,3,-350,2

2011to2005individualtop5NmegaR,2011to2005,individualtop5NmegaR,0,0,0,0,0,0,1,1,3,-355,1

2011to2005top5numsNmegaR,2011to2005,top5numsNmegaR,0,0,0,0,0,2,0,3,2,-340,3

2011to2005top5NmegaR,2011to2005,top5NmegaR,0,0,0,0,0,0,1,0,2,-358,1

2011to2005top6R,2011to2005,top6R,0,0,0,0,0,0,0,3,3,-357,2

2011to2005individualtop5Nmega3,2011to2005,individualtop5Nmega3,0,0,0,0,0,1,1,3,10,-335,4

2011to2005top5numsNmega3,2011to2005,top5numsNmega3,0,0,0,0,0,1,0,3,13,-338,5

2011to2005top5Nmega3,2011to2005,top5Nmega3,0,0,0,1,0,2,0,4,4,382,3

2011to2005top63,2011to2005,top63,0,0,0,0,0,1,2,4,8,-329,4

2011to2005individualtop5Nmega2,2011to2005,individualtop5Nmega2,0,0,0,0,0,2,0,8,11,-321,6

2011to2005top5numsNmega2,2011to2005,top5numsNmega2,0,0,0,0,0,0,0,5,2,-354,2

2011to2005top5Nmega2,2011to2005,top5Nmega2,0,0,0,0,0,0,0,0,2,-364,1

2011to2005top62,2011to2005,top62,0,0,0,0,0,1,2,2,2,-339,3

2011to2005individualtop5Nmega,2011to2005,individualtop5Nmega,0,0,0,0,0,1,1,7,8,-329,4

2011to2005top5numsNmega,2011to2005,top5numsNmega,0,0,0,0,0,3,0,0,0,-339,1

2011to2005top5Nmega,2011to2005,top5Nmega,0,0,0,0,0,2,1,1,3,-337,2

2011to2005top6,2011to2005,top6,0,0,0,0,0,2,0,0,0,-348,1

2010to2005individualbottomall6R,2010to2005,individualbottomall6R,0,0,0,0,0,0,1,2,6,-454,1

2010to2005bottomall6R,2010to2005,bottomall6R,0,0,0,0,0,3,0,7,14,-415,5

2010to2005all6avgR,2010to2005,all6avgR,0,0,0,0,0,1,0,4,4,-449,2

2010to2005all6medR,2010to2005,all6medR,0,0,0,0,0,3,0,2,2,-437,1

2010to2005individualbottomall6,2010to2005,individualbottomall6,0,0,0,0,0,1,2,2,6,-439,1

2010to2005bottomall6,2010to2005,bottomall6,0,0,0,0,0,3,0,0,0,-443,1

2010to2005all6avg,2010to2005,all6avg,0,0,0,0,0,1,2,2,6,-439,1

2010to2005all6med,2010to2005,all6med,0,0,0,0,0,3,0,2,2,-437,1

2010to2005individualtop5NmegaSL4,2010to2005,individualtop5NmegaSL4,0,0,0,0,0,3,0,0,0,-443,1

2010to2005individualtop5NmegaSL3,2010to2005,individualtop5NmegaSL3,0,0,0,0,0,2,0,0,0,-452,0

2010to2005individualtop5NmegaSL2,2010to2005,individualtop5NmegaSL2,0,0,0,0,0,1,0,3,2,-453,1

2010to2005individualtop5NmegaSL1,2010to2005,individualtop5NmegaSL1,0,0,0,0,0,2,0,5,11,-431,3

2010to2005individualtop5Nmega3R,2010to2005,individualtop5Nmega3R,0,0,0,0,0,0,0,5,12,-553,3

2010to2005top5numsNmega3R,2010to2005,top5numsNmega3R,0,0,0,0,0,2,0,6,8,-537,2

2010to2005top5Nmega3R,2010to2005,top5Nmega3R,0,0,0,0,0,3,0,3,9,-533,4

2010to2005top63R,2010to2005,top63R,0,0,0,0,0,1,0,4,7,-551,2

2010to2005individualtop5Nmega2R,2010to2005,individualtop5Nmega2R,0,0,0,0,0,1,0,5,11,-440,3

2010to2005top5numsNmega2R,2010to2005,top5numsNmega2R,0,0,0,0,0,3,1,7,8,-415,4

2010to2005top5Nmega2R,2010to2005,top5Nmega2R,0,0,0,0,0,0,0,2,3,-463,1

2010to2005top62R,2010to2005,top62R,0,0,0,0,0,4,1,1,8,-418,3

2010to2005individualtop5NmegaR,2010to2005,individualtop5NmegaR,0,0,0,0,0,0,1,3,5,-453,2

2010to2005top5numsNmegaR,2010to2005,top5numsNmegaR,0,0,0,0,0,1,1,4,4,-443,2

2010to2005top5NmegaR,2010to2005,top5NmegaR,0,0,0,0,0,0,0,4,9,-453,3

2010to2005top6R,2010to2005,top6R,0,0,0,0,0,1,0,2,4,-453,1

2010to2005individualtop5Nmega3,2010to2005,individualtop5Nmega3,0,0,0,0,0,0,1,2,12,-448,3

2010to2005top5numsNmega3,2010to2005,top5numsNmega3,0,0,0,0,0,1,0,5,11,-440,3

2010to2005top5Nmega3,2010to2005,top5Nmega3,0,0,0,0,0,2,1,2,3,-439,1

2010to2005top63,2010to2005,top63,0,0,0,0,1,2,1,9,13,-361,5

2010to2005individualtop5Nmega2,2010to2005,individualtop5Nmega2,0,0,0,0,0,2,2,7,12,-414,4

2010to2005top5numsNmega2,2010to2005,top5numsNmega2,0,0,0,0,1,3,1,2,5,-374,2

2010to2005top5Nmega2,2010to2005,top5Nmega2,0,0,0,0,0,0,1,4,5,-451,2

2010to2005top62,2010to2005,top62,0,0,0,0,0,3,0,3,3,-434,3

2010to2005individualtop5Nmega,2010to2005,individualtop5Nmega,0,0,0,0,0,1,1,7,8,-433,3

2010to2005top5numsNmega,2010to2005,top5numsNmega,0,0,0,1,0,2,0,1,12,280,3

2010to2005top5Nmega,2010to2005,top5Nmega,0,0,0,0,0,0,1,2,6,-454,1

 2010to2005top6,2010to2005,top6,0,0,0,0,0,2,0,2,11,-437,2

2009to2005individualbottomall6R,2009to2005,individualbottomall6R,0,0,0,0,0,1,0,2,7,-555,1

2009to2005bottomall6R,2009to2005,bottomall6R,0,0,0,0,0,4,0,6,8,-519,3

2009to2005all6avgR,2009to2005,all6avgR,0,0,0,0,0,2,1,3,5,-540,2

2009to2005all6medR,2009to2005,all6medR,0,0,0,0,0,3,1,2,4,-534,2

2009to2005individualbottomall6,2009to2005,individualbottomall6,0,0,0,0,1,1,0,5,6,-496,2

2009to2005bottomall6,2009to2005,bottomall6,0,0,0,0,0,4,0,0,0,-539,1

2009to2005all6avg,2009to2005,all6avg,0,0,0,0,0,3,1,4,9,-525,4

2009to2005all6med,2009to2005,all6med,0,0,0,1,0,2,0,3,6,173,2

2009to2005individualtop5NmegaSL4,2009to2005,individualtop5NmegaSL4,0,0,0,0,0,4,0,0,0,-539,1

2009to2005individualtop5NmegaSL3,2009to2005,individualtop5NmegaSL3,0,0,0,0,0,2,1,2,6,-541,1

 2009to2005individualtop5NmegaSL2,2009to2005,individualtop5NmegaSL2,0,0,0,0,0,2,2,4,5,-532,2

2009to2005individualtop5NmegaSL1,2009to2005,individualtop5NmegaSL1,0,0,0,0,0,3,1,6,12,-518,4

2009to2005individualtop5Nmega3R,2009to2005,individualtop5Nmega3R,0,0,0,0,0,3,1,4,9,-525,4

2009to2005top5numsNmega3R,2009to2005,top5numsNmega3R,0,0,0,0,0,2,0,7,7,-536,2

2009to2005top5Nmega3R,2009to2005,top5Nmega3R,0,0,0,0,0,2,1,1,9,-540,2

2009to2005top63R,2009to2005,top63R,0,0,0,0,0,1,0,3,6,-554,2

2009to2005individualtop5Nmega2R,2009to2005,individualtop5Nmega2R,0,0,0,0,0,0,0,0,5,-570,1

2009to2005top5numsNmega2R,2009to2005,top5numsNmega2R,0,0,0,0,0,2,0,4,1,-548,1

2009to2005top5Nmega2R,2009to2005,top5Nmega2R,0,0,0,0,0,0,1,5,5,-554,2

2009to2005top62R,2009to2005,top62R,0,0,0,0,0,3,1,2,4,-534,2

2009to2005individualtop5NmegaR,2009to2005,individualtop5NmegaR,0,0,0,0,0,4,0,0,5,-534,2

2009to2005top5numsNmegaR,2009to2005,top5numsNmegaR,0,0,0,0,1,4,0,6,10,-463,4

2009to2005top5NmegaR,2009to2005,top5NmegaR,0,0,0,0,0,1,1,4,11,-541,3

2009to2005top6R,2009to2005,top6R,0,0,0,0,0,2,0,0,0,-557,0

2009to2005individualtop5Nmega3,2009to2005,individualtop5Nmega3,0,0,0,0,0,1,3,3,16,-526,5

2009to2005top5numsNmega3,2009to2005,top5numsNmega3,0,0,0,0,0,0,0,5,4,-561,2

2009to2005top5Nmega3,2009to2005,top5Nmega3,0,0,0,0,0,3,1,3,7,-529,3

2009to2005top63,2009to2005,top63,0,0,0,0,0,2,1,6,16,-523,4

2009to2005individualtop5Nmega2,2009to2005,individualtop5Nmega2,0,0,0,0,0,2,0,4,12,-537,3

2009to2005top5numsNmega2,2009to2005,top5numsNmega2,0,0,0,1,0,2,0,5,11,182,3

2009to2005top5Nmega2,2009to2005,top5Nmega2,0,0,0,0,0,0,0,3,13,-556,3

2009to2005top62,2009to2005,top62,0,0,0,0,0,1,0,0,0,-566,0

2009to2005individualtop5Nmega,2009to2005,individualtop5Nmega,0,0,0,0,0,3,2,3,12,-518,4

2009to2005top5numsNmega,2009to2005,top5numsNmega,0,0,0,0,0,4,0,0,0,-539,1

2009to2005top5Nmega,2009to2005,top5Nmega,0,0,0,0,0,0,0,5,9,-556,3

2009to2005top6,2009to2005,top6,0,0,0,0,0,2,0,0,0,-557,0

2008to2005individualbottomall6R,2008to2005,individualbottomall6R,0,0,0,0,0,1,1,6,4,-648,2

2008to2005bottomall6R,2008to2005,bottomall6R,0,0,0,0,0,0,2,5,18,-639,4

2008to2005all6avgR,2008to2005,all6avgR,0,0,0,0,0,2,1,6,7,-636,2

2008to2005all6medR,2008to2005,all6medR,0,0,0,0,0,1,0,5,4,-656,2

 2008to2005individualbottomall6,2008to2005,individualbottomall6,0,0,0,0,0,4,0,4,10,-625,3

2008to2005bottomall6,2008to2005,bottomall6,0,0,0,0,0,1,0,0,0,-670,0

2008to2005all6avg,2008to2005,all6avg,0,0,0,0,0,1,0,7,10,-646,2

2008to2005all6med,2008to2005,all6med,0,0,0,0,0,2,0,3,4,-651,1

2008to2005individualtop5NmegaSL4,2008to2005,individualtop5NmegaSL4,0,0,0,1,0,5,0,0,0,84,1

2008to2005individualtop5NmegaSL3,2008to2005,individualtop5NmegaSL3,0,0,0,0,0,4,1,3,7,-624,2

2008to2005individualtop5NmegaSL2,2008to2005,individualtop5NmegaSL2,0,0,0,0,0,4,2,2,8,-619,2

2008to2005individualtop5NmegaSL1,2008to2005,individualtop5NmegaSL1,0,0,0,0,0,4,0,11,12,-609,5

2008to2005individualtop5Nmega3R,2008to2005,individualtop5Nmega3R,0,0,0,0,0,4,1,2,3,-630,1

2008to2005top5numsNmega3R,2008to2005,top5numsNmega3R,0,0,0,0,0,3,0,2,4,-644,1

2008to2005top5Nmega3R,2008to2005,top5Nmega3R,0,0,0,0,0,1,0,4,10,-652,2

2008to2005top63R,2008to2005,top63R,0,0,0,0,0,2,0,0,0,-661,0

2008to2005individualtop5Nmega2R,2008to2005,individualtop5Nmega2R,0,0,0,0,0,2,0,4,6,-647,2

2008to2005top5numsNmega2R,2008to2005,top5numsNmega2R,0,0,0,0,0,5,1,3,6,-616,2

2008to2005top5Nmega2R,2008to2005,top5Nmega2R,0,0,0,0,0,2,0,3,6,-649,1

2008to2005top62R,2008to2005,top62R,0,0,0,0,0,4,0,4,10,-625,3

2008to2005individualtop5NmegaR,2008to2005,individualtop5NmegaR,0,0,0,0,0,4,0,8,7,-620,3

2008to2005top5numsNmegaR,2008to2005,top5numsNmegaR,0,0,0,0,0,0,1,7,7,-652,2

2008to2005top5NmegaR,2008to2005,top5NmegaR,0,0,0,0,0,2,2,2,9,-636,1

2008to2005top6R,2008to2005,top6R,0,0,0,0,0,0,1,7,7,-652,2

2008to2005individualtop5Nmega3,2008to2005,individualtop5Nmega3,0,0,0,0,1,4,1,7,13,-556,4

2008to2005top5numsNmega3,2008to2005,top5numsNmega3,0,0,0,0,0,1,1,2,4,-656,1

2008to2005top5Nmega3,2008to2005,top5Nmega3,0,0,0,0,0,2,1,2,4,-647,1

2008to2005top63,2008to2005,top63,0,0,0,0,0,1,0,4,10,-652,2

2008to2005individualtop5Nmega2,2008to2005,individualtop5Nmega2,0,0,0,0,0,2,1,4,17,-630,4

2008to2005top5numsNmega2,2008to2005,top5numsNmega2,0,0,0,0,0,2,0,0,0,-661,0

2008to2005top5Nmega2,2008to2005,top5Nmega2,0,0,0,0,0,1,1,1,4,-658,1

2008to2005top62,2008to2005,top62,0,0,0,0,0,4,0,3,11,-626,3

2008to2005individualtop5Nmega,2008to2005,individualtop5Nmega,0,0,0,1,0,1,2,8,13,89,3

2008to2005top5numsNmega,2008to2005,top5numsNmega,0,0,0,0,0,2,0,5,11,-640,3

2008to2005top5Nmega,2008to2005,top5Nmega,0,0,0,0,0,1,1,4,10,-646,2

2008to2005top6,2008to2005,top6,0,0,0,0,0,2,0,5,11,-640,3

2007to2005individualbottomall6R,2007to2005,individualbottomall6R,0,0,0,0,0,1,2,11,9,-732,2

2007to2005bottomall6R,2007to2005,bottomall6R,0,0,0,0,0,1,1,5,6,-753,2

2007to2005all6avgR,2007to2005,all6avgR,0,0,0,0,1,6,2,6,6,-646,3

2007to2005all6medR,2007to2005,all6medR,0,0,0,0,0,6,1,3,6,-712,2

2007to2005individualbottomall6,2007to2005,individualbottomall6,0,0,0,0,0,3,0,10,6,-731,2

2007to2005bottomall6,2007to2005,bottomall6,0,0,0,0,0,0,0,0,0,-784,0

2007to2005all6avg,2007to2005,all6avg,0,0,0,0,0,2,2,5,3,-741,1

2007to2005all6med,2007to2005,all6med,0,0,0,0,0,4,0,7,3,-731,2

2007to2005individualtop5NmegaSL4,2007to2005,individualtop5NmegaSL4,0,0,0,0,0,2,0,0,0,-766,0

2007to2005individualtop5NmegaSL3,2007to2005,individualtop5NmegaSL3,0,0,0,0,0,2,1,4,8,-744,2

2007to2005individualtop5NmegaSL2,2007to2005,individualtop5NmegaSL2,0,0,0,0,1,0,0,5,10,-710,2

2007to2005individualtop5NmegaSL1,2007to2005,individualtop5NmegaSL1,0,0,0,0,0,2,0,6,19,-735,3

2007to2005individualtop5Nmega3R,2007to2005,individualtop5Nmega3R,0,0,0,0,1,2,0,4,14,-690,3

 2007to2005top5numsNmega3R,2007to2005,top5numsNmega3R,0,0,0,0,1,0,0,7,11,-705,2

2007to2005top5Nmega3R,2007to2005,top5Nmega3R,0,0,0,0,0,3,1,5,21,-720,4

2007to2005top63R,2007to2005,top63R,0,0,0,0,0,4,1,3,10,-726,2

2007to2005individualtop5Nmega2R,2007to2005,individualtop5Nmega2R,0,0,0,0,0,0,0,5,7,-767,2

2007to2005top5numsNmega2R,2007to2005,top5numsNmega2R,0,0,0,0,0,3,1,4,7,-736,2

2007to2005top5Nmega2R,2007to2005,top5Nmega2R,0,0,0,0,0,4,1,10,15,-707,4

2007to2005top62R,2007to2005,top62R,0,0,0,0,1,3,2,2,11,-676,1

2007to2005individualtop5NmegaR,2007to2005,individualtop5NmegaR,0,0,0,0,0,2,0,8,6,-744,2

2007to2005top5numsNmegaR,2007to2005,top5numsNmegaR,0,0,0,1,0,3,2,4,8,-11,2

2007to2005top5NmegaR,2007to2005,top5NmegaR,0,0,0,0,0,2,2,3,9,-739,1

2007to2005top6R,2007to2005,top6R,0,0,0,0,0,3,2,6,13,-720,3

2007to2005individualtop5Nmega3,2007to2005,individualtop5Nmega3,0,0,0,0,0,3,3,9,19,-702,3

2007to2005top5numsNmega3,2007to2005,top5numsNmega3,0,0,0,0,0,1,1,3,11,-752,1

2007to2005top5Nmega3,2007to2005,top5Nmega3,0,0,0,0,1,4,2,9,14,-650,4

2007to2005top63,2007to2005,top63,0,0,0,0,0,3,0,0,0,-757,0

 2007to2005individualtop5Nmega2,2007to2005,individualtop5Nmega2,0,0,0,0,0,0,1,7,18,-746,3

2007to2005top5numsNmega2,2007to2005,top5numsNmega2,0,0,0,0,0,2,0,4,12,-746,3

2007to2005top5Nmega2,2007to2005,top5Nmega2,0,0,0,0,0,5,1,5,8,-715,3

2007to2005top62,2007to2005,top62,0,0,0,0,0,4,0,10,11,-717,3

2007to2005individualtop5Nmega,2007to2005,individualtop5Nmega,0,0,0,0,0,3,0,3,15,-736,2

2007to2005top5numsNmega,2007to2005,top5numsNmega,0,0,0,0,0,5,0,0,0,-739,1

2007to2005top5Nmega,2007to2005,top5Nmega,0,0,0,0,0,1,1,17,13,-722,4

2007to2005top6,2007to2005,top6,0,0,0,0,0,3,0,0,0,-757,0

2006to2005individualbottomall6R,2006to2005,individualbottomall6R,0,0,0,0,0,2,1,5,20,-834,3

2006to2005bottomall6R,2006to2005,bottomall6R,0,0,0,0,0,2,1,8,10,-838,2

2006to2005all6avgR,2006to2005,all6avgR,0,0,0,0,0,2,2,2,8,-846,1

2006to2005all6medR,2006to2005,all6medR,0,0,0,0,0,2,2,5,5,-843,2

2006to2005individualbottomall6,2006to2005,individualbottomall6,0,0,0,0,0,6,3,8,9,-791,3

2006to2005bottomall6,2006to2005,bottomall6,0,0,0,0,0,2,1,5,14,-840,3

2006to2005all6avg,2006to2005,all6avg,0,0,0,0,0,2,2,14,16,-814,4

2006to2005all6med,2006to2005,all6med,0,0,0,0,0,0,1,8,12,-854,2

2006to2005individualtop5NmegaSL4,2006to2005,individualtop5NmegaSL4,0,0,0,0,0,1,0,0,0,-879,0

2006to2005individualtop5NmegaSL3,2006to2005,individualtop5NmegaSL3,0,0,0,0,0,1,1,10,7,-846,2

2006to2005individualtop5NmegaSL2,2006to2005,individualtop5NmegaSL2,0,0,0,0,0,1,3,7,8,-839,2

2006to2005individualtop5NmegaSL1,2006to2005,individualtop5NmegaSL1,0,0,0,0,0,1,0,8,16,-847,3

2006to2005individualtop5Nmega3R,2006to2005,individualtop5Nmega3R,0,0,0,0,0,4,0,7,12,-826,2

2006to2005top5numsNmega3R,2006to2005,top5numsNmega3R,0,0,0,0,0,0,1,12,10,-848,2

2006to2005top5Nmega3R,2006to2005,top5Nmega3R,0,0,0,0,0,1,2,4,9,-850,1

2006to2005top63R,2006to2005,top63R,0,0,0,0,0,0,0,3,12,-870,1

2006to2005individualtop5Nmega2R,2006to2005,individualtop5Nmega2R,0,0,0,0,0,4,0,7,16,-822,3

2006to2005top5numsNmega2R,2006to2005,top5numsNmega2R,0,0,0,0,1,0,1,8,13,-799,2

 2006to2005top5Nmega2R,2006to2005,top5Nmega2R,0,0,0,0,0,2,0,0,0,-870,0

2006to2005top62R,2006to2005,top62R,0,0,0,0,0,3,0,4,22,-831,2

2006to2005individualtop5NmegaR,2006to2005,individualtop5NmegaR,0,0,0,0,0,2,1,7,11,-839,2

 2006to2005top5numsNmegaR,2006to2005,top5numsNmegaR,0,0,0,0,0,3,0,9,10,-833,2

 2006to2005top5NmegaR,2006to2005,top5NmegaR,0,0,0,0,0,2,1,9,11,-835,2

2006to2005top6R,2006to2005,top6R,0,0,0,0,0,3,0,0,0,-861,0

2006to2005individualtop5Nmega3,2006to2005,individualtop5Nmega3,0,0,0,0,0,0,0,10,20,-848,3

2006to2005top5numsNmega3,2006to2005,top5numsNmega3,0,0,0,0,0,2,0,2,13,-853,1

2006to2005top5Nmega3,2006to2005,top5Nmega3,0,0,0,0,0,7,0,0,0,-825,1

2006to2005top63,2006to2005,top63,0,0,0,0,0,3,0,4,6,-847,1

2006to2005individualtop5Nmega2,2006to2005,individualtop5Nmega2,0,0,0,0,0,3,1,6,14,-829,3

2006to2005top5numsNmega2,2006to2005,top5numsNmega2,0,0,0,0,0,4,0,0,0,-852,0

2006to2005top5Nmega2,2006to2005,top5Nmega2,0,0,0,0,0,2,2,3,10,-842,1

2006to2005top62,2006to2005,top62,0,0,0,0,0,3,0,0,0,-861,0

2006to2005individualtop5Nmega,2006to2005,individualtop5Nmega,0,0,0,0,0,0,0,10,11,-857,2

2006to2005top5numsNmega,2006to2005,top5numsNmega,0,0,0,0,0,2,2,7,11,-833,2

2006to2005top5Nmega,2006to2005,top5Nmega,0,0,0,0,1,2,0,6,16,-788,3

2006to2005top6,2006to2005,top6,0,0,0,0,0,4,1,11,8,-816,2

2005to2005individualbottomall6R,2005to2005,individualbottomall6R,0,0,0,0,1,4,1,11,16,-858,3

2005to2005bottomall6R,2005to2005,bottomall6R,0,0,0,0,0,1,0,7,11,-958,2

2005to2005all6avgR,2005to2005,all6avgR,0,0,0,0,0,2,1,6,7,-949,2

2005to2005all6medR,2005to2005,all6medR,0,0,0,0,0,9,0,5,12,-889,3

2005to2005individualbottomall6,2005to2005,individualbottomall6,0,0,0,0,0,4,4,4,13,-911,1

2005to2005bottomall6,2005to2005,bottomall6,0,0,0,0,0,3,0,5,16,-939,3

2005to2005all6avg,2005to2005,all6avg,0,0,0,0,0,5,1,10,17,-904,4

2005to2005all6med,2005to2005,all6med,0,0,0,1,0,7,2,8,19,-164,4

2005to2005individualtop5NmegaSL4,2005to2005,individualtop5NmegaSL4,0,0,0,0,0,4,0,0,0,-956,0

2005to2005individualtop5NmegaSL3,2005to2005,individualtop5NmegaSL3,0,0,0,0,0,4,0,0,0,-956,0

2005to2005individualtop5NmegaSL2,2005to2005,individualtop5NmegaSL2,0,0,0,0,0,0,0,11,10,-960,2

2005to2005individualtop5NmegaSL1,2005to2005,individualtop5NmegaSL1,0,0,0,0,0,4,2,7,11,-919,2

2005to2005individualtop5Nmega3R,2005to2005,individualtop5Nmega3R,0,0,0,0,0,4,0,8,8,-932,2

2005to2005top5numsNmega3R,2005to2005,top5numsNmega3R,0,0,0,0,1,4,0,7,8,-880,2

2005to2005top5Nmega3R,2005to2005,top5Nmega3R,0,0,0,0,0,2,4,10,9,-921,2

2005to2005top63R,2005to2005,top63R,0,0,0,0,0,3,0,5,9,-946,2

2005to2005individualtop5Nmega2R,2005to2005,individualtop5Nmega2R,0,0,0,0,0,5,0,9,19,-910,4

2005to2005top5numsNmega2R,2005to2005,top5numsNmega2R,0,0,0,0,0,2,0,9,19,-937,3

2005to2005top5Nmega2R,2005to2005,top5Nmega2R,0,0,0,0,0,4,0,10,23,-913,3

2005to2005top62R,2005to2005,top62R,0,0,0,0,0,1,3,9,17,-930,3

2005to2005individualtop5NmegaR,2005to2005,individualtop5NmegaR,0,0,0,0,0,1,1,8,19,-942,3

2005to2005top5numsNmegaR,2005to2005,top5numsNmegaR,0,0,0,0,0,2,1,11,16,-930,3

2005to2005top5NmegaR,2005to2005,top5NmegaR,0,0,0,0,0,4,2,6,8,-924,2

2005to2005top6R,2005to2005,top6R,0,0,0,0,1,6,2,11,15,-835,4

2005to2005individualtop5Nmega3,2005to2005,individualtop5Nmega3,0,0,0,0,0,0,2,8,28,-936,4

2005to2005top5numsNmega3,2005to2005,top5numsNmega3,0,0,0,0,0,3,0,0,0,-965,0

2005to2005top5Nmega3,2005to2005,top5Nmega3,0,0,0,1,0,3,0,0,0,-247,0

2005to2005top63,2005to2005,top63,0,0,0,0,0,5,0,0,0,-947,1

2005to2005individualtop5Nmega2,2005to2005,individualtop5Nmega2,0,0,0,0,0,5,0,12,11,-912,3

2005to2005top5numsNmega2,2005to2005,top5numsNmega2,0,0,0,0,0,2,0,0,0,-974,0

2005to2005top5Nmega2,2005to2005,top5Nmega2,0,0,0,0,0,3,0,6,17,-936,3

2005to2005top62,2005to2005,top62,0,0,0,0,0,2,0,5,15,-949,3

2005to2005individualtop5Nmega,2005to2005,individualtop5Nmega,0,0,0,0,0,2,1,9,13,-937,2

2005to2005top5numsNmega,2005to2005,top5numsNmega,0,0,0,0,0,2,0,0,0,-974,0

2005to2005top5Nmega,2005to2005,top5Nmega,0,0,0,0,0,3,1,9,16,-925,3

2005to2005top6,2005to2005,top6,0,0,0,0,0,6,0,0,0,-938,1

 

 Click here to go to Chapter 6:   www.leisdesignservices.com/sqoopexporthdfs2mysql.htm

 Or click here to go to the Table of Content:  www.leisdesignservices.com/hadoopproofofconcept.htm