LEI'S DESIGN SERVICES

EXPERIENCED IN CHIP DESIGN VERIFICATION

Chapter 6:  Sqoop Export from HDFS to MYSQL

 

 Figure 5:  Sqoop export from HDFS to MYSQL diagram

6.1 Dataset

HDFS source file:  /output/megamillionDataExtraction/Period-r-00000

 

6.2 Problem Statement

Export HDFS file that contains the summary of the data analysis report to a table in MYSQL.

 

6.3 Approach

a)      Create a database, megamillionAnalysis, in MYSQL.  Create a table, megamillionDataExtraction, in MYSQL. 

b)      Use Sqoop to export the summary report from HDFS to a MYSQL table.

c)      Use MYSQL to do post-processing of the MYSQL table.

Figure 5 above shows the Sqoop export from HDFS to MYSQL diagram.

 

6.4 Code

unix shell script to run sqoop export:  runsqoopexportmegamillion

Command: ./ runsqoopexportmegamillion

Code content:

mysql -u root -p < mysqlMegamillion

rm /home/notroot/lab/workspacehadoopHW/./megamillionDataExtraction.java

 

sqoop export --connect jdbc:mysql://localhost/megamillionAnalysis --table megamillionDataExtraction --username root -P --export-dir /output/megamillionDataExtraction/Period-r-00000 --input-fields-terminated-by ',' --lines-terminated-by '\n' --verbose

 

mysql -u root -p < mysqlmegamillionPostProcessing

 

MYSQL database and table creation file name:  mysqlMegamillion

 

Command:  mysql -u root -p < mysqlMegamillion, which is found in the unix shell script, runsqoopexportmegamillion.

Code content:

#mysql -u root -p

drop database megamillionAnalysis;

create database megamillionAnalysis;

use megamillionAnalysis;

create Table megamillionDataExtraction(

ID VARCHAR(70) NOT NULL,

Period VARCHAR(20) NOT NULL,

AnalysisType VARCHAR(50) NOT NULL,

Win6nums VARCHAR(10) NOT NULL,

Win5nums VARCHAR(10) NOT NULL,

Win4numsNmega VARCHAR(10) NOT NULL,

Win4nums VARCHAR(10) NOT NULL,

Win3numsNmega VARCHAR(10) NOT NULL,

Win3nums VARCHAR(10) NOT NULL,

Win2numsNmega VARCHAR(10) NOT NULL,

Win1numNmega VARCHAR(10) NOT NULL,

Winmega VARCHAR(10) NOT NULL,

Profit VARCHAR(10) NOT NULL,

WinPercent VARCHAR(10) NOT NULL,

PRIMARY KEY(ID));

 

MYSQL file for post-processing: mysqlmegamillionPostProcessing

Command: mysql -u root -p < mysqlmegamillionPostProcessing

Code content:

use megamillionAnalysis;

#to display the columns Period, AnalysisType, Profit, and WinPercent from

#MYSQL table, megamillionDataExtraction

 select Period,AnalysisType,Profit,WinPercent from megamillionDataExtraction;

 

6.5 Execution

Command to create database and table in MYSQL, export from HDFS to MYSQL using Sqoop, and extract column data from MYSQL:

./ runsqoopexportmegamillion

 

 

Output result content:

 Enter password:
