LEI'S DESIGN SERVICES

EXPERIENCED IN CHIP DESIGN VERIFICATION

Chapter 8:  Sqoop Import from MYSQL to HBase

 

 Figure 7: Sqoop import from MYSQL to Hbase diagram

 

8.1 Dataset

Source MYSQL database:  megamillionAnalysis

Source MYSQL table:  megamillionDataExtraction

 

8.2 Problem Statement

Using Sqoop, import a MYSQL table to a HBase table.

 

8.3 Approach

a) Create a HBase table, megamillionDataExtractionHbase.

b)      Import MYSQL table into the HBase table using Sqoop.

c)      Do HBase table data post-processing.

Figure 7 above shows the Sqoop import from MYSQL to Hbase diagram.

 

8.4 Code

Unix shell script to run Sqoop import from MYSQL into HBase:  runsqoopimportmegamillion2hbase

Command:  ./ runsqoopimportmegamillion2hbase

File content:

hbase shell hbaseMegamillion

#import customer table in big database in mysql back to hdfs /output/sqoop

#directory

sqoop import --connect jdbc:mysql://localhost/megamillionAnalysis --table megamillionDataExtraction --username root -P --hbase-table megamillionDataExtractionHBase --column-family info --hbase-row-key ID --hbase-create-table -m 1

 

#check the import data files in HBase table

hbase shell hbasemegamillionPostProcessing

 

 

HBase script name to create a Hbase table:  hbaseMegamillion

Command:  hbase shell hbaseMegamillion

File content:

disable 'megamillionDataExtractionHBase'

drop 'megamillionDataExtractionHBase'

create 'megamillionDataExtractionHBase', 'Period', 'Win6nums', 'Win5nums', 'Win4

numsNmega', 'Win4nums', 'Win3numsNmega', 'Win3nums', 'Win2numsNmega', 'Win1numNmega', 'Winmega', 'Profit', 'WinPercent';

exit

 

HBase script name to do post-processing of Hbase table:  hbasemegamillionPostProcessing

Command:  hbase shell hbasemegamillionPostProcessing

File content:

#scan 'megamillionDataExtractionHBase'

 

scan 'megamillionDataExtractionHBase', {COLUMNS => ['info:Profit', 'info:Win4nums']}

 

exit

 

8.5 Execution

 

Command to create Hbase table, import MYSQL table to Hbase using Sqoop, and run post-processing: 

./ runsqoopimportmegamillion2hbase

Output content:

SLF4J: Class path contains multiple SLF4J bindings.

SLF4J: Found binding in [jar:file:/home/notroot/lab/software/hbase-1.1.0/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]

SLF4J: Found binding in [jar:file:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]

SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.

SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]

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'.

2015-09-14 17:49:38,511 WARN  [main] util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable

0 row(s) in 4.4900 seconds

 

0 row(s) in 2.5520 seconds

 

0 row(s) in 2.9360 seconds

 

Enter password:

15/09/14 17:50:04 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.

15/09/14 17:50:04 INFO tool.CodeGenTool: Beginning code generation

15/09/14 17:50:05 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `megamillionDataExtraction` AS t LIMIT 1

15/09/14 17:50:05 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `megamillionDataExtraction` AS t LIMIT 1

15/09/14 17:50:05 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /home/notroot/lab/software/hadoop-2.6.0

Note: /tmp/sqoop-root/compile/45a546db09a9834fff9471d3d5e1bee0/megamillionDataExtraction.java uses or overrides a deprecated API.

Note: Recompile with -Xlint:deprecation for details.

15/09/14 17:50:13 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-root/compile/45a546db09a9834fff9471d3d5e1bee0/megamillionDataExtraction.jar

15/09/14 17:50:13 WARN manager.MySQLManager: It looks like you are importing from mysql.

15/09/14 17:50:13 WARN manager.MySQLManager: This transfer can be faster! Use the --direct

15/09/14 17:50:13 WARN manager.MySQLManager: option to exercise a MySQL-specific fast path.

15/09/14 17:50:13 INFO manager.MySQLManager: Setting zero DATETIME behavior to convertToNull (mysql)

15/09/14 17:50:13 INFO mapreduce.ImportJobBase: Beginning import of megamillionDataExtraction

SLF4J: Class path contains multiple SLF4J bindings.

SLF4J: Found binding in [jar:file:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]

SLF4J: Found binding in [jar:file:/home/notroot/lab/software/hbase-1.1.0/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]

SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.

SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]

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/14 17:50:15 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable

15/09/14 17:50:15 INFO Configuration.deprecation: mapred.jar is deprecated. Instead, use mapreduce.job.jar

15/09/14 17:50:15 INFO Configuration.deprecation: mapred.map.tasks is deprecated. Instead, use mapreduce.job.maps

15/09/14 17:50:17 INFO zookeeper.RecoverableZooKeeper: Process identifier=hconnection-0xf28b27 connecting to ZooKeeper ensemble=localhost:2222

15/09/14 17:50:17 INFO zookeeper.ZooKeeper: Client environment:zookeeper.version=3.4.6-1569965, built on 02/20/2014 09:09 GMT

15/09/14 17:50:17 INFO zookeeper.ZooKeeper: Client environment:host.name=localhost

15/09/14 17:50:17 INFO zookeeper.ZooKeeper: Client environment:java.version=1.8.0_45-internal

15/09/14 17:50:17 INFO zookeeper.ZooKeeper: Client environment:java.vendor=Oracle Corporation

15/09/14 17:50:17 INFO zookeeper.ZooKeeper: Client environment:java.home=/usr/lib/jvm/java-8-openjdk-i386/jre

