Sqoop

/usr/local/sqoop/bin/sqoop import –connect jdbc:mysql://IP/DBname–username user –password pass -table tablename –target-dir /root/filename  –direct –null-string ”  –null-non-string ”

export HADOOP_MAPRED_HOME=/home/hadoop-user/hadoop-1.2.1
export HADOOP_COMMON_HOME=/home/hadoop-user/hadoop-1.2.1

– 

~/hadoop-1.2.1/bin/hadoop job -kill job_201404031318_0001

Whirr

[moyal.ravindra@localhost ~]$ export JAVA_HOME=/home/moyal.ravindra/jdk1.6.0_45
[moyal.ravindra@localhost ~]$ export PATH=$JAVA_HOME/bin:$PATH
[moyal.ravindra@localhost ~]$ java -version

 

 

 

[hadoop-datanode+hadoop-tasktracker]: ssh -i /home/moyal.ravindra/.ssh/id_rsa -o “UserKnownHostsFile /dev/null” -o StrictHostKeyChecking=no moyal.ravindra@54.81.152.45
[hadoop-datanode+hadoop-tasktracker]: ssh -i /home/moyal.ravindra/.ssh/id_rsa -o “UserKnownHostsFile /dev/null” -o StrictHostKeyChecking=no moyal.ravindra@54.205.180.58
[hadoop-datanode+hadoop-tasktracker]: ssh -i /home/moyal.ravindra/.ssh/id_rsa -o “UserKnownHostsFile /dev/null” -o StrictHostKeyChecking=no moyal.ravindra@54.237.149.163
[hadoop-namenode+hadoop-jobtracker]: ssh -i /home/moyal.ravindra/.ssh/id_rsa -o “UserKnownHostsFile /dev/null” -o StrictHostKeyChecking=no moyal.ravindra@54.80.152.150