rm: cannot remove `/home/notroot/lab/workspacehadoopHW/./megamillionDataExtracti
on.java': No such file or directory
15/09/14 15:11:44 DEBUG tool.BaseSqoopTool: Enabled debug logging.
Enter password:
15/09/14 15:11:49 DEBUG sqoop.ConnFactory: Loaded manager factory: com.cloudera.
sqoop.manager.DefaultManagerFactory
15/09/14 15:11:49 DEBUG sqoop.ConnFactory: Trying ManagerFactory: com.cloudera.s
qoop.manager.DefaultManagerFactory
15/09/14 15:11:49 DEBUG manager.DefaultManagerFactory: Trying with scheme: jdbc:
mysql:
15/09/14 15:11:49 INFO manager.MySQLManager: Preparing to use a MySQL streaming
resultset.
15/09/14 15:11:49 DEBUG sqoop.ConnFactory: Instantiated ConnManager org.apache.s
qoop.manager.MySQLManager@16a4e4b
15/09/14 15:11:49 INFO tool.CodeGenTool: Beginning code generation
15/09/14 15:11:50 DEBUG manager.SqlManager: No connection paramenters specified.
 Using regular API for making connection.
15/09/14 15:11:51 DEBUG manager.SqlManager: Using fetchSize for next query: -214
7483648
15/09/14 15:11:51 INFO manager.SqlManager: Executing SQL statement: SELECT t.* F
ROM `megamillionDataExtraction` AS t LIMIT 1
15/09/14 15:11:51 DEBUG orm.ClassWriter: selected columns:
15/09/14 15:11:51 DEBUG orm.ClassWriter:   ID
15/09/14 15:11:51 DEBUG orm.ClassWriter:   Period
15/09/14 15:11:51 DEBUG orm.ClassWriter:   AnalysisType
15/09/14 15:11:51 DEBUG orm.ClassWriter:   Win6nums
15/09/14 15:11:51 DEBUG orm.ClassWriter:   Win5nums
15/09/14 15:11:51 DEBUG orm.ClassWriter:   Win4numsNmega
15/09/14 15:11:51 DEBUG orm.ClassWriter:   Win4nums
15/09/14 15:11:51 DEBUG orm.ClassWriter:   Win3numsNmega
15/09/14 15:11:51 DEBUG orm.ClassWriter:   Win3nums
15/09/14 15:11:51 DEBUG orm.ClassWriter:   Win2numsNmega
15/09/14 15:11:51 DEBUG orm.ClassWriter:   Win1numNmega
15/09/14 15:11:51 DEBUG orm.ClassWriter:   Winmega
15/09/14 15:11:51 DEBUG orm.ClassWriter:   Profit
15/09/14 15:11:51 DEBUG orm.ClassWriter:   WinPercent
15/09/14 15:11:51 DEBUG manager.SqlManager: Using fetchSize for next query: -214
7483648
15/09/14 15:11:51 INFO manager.SqlManager: Executing SQL statement: SELECT t.* F
ROM `megamillionDataExtraction` AS t LIMIT 1
15/09/14 15:11:51 DEBUG orm.ClassWriter: Writing source file: /tmp/sqoop-root/co
mpile/ce0df4ddef6beee4a8d5465f9efe1c0a/megamillionDataExtraction.java
15/09/14 15:11:51 DEBUG orm.ClassWriter: Table name: megamillionDataExtraction
15/09/14 15:11:51 DEBUG orm.ClassWriter: Columns: ID:12, Period:12, AnalysisType
:12, Win6nums:12, Win5nums:12, Win4numsNmega:12, Win4nums:12, Win3numsNmega:12,
Win3nums:12, Win2numsNmega:12, Win1numNmega:12, Winmega:12, Profit:12, WinPercen
t:12,
15/09/14 15:11:51 DEBUG orm.ClassWriter: sourceFilename is megamillionDataExtrac
tion.java
15/09/14 15:11:51 DEBUG orm.CompilationManager: Found existing /tmp/sqoop-root/c
ompile/ce0df4ddef6beee4a8d5465f9efe1c0a/
15/09/14 15:11:51 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /home/notro
ot/lab/software/hadoop-2.6.0
15/09/14 15:11:52 DEBUG orm.CompilationManager: Adding source file: /tmp/sqoop-r
oot/compile/ce0df4ddef6beee4a8d5465f9efe1c0a/megamillionDataExtraction.java
15/09/14 15:11:52 DEBUG orm.CompilationManager: Invoking javac with args:
15/09/14 15:11:52 DEBUG orm.CompilationManager:   -sourcepath
15/09/14 15:11:52 DEBUG orm.CompilationManager:   /tmp/sqoop-root/compile/ce0df4
ddef6beee4a8d5465f9efe1c0a/
15/09/14 15:11:52 DEBUG orm.CompilationManager:   -d
15/09/14 15:11:52 DEBUG orm.CompilationManager:   /tmp/sqoop-root/compile/ce0df4
ddef6beee4a8d5465f9efe1c0a/
15/09/14 15:11:52 DEBUG orm.CompilationManager:   -classpath
15/09/14 15:11:52 DEBUG orm.CompilationManager:   /home/notroot/lab/software/had
oop-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/sh
are/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/h
adoop-2.6.0/share/hadoop/common/lib/servlet-api-2.5.jar:/home/notroot/lab/softwa
re/hadoop-2.6.0/share/hadoop/common/lib/zookeeper-3.4.6.jar:/home/notroot/lab/so
ftware/hadoop-2.6.0/share/hadoop/common/lib/curator-framework-2.6.0.jar:/home/no
troot/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.j
ar:/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/jerse
y-core-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/a
pacheds-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/sha
re/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/la
b/software/hadoop-2.6.0/share/hadoop/common/lib/htrace-core-3.0.4.jar:/home/notr
oot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/hadoop-auth-2.6.0.jar:/hom
e/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-ap
i-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/comm
on/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/hado
op-2.6.0/share/hadoop/common/lib/jersey-server-1.9.jar:/home/notroot/lab/softwar
e/hadoop-2.6.0/share/hadoop/common/lib/jackson-mapper-asl-1.9.13.jar:/home/notro
ot/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-cod
ec-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/h
adoop/common/lib/jaxb-impl-2.2.3-1.jar:/home/notroot/lab/software/hadoop-2.6.0/s
hare/hadoop/common/lib/hadoop-annotations-2.6.0.jar:/home/notroot/lab/software/h
adoop-2.6.0/share/hadoop/common/lib/xmlenc-0.52.jar:/home/notroot/lab/software/h
adoop-2.6.0/share/hadoop/common/lib/curator-client-2.6.0.jar:/home/notroot/lab/s
oftware/hadoop-2.6.0/share/hadoop/common/lib/jackson-core-asl-1.9.13.jar:/home/n
otroot/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-xmlb
uilder-0.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/j
unit-4.11.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/co
mmons-lang-2.6.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/l
ib/commons-io-2.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/commo
n/lib/log4j-1.2.17.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/comm
on/lib/asm-3.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/l
ib/mockito-all-1.8.5.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/co
mmon/lib/jersey-json-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoo
p/common/lib/commons-net-3.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/h
adoop/common/lib/commons-cli-1.2.jar:/home/notroot/lab/software/hadoop-2.6.0/sha
re/hadoop/common/lib/jsr305-1.3.9.jar:/home/notroot/lab/software/hadoop-2.6.0/sh
are/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/so
ftware/hadoop-2.6.0/share/hadoop/common/lib/gson-2.2.4.jar:/home/notroot/lab/sof
tware/hadoop-2.6.0/share/hadoop/common/lib/curator-recipes-2.6.0.jar:/home/notro
ot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jackson-jaxrs-1.9.13.jar:/h
ome/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/j
sch-0.1.42.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/a
vro-1.7.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/je
ts3t-0.9.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/j
ettison-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/comm
on/hadoop-nfs-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/com
mon/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/sh
are/hadoop/hdfs:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/se
rvlet-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/hdf
s/lib/jersey-core-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/h
dfs/lib/jetty-6.1.26.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hd
fs/lib/jetty-util-6.1.26.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoo
p/hdfs/lib/netty-3.6.2.Final.jar:/home/notroot/lab/software/hadoop-2.6.0/share/h
adoop/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/so
ftware/hadoop-2.6.0/share/hadoop/hdfs/lib/commons-codec-1.4.jar:/home/notroot/la
b/software/hadoop-2.6.0/share/hadoop/hdfs/lib/jersey-server-1.9.jar:/home/notroo
t/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:/ho
me/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-lan
g-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-h
dfs-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/hadoop-h
dfs-2.6.0-tests.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/li
b/guice-servlet-3.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yar
n/lib/activation-1.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/ya
rn/lib/guice-3.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/l
ib/jackson-xc-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/ya
rn/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/hadoo
p/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/sha
re/hadoop/yarn/lib/jetty-6.1.26.jar:/home/notroot/lab/software/hadoop-2.6.0/shar
e/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/had
oop-2.6.0/share/hadoop/yarn/lib/commons-httpclient-3.1.jar:/home/notroot/lab/sof
tware/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/notroo
t/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/commons-compress-1.4.1.jar:/ho
me/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jline-0.9.94.jar:/hom
e/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/gu
ava-11.0.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jax
b-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/hadoo
p/yarn/lib/javax.inject-1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hado
op/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/had
oop-2.6.0/share/hadoop/yarn/lib/log4j-1.2.17.jar:/home/notroot/lab/software/hado
op-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/s
hare/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/hado
op-2.6.0/share/hadoop/yarn/lib/jettison-1.1.jar:/home/notroot/lab/software/hadoo
p-2.6.0/share/hadoop/yarn/lib/aopalliance-1.0.jar:/home/notroot/lab/software/had
oop-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/s
oftware/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-server-web-proxy-2.6.0.jar:/h
ome/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/h
adoop/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/s
oftware/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-co
mmon-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/hadoo
p-2.6.0/share/hadoop/yarn/hadoop-yarn-server-resourcemanager-2.6.0.jar:/home/not
root/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-applications-distri
butedshell-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapred
uce/lib/hamcrest-core-1.3.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hado
op/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/had
oop-2.6.0/share/hadoop/mapreduce/lib/guice-3.0.jar:/home/notroot/lab/software/ha
doop-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/notro
ot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/lib/netty-3.6.2.Final.jar:/h
ome/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/commo
ns-compress-1.4.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapre
duce/lib/jersey-server-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/had
oop/mapreduce/lib/jackson-mapper-asl-1.9.13.jar:/home/notroot/lab/software/hadoo
p-2.6.0/share/hadoop/mapreduce/lib/hadoop-annotations-2.6.0.jar:/home/notroot/la
b/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/common
s-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/l
ib/paranamer-2.3.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapred
uce/lib/xz-1.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduc
e/lib/avro-1.7.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapred
uce/lib/jersey-guice-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoo
p/mapreduce/lib/aopalliance-1.0.jar:/home/notroot/lab/software/hadoop-2.6.0/shar
e/hadoop/mapreduce/hadoop-mapreduce-client-hs-plugins-2.6.0.jar:/home/notroot/la
b/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/ha
doop/mapreduce/hadoop-mapreduce-examples-2.6.0.jar:/home/notroot/lab/software/ha
doop-2.6.0/share/hadoop/mapreduce/hadoop-mapreduce-client-hs-2.6.0.jar:/home/not
root/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/hadoop-mapreduce-client-co
re-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/hado
op-mapreduce-client-shuffle-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/sh
are/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/bi
n/../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/softw
are/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/bin/../lib/avro-ipc-1.5.3.jar:/home/notr
oot/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-alph
a/bin/../lib/hsqldb-1.8.0.10.jar:/home/notroot/lab/software/sqoop-1.4.3.bin__had
oop-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:/ho
me/notroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/bin/../lib/jopt-simp
le-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:/ho
me/notroot/lab/software/hbase-1.1.0:/home/notroot/lab/software/hbase-1.1.0/lib/a
ctivation-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/no
troot/lab/software/hbase-1.1.0/lib/apacheds-kerberos-codec-2.0.0-M15.jar:/home/n
otroot/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/hbas
e-1.1.0/lib/asm-3.1.jar:/home/notroot/lab/software/hbase-1.1.0/lib/avro-1.7.4.ja
r:/home/notroot/lab/software/hbase-1.1.0/lib/commons-beanutils-1.7.0.jar:/home/n
otroot/lab/software/hbase-1.1.0/lib/commons-beanutils-core-1.8.0.jar:/home/notro
ot/lab/software/hbase-1.1.0/lib/commons-cli-1.2.jar:/home/notroot/lab/software/h
base-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-configura
tion-1.6.jar:/home/notroot/lab/software/hbase-1.1.0/lib/commons-daemon-1.0.13.ja
r:/home/notroot/lab/software/hbase-1.1.0/lib/commons-digester-1.8.jar:/home/notr
oot/lab/software/hbase-1.1.0/lib/commons-el-1.0.jar:/home/notroot/lab/software/h
base-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/sof
tware/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/disrupto
r-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/notroo
t/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/s
oftware/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/hb
ase-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/so
ftware/hbase-1.1.0/lib/hadoop-mapreduce-client-shuffle-2.5.1.jar:/home/notroot/l
ab/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-ann
otations-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:/ho
me/notroot/lab/software/hbase-1.1.0/lib/hbase-common-1.1.0-tests.jar:/home/notro
ot/lab/software/hbase-1.1.0/lib/hbase-examples-1.1.0.jar:/home/notroot/lab/softw
are/hbase-1.1.0/lib/hbase-hadoop2-compat-1.1.0.jar:/home/notroot/lab/software/hb
ase-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/not
root/lab/software/hbase-1.1.0/lib/httpclient-4.2.5.jar:/home/notroot/lab/softwar
e/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-j
axrs-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/s
oftware/hbase-1.1.0/lib/jasper-compiler-5.5.23.jar:/home/notroot/lab/software/hb
ase-1.1.0/lib/jasper-runtime-5.5.23.jar:/home/notroot/lab/software/hbase-1.1.0/l
ib/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/not
root/lab/software/hbase-1.1.0/lib/jaxb-impl-2.2.3-1.jar:/home/notroot/lab/softwa
re/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/notr
oot/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/so
ftware/hbase-1.1.0/lib/jetty-sslengine-6.1.26.jar:/home/notroot/lab/software/hba
se-1.1.0/lib/jetty-util-6.1.26.jar:/home/notroot/lab/software/hbase-1.1.0/lib/jo
ni-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/so
ftware/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/h
base-1.1.0/lib/libthrift-0.9.0.jar:/home/notroot/lab/software/hbase-1.1.0/lib/lo
g4j-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/softwa
re/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:/ho
me/notroot/lab/software/hbase-1.1.0/lib/slf4j-api-1.7.7.jar:/home/notroot/lab/so
ftware/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/spy
memcached-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/sn
appy-java-1.0.4.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/commo
n/lib/activation-1.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/co
mmon/lib/slf4j-log4j12-1.7.5.jar:/home/notroot/lab/software/hadoop-2.6.0/share/h
adoop/common/lib/jackson-xc-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/s
hare/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/sof
tware/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/notr
oot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-math3-3.1.1.jar:/h
ome/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jersey-core-1.9.ja
r:/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/je
tty-6.1.26.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/j
etty-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/com
mon/lib/netty-3.6.2.Final.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hado
op/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/ha
doop-2.6.0/share/hadoop/common/lib/htrace-core-3.0.4.jar:/home/notroot/lab/softw
are/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/n
otroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-el-1.0.jar:/hom
e/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/common
s-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/hado
op/common/lib/jsp-api-2.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hado
op/common/lib/commons-codec-1.4.jar:/home/notroot/lab/software/hadoop-2.6.0/shar
e/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/softwa
re/hadoop-2.6.0/share/hadoop/common/lib/httpclient-4.2.5.jar:/home/notroot/lab/s
oftware/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/c
ommon/lib/hadoop-annotations-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/s
hare/hadoop/common/lib/xmlenc-0.52.jar:/home/notroot/lab/software/hadoop-2.6.0/s
hare/hadoop/common/lib/curator-client-2.6.0.jar:/home/notroot/lab/software/hadoo
p-2.6.0/share/hadoop/common/lib/jackson-core-asl-1.9.13.jar:/home/notroot/lab/so
ftware/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.ja
r:/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-al
l-1.8.5.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jers
ey-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/com
mon/lib/jsr305-1.3.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/co
mmon/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/commo
n/lib/jasper-compiler-5.5.23.jar:/home/notroot/lab/software/hadoop-2.6.0/share/h
adoop/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/softwa
re/hadoop-2.6.0/share/hadoop/common/lib/jackson-jaxrs-1.9.13.jar:/home/notroot/l
ab/software/hadoop-2.6.0/share/hadoop/common/lib/commons-beanutils-core-1.8.0.ja
r:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jsch-0.1.42.ja
r:/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.ja
r:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/lib/jettison-1.1.j
ar:/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-co
mmon-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/common/hadoo
p-common-2.6.0-tests.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hd
fs:/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/ne
tty-3.6.2.Final.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/li
b/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/ha
doop/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/hado
op-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/ha
doop-2.6.0/share/hadoop/hdfs/lib/jersey-server-1.9.jar:/home/notroot/lab/softwar
e/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/la
b/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:/ho
me/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/commons-io-2.4.jar:/h
ome/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/log4j-1.2.17.jar:/ho
me/notroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/asm-3.2.jar:/home/not
root/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/commons-cli-1.2.jar:/home/n
otroot/lab/software/hadoop-2.6.0/share/hadoop/hdfs/lib/jsr305-1.3.9.jar:/home/no
troot/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:/ho
me/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-tes
ts.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/guice-servl
et-3.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/activat
ion-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/servle
t-api-2.5.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/zook
eeper-3.4.6.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/pr
otobuf-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/yar
n/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/ha
doop/yarn/lib/leveldbjni-all-1.8.jar:/home/notroot/lab/software/hadoop-2.6.0/sha
re/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/softwar
e/hadoop-2.6.0/share/hadoop/yarn/lib/commons-compress-1.4.1.jar:/home/notroot/la
b/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/not
root/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/jackson-mapper-asl-1.9.13.j
ar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/guava-11.0.2.ja
r:/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/ja
vax.inject-1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/lib/c
ommons-collections-3.2.1.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoo
p/yarn/lib/commons-lang-2.6.jar:/home/notroot/lab/software/hadoop-2.6.0/share/ha
doop/yarn/lib/commons-io-2.4.jar:/home/notroot/lab/software/hadoop-2.6.0/share/h
adoop/yarn/lib/jersey-client-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/sha
re/hadoop/yarn/lib/log4j-1.2.17.jar:/home/notroot/lab/software/hadoop-2.6.0/shar
e/hadoop/yarn/lib/asm-3.2.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hado
op/yarn/lib/jersey-json-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/ha
doop/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/h
adoop/yarn/lib/xz-1.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/y
arn/lib/jackson-jaxrs-1.9.13.jar:/home/notroot/lab/software/hadoop-2.6.0/share/h
adoop/yarn/lib/jersey-guice-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/shar
e/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/sha
re/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/hadoo
p-2.6.0/share/hadoop/yarn/hadoop-yarn-server-web-proxy-2.6.0.jar:/home/notroot/l
ab/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/ha
doop-yarn-registry-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoo
p/yarn/hadoop-yarn-server-nodemanager-2.6.0.jar:/home/notroot/lab/software/hadoo
p-2.6.0/share/hadoop/yarn/hadoop-yarn-server-tests-2.6.0.jar:/home/notroot/lab/s
oftware/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-common-2.6.0.jar:/home/notroo
t/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-server-common-2.6.0.ja
r:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/yarn/hadoop-yarn-server-a
pplicationhistoryservice-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/soft
ware/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/hamcr
est-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/sha
re/hadoop/mapreduce/lib/guice-3.0.jar:/home/notroot/lab/software/hadoop-2.6.0/sh
are/hadoop/mapreduce/lib/protobuf-java-2.5.0.jar:/home/notroot/lab/software/hado
op-2.6.0/share/hadoop/mapreduce/lib/jersey-core-1.9.jar:/home/notroot/lab/softwa
re/hadoop-2.6.0/share/hadoop/mapreduce/lib/netty-3.6.2.Final.jar:/home/notroot/l
ab/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/jers
ey-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/ha
doop-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/no
troot/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.j
ar:/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/jerse
y-guice-1.9.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/l
ib/aopalliance-1.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapr
educe/hadoop-mapreduce-client-hs-plugins-2.6.0.jar:/home/notroot/lab/software/ha
doop-2.6.0/share/hadoop/mapreduce/hadoop-mapreduce-client-jobclient-2.6.0.jar:/h
ome/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/hadoop-mapreduce-cl
ient-app-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduc
e/hadoop-mapreduce-examples-2.6.0.jar:/home/notroot/lab/software/hadoop-2.6.0/sh
are/hadoop/mapreduce/hadoop-mapreduce-client-hs-2.6.0.jar:/home/notroot/lab/soft
ware/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/ma
preduce/hadoop-mapreduce-client-common-2.6.0.jar:/home/notroot/lab/software/hado
op-2.6.0/share/hadoop/mapreduce/hadoop-mapreduce-client-jobclient-2.6.0-tests.ja
r:/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-tes
t-1.4.3.jar::/home/notroot/lab/software/hadoop-2.6.0/contrib/capacity-scheduler/
*.jar:/home/notroot/lab/software/hadoop-2.6.0/share/hadoop/mapreduce/hadoop-mapr
educe-client-core-2.6.0.jar:/home/notroot/lab/software/sqoop-1.4.3.bin__hadoop-2
.0.0-alpha/sqoop-1.4.3.jar
Note: /tmp/sqoop-root/compile/ce0df4ddef6beee4a8d5465f9efe1c0a/megamillionDataEx
traction.java uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
15/09/14 15:12:00 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-root
/compile/ce0df4ddef6beee4a8d5465f9efe1c0a/megamillionDataExtraction.jar
15/09/14 15:12:00 DEBUG orm.CompilationManager: Scanning for .class files in dir
ectory: /tmp/sqoop-root/compile/ce0df4ddef6beee4a8d5465f9efe1c0a
15/09/14 15:12:00 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-root/c
ompile/ce0df4ddef6beee4a8d5465f9efe1c0a/megamillionDataExtraction.class -> megam
illionDataExtraction.class
15/09/14 15:12:00 DEBUG orm.CompilationManager: Finished writing jar file /tmp/s
qoop-root/compile/ce0df4ddef6beee4a8d5465f9efe1c0a/megamillionDataExtraction.jar
15/09/14 15:12:00 INFO mapreduce.ExportJobBase: Beginning export of megamillionD
ataExtraction
15/09/14 15:12:00 DEBUG util.ClassLoaderStack: Checking for existing class: mega
millionDataExtraction
15/09/14 15:12:00 DEBUG util.ClassLoaderStack: Attempting to load jar through UR
L: jar:file:///tmp/sqoop-root/compile/ce0df4ddef6beee4a8d5465f9efe1c0a/megamilli
onDataExtraction.jar!/
15/09/14 15:12:00 DEBUG util.ClassLoaderStack: Previous classloader is sun.misc.
Launcher$AppClassLoader@369c4
15/09/14 15:12:00 DEBUG util.ClassLoaderStack: Testing class in jar: megamillion
DataExtraction
15/09/14 15:12:00 DEBUG util.ClassLoaderStack: Loaded jar into current JVM: jar:
file:///tmp/sqoop-root/compile/ce0df4ddef6beee4a8d5465f9efe1c0a/megamillionDataE
xtraction.jar!/
15/09/14 15:12:00 DEBUG util.ClassLoaderStack: Added classloader for jar /tmp/sq
oop-root/compile/ce0df4ddef6beee4a8d5465f9efe1c0a/megamillionDataExtraction.jar:
 java.net.FactoryURLClassLoader@1d102a2
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.cla
ss]
SLF4J: Found binding in [jar:file:/home/notroot/lab/software/hbase-1.1.0/lib/slf
4j-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/ha
doop-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 15:12:02 WARN util.NativeCodeLoader: Unable to load native-hadoop libra
ry for your platform... using builtin-java classes where applicable
15/09/14 15:12:03 INFO Configuration.deprecation: mapred.jar is deprecated. Inst
ead, use mapreduce.job.jar
15/09/14 15:12:06 DEBUG mapreduce.JobBase: Using InputFormat: class org.apache.s
qoop.mapreduce.ExportInputFormat
15/09/14 15:12:06 INFO Configuration.deprecation: mapred.reduce.tasks.speculativ
e.execution is deprecated. Instead, use mapreduce.reduce.speculative
15/09/14 15:12:06 INFO Configuration.deprecation: mapred.map.tasks.speculative.e
xecution is deprecated. Instead, use mapreduce.map.speculative
15/09/14 15:12:06 INFO Configuration.deprecation: mapred.map.tasks is deprecated
. Instead, use mapreduce.job.maps
15/09/14 15:12:06 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/n
otroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/sqoop-1.4.3.jar
15/09/14 15:12:06 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/n
otroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/lib/mysql-connector-java
-5.0.8.jar
15/09/14 15:12:06 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/n
otroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/sqoop-1.4.3.jar
15/09/14 15:12:06 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/n
otroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/sqoop-1.4.3.jar
15/09/14 15:12:06 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/n
otroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/lib/snappy-java-1.0.3.2.
jar
15/09/14 15:12:06 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/n
otroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/lib/commons-io-1.4.jar
15/09/14 15:12:06 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/n
otroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/lib/ant-contrib-1.0b3.ja
r
15/09/14 15:12:06 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/n
otroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/lib/ant-eclipse-1.0-jvm1
.2.jar
15/09/14 15:12:06 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/n
otroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/lib/avro-ipc-1.5.3.jar
15/09/14 15:12:06 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/n
otroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/lib/avro-1.5.3.jar
15/09/14 15:12:06 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/n
otroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/lib/hsqldb-1.8.0.10.jar
15/09/14 15:12:06 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/n
otroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/lib/paranamer-2.3.jar
15/09/14 15:12:06 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/n
otroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/lib/jackson-mapper-asl-1
.7.3.jar
15/09/14 15:12:06 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/n
otroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/lib/avro-mapred-1.5.3.ja
r
15/09/14 15:12:06 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/n
otroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/lib/mysql-connector-java
-5.0.8.jar
15/09/14 15:12:06 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/n
otroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/lib/jackson-core-asl-1.7
.3.jar
15/09/14 15:12:06 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/n
otroot/lab/software/sqoop-1.4.3.bin__hadoop-2.0.0-alpha/lib/jopt-simple-3.2.jar
15/09/14 15:12:07 INFO client.RMProxy: Connecting to ResourceManager at /0.0.0.0
:8032
15/09/14 15:12:12 INFO input.FileInputFormat: Total input paths to process : 1
15/09/14 15:12:12 DEBUG mapreduce.ExportInputFormat: Target numMapTasks=4
15/09/14 15:12:12 DEBUG mapreduce.ExportInputFormat: Total input bytes=26925
15/09/14 15:12:12 DEBUG mapreduce.ExportInputFormat: maxSplitSize=6731
15/09/14 15:12:12 INFO input.FileInputFormat: Total input paths to process : 1
15/09/14 15:12:13 DEBUG mapreduce.ExportInputFormat: Generated splits:
15/09/14 15:12:13 DEBUG mapreduce.ExportInputFormat:   Paths:/output/megamillion
DataExtraction/Period-r-00000:0+6731 Locations:localhost:;
15/09/14 15:12:13 DEBUG mapreduce.ExportInputFormat:   Paths:/output/megamillion
DataExtraction/Period-r-00000:6731+6731 Locations:localhost:;
15/09/14 15:12:13 DEBUG mapreduce.ExportInputFormat:   Paths:/output/megamillion
DataExtraction/Period-r-00000:13462+6731 Locations:localhost:;
15/09/14 15:12:13 DEBUG mapreduce.ExportInputFormat:   Paths:/output/megamillion
DataExtraction/Period-r-00000:20193+3366,/output/megamillionDataExtraction/Perio
d-r-00000:23559+3366 Locations:localhost:;
15/09/14 15:12:13 INFO mapreduce.JobSubmitter: number of splits:4
15/09/14 15:12:14 INFO mapreduce.JobSubmitter: Submitting tokens for job: job_14
42255635725_0003
15/09/14 15:12:15 INFO impl.YarnClientImpl: Submitted application application_14
42255635725_0003
15/09/14 15:12:16 INFO mapreduce.Job: The url to track the job: http://localhost
:8088/proxy/application_1442255635725_0003/
15/09/14 15:12:16 INFO mapreduce.Job: Running job: job_1442255635725_0003
15/09/14 15:12:49 INFO mapreduce.Job: Job job_1442255635725_0003 running in uber
 mode : false
15/09/14 15:12:49 INFO mapreduce.Job:  map 0% reduce 0%
15/09/14 15:13:21 INFO mapreduce.Job:  map 50% reduce 0%
15/09/14 15:13:47 INFO mapreduce.Job:  map 75% reduce 0%
15/09/14 15:13:48 INFO mapreduce.Job:  map 100% reduce 0%
15/09/14 15:13:49 INFO mapreduce.Job: Job job_1442255635725_0003 completed succe
ssfully
15/09/14 15:13:50 INFO mapreduce.Job: Counters: 30
    File System Counters
        FILE: Number of bytes read=0
        FILE: Number of bytes written=457524
        FILE: Number of read operations=0
        FILE: Number of large read operations=0
        FILE: Number of write operations=0
        HDFS: Number of bytes read=32634
        HDFS: Number of bytes written=0
        HDFS: Number of read operations=19
        HDFS: Number of large read operations=0
        HDFS: Number of write operations=0
    Job Counters
        Launched map tasks=4
        Data-local map tasks=4
        Total time spent by all maps in occupied slots (ms)=107429
        Total time spent by all reduces in occupied slots (ms)=0
        Total time spent by all map tasks (ms)=107429
        Total vcore-seconds taken by all map tasks=107429
        Total megabyte-seconds taken by all map tasks=110007296
    Map-Reduce Framework
        Map input records=360
        Map output records=360
        Input split bytes=581
        Spilled Records=0
        Failed Shuffles=0
        Merged Map outputs=0
        GC time elapsed (ms)=1641
        CPU time spent (ms)=6850
        Physical memory (bytes) snapshot=303517696
        Virtual memory (bytes) snapshot=2192109568
        Total committed heap usage (bytes)=130285568
    File Input Format Counters
        Bytes Read=0
    File Output Format Counters
        Bytes Written=0
15/09/14 15:13:50 INFO mapreduce.ExportJobBase: Transferred 31.8691 KB in 103.70
72 seconds (314.6745 bytes/sec)
15/09/14 15:13:50 INFO mapreduce.ExportJobBase: Exported 360 records.
15/09/14 15:13:50 DEBUG util.ClassLoaderStack: Restoring classloader: sun.misc.L
auncher$AppClassLoader@369c4

Enter password:

Period  AnalysisType    Profit    WinPercent

2005to2005     all6avg  -904     4

2005to2005     all6avgR           -949     2

2005to2005     all6med            -164     4

2005to2005     all6medR          -889     3

2005to2005     bottomall6        -939     3

2005to2005     bottomall6R      -958     2

2005to2005     individualbottomall6      -911     1

2005to2005     individualbottomall6R    -858     3

2005to2005     individualtop5Nmega    -937     2

2005to2005     individualtop5Nmega2  -912     3

2005to2005     individualtop5Nmega2R            -910     4

2005to2005     individualtop5Nmega3  -936     4

2005to2005     individualtop5Nmega3R            -932     2

2005to2005     individualtop5NmegaR  -942     3

2005to2005     individualtop5NmegaSL1          -919     2

2005to2005     individualtop5NmegaSL2          -960     2

2005to2005     individualtop5NmegaSL3          -956     0

2005to2005     individualtop5NmegaSL4          -956     0

2005to2005     top5Nmega      -925     3

2005to2005     top5Nmega2    -936     3

2005to2005     top5Nmega2R  -913     3

2005to2005     top5Nmega3    -247     0

2005to2005     top5Nmega3R  -921     2

2005to2005     top5NmegaR    -924     2

2005to2005     top5numsNmega          -974     0

2005to2005     top5numsNmega2        -974     0

2005to2005     top5numsNmega2R      -937     3

2005to2005     top5numsNmega3        -965     0

2005to2005     top5numsNmega3R      -880     2

2005to2005     top5numsNmegaR        -930     3

2005to2005     top6     -938     1

2005to2005     top62   -949     3

2005to2005     top62R -930     3

2005to2005     top63   -947     1

2005to2005     top63R -946     2

2005to2005     top6R   -835     4

2006to2005     all6avg  -814     4

2006to2005         all6avgR       -846         1

2006to2005         all6med         -854         2

2006to2005         all6medR       -843         2

2006to2005         bottomall6    -840         3

2006to2005         bottomall6R -838         2

2006to2005         individualbottomall6         -791         3

2006to2005         individualbottomall6R         -834         3

2006to2005         individualtop5Nmega         -857         2

2006to2005         individualtop5Nmega2       -829         3

2006to2005         individualtop5Nmega2R     -822         3

2006to2005         individualtop5Nmega3       -848         3

2006to2005         individualtop5Nmega3R     -826         2

2006to2005         individualtop5NmegaR       -839         2

2006to2005         individualtop5NmegaSL1   -847         3

2006to2005         individualtop5NmegaSL2   -839         2

2006to2005         individualtop5NmegaSL3   -846         2

2006to2005         individualtop5NmegaSL4   -879         0

2006to2005         top5Nmega -788         3

2006to2005         top5Nmega2         -842         1

2006to2005         top5Nmega2R         -870         0

2006to2005         top5Nmega3         -825         1

2006to2005         top5Nmega3R         -850         1

2006to2005         top5NmegaR         -835         2

2006to2005         top5numsNmega         -833         2

2006to2005         top5numsNmega2         -852         0

2006to2005         top5numsNmega2R         -799         2

2006to2005         top5numsNmega3         -853         1

2006to2005         top5numsNmega3R         -848         2

2006to2005         top5numsNmegaR         -833         2

2006to2005            top6            -816            2

2006to2005         top62         -861         0

2006to2005         top62R         -831         2

2006to2005         top63         -847         1

2006to2005         top63R         -870         1

2006to2005         top6R         -861         0

2007to2005         all6avg         -741         1

2007to2005         all6avgR       -646         3

2007to2005         all6med         -731         2

2007to2005         all6medR       -712         2

2007to2005         bottomall6    -784         0

2007to2005         bottomall6R -753         2

2007to2005         individualbottomall6         -731         2

2007to2005         individualbottomall6R         -732         2

2007to2005         individualtop5Nmega         -736         2

2007to2005         individualtop5Nmega2       -746         3

2007to2005            individualtop5Nmega2R          -767            2

2007to2005            individualtop5Nmega3            -702            3

2007to2005            individualtop5Nmega3R          -690            3

2007to2005            individualtop5NmegaR            -744            2

2007to2005            individualtop5NmegaSL1        -735            3

2007to2005            individualtop5NmegaSL2        -710            2

2007to2005            individualtop5NmegaSL3        -744            2

2007to2005            individualtop5NmegaSL4        -766            0

2007to2005            top5Nmega    -722            4

2007to2005            top5Nmega2  -715            3

2007to2005            top5Nmega2R            -707            4

2007to2005            top5Nmega3  -650            4

2007to2005            top5Nmega3R            -720            4

2007to2005            top5NmegaR  -739            1

2007to2005            top5numsNmega            -739            1

2007to2005            top5numsNmega2            -746            3

2007to2005            top5numsNmega2R            -736            2

2007to2005            top5numsNmega3            -752            1

2007to2005            top5numsNmega3R            -705            2

2007to2005            top5numsNmegaR            -11            2

2007to2005            top6            -757            0

2007to2005            top62            -717            3

2007to2005            top62R            -676            1

2007to2005            top63            -757            0

2007to2005            top63R            -726            2

2007to2005            top6R            -720            3

2008to2005            all6avg            -646            2

2008to2005            all6avgR          -636            2

2008to2005            all6med            -651            1

2008to2005            all6medR          -656            2

2008to2005            bottomall6       -670            0

2008to2005            bottomall6R    -639            4

2008to2005            individualbottomall6            -625            3

2008to2005            individualbottomall6R            -648            2

2008to2005            individualtop5Nmega            89            3

2008to2005            individualtop5Nmega2            -630            4

2008to2005            individualtop5Nmega2R          -647            2

2008to2005            individualtop5Nmega3            -556            4

2008to2005            individualtop5Nmega3R          -630            1

2008to2005            individualtop5NmegaR            -620            3

2008to2005            individualtop5NmegaSL1        -609            5

2008to2005            individualtop5NmegaSL2        -619            2

2008to2005            individualtop5NmegaSL3        -624            2

2008to2005            individualtop5NmegaSL4        84            1

2008to2005            top5Nmega    -646            2

2008to2005            top5Nmega2  -658            1

2008to2005            top5Nmega2R            -649            1

2008to2005         top5Nmega3         -647         1

2008to2005         top5Nmega3R         -652         2

2008to2005         top5NmegaR         -636         1

2008to2005         top5numsNmega         -640         3

2008to2005         top5numsNmega2         -661         0

2008to2005         top5numsNmega2R         -616         2

2008to2005         top5numsNmega3         -656         1

2008to2005         top5numsNmega3R         -644         1

2008to2005         top5numsNmegaR         -652         2

2008to2005         top6         -640         3

2008to2005         top62         -626         3

2008to2005         top62R         -625         3

2008to2005         top63         -652         2

2008to2005         top63R         -661         0

2008to2005         top6R         -652         2

2009to2005         all6avg         -525         4

2009to2005         all6avgR       -540         2

2009to2005         all6med         173         2

2009to2005         all6medR       -534         2

2009to2005         bottomall6    -539         1

2009to2005         bottomall6R -519         3

2009to2005         individualbottomall6         -496         2

2009to2005         individualbottomall6R         -555         1

2009to2005         individualtop5Nmega         -518         4

2009to2005         individualtop5Nmega2       -537         3

2009to2005         individualtop5Nmega2R     -570         1

2009to2005         individualtop5Nmega3       -526         5

2009to2005         individualtop5Nmega3R     -525         4

2009to2005         individualtop5NmegaR       -534         2

2009to2005         individualtop5NmegaSL1   -518         4

2009to2005         individualtop5NmegaSL2   -532         2

2009to2005         individualtop5NmegaSL3   -541         1

2009to2005         individualtop5NmegaSL4   -539         1

2009to2005         top5Nmega -556         3

2009to2005         top5Nmega2         -556         3

2009to2005         top5Nmega2R         -554         2

2009to2005         top5Nmega3         -529         3

2009to2005         top5Nmega3R         -540         2

2009to2005         top5NmegaR         -541         3

2009to2005         top5numsNmega         -539         1

2009to2005         top5numsNmega2         182         3

2009to2005         top5numsNmega2R         -548         1

2009to2005         top5numsNmega3         -561         2

2009to2005         top5numsNmega3R         -536         2

2009to2005         top5numsNmegaR         -463         4

2009to2005            top6            -557            0

2009to2005         top62         -566         0

2009to2005         top62R         -534         2

2009to2005         top63         -523         4

2009to2005         top63R         -554         2

2009to2005         top6R         -557         0

2010to2005         all6avg         -439         1

2010to2005         all6avgR       -449         2

2010to2005         all6med         -437         1

2010to2005         all6medR       -437         1

2010to2005         bottomall6    -443         1

2010to2005         bottomall6R -415         5

2010to2005         individualbottomall6         -439         1

2010to2005         individualbottomall6R         -454         1

2010to2005         individualtop5Nmega         -433         3

2010to2005         individualtop5Nmega2       -414         4

2010to2005         individualtop5Nmega2R     -440         3

2010to2005         individualtop5Nmega3       -448         3

2010to2005         individualtop5Nmega3R     -553         3

2010to2005         individualtop5NmegaR       -453         2

2010to2005         individualtop5NmegaSL1   -431         3

2010to2005         individualtop5NmegaSL2   -453         1

2010to2005         individualtop5NmegaSL3   -452         0

2010to2005         individualtop5NmegaSL4   -443         1

2010to2005         top5Nmega -454         1

2010to2005         top5Nmega2         -451         2

2010to2005         top5Nmega2R         -463         1

2010to2005         top5Nmega3         -439         1

2010to2005         top5Nmega3R         -533         4

2010to2005         top5NmegaR         -453         3

2010to2005         top5numsNmega         280         3

2010to2005         top5numsNmega2         -374         2

2010to2005         top5numsNmega2R         -415         4

2010to2005         top5numsNmega3         -440         3

2010to2005         top5numsNmega3R         -537         2

2010to2005         top5numsNmegaR         -443         2

2010to2005         top6         -437         2

2010to2005         top62         -434         3

2010to2005         top62R         -418         3

2010to2005         top63         -361         5

2010to2005         top63R         -551         2

2010to2005         top6R         -453         1

2011to2005         all6avg         -315         2

2011to2005         all6avgR       -341         2

2011to2005         all6med         -348         1

2011to2005         all6medR       -334         2

2011to2005            bottomall6       -357            0

2011to2005      bottomall6R      -353      2

2011to2005      individualbottomall6    -358      2

2011to2005      individualbottomall6R  -357      2

2011to2005      individualtop5Nmega   -329      4

2011to2005      individualtop5Nmega2 -321      6

2011to2005      individualtop5Nmega2R      -338      4

2011to2005      individualtop5Nmega3 -335      4

2011to2005      individualtop5Nmega3R      -286      6

2011to2005      individualtop5NmegaR      -355      1

2011to2005      individualtop5NmegaSL1      -340      3

2011to2005      individualtop5NmegaSL2      -352      1

2011to2005      individualtop5NmegaSL3      -357      0

2011to2005      individualtop5NmegaSL4      -348      1

2011to2005      top5Nmega      -337      2

2011to2005      top5Nmega2      -364      1

2011to2005      top5Nmega2R      -332      4

2011to2005      top5Nmega3      382      3

2011to2005      top5Nmega3R      -316      2

2011to2005      top5NmegaR      -358      1

2011to2005      top5numsNmega      -339      1

2011to2005      top5numsNmega2      -354      2

2011to2005      top5numsNmega2R    -333      5

2011to2005      top5numsNmega3      -338      5

2011to2005      top5numsNmega3R    -297      7

2011to2005      top5numsNmegaR      -340      3

2011to2005    top6      -348      1

2011to2005    top62      -339      3

2011to2005    top62R      -350      2

2011to2005    top63      -329      4

2011to2005    top63R      -352      1

2011to2005    top6R      -357      2

2012to2005    all6avg      -242      2

2012to2005      all6avgR    -262      0

2012to2005    all6med      -242      2

2012to2005      all6medR    -262      0

2012to2005      bottomall6 -253      0

2012to2005      bottomall6R      -262      0

2012to2005      individualbottomall6    459      0

2012to2005      individualbottomall6R  -198      3

2012to2005      individualtop5Nmega   480      5

2012to2005      individualtop5Nmega2 -238      7

2012to2005      individualtop5Nmega2R      -248      4

2012to2005      individualtop5Nmega3 -222      7

2012to2005      individualtop5Nmega3R      -230      7

2012to2005      individualtop5NmegaR      -243      1

2012to2005            individualtop5NmegaSL1        -229            5

2012to2005            individualtop5NmegaSL2        -247            0

2012to2005            individualtop5NmegaSL3        -243            2

2012to2005            individualtop5NmegaSL4        465            0

2012to2005            top5Nmega    -243            1

2012to2005            top5Nmega2  -259            1

2012to2005            top5Nmega2R            -252            0

2012to2005            top5Nmega3  -249            1

2012to2005            top5Nmega3R            -185            4

2012to2005            top5NmegaR  -248            1

2012to2005            top5numsNmega            -244            1

2012to2005            top5numsNmega2            -253            0

2012to2005            top5numsNmega2R            -224            8

2012to2005            top5numsNmega3            -246            5

2012to2005            top5numsNmega3R            -230            7

2012to2005            top5numsNmegaR            -261            0

2012to2005            top6            -244            1

2012to2005            top62            -262            0

2012to2005            top62R            -249            4

2012to2005            top63            -181            4

2012to2005            top63R            -262            0

2012to2005            top6R            -253            0

2013to2005            all6avg            -157            0

2013to2005            all6avgR          -157            0

2013to2005            all6med            -157            0

2013to2005            all6medR          -157            0

2013to2005            bottomall6       -157            0

2013to2005            bottomall6R    -157            0

2013to2005            individualbottomall6            -157            0

2013to2005            individualbottomall6R            -157            0

2013to2005            individualtop5Nmega            -141            7

2013to2005            individualtop5Nmega2            -140            9

2013to2005            individualtop5Nmega2R          -157            0

2013to2005            individualtop5Nmega3            -143            7

2013to2005            individualtop5Nmega3R          -157            0

2013to2005            individualtop5NmegaR            -157            0

2013to2005            individualtop5NmegaSL1        -141            7

2013to2005            individualtop5NmegaSL2        -157            0

2013to2005            individualtop5NmegaSL3        -157            0

2013to2005            individualtop5NmegaSL4        -157            0

2013to2005            top5Nmega    -139            1

2013to2005            top5Nmega2  -157            0

2013to2005            top5Nmega2R            -157            0

2013to2005            top5Nmega3  -157            0

2013to2005            top5Nmega3R            -135            9

2013to2005            top5NmegaR  -148            1

2013to2005            top5numsNmega            -157            0

 

2013to2005         top5numsNmega2         -146         7

2013to2005         top5numsNmega2R         -157         0

2013to2005         top5numsNmega3         -148         4

2013to2005         top5numsNmega3R         -157         0

2013to2005         top5numsNmegaR         -157         0

2013to2005         top6         -148         1

2013to2005         top62         -148         5

2013to2005         top62R         -137         6

2013to2005         top63         -144         5

2013to2005         top63R         -157         0

2013to2005         top6R         -147         5

2014to2005         all6avg         -53         0

2014to2005         all6avgR       -53         0

2014to2005         all6med         -53         0

2014to2005         all6medR       -53         0

2014to2005         bottomall6    -53         0

2014to2005         bottomall6R -53         0

2014to2005         individualbottomall6         -53         0

2014to2005         individualbottomall6R         -53         0

2014to2005         individualtop5Nmega         -46         10

2014to2005         individualtop5Nmega2       -36         15

2014to2005         individualtop5Nmega2R     -48         6

2014to2005         individualtop5Nmega3       -52         2

2014to2005         individualtop5Nmega3R     -51         4

2014to2005         individualtop5NmegaR       -46         11

2014to2005         individualtop5NmegaSL1   -47         8

2014to2005         individualtop5NmegaSL2   -53         0

2014to2005         individualtop5NmegaSL3   -53         0

2014to2005         individualtop5NmegaSL4   -53         0

2014to2005         top5Nmega -41         10

2014to2005            top5Nmega2  -47            8

2014to2005         top5Nmega2R         -49         6

2014to2005         top5Nmega3         -50         6

2014to2005         top5Nmega3R         -50         6

2014to2005         top5NmegaR         -44         13

2014to2005         top5numsNmega         -53         0

2014to2005         top5numsNmega2         -53         0

2014to2005         top5numsNmega2R         -48         6

2014to2005         top5numsNmega3         -53         0

2014to2005         top5numsNmega3R         -51         4

2014to2005         top5numsNmegaR         -45         12

2014to2005         top6         -53         0

2014to2005         top62         -53         0

2014to2005         top62R         -53         0

2014to2005         top63         -50         6

2014to2005            top63R            -53            0

2014to2005            top6R            -53            0

 

 Click here to go to Chapter 7:   www.leisdesignservices.com/sqoopimportmysql2hive.htm

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