15/09/14 17:50:17 INFO zookeeper.ZooKeeper: Client environment:java.class.path=/home/notroot/lab/software/hadoop-2.6.0/etc/hadoop:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/hamcrest-core-1.3.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/snappy-java-1.0.4.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/activation-1.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jackson-xc-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/servlet-api-2.5.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/zookeeper-3.4.6.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/curator-framework-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/protobuf-java-2.5.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/httpcore-4.2.5.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-math3-3.1.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jersey-core-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/apacheds-i18n-2.0.0-M15.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jetty-6.1.26.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jetty-util-6.1.26.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jaxb-api-2.2.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/netty-3.6.2.Final.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-httpclient-3.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jasper-runtime-5.5.23.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/htrace-core-3.0.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/hadoop-auth-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-logging-1.1.3.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-el-1.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/stax-api-1.0-2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/api-asn1-api-1.0.0-M20.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-compress-1.4.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-digester-1.8.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jsp-api-2.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-codec-1.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jersey-server-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jackson-mapper-asl-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/httpclient-4.2.5.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/guava-11.0.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/apacheds-kerberos-codec-2.0.0-M15.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/slf4j-api-1.7.5.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-beanutils-1.7.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jaxb-impl-2.2.3-1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/hadoop-annotations-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/xmlenc-0.52.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/curator-client-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jackson-core-asl-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-collections-3.2.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/java-xmlbuilder-0.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/junit-4.11.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-lang-2.6.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-io-2.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/log4j-1.2.17.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/asm-3.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/mockito-all-1.8.5.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jersey-json-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-net-3.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-cli-1.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jsr305-1.3.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/paranamer-2.3.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/xz-1.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jasper-compiler-5.5.23.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-configuration-1.6.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/gson-2.2.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/curator-recipes-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jackson-jaxrs-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-beanutils-core-1.8.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jsch-0.1.42.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/avro-1.7.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jets3t-0.9.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jettison-1.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/api-util-1.0.0-M20.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/hadoop-nfs-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/hadoop-common-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/hadoop-common-2.6.0-tests.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/servlet-api-2.5.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/protobuf-java-2.5.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/jersey-core-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/jetty-6.1.26.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/jetty-util-6.1.26.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/netty-3.6.2.Final.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/jasper-runtime-5.5.23.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/htrace-core-3.0.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/commons-logging-1.1.3.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/commons-el-1.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/commons-daemon-1.0.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/jsp-api-2.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/commons-codec-1.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/jersey-server-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/jackson-mapper-asl-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/guava-11.0.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/xmlenc-0.52.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/jackson-core-asl-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/commons-lang-2.6.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/commons-io-2.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/log4j-1.2.17.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/asm-3.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/commons-cli-1.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/jsr305-1.3.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/xml-apis-1.3.04.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/xercesImpl-2.9.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/hadoop-hdfs-nfs-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/hadoop-hdfs-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/hadoop-hdfs-2.6.0-tests.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/guice-servlet-3.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/activation-1.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/guice-3.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jackson-xc-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/servlet-api-2.5.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/zookeeper-3.4.6.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/protobuf-java-2.5.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jersey-core-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jetty-6.1.26.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jetty-util-6.1.26.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jaxb-api-2.2.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/netty-3.6.2.Final.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/leveldbjni-all-1.8.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/commons-httpclient-3.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/commons-logging-1.1.3.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/stax-api-1.0-2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/commons-compress-1.4.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jline-0.9.94.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/commons-codec-1.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jersey-server-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jackson-mapper-asl-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/guava-11.0.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jaxb-impl-2.2.3-1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jackson-core-asl-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/javax.inject-1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/commons-collections-3.2.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/commons-lang-2.6.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/commons-io-2.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jersey-client-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/log4j-1.2.17.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/asm-3.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jersey-json-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/commons-cli-1.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jsr305-1.3.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/xz-1.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jackson-jaxrs-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jersey-guice-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jettison-1.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/aopalliance-1.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-api-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-client-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-server-web-proxy-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-applications-unmanaged-am-launcher-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-registry-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-server-nodemanager-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-server-tests-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-common-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-server-common-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-server-applicationhistoryservice-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-server-resourcemanager-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-applications-distributedshell-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/hamcrest-core-1.3.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/snappy-java-1.0.4.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/guice-servlet-3.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/guice-3.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/protobuf-java-2.5.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/jersey-core-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/netty-3.6.2.Final.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/leveldbjni-all-1.8.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/commons-compress-1.4.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/jersey-server-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/jackson-mapper-asl-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/hadoop-annotations-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/jackson-core-asl-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/javax.inject-1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/junit-4.11.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/commons-io-2.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/log4j-1.2.17.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/asm-3.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/paranamer-2.3.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/xz-1.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/avro-1.7.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/jersey-guice-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/aopalliance-1.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/hadoop-mapreduce-client-hs-plugins-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/hadoop-mapreduce-client-jobclient-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/hadoop-mapreduce-client-app-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/hadoop-mapreduce-examples-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/hadoop-mapreduce-client-hs-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/hadoop-mapreduce-client-core-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/hadoop-mapreduce-client-shuffle-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/hadoop-mapreduce-client-common-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/hadoop-mapreduce-client-jobclient-2.6.0-tests.jar:/home/notroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/bin/../conf::/home/notroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/bin/../lib/ant-contrib-1.0b3.jar:/home/notroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/bin/../lib/ant-eclipse-1.0-jvm1.2.jar:/home/notroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/bin/../lib/avro-1.5.3.jar:/home/notroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/bin/../lib/avro-ipc-1.5.3.jar:/home/notroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/bin/../lib/avro-mapred-1.5.3.jar:/home/notroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/bin/../lib/commons-io-1.4.jar:/home/notroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/bin/../lib/hsqldb-1.8.0.10.jar:/home/notroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/bin/../lib/jackson-core-asl-1.7.3.jar:/home/notroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/bin/../lib/jackson-mapper-asl-1.7.3.jar:/home/notroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/bin/../lib/jopt-simple-3.2.jar:/home/notroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/bin/../lib/mysql-connector-java-5.0.8.jar:/home/notroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/bin/../lib/paranamer-2.3.jar:/home/notroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/bin/../lib/snappy-java-1.0.3.2.jar:/home/notroot/lab/software/hbase-1.1.0/conf:/usr/lib/jvm/java-8-openjdk-i386/lib/tools.jar:/home/notroot/lab/software/hbase-1.1.0:/home/notroot/lab/software/hbase-1.1.0/lib/activation-1.1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/aopalliance-1.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/apacheds-i18n-2.0.0-M15.jar:/home/notroot/lab/software/hbase-1.1.0/lib/apacheds-kerberos-codec-2.0.0-M15.jar:/home/notroot/lab/software/hbase-1.1.0/lib/api-asn1-api-1.0.0-M20.jar:/home/notroot/lab/software/hbase-1.1.0/lib/api-util-1.0.0-M20.jar:/home/notroot/lab/software/hbase-1.1.0/lib/asm-3.1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/avro-1.7.4.jar:/home/notroot/lab/software/hbase-1.1.0/lib/commons-beanutils-1.7.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/commons-beanutils-core-1.8.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/commons-cli-1.2.jar:/home/notroot/lab/software/hbase-1.1.0/lib/commons-codec-1.9.jar:/home/notroot/lab/software/hbase-1.1.0/lib/commons-collections-3.2.1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/commons-compress-1.4.1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/commons-configuration-1.6.jar:/home/notroot/lab/software/hbase-1.1.0/lib/commons-daemon-1.0.13.jar:/home/notroot/lab/software/hbase-1.1.0/lib/commons-digester-1.8.jar:/home/notroot/lab/software/hbase-1.1.0/lib/commons-el-1.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/commons-httpclient-3.1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/commons-io-2.4.jar:/home/notroot/lab/software/hbase-1.1.0/lib/commons-lang-2.6.jar:/home/notroot/lab/software/hbase-1.1.0/lib/commons-logging-1.2.jar:/home/notroot/lab/software/hbase-1.1.0/lib/commons-math-2.2.jar:/home/notroot/lab/software/hbase-1.1.0/lib/commons-math3-3.1.1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/commons-net-3.1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/disruptor-3.3.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/findbugs-annotations-1.3.9-1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/guava-12.0.1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/guice-3.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/guice-servlet-3.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hadoop-annotations-2.5.1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hadoop-auth-2.5.1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hadoop-client-2.5.1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hadoop-common-2.5.1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hadoop-hdfs-2.5.1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hadoop-mapreduce-client-app-2.5.1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hadoop-mapreduce-client-common-2.5.1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hadoop-mapreduce-client-core-2.5.1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hadoop-mapreduce-client-jobclient-2.5.1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hadoop-mapreduce-client-shuffle-2.5.1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hadoop-yarn-api-2.5.1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hadoop-yarn-client-2.5.1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hadoop-yarn-common-2.5.1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hadoop-yarn-server-common-2.5.1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hbase-annotations-1.1.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hbase-annotations-1.1.0-tests.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hbase-client-1.1.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hbase-common-1.1.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hbase-common-1.1.0-tests.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hbase-examples-1.1.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hbase-hadoop2-compat-1.1.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hbase-hadoop-compat-1.1.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hbase-it-1.1.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hbase-it-1.1.0-tests.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hbase-prefix-tree-1.1.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hbase-procedure-1.1.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hbase-protocol-1.1.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hbase-rest-1.1.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hbase-server-1.1.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hbase-server-1.1.0-tests.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hbase-shell-1.1.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/hbase-thrift-1.1.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/htrace-core-3.1.0-incubating.jar:/home/notroot/lab/software/hbase-1.1.0/lib/httpclient-4.2.5.jar:/home/notroot/lab/software/hbase-1.1.0/lib/httpcore-4.1.3.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jackson-core-asl-1.9.13.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jackson-jaxrs-1.9.13.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jackson-mapper-asl-1.9.13.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jackson-xc-1.9.13.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jamon-runtime-2.3.1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jasper-compiler-5.5.23.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jasper-runtime-5.5.23.jar:/home/notroot/lab/software/hbase-1.1.0/lib/javax.inject-1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/java-xmlbuilder-0.4.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jaxb-api-2.2.2.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jaxb-impl-2.2.3-1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jcodings-1.0.8.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jersey-client-1.9.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jersey-core-1.9.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jersey-guice-1.9.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jersey-json-1.9.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jersey-server-1.9.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jets3t-0.9.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jettison-1.3.3.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jetty-6.1.26.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jetty-sslengine-6.1.26.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jetty-util-6.1.26.jar:/home/notroot/lab/software/hbase-1.1.0/lib/joni-2.1.2.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jruby-complete-1.6.8.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jsch-0.1.42.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jsp-2.1-6.1.14.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jsp-api-2.1-6.1.14.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jsr305-1.3.9.jar:/home/notroot/lab/software/hbase-1.1.0/lib/junit-4.11.jar:/home/notroot/lab/software/hbase-1.1.0/lib/leveldbjni-all-1.8.jar:/home/notroot/lab/software/hbase-1.1.0/lib/libthrift-0.9.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/log4j-1.2.17.jar:/home/notroot/lab/software/hbase-1.1.0/lib/metrics-core-2.2.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/netty-3.2.4.Final.jar:/home/notroot/lab/software/hbase-1.1.0/lib/netty-all-4.0.23.Final.jar:/home/notroot/lab/software/hbase-1.1.0/lib/paranamer-2.3.jar:/home/notroot/lab/software/hbase-1.1.0/lib/protobuf-java-2.5.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/servlet-api-2.5-6.1.14.jar:/home/notroot/lab/software/hbase-1.1.0/lib/servlet-api-2.5.jar:/home/notroot/lab/software/hbase-1.1.0/lib/slf4j-api-1.7.7.jar:/home/notroot/lab/software/hbase-1.1.0/lib/slf4j-log4j12-1.7.5.jar:/home/notroot/lab/software/hbase-1.1.0/lib/snappy-java-1.0.4.1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/spymemcached-2.11.6.jar:/home/notroot/lab/software/hbase-1.1.0/lib/xmlenc-0.52.jar:/home/notroot/lab/software/hbase-1.1.0/lib/xz-1.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/zookeeper-3.4.6.jar:/home/notroot/lab/software/hadoop-2.6.0/etc/hadoop:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/hamcrest-core-1.3.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/snappy-java-1.0.4.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/activation-1.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jackson-xc-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/servlet-api-2.5.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/zookeeper-3.4.6.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/curator-framework-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/protobuf-java-2.5.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/httpcore-4.2.5.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-math3-3.1.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jersey-core-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/apacheds-i18n-2.0.0-M15.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jetty-6.1.26.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jetty-util-6.1.26.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jaxb-api-2.2.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/netty-3.6.2.Final.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-httpclient-3.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jasper-runtime-5.5.23.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/htrace-core-3.0.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/hadoop-auth-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-logging-1.1.3.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-el-1.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/stax-api-1.0-2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/api-asn1-api-1.0.0-M20.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-compress-1.4.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-digester-1.8.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jsp-api-2.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-codec-1.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jersey-server-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jackson-mapper-asl-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/httpclient-4.2.5.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/guava-11.0.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/apacheds-kerberos-codec-2.0.0-M15.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/slf4j-api-1.7.5.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-beanutils-1.7.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jaxb-impl-2.2.3-1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/hadoop-annotations-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/xmlenc-0.52.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/curator-client-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jackson-core-asl-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-collections-3.2.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/java-xmlbuilder-0.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/junit-4.11.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-lang-2.6.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-io-2.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/log4j-1.2.17.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/asm-3.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/mockito-all-1.8.5.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jersey-json-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-net-3.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-cli-1.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jsr305-1.3.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/paranamer-2.3.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/xz-1.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jasper-compiler-5.5.23.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-configuration-1.6.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/gson-2.2.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/curator-recipes-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jackson-jaxrs-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-beanutils-core-1.8.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jsch-0.1.42.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/avro-1.7.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jets3t-0.9.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jettison-1.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/api-util-1.0.0-M20.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/hadoop-nfs-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/hadoop-common-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/hadoop-common-2.6.0-tests.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/servlet-api-2.5.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/protobuf-java-2.5.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/jersey-core-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/jetty-6.1.26.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/jetty-util-6.1.26.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/netty-3.6.2.Final.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/jasper-runtime-5.5.23.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/htrace-core-3.0.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/commons-logging-1.1.3.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/commons-el-1.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/commons-daemon-1.0.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/jsp-api-2.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/commons-codec-1.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/jersey-server-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/jackson-mapper-asl-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/guava-11.0.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/xmlenc-0.52.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/jackson-core-asl-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/commons-lang-2.6.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/commons-io-2.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/log4j-1.2.17.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/asm-3.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/commons-cli-1.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/jsr305-1.3.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/xml-apis-1.3.04.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/xercesImpl-2.9.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/hadoop-hdfs-nfs-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/hadoop-hdfs-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/hadoop-hdfs-2.6.0-tests.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/guice-servlet-3.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/activation-1.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/guice-3.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jackson-xc-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/servlet-api-2.5.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/zookeeper-3.4.6.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/protobuf-java-2.5.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jersey-core-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jetty-6.1.26.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jetty-util-6.1.26.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jaxb-api-2.2.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/netty-3.6.2.Final.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/leveldbjni-all-1.8.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/commons-httpclient-3.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/commons-logging-1.1.3.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/stax-api-1.0-2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/commons-compress-1.4.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jline-0.9.94.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/commons-codec-1.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jersey-server-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jackson-mapper-asl-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/guava-11.0.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jaxb-impl-2.2.3-1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jackson-core-asl-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/javax.inject-1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/commons-collections-3.2.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/commons-lang-2.6.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/commons-io-2.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jersey-client-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/log4j-1.2.17.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/asm-3.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jersey-json-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/commons-cli-1.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jsr305-1.3.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/xz-1.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jackson-jaxrs-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jersey-guice-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jettison-1.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/aopalliance-1.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-api-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-client-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-server-web-proxy-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-applications-unmanaged-am-launcher-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-registry-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-server-nodemanager-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-server-tests-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-common-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-server-common-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-server-applicationhistoryservice-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-server-resourcemanager-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-applications-distributedshell-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/hamcrest-core-1.3.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/snappy-java-1.0.4.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/guice-servlet-3.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/guice-3.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/protobuf-java-2.5.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/jersey-core-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/netty-3.6.2.Final.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/leveldbjni-all-1.8.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/commons-compress-1.4.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/jersey-server-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/jackson-mapper-asl-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/hadoop-annotations-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/jackson-core-asl-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/javax.inject-1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/junit-4.11.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/commons-io-2.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/log4j-1.2.17.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/asm-3.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/paranamer-2.3.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/xz-1.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/avro-1.7.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/jersey-guice-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/aopalliance-1.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/hadoop-mapreduce-client-hs-plugins-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/hadoop-mapreduce-client-jobclient-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/hadoop-mapreduce-client-app-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/hadoop-mapreduce-examples-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/hadoop-mapreduce-client-hs-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/hadoop-mapreduce-client-core-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/hadoop-mapreduce-client-shuffle-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/hadoop-mapreduce-client-common-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/hadoop-mapreduce-client-jobclient-2.6.0-tests.jar:/home/notroot/lab/software/hadoop-2.6.0/contrib/capacity-scheduler/*.jar:/home/notroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/bin/../sqoop-1.4.3.jar:/home/notroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/bin/../sqoop-test-1.4.3.jar::/home/notroot/lab/software/hadoop-2.6.0/contrib/capacity-scheduler/*.jar

15/09/14 17:50:17 INFO zookeeper.ZooKeeper: Client environment:java.library.path=/home/notroot/lab/software/hadoop-2.6.0/lib/native

15/09/14 17:50:17 INFO zookeeper.ZooKeeper: Client environment:java.io.tmpdir=/tmp

15/09/14 17:50:17 INFO zookeeper.ZooKeeper: Client environment:java.compiler=<NA>

15/09/14 17:50:17 INFO zookeeper.ZooKeeper: Client environment:os.name=Linux

15/09/14 17:50:17 INFO zookeeper.ZooKeeper: Client environment:os.arch=i386

15/09/14 17:50:17 INFO zookeeper.ZooKeeper: Client environment:os.version=3.2.0-23-generic

15/09/14 17:50:17 INFO zookeeper.ZooKeeper: Client environment:user.name=root

15/09/14 17:50:17 INFO zookeeper.ZooKeeper: Client environment:user.home=/root

15/09/14 17:50:17 INFO zookeeper.ZooKeeper: Client environment:user.dir=/home/notroot/lab/workspacehadoopHW

15/09/14 17:50:17 INFO zookeeper.ZooKeeper: Initiating client connection, connectString=localhost:2222 sessionTimeout=90000 watcher=hconnection-0xf28b270x0, quorum=localhost:2222, baseZNode=/hbase

15/09/14 17:50:18 INFO zookeeper.ClientCnxn: Opening socket connection to server localhost/127.0.0.1:2222. Will not attempt to authenticate using SASL (unknown error)

15/09/14 17:50:18 INFO zookeeper.ClientCnxn: Socket connection established to localhost/127.0.0.1:2222, initiating session

15/09/14 17:50:18 INFO zookeeper.ClientCnxn: Session establishment complete on server localhost/127.0.0.1:2222, sessionid = 0x14fcdd3de500008, negotiated timeout = 90000

15/09/14 17:50:23 INFO mapreduce.HBaseImportJob: Creating missing column family info

15/09/14 17:50:23 INFO client.HBaseAdmin: Started disable of megamillionDataExtractionHBase

15/09/14 17:50:26 INFO client.HBaseAdmin: Disabled megamillionDataExtractionHBase

15/09/14 17:50:27 INFO client.HBaseAdmin: Started enable of megamillionDataExtractionHBase

15/09/14 17:50:29 INFO client.HBaseAdmin: Enabled megamillionDataExtractionHBase

15/09/14 17:50:30 INFO client.RMProxy: Connecting to ResourceManager at /0.0.0.0:8032

15/09/14 17:50:50 INFO mapreduce.JobSubmitter: number of splits:1

15/09/14 17:50:53 INFO mapreduce.JobSubmitter: Submitting tokens for job: job_1442255635725_0005

15/09/14 17:50:54 INFO impl.YarnClientImpl: Submitted application application_1442255635725_0005

15/09/14 17:50:55 INFO mapreduce.Job: The url to track the job: http://localhost:8088/proxy/application_1442255635725_0005/

15/09/14 17:50:55 INFO mapreduce.Job: Running job: job_1442255635725_0005

15/09/14 17:51:31 INFO mapreduce.Job: Job job_1442255635725_0005 running in uber mode : false

15/09/14 17:51:31 INFO mapreduce.Job:  map 0% reduce 0%

15/09/14 17:52:23 INFO mapreduce.Job:  map 100% reduce 0%

15/09/14 17:52:24 INFO mapreduce.Job: Job job_1442255635725_0005 completed successfully

15/09/14 17:52:25 INFO mapreduce.Job: Counters: 30

            File System Counters

                        FILE: Number of bytes read=0

                        FILE: Number of bytes written=144033

                        FILE: Number of read operations=0

                        FILE: Number of large read operations=0

                        FILE: Number of write operations=0

                        HDFS: Number of bytes read=87

                        HDFS: Number of bytes written=0

                        HDFS: Number of read operations=1

                        HDFS: Number of large read operations=0

                        HDFS: Number of write operations=0

            Job Counters

                        Launched map tasks=1

                        Other local map tasks=1

                        Total time spent by all maps in occupied slots (ms)=40940

                        Total time spent by all reduces in occupied slots (ms)=0

                        Total time spent by all map tasks (ms)=40940

                        Total vcore-seconds taken by all map tasks=40940

                        Total megabyte-seconds taken by all map tasks=41922560

            Map-Reduce Framework

                        Map input records=360

                        Map output records=360

                        Input split bytes=87

                        Spilled Records=0

                        Failed Shuffles=0

                        Merged Map outputs=0

                        GC time elapsed (ms)=816

                        CPU time spent (ms)=6570

                        Physical memory (bytes) snapshot=97026048

                        Virtual memory (bytes) snapshot=568180736

                        Total committed heap usage (bytes)=32571392

            File Input Format Counters

                        Bytes Read=0

            File Output Format Counters

                        Bytes Written=0

15/09/14 17:52:25 INFO mapreduce.ImportJobBase: Transferred 0 bytes in 115.4528 seconds (0 bytes/sec)

15/09/14 17:52:25 INFO mapreduce.ImportJobBase: Retrieved 360 records.

.

.

,

The output of  the HBase shell script, hbasemegamillionPostProcessing, displays the content of the columns, Profit and Win4nums, in the table, megamillionDataExtractionHBase. 

Below is the output content:

 

ROW  COLUMN+CELL

 2005to2005all6avg column=info:Profit, timestamp=1441253051672, value=-904

 2005to2005all6avg column=info:Win4nums, timestamp=1441253051672,

value=0

 2005to2005all6avgR column=info:Profit, timestamp=1441253051672, value=-949

 2005to2005all6avgR column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005all6med column=info:Profit, timestamp=1441253051672, value=-164

 2005to2005all6med column=info:Win4nums, timestamp=1441253051672, value=1

 2005to2005all6medR column=info:Profit, timestamp=1441253051672, value=-889

 2005to2005all6medR column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005bottomall6 column=info:Profit, timestamp=1441253051672, value=-939

 2005to2005bottomall6 column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005bottomall6R column=info:Profit, timestamp=1441253051672, value=-958

 2005to2005bottomall6R column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005individualbottomall6 column=info:Profit, timestamp=1441253051672, value=-911

 2005to2005individualbottomall6 column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005individualbottomall6R column=info:Profit, timestamp=1441253051672, value=-858

 2005to2005individualbottomall6R column=info:Win4nums, timestamp=1441253051672,

value=0

 2005to2005individualtop5Nmega column=info:Profit, timestamp=1441253051672, value=-937

2005to2005individualtop5Nmega column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005individualtop5Nmega2 column=info:Profit, timestamp=1441253051672, value=-912

 2005to2005individualtop5Nmega2 column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005individualtop5Nmega2R column=info:Profit, timestamp=1441253051672, value=-910

 2005to2005individualtop5Nmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005individualtop5Nmega3 column=info:Profit, timestamp=1441253051672, value=-936

 2005to2005individualtop5Nmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005individualtop5Nmega3R column=info:Profit, timestamp=1441253051672, value=-932

 2005to2005individualtop5Nmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005individualtop5NmegaR column=info:Profit, timestamp=1441253051672, value=-942

 2005to2005individualtop5NmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005individualtop5NmegaSL1 column=info:Profit, timestamp=1441253051672, value=-919

 2005to2005individualtop5NmegaSL1 column=info:Win4nums, timestamp=1441253051672,value=0

 2005to2005individualtop5NmegaSL2 column=info:Profit, timestamp=1441253051672, value=-960

 2005to2005individualtop5NmegaSL2 column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005individualtop5NmegaSL3 column=info:Profit, timestamp=1441253051672, value=-956

 2005to2005individualtop5NmegaSL3 column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005individualtop5NmegaSL4 column=info:Profit, timestamp=1441253051672, value=-956

 2005to2005individualtop5NmegaSL4 column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005top5Nmega column=info:Profit, timestamp=1441253051672, value=-925

 2005to2005top5Nmega column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005top5Nmega2 column=info:Profit, timestamp=1441253051672, value=-936

 2005to2005top5Nmega2 column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005top5Nmega2R column=info:Profit, timestamp=1441253051672, value=-913

 2005to2005top5Nmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005top5Nmega3 column=info:Profit, timestamp=1441253051672, value=-247

 2005to2005top5Nmega3 column=info:Win4nums, timestamp=1441253051672, value=1

 2005to2005top5Nmega3R column=info:Profit, timestamp=1441253051672, value=-921

 2005to2005top5Nmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005top5NmegaR column=info:Profit, timestamp=1441253051672, value=-924

2005to2005top5NmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005top5numsNmega column=info:Profit, timestamp=1441253051672, value=-974

 2005to2005top5numsNmega column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005top5numsNmega2 column=info:Profit, timestamp=1441253051672, value=-974

 2005to2005top5numsNmega2 column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005top5numsNmega2R column=info:Profit, timestamp=1441253051672, value=-937

 2005to2005top5numsNmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005top5numsNmega3 column=info:Profit, timestamp=1441253051672, value=-965

 2005to2005top5numsNmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005top5numsNmega3R column=info:Profit, timestamp=1441253051672, value=-880

 2005to2005top5numsNmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005top5numsNmegaR column=info:Profit, timestamp=1441253051672, value=-930

 2005to2005top5numsNmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005top6 column=info:Profit, timestamp=1441253051672, value=-938

 2005to2005top6 column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005top62 column=info:Profit, timestamp=1441253051672, value=-949

 2005to2005top62 column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005top62R column=info:Profit, timestamp=1441253051672, value=-930

2005to2005top62R column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005top63 column=info:Profit, timestamp=1441253051672, value=-947

 2005to2005top63 column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005top63R column=info:Profit, timestamp=1441253051672, value=-946

 2005to2005top63R column=info:Win4nums, timestamp=1441253051672, value=0

 2005to2005top6R column=info:Profit, timestamp=1441253051672, value=-835

 2005to2005top6R column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005all6avg column=info:Profit, timestamp=1441253051672, value=-814

 2006to2005all6avg column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005all6avgR column=info:Profit, timestamp=1441253051672, value=-846

2006to2005all6avgR column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005all6med column=info:Profit, timestamp=1441253051672, value=-854

 2006to2005all6med column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005all6medR column=info:Profit, timestamp=1441253051672, value=-843

 2006to2005all6medR column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005bottomall6 column=info:Profit, timestamp=1441253051672, value=-840

 2006to2005bottomall6 column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005bottomall6R column=info:Profit, timestamp=1441253051672, value=-838

 2006to2005bottomall6R column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005individualbottomall6 column=info:Profit, timestamp=1441253051672, value=-791

 2006to2005individualbottomall6 column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005individualbottomall6R column=info:Profit, timestamp=1441253051672, value=-834

 2006to2005individualbottomall6R column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005individualtop5Nmega column=info:Profit, timestamp=1441253051672, value=-857

 2006to2005individualtop5Nmega column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005individualtop5Nmega2 column=info:Profit, timestamp=1441253051672, value=-829

 2006to2005individualtop5Nmega2 column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005individualtop5Nmega2R column=info:Profit, timestamp=1441253051672, value=-822

 2006to2005individualtop5Nmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005individualtop5Nmega3 column=info:Profit, timestamp=1441253051672,

value=-848

 2006to2005individualtop5Nmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005individualtop5Nmega3R column=info:Profit, timestamp=1441253051672, value=-826

 2006to2005individualtop5Nmega3R column=info:Win4nums, timestamp=1441253051672,value=0

2006to2005individualtop5NmegaR column=info:Profit, timestamp=1441253051672, value=-839

2006to2005individualtop5NmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005individualtop5NmegaSL1 column=info:Profit, timestamp=1441253051672, value=-847

 2006to2005individualtop5NmegaSL1 column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005individualtop5NmegaSL2 column=info:Profit, timestamp=1441253051672, value=-839

 2006to2005individualtop5NmegaSL2 column=info:Win4nums, timestamp=1441253051672,value=0

 2006to2005individualtop5NmegaSL3 column=info:Profit, timestamp=1441253051672, value=-846

 2006to2005individualtop5NmegaSL3 column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005individualtop5NmegaSL4 column=info:Profit, timestamp=1441253051672, value=-879

 2006to2005individualtop5NmegaSL4 column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005top5Nmega column=info:Profit, timestamp=1441253051672, value=-788

 2006to2005top5Nmega column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005top5Nmega2 column=info:Profit, timestamp=1441253051672, value=-842

 2006to2005top5Nmega2 column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005top5Nmega2R column=info:Profit, timestamp=1441253051672, value=-870

 2006to2005top5Nmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005top5Nmega3 column=info:Profit, timestamp=1441253051672,

value=-825

 2006to2005top5Nmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005top5Nmega3R column=info:Profit, timestamp=1441253051672, value=-850

 2006to2005top5Nmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005top5NmegaR column=info:Profit, timestamp=1441253051672, value=-835

 2006to2005top5NmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005top5numsNmega column=info:Profit, timestamp=1441253051672, value=-833

2006to2005top5numsNmega column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005top5numsNmega2 column=info:Profit, timestamp=1441253051672, value=-852

 2006to2005top5numsNmega2 column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005top5numsNmega2R column=info:Profit, timestamp=1441253051672, value=-799

 2006to2005top5numsNmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005top5numsNmega3 column=info:Profit, timestamp=1441253051672, value=-853

 2006to2005top5numsNmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005top5numsNmega3R column=info:Profit, timestamp=1441253051672, value=-848

 2006to2005top5numsNmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005top5numsNmegaR column=info:Profit, timestamp=1441253051672, value=-833

 2006to2005top5numsNmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005top6 column=info:Profit, timestamp=1441253051672, value=-816

 2006to2005top6 column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005top62 column=info:Profit, timestamp=1441253051672, value=-861

2006to2005top62 column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005top62R column=info:Profit, timestamp=1441253051672, value=-831

 2006to2005top62R column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005top63 column=info:Profit, timestamp=1441253051672, value=-847

 2006to2005top63 column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005top63R column=info:Profit, timestamp=1441253051672, value=-870

 2006to2005top63R column=info:Win4nums, timestamp=1441253051672, value=0

 2006to2005top6R column=info:Profit, timestamp=1441253051672, value=-861

 2006to2005top6R column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005all6avg column=info:Profit, timestamp=1441253051672, value=-741

 2007to2005all6avg column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005all6avgR column=info:Profit, timestamp=1441253051672, value=-646

 2007to2005all6avgR column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005all6med column=info:Profit, timestamp=1441253051672, value=-731

 2007to2005all6med column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005all6medR column=info:Profit, timestamp=1441253051672, value=-712

 2007to2005all6medR column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005bottomall6 column=info:Profit, timestamp=1441253051672, value=-784

 2007to2005bottomall6 column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005bottomall6R column=info:Profit, timestamp=1441253051672, value=-753

 2007to2005bottomall6R column=info:Win4nums, timestamp=1441253051672,

value=0

 2007to2005individualbottomall6 column=info:Profit, timestamp=1441253051672, value=-731

 2007to2005individualbottomall6 column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005individualbottomall6R column=info:Profit, timestamp=1441253051672, value=-732

 2007to2005individualbottomall6R column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005individualtop5Nmega column=info:Profit, timestamp=1441253051672, value=-736

 2007to2005individualtop5Nmega column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005individualtop5Nmega2 column=info:Profit, timestamp=1441253051672, value=-746

 2007to2005individualtop5Nmega2 column=info:Win4nums, timestamp=1441253051672, value=0

2007to2005individualtop5Nmega2R column=info:Profit, timestamp=1441253051672, value=-767

 2007to2005individualtop5Nmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005individualtop5Nmega3 column=info:Profit, timestamp=1441253051672, value=-702

 2007to2005individualtop5Nmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005individualtop5Nmega3R column=info:Profit, timestamp=1441253051672, value=-690

 2007to2005individualtop5Nmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005individualtop5NmegaR column=info:Profit, timestamp=1441253051672, value=-744

 2007to2005individualtop5NmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005individualtop5NmegaSL1 column=info:Profit, timestamp=1441253051672, value=-735

 2007to2005individualtop5NmegaSL1 column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005individualtop5NmegaSL2 column=info:Profit, timestamp=1441253051672, value=-710

 2007to2005individualtop5NmegaSL2 column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005individualtop5NmegaSL3 column=info:Profit, timestamp=1441253051672, value=-744

 2007to2005individualtop5NmegaSL3 column=info:Win4nums, timestamp=1441253051672, value=0

2007to2005individualtop5NmegaSL4 column=info:Profit, timestamp=1441253051672, value=-766

 2007to2005individualtop5NmegaSL4 column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005top5Nmega column=info:Profit, timestamp=1441253051672, value=-722

 2007to2005top5Nmega column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005top5Nmega2 column=info:Profit, timestamp=1441253051672, value=-715

 2007to2005top5Nmega2 column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005top5Nmega2R column=info:Profit, timestamp=1441253051672, value=-707

 2007to2005top5Nmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005top5Nmega3 column=info:Profit, timestamp=1441253051672, value=-650

 2007to2005top5Nmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005top5Nmega3R column=info:Profit, timestamp=1441253051672, value=-720

 2007to2005top5Nmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005top5NmegaR column=info:Profit, timestamp=1441253051672, value=-739

 2007to2005top5NmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005top5numsNmega column=info:Profit, timestamp=1441253051672, value=-739

 2007to2005top5numsNmega column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005top5numsNmega2 column=info:Profit, timestamp=1441253051672, value=-746

 2007to2005top5numsNmega2 column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005top5numsNmega2R column=info:Profit, timestamp=1441253051672, value=-736

 2007to2005top5numsNmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005top5numsNmega3 column=info:Profit, timestamp=1441253051672, value=-752

 2007to2005top5numsNmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005top5numsNmega3R column=info:Profit, timestamp=1441253051672, value=-705

 2007to2005top5numsNmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005top5numsNmegaR column=info:Profit, timestamp=1441253051672,

value=-11

 2007to2005top5numsNmegaR column=info:Win4nums, timestamp=1441253051672, value=1

 2007to2005top6 column=info:Profit, timestamp=1441253051672, value=-757

 2007to2005top6 column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005top62 column=info:Profit, timestamp=1441253051672, value=-717

 2007to2005top62 column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005top62R column=info:Profit, timestamp=1441253051672, value=-676

 2007to2005top62R column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005top63 column=info:Profit, timestamp=1441253051672, value=-757

 2007to2005top63 column=info:Win4nums, timestamp=1441253051672, value=0

 2007to2005top63R column=info:Profit, timestamp=1441253051672, value=-726

 2007to2005top63R column=info:Win4nums, timestamp=1441253051672, value=0

2007to2005top6R column=info:Profit, timestamp=1441253051672, value=-720

 2007to2005top6R column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005all6avg column=info:Profit, timestamp=1441253051672, value=-646

 2008to2005all6avg column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005all6avgR column=info:Profit, timestamp=1441253051672, value=-636

 2008to2005all6avgR column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005all6med column=info:Profit, timestamp=1441253051672, value=-651

 2008to2005all6med column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005all6medR column=info:Profit, timestamp=1441253051672, value=-656

 2008to2005all6medR column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005bottomall6 column=info:Profit, timestamp=1441253051672, value=-670

 2008to2005bottomall6 column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005bottomall6R column=info:Profit, timestamp=1441253051672, value=-639

 2008to2005bottomall6R column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005individualbottomall6 column=info:Profit, timestamp=1441253051672, value=-625

 2008to2005individualbottomall6 column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005individualbottomall6R column=info:Profit, timestamp=1441253051672, value=-648

 2008to2005individualbottomall6R column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005individualtop5Nmega column=info:Profit, timestamp=1441253051672, value=89

 2008to2005individualtop5Nmega column=info:Win4nums, timestamp=1441253051672, value=1

 2008to2005individualtop5Nmega2 column=info:Profit, timestamp=1441253051672, value=-630

2008to2005individualtop5Nmega2 column=info:Win4nums, timestamp=1441253051672, value=0

2008to2005individualtop5Nmega2R column=info:Profit, timestamp=1441253051672, value=-647

 2008to2005individualtop5Nmega2R column=info:Win4nums, timestamp=1441253051672, value=0

2008to2005individualtop5Nmega3 column=info:Profit, timestamp=1441253051672, value=-556

 2008to2005individualtop5Nmega3 column=info:Win4nums, timestamp=1441253051672, value=0

2008to2005individualtop5Nmega3R column=info:Profit, timestamp=1441253051672, value=-630

 2008to2005individualtop5Nmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005individualtop5NmegaR column=info:Profit, timestamp=1441253051672, value=-620

 2008to2005individualtop5NmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005individualtop5NmegaSL1 column=info:Profit, timestamp=1441253051672, value=-609

 2008to2005individualtop5NmegaSL1 column=info:Win4nums, timestamp=1441253051672,value=0

 2008to2005individualtop5NmegaSL2 column=info:Profit, timestamp=1441253051672, value=-619

 2008to2005individualtop5NmegaSL2 column=info:Win4nums, timestamp=1441253051672,value=0

 2008to2005individualtop5NmegaSL3 column=info:Profit, timestamp=1441253051672, value=-624

 2008to2005individualtop5NmegaSL3 column=info:Win4nums, timestamp=1441253051672,value=0

 2008to2005individualtop5NmegaSL4 column=info:Profit, timestamp=1441253051672, value=84

 2008to2005individualtop5NmegaSL4 column=info:Win4nums, timestamp=1441253051672, value=1

 2008to2005top5Nmega column=info:Profit, timestamp=1441253051672, value=-646

 2008to2005top5Nmega column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005top5Nmega2 column=info:Profit, timestamp=1441253051672, value=-658

 2008to2005top5Nmega2 column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005top5Nmega2R column=info:Profit, timestamp=1441253051672, value=-

649

 2008to2005top5Nmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005top5Nmega3 column=info:Profit, timestamp=1441253051672, value=-647

 2008to2005top5Nmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005top5Nmega3R column=info:Profit, timestamp=1441253051672, value=-

652

 2008to2005top5Nmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005top5NmegaR column=info:Profit, timestamp=1441253051672, value=-636

 2008to2005top5NmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005top5numsNmega column=info:Profit, timestamp=1441253051672, value=-640

 2008to2005top5numsNmega column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005top5numsNmega2 column=info:Profit, timestamp=1441253051672, value=-661

 2008to2005top5numsNmega2 column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005top5numsNmega2R column=info:Profit, timestamp=1441253051672, value=-616

 2008to2005top5numsNmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005top5numsNmega3 column=info:Profit, timestamp=1441253051672, value=-656

 2008to2005top5numsNmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005top5numsNmega3R column=info:Profit, timestamp=1441253051672, value=-644

 2008to2005top5numsNmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005top5numsNmegaR column=info:Profit, timestamp=1441253051672, value=-652

 2008to2005top5numsNmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005top6 column=info:Profit, timestamp=1441253051672, value=-640

 2008to2005top6 column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005top62 column=info:Profit, timestamp=1441253051672, value=-626

 2008to2005top62 column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005top62R column=info:Profit, timestamp=1441253051672, value=-625

 2008to2005top62R column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005top63 column=info:Profit, timestamp=1441253051672, value=-652

 2008to2005top63 column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005top63R column=info:Profit, timestamp=1441253051672, value=-661

 2008to2005top63R column=info:Win4nums, timestamp=1441253051672, value=0

 2008to2005top6R column=info:Profit, timestamp=1441253051672, value=-652

 2008to2005top6R column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005all6avg column=info:Profit, timestamp=1441253051672, value=-525

 2009to2005all6avg column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005all6avgR column=info:Profit, timestamp=1441253051672, value=-540

2009to2005all6avgR column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005all6med column=info:Profit, timestamp=1441253051672, value=173

 2009to2005all6med column=info:Win4nums, timestamp=1441253051672, value=1

2009to2005all6medR column=info:Profit, timestamp=1441253051672, value=-534

 2009to2005all6medR column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005bottomall6 column=info:Profit, timestamp=1441253051672, value=-539

 2009to2005bottomall6 column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005bottomall6R column=info:Profit, timestamp=1441253051672, value=-519

 2009to2005bottomall6R column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005individualbottomall6 column=info:Profit, timestamp=1441253051672, value=-496

 2009to2005individualbottomall6 column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005individualbottomall6R column=info:Profit, timestamp=1441253051672, value=-555

 2009to2005individualbottomall6R column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005individualtop5Nmega column=info:Profit, timestamp=1441253051672, value=-518

 2009to2005individualtop5Nmega column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005individualtop5Nmega2 column=info:Profit, timestamp=1441253051672, value=-537

 2009to2005individualtop5Nmega2 column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005individualtop5Nmega2R column=info:Profit, timestamp=1441253051672, value=-570

 2009to2005individualtop5Nmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005individualtop5Nmega3 column=info:Profit, timestamp=1441253051672, value=-526

 2009to2005individualtop5Nmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005individualtop5Nmega3R column=info:Profit, timestamp=1441253051672,

value=-525

 2009to2005individualtop5Nmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005individualtop5NmegaR column=info:Profit, timestamp=1441253051672, value=-534

 2009to2005individualtop5NmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005individualtop5NmegaSL1 column=info:Profit, timestamp=1441253051672, value=-518

2009to2005individualtop5NmegaSL1 column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005individualtop5NmegaSL2 column=info:Profit, timestamp=1441253051672, value=-532

 2009to2005individualtop5NmegaSL2 column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005individualtop5NmegaSL3 column=info:Profit, timestamp=1441253051672, value=-541

 2009to2005individualtop5NmegaSL3 column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005individualtop5NmegaSL4 column=info:Profit, timestamp=1441253051672, value=-539

 2009to2005individualtop5NmegaSL4 column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005top5Nmega column=info:Profit, timestamp=1441253051672, value=-556

 2009to2005top5Nmega column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005top5Nmega2 column=info:Profit, timestamp=1441253051672, value=-556

 2009to2005top5Nmega2 column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005top5Nmega2R column=info:Profit, timestamp=1441253051672, value=-554

 2009to2005top5Nmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005top5Nmega3 column=info:Profit, timestamp=1441253051672, value=-529

 2009to2005top5Nmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005top5Nmega3R column=info:Profit, timestamp=1441253051672, value=-540

 2009to2005top5Nmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005top5NmegaR column=info:Profit, timestamp=1441253051672, value=-541

 2009to2005top5NmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005top5numsNmega column=info:Profit, timestamp=1441253051672, value=-

539

 2009to2005top5numsNmega column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005top5numsNmega2 column=info:Profit, timestamp=1441253051672, value=182

 2009to2005top5numsNmega2 column=info:Win4nums, timestamp=1441253051672, value=1

2009to2005top5numsNmega2R column=info:Profit, timestamp=1441253051672, value=-548

 2009to2005top5numsNmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005top5numsNmega3 column=info:Profit, timestamp=1441253051672, value=-561

 2009to2005top5numsNmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005top5numsNmega3R column=info:Profit, timestamp=1441253051672,

value=-536

 2009to2005top5numsNmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005top5numsNmegaR column=info:Profit, timestamp=1441253051672, value=-463

 2009to2005top5numsNmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005top6 column=info:Profit, timestamp=1441253051672, value=-557

 2009to2005top6 column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005top62 column=info:Profit, timestamp=1441253051672, value=-566

 2009to2005top62 column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005top62R column=info:Profit, timestamp=1441253051672, value=-534

 2009to2005top62R column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005top63 column=info:Profit, timestamp=1441253051672, value=-523

 2009to2005top63 column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005top63R column=info:Profit, timestamp=1441253051672, value=-554

 2009to2005top63R column=info:Win4nums, timestamp=1441253051672, value=0

 2009to2005top6R column=info:Profit, timestamp=1441253051672, value=-557

 2009to2005top6R column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005all6avg column=info:Profit, timestamp=1441253051672, value=-439

 2010to2005all6avg column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005all6avgR column=info:Profit, timestamp=1441253051672, value=-449

 2010to2005all6avgR column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005all6med column=info:Profit, timestamp=1441253051672, value=-437

 2010to2005all6med column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005all6medR column=info:Profit, timestamp=1441253051672, value=-437

 2010to2005all6medR column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005bottomall6 column=info:Profit, timestamp=1441253051672, value=-443

 2010to2005bottomall6 column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005bottomall6R column=info:Profit, timestamp=1441253051672, value=-415

 2010to2005bottomall6R column=info:Win4nums, timestamp=1441253051672, value=0

2010to2005individualbottomall6 column=info:Profit, timestamp=1441253051672, value=-439

 2010to2005individualbottomall6 column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005individualbottomall6R column=info:Profit, timestamp=1441253051672, value=-454

 2010to2005individualbottomall6R column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005individualtop5Nmega column=info:Profit, timestamp=1441253051672, value=-433

 2010to2005individualtop5Nmega column=info:Win4nums,

timestamp=1441253051672, value=0

 2010to2005individualtop5Nmega2 column=info:Profit, timestamp=1441253051672, value=-414

 2010to2005individualtop5Nmega2 column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005individualtop5Nmega2R column=info:Profit, timestamp=1441253051672, value=-440

 2010to2005individualtop5Nmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005individualtop5Nmega3 column=info:Profit, timestamp=1441253051672, value=-448

 2010to2005individualtop5Nmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005individualtop5Nmega3R column=info:Profit, timestamp=1441253051672, value=-553

 2010to2005individualtop5Nmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005individualtop5NmegaR column=info:Profit, timestamp=1441253051672, value=-453

 2010to2005individualtop5NmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005individualtop5NmegaSL1 column=info:Profit, timestamp=1441253051672, value=-431

 2010to2005individualtop5NmegaSL1 column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005individualtop5NmegaSL2 column=info:Profit, timestamp=1441253051672, value=-453

 2010to2005individualtop5NmegaSL2 column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005individualtop5NmegaSL3 column=info:Profit, timestamp=1441253051672, value=-452

 2010to2005individualtop5NmegaSL3 column=info:Win4nums, timestamp=1441253051672,value=0

 2010to2005individualtop5NmegaSL4 column=info:Profit, timestamp=1441253051672, value=-443

 2010to2005individualtop5NmegaSL4 column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005top5Nmega column=info:Profit, timestamp=1441253051672, value=-454

 2010to2005top5Nmega column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005top5Nmega2 column=info:Profit, timestamp=1441253051672, value=-451

 2010to2005top5Nmega2 column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005top5Nmega2R column=info:Profit, timestamp=1441253051672, value=-463

 2010to2005top5Nmega2R column=info:Win4nums, timestamp=1441253051672,

value=0

 2010to2005top5Nmega3 column=info:Profit, timestamp=1441253051672, value=-439

 2010to2005top5Nmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005top5Nmega3R column=info:Profit, timestamp=1441253051672, value=-533

 2010to2005top5Nmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005top5NmegaR column=info:Profit, timestamp=1441253051672, value=-453

 2010to2005top5NmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005top5numsNmega column=info:Profit, timestamp=1441253051672, value=280

 2010to2005top5numsNmega column=info:Win4nums, timestamp=1441253051672, value=1

 2010to2005top5numsNmega2 column=info:Profit, timestamp=1441253051672, value=-374

 2010to2005top5numsNmega2 column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005top5numsNmega2R column=info:Profit, timestamp=1441253051672, value=-415

 2010to2005top5numsNmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005top5numsNmega3 column=info:Profit, timestamp=1441253051672, value=-440

 2010to2005top5numsNmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005top5numsNmega3R column=info:Profit, timestamp=1441253051672, value=-537

 2010to2005top5numsNmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005top5numsNmegaR column=info:Profit, timestamp=1441253051672, value=-443

 2010to2005top5numsNmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005top6 column=info:Profit, timestamp=1441253051672, value=-437

 2010to2005top6 column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005top62 column=info:Profit, timestamp=1441253051672, value=-434

 2010to2005top62 column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005top62R column=info:Profit, timestamp=1441253051672, value=-418

 2010to2005top62R column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005top63 column=info:Profit, timestamp=1441253051672, value=-361

 2010to2005top63 column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005top63R column=info:Profit, timestamp=1441253051672, value=-551

 2010to2005top63R column=info:Win4nums, timestamp=1441253051672, value=0

 2010to2005top6R column=info:Profit, timestamp=1441253051672, value=-453

 2010to2005top6R column=info:Win4nums, timestamp=1441253051672,value=0

 2011to2005all6avg column=info:Profit, timestamp=1441253051672, value=-315

 2011to2005all6avg column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005all6avgR column=info:Profit, timestamp=1441253051672, value=-341

 2011to2005all6avgR column=info:Win4nums, timestamp=1441253051672, value=0

2011to2005all6med column=info:Profit, timestamp=1441253051672, value=-348

 2011to2005all6med column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005all6medR column=info:Profit, timestamp=1441253051672, value=-334

 2011to2005all6medR column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005bottomall6 column=info:Profit, timestamp=1441253051672, value=-357

 2011to2005bottomall6 column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005bottomall6R column=info:Profit, timestamp=1441253051672, value=-353

 2011to2005bottomall6R column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005individualbottomall6 column=info:Profit, timestamp=1441253051672, value=-358

 2011to2005individualbottomall6 column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005individualbottomall6R column=info:Profit, timestamp=1441253051672, value=-357

2011to2005individualbottomall6R column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005individualtop5Nmega column=info:Profit, timestamp=1441253051672, value=-329

 2011to2005individualtop5NmegaSL1 column=info:Profit, timestamp=1441253051672, value=-340

 2011to2005individualtop5NmegaSL1 column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005individualtop5NmegaSL2 column=info:Profit, timestamp=1441253051672, value=-352

2011to2005individualtop5NmegaSL2 column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005individualtop5NmegaSL3 column=info:Profit, timestamp=1441253051672, value=-357

 2011to2005individualtop5NmegaSL3 column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005individualtop5NmegaSL4 column=info:Profit, timestamp=1441253051672, value=-348

 2011to2005individualtop5NmegaSL4 column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005top5Nmega column=info:Profit, timestamp=1441253051672, value=-337

 2011to2005top5Nmega column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005top5Nmega2 column=info:Profit, timestamp=1441253051672, value=-364

 2011to2005top5Nmega2 column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005individualtop5Nmega column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005individualtop5Nmega2 column=info:Profit, timestamp=1441253051672, value=-321

 2011to2005individualtop5Nmega2 column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005individualtop5Nmega2R column=info:Profit, timestamp=1441253051672, value=-338

 2011to2005individualtop5Nmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005individualtop5Nmega3 column=info:Profit, timestamp=1441253051672, value=-335

 2011to2005individualtop5Nmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005individualtop5Nmega3R column=info:Profit, timestamp=1441253051672, value=-286

 2011to2005individualtop5Nmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005individualtop5NmegaR column=info:Profit, timestamp=1441253051672, value=-355

 2011to2005individualtop5NmegaR column=info:Win4nums, timestamp=1441253051672, value=0

2011to2005top5Nmega2R column=info:Profit, timestamp=1441253051672, value=-332

 2011to2005top5Nmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005top5Nmega3 column=info:Profit, timestamp=1441253051672, value=382

 2011to2005top5Nmega3 column=info:Win4nums, timestamp=1441253051672, value=1

 2011to2005top5Nmega3R column=info:Profit, timestamp=1441253051672, value=-316

 2011to2005top5Nmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005top5NmegaR column=info:Profit, timestamp=1441253051672, value=-358

 2011to2005top5NmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005top5numsNmega column=info:Profit, timestamp=1441253051672, value=-339

2011to2005top5numsNmega column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005top5numsNmega2 column=info:Profit, timestamp=1441253051672, value=-354

 2011to2005top5numsNmega2 column=info:Win4nums, timestamp=1441253051672, value=0

2011to2005top5numsNmega2R column=info:Profit, timestamp=1441253051672, value=-333

 2011to2005top5numsNmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005top5numsNmega3 column=info:Profit, timestamp=1441253051672, value=-338

 2011to2005top5numsNmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005top5numsNmega3R column=info:Profit, timestamp=1441253051672, value=-297

 2011to2005top5numsNmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005top5numsNmegaR column=info:Profit, timestamp=1441253051672, value=-340

 2011to2005top5numsNmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005top6 column=info:Profit, timestamp=1441253051672, value=-348

 2011to2005top6 column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005top62 column=info:Profit, timestamp=1441253051672, value=-339

 2011to2005top62 column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005top62R column=info:Profit, timestamp=1441253051672, value=-350

2011to2005top62R column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005top63 column=info:Profit, timestamp=1441253051672, value=-329

 2011to2005top63 column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005top63R column=info:Profit, timestamp=1441253051672, value=-352

 2011to2005top63R column=info:Win4nums, timestamp=1441253051672, value=0

 2011to2005top6R column=info:Profit, timestamp=1441253051672, value=-357

 2011to2005top6R column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005all6avg column=info:Profit, timestamp=1441253051672, value=-242

 2012to2005all6avg column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005all6avgR column=info:Profit, timestamp=1441253051672, value=-262

 2012to2005all6avgR column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005all6med column=info:Profit, timestamp=1441253051672, value=-242

 2012to2005all6med column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005all6medR column=info:Profit, timestamp=1441253051672, value=-262

 2012to2005all6medR column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005bottomall6 column=info:Profit, timestamp=1441253051672, value=-253

 2012to2005bottomall6 column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005bottomall6R column=info:Profit, timestamp=1441253051672, value=-262

 2012to2005bottomall6R column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005individualbottomall6 column=info:Profit, timestamp=1441253051672, val

ue=459

 2012to2005individualbottomall6 column=info:Win4nums, timestamp=1441253051672, value=1

2012to2005individualbottomall6R column=info:Profit, timestamp=1441253051672,

value=-198

 2012to2005individualbottomall6R column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005individualtop5Nmega column=info:Profit, timestamp=1441253051672, value=480

 2012to2005individualtop5Nmega column=info:Win4nums, timestamp=1441253051672, value=1

2012to2005individualtop5Nmega2 column=info:Profit, timestamp=1441253051672, value=-238

 2012to2005individualtop5Nmega2 column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005individualtop5Nmega2R column=info:Profit, timestamp=1441253051672, value=-248

2012to2005individualtop5Nmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005individualtop5Nmega3 column=info:Profit, timestamp=1441253051672, value=-222

 2012to2005individualtop5Nmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005individualtop5Nmega3R column=info:Profit, timestamp=1441253051672, value=-230

 2012to2005individualtop5Nmega3R column=info:Win4nums, timestamp=1441253051672,value=0

 2012to2005individualtop5NmegaR column=info:Profit, timestamp=1441253051672, value=-243

 2012to2005individualtop5NmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005individualtop5NmegaSL1 column=info:Profit, timestamp=1441253051672, value=-229

 2012to2005individualtop5NmegaSL1 column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005individualtop5NmegaSL2 column=info:Profit, timestamp=1441253051672, value=-247

 2012to2005individualtop5NmegaSL2 column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005individualtop5NmegaSL3 column=info:Profit, timestamp=1441253051672, value=-243

 2012to2005individualtop5NmegaSL3 column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005individualtop5NmegaSL4 column=info:Profit, timestamp=1441253051672, value=465

 2012to2005individualtop5NmegaSL4 column=info:Win4nums, timestamp=1441253051672, value=1

 2012to2005top5Nmega column=info:Profit, timestamp=1441253051672, value=-

243

 2012to2005top5Nmega column=info:Win4nums, timestamp=1441253051672,

value=0

2012to2005top5Nmega2 column=info:Profit, timestamp=1441253051672, value=-259

 2012to2005top5Nmega2 column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005top5Nmega2R column=info:Profit, timestamp=1441253051672, value=-252

 2012to2005top5Nmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005top5Nmega3 column=info:Profit, timestamp=1441253051672, value=-249

 2012to2005top5Nmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005top5Nmega3R column=info:Profit, timestamp=1441253051672, value=-185

 2012to2005top5Nmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005top5NmegaR column=info:Profit, timestamp=1441253051672, value=-248

 2012to2005top5NmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005top5numsNmega column=info:Profit, timestamp=1441253051672, value=-244

 2012to2005top5numsNmega column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005top5numsNmega2 column=info:Profit, timestamp=1441253051672, value=-253

 2012to2005top5numsNmega2 column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005top5numsNmega2R column=info:Profit, timestamp=1441253051672, value=-224

 2012to2005top5numsNmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005top5numsNmega3 column=info:Profit, timestamp=1441253051672, value=-246

 2012to2005top5numsNmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005top5numsNmega3R column=info:Profit, timestamp=1441253051672, value=-230

 2012to2005top5numsNmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005top5numsNmegaR column=info:Profit, timestamp=1441253051672, value=-261

 2012to2005top5numsNmegaR column=info:Win4nums, timestamp=1441253051672,

value=0

 2012to2005top6 column=info:Profit, timestamp=1441253051672, value=-244

 2012to2005top6 column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005top62 column=info:Profit, timestamp=1441253051672, value=-262

 2012to2005top62 column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005top62R column=info:Profit, timestamp=1441253051672, value=-249

 2012to2005top62R column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005top63 column=info:Profit, timestamp=1441253051672, value=-181

 2012to2005top63 column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005top63R column=info:Profit, timestamp=1441253051672, value=-262

 2012to2005top63R column=info:Win4nums, timestamp=1441253051672, value=0

 2012to2005top6R column=info:Profit, timestamp=1441253051672, value=-253

 2012to2005top6R column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005all6avg column=info:Profit, timestamp=1441253051672, value=-157

 2013to2005all6avg column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005all6avgR column=info:Profit, timestamp=1441253051672, value=-157

 2013to2005all6avgR column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005all6med column=info:Profit, timestamp=1441253051672, value=-157

2013to2005all6med column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005all6medR column=info:Profit, timestamp=1441253051672, value=-157

 2013to2005all6medR column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005bottomall6 column=info:Profit, timestamp=1441253051672, value=-157

 2013to2005bottomall6 column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005bottomall6R column=info:Profit, timestamp=1441253051672, value=-157

 2013to2005bottomall6R column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005individualbottomall6 column=info:Profit, timestamp=1441253051672, value=-157

 2013to2005individualbottomall6 column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005individualbottomall6R column=info:Profit, timestamp=1441253051672, value=-157

 2013to2005individualbottomall6R column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005individualtop5Nmega column=info:Profit, timestamp=1441253051672, value=-141

 2013to2005individualtop5Nmega column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005individualtop5Nmega2 column=info:Profit, timestamp=1441253051672, value=-140

 2013to2005individualtop5Nmega2 column=info:Win4nums, timestamp=1441253051672, value=0

2013to2005individualtop5Nmega2R column=info:Profit, timestamp=1441253051672, value=-157

 2013to2005individualtop5Nmega2R column=info:Win4nums, timestamp=1441253051672, value=0

2013to2005individualtop5Nmega3 column=info:Profit, timestamp=1441253051672, value=-143

 2013to2005individualtop5Nmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005individualtop5Nmega3R column=info:Profit, timestamp=1441253051672, value=-157

 2013to2005individualtop5Nmega3R column=info:Win4nums, timestamp=1441253051672, value=0

2013to2005individualtop5NmegaR column=info:Profit, timestamp=1441253051672, value=-157

 2013to2005individualtop5NmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005individualtop5NmegaSL1 column=info:Profit, timestamp=1441253051672, value=-141

 2013to2005individualtop5NmegaSL1 column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005individualtop5NmegaSL2 column=info:Profit, timestamp=1441253051672, value=-157

 2013to2005individualtop5NmegaSL2 column=info:Win4nums, timestamp=1441253051672,value=0

 2013to2005individualtop5NmegaSL3 column=info:Profit, timestamp=1441253051672, value=-157

 2013to2005individualtop5NmegaSL3 column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005individualtop5NmegaSL4 column=info:Profit, timestamp=1441253051672, value=-157

 2013to2005individualtop5NmegaSL4 column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005top5Nmega column=info:Profit, timestamp=1441253051672, value=-139

 2013to2005top5Nmega column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005top5Nmega2 column=info:Profit, timestamp=1441253051672, value=-157

 2013to2005top5Nmega2 column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005top5Nmega2R column=info:Profit, timestamp=1441253051672, value=-157

 2013to2005top5Nmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005top5Nmega3 column=info:Profit, timestamp=1441253051672, value=-157

 2013to2005top5Nmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005top5Nmega3R column=info:Profit, timestamp=1441253051672, value=-

135

 2013to2005top5Nmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005top5NmegaR column=info:Profit, timestamp=1441253051672, value=-148

 2013to2005top5NmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005top5numsNmega column=info:Profit, timestamp=1441253051672, value=-157

2013to2005top5numsNmega column=info:Win4nums, timestamp=1441253051672, value=0

2013to2005top5numsNmega2 column=info:Profit, timestamp=1441253051672, value=-146

 2013to2005top5numsNmega2 column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005top5numsNmega2R column=info:Profit, timestamp=1441253051672,

value=-157

 2013to2005top5numsNmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005top5numsNmega3 column=info:Profit, timestamp=1441253051672, value=-148

 2013to2005top5numsNmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005top5numsNmega3R column=info:Profit, timestamp=1441253051672, value=-157

 2013to2005top5numsNmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005top5numsNmegaR column=info:Profit, timestamp=1441253051672, value=-157

 2013to2005top5numsNmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005top6 column=info:Profit, timestamp=1441253051672, value=-148

 2013to2005top6 column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005top62 column=info:Profit, timestamp=1441253051672, value=-148

 2013to2005top62 column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005top62R column=info:Profit, timestamp=1441253051672, value=-137

 2013to2005top62R column=info:Win4nums, timestamp=1441253051672, value=0

2013to2005top63 column=info:Profit, timestamp=1441253051672, value=-144

 2013to2005top63 column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005top63R column=info:Profit, timestamp=1441253051672, value=-157

 2013to2005top63R column=info:Win4nums, timestamp=1441253051672, value=0

 2013to2005top6R column=info:Profit, timestamp=1441253051672, value=-147

 2013to2005top6R column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005all6avg column=info:Profit, timestamp=1441253051672, value=-53

 2014to2005all6avg column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005all6avgR column=info:Profit, timestamp=1441253051672, value=-53

2014to2005all6avgR column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005all6med column=info:Profit, timestamp=1441253051672, value=-53

 2014to2005all6med column=info:Win4nums, timestamp=1441253051672, value=0

2014to2005all6medR column=info:Profit, timestamp=1441253051672, value=-53

 2014to2005all6medR column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005bottomall6 column=info:Profit, timestamp=1441253051672, value=-53

 2014to2005bottomall6 column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005bottomall6R column=info:Profit, timestamp=1441253051672, value=-53

 2014to2005bottomall6R column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005individualbottomall6 column=info:Profit, timestamp=1441253051672, value=-53

2014to2005individualbottomall6 column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005individualbottomall6R column=info:Profit, timestamp=1441253051672, value=-53

 2014to2005individualbottomall6R column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005individualtop5Nmega column=info:Profit, timestamp=1441253051672, value=-46

 2014to2005individualtop5Nmega column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005individualtop5Nmega2 column=info:Profit, timestamp=1441253051672, value=-36

 2014to2005individualtop5Nmega2 column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005individualtop5Nmega2R column=info:Profit, timestamp=1441253051672, value=-48

 2014to2005individualtop5Nmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005individualtop5Nmega3 column=info:Profit, timestamp=1441253051672, value=-52

 2014to2005individualtop5Nmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005individualtop5Nmega3R column=info:Profit, timestamp=1441253051672, value=-51

 2014to2005individualtop5Nmega3R column=info:Win4nums, timestamp=1441253051672, value=0

2014to2005individualtop5NmegaR column=info:Profit, timestamp=1441253051672, value=-46

 2014to2005individualtop5NmegaR column=info:Win4nums, timestamp=1441253051672, value=0

2014to2005individualtop5NmegaSL1 column=info:Profit, timestamp=1441253051672, value=-47

 2014to2005individualtop5NmegaSL1 column=info:Win4nums, timestamp=1441253051672,value=0

 2014to2005individualtop5NmegaSL2 column=info:Profit, timestamp=1441253051672, value=-53

 2014to2005individualtop5NmegaSL2 column=info:Win4nums, timestamp=1441253051672,value=0

2014to2005individualtop5NmegaSL3 column=info:Profit, timestamp=1441253051672, value=-53

 2014to2005individualtop5NmegaSL3 column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005individualtop5NmegaSL4 column=info:Profit, timestamp=1441253051672, value=-53

 2014to2005individualtop5NmegaSL4 column=info:Win4nums, timestamp=1441253051672, value=0

2014to2005top5Nmega column=info:Profit, timestamp=1441253051672, value=-41

 2014to2005top5Nmega column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005top5Nmega2 column=info:Profit, timestamp=1441253051672, value=-47

 2014to2005top5Nmega2 column=info:Win4nums, timestamp=1441253051672, value=0

2014to2005top5Nmega2R column=info:Profit, timestamp=1441253051672, value=-49

 2014to2005top5Nmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005top5Nmega3 column=info:Profit, timestamp=1441253051672, value=-50

 2014to2005top5Nmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005top5Nmega3R column=info:Profit, timestamp=1441253051672, value=-50

 2014to2005top5Nmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005top5NmegaR column=info:Profit, timestamp=1441253051672, value=-44

 2014to2005top5NmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005top5numsNmega column=info:Profit, timestamp=1441253051672, value=-53

 2014to2005top5numsNmega column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005top5numsNmega2 column=info:Profit, timestamp=1441253051672, value=-53

2014to2005top5numsNmega2 column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005top5numsNmega2R column=info:Profit, timestamp=1441253051672, value=-48

 2014to2005top5numsNmega2R column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005top5numsNmega3 column=info:Profit, timestamp=1441253051672, value=-53

2014to2005top5numsNmega3 column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005top5numsNmega3R column=info:Profit, timestamp=1441253051672, value=-51

 2014to2005top5numsNmega3R column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005top5numsNmegaR column=info:Profit, timestamp=1441253051672, value=-45

2014to2005top5numsNmegaR column=info:Profit, timestamp=1441253051672, value=-45

 2014to2005top5numsNmegaR column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005top6 column=info:Profit, timestamp=1441253051672, value=-53

 2014to2005top6 column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005top62 column=info:Profit, timestamp=1441253051672, value=-53

 2014to2005top62 column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005top62R column=info:Profit, timestamp=1441253051672, value=-53

 2014to2005top62R column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005top63 column=info:Profit, timestamp=1441253051672, value=-50

 2014to2005top63 column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005top63R column=info:Profit, timestamp=1441253051672, value=-53

 2014to2005top63R column=info:Win4nums, timestamp=1441253051672, value=0

 2014to2005top6R column=info:Profit, timestamp=1441253051672, value=-53

 2014to2005top6R column=info:Win4nums, timestamp=1441253051672, value=0

360 row(s) in 3.2750 seconds

 Click here to go to Chapter 9:   www.leisdesignservices.com/conclusion.htm

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