2 Questions regarding insert data into HBase. 1. Can free-form query be used with hbase as the destination data store? As I notice a target-dir must be specified when using free-form query?If can't then I have to import the data first into HDFS and then bulk load into HBase.
2. When I'm inserting data from Oracle into hbase directly, Both(free-form query or the the general form) throw the Exception 'Could not insert row with null value for row-key column' several times and this caused no rows inserted for the created hbase table. The command I'm using is sqoop import \ --verbose \ --connect jdbc:oracle:thin:@//10.239.47.36:1521/dx \ --connection-manager com.cloudera.sqoop.manager.OracleManager \ --username *** \ --password ****** \ --table ODS.TESTTABLE \ --column-family cf \ --hbase-create-table \ --hbase-row-key prod_inst_id \ --hbase-table testtable \ -m 1 The verbose output generated is 12/03/06 15:05:56 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead. 12/03/06 15:05:56 INFO manager.SqlManager: Using default fetchSize of 1000 12/03/06 15:05:56 INFO tool.CodeGenTool: Beginning code generation 12/03/06 15:05:56 INFO manager.OracleManager: Time zone has been set to GMT 12/03/06 15:05:56 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM ODS.TESTTABLE t WHERE 1=0 12/03/06 15:05:56 INFO orm.CompilationManager: HADOOP_HOME is /usr/lib/hadoop 12/03/06 15:05:56 INFO orm.CompilationManager: Found hadoop core jar at: /usr/lib/hadoop/hadoop-core.jar Note: /tmp/sqoop-wbian/compile/7b090c37478d9d670949f4924354bcb3/ODS_TESTTABLE.java uses or overrides a deprecated API. Note: Recompile with -Xlint:deprecation for details. 12/03/06 15:05:58 ERROR orm.CompilationManager: Could not rename /tmp/sqoop-wbian/compile/7b090c37478d9d670949f4924354bcb3/ODS_TESTTABLE.java to /home/wbian/./ODS_TESTTABLE.java java.io.IOException: Destination '/home/wbian/./ODS_TESTTABLE.java' already exists at org.apache.commons.io.FileUtils.moveFile(FileUtils.java:1811) at org.apache.sqoop.orm.CompilationManager.compile(CompilationManager.java:227) at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:83) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:367) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:453) at org.apache.sqoop.Sqoop.run(Sqoop.java:145) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) at org.apache.sqoop.Sqoop.main(Sqoop.java:238) at com.cloudera.sqoop.Sqoop.main(Sqoop.java:57) 12/03/06 15:05:58 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-wbian/compile/7b090c37478d9d670949f4924354bcb3/ODS.TESTTABLE.jar 12/03/06 15:05:58 INFO manager.OracleManager: Time zone has been set to GMT 12/03/06 15:05:58 INFO manager.OracleManager: Time zone has been set to GMT 12/03/06 15:05:58 INFO mapreduce.ImportJobBase: Beginning import of ODS.TESTTABLE 12/03/06 15:05:58 INFO manager.OracleManager: Time zone has been set to GMT 12/03/06 15:05:58 INFO zookeeper.ZooKeeper: Client environment:zookeeper.version=3.3.3-Intel-26555, built on 05/23/2011 04:09 GMT 12/03/06 15:05:58 INFO zookeeper.ZooKeeper: Client environment:host.name =xmlqa-clv17 12/03/06 15:05:58 INFO zookeeper.ZooKeeper: Client environment:java.version=1.6.0_16 12/03/06 15:05:58 INFO zookeeper.ZooKeeper: Client environment:java.vendor=Sun Microsystems Inc. 12/03/06 15:05:58 INFO zookeeper.ZooKeeper: Client environment:java.home=/usr/java/jdk1.6.0_16/jre 12/03/06 15:05:58 INFO zookeeper.ZooKeeper: Client environment:java.class.path=/usr/lib/hadoop/conf:/usr/java/jdk1.6.0_16/lib/tools.jar:/usr/lib/hadoop:/usr/lib/hadoop/hadoop-core-0.20.2-Intel.jar:/usr/lib/hadoop/lib/ant-contrib-1.0b3.jar:/usr/lib/hadoop/lib/aspectjrt-1.6.5.jar:/usr/lib/hadoop/lib/aspectjtools-1.6.5.jar:/usr/lib/hadoop/lib/commons-cli-1.2.jar:/usr/lib/hadoop/lib/commons-codec-1.4.jar:/usr/lib/hadoop/lib/commons-daemon-1.0.1.jar:/usr/lib/hadoop/lib/commons-el-1.0.jar:/usr/lib/hadoop/lib/commons-httpclient-3.0.1.jar:/usr/lib/hadoop/lib/commons-logging-1.0.4.jar:/usr/lib/hadoop/lib/commons-logging-api-1.0.4.jar:/usr/lib/hadoop/lib/commons-net-1.4.1.jar:/usr/lib/hadoop/lib/core-3.1.1.jar:/usr/lib/hadoop/lib/hadoop-fairscheduler-0.20.2-Intel.jar:/usr/lib/hadoop/lib/hsqldb-1.8.0.10.jar:/usr/lib/hadoop/lib/jackson-core-asl-1.5.2.jar:/usr/lib/hadoop/lib/jackson-mapper-asl-1.5.2.jar:/usr/lib/hadoop/lib/jasper-compiler-5.5.12.jar:/usr/lib/hadoop/lib/jasper-runtime-5.5.12.jar:/usr/lib/hadoop/lib/jets3t-0.6.1.jar:/usr/lib/hadoop/lib/jetty-6.1.26.jar:/usr/lib/hadoop/lib/jetty-servlet-tester-6.1.26.jar:/usr/lib/hadoop/lib/jetty-util-6.1.26.jar:/usr/lib/hadoop/lib/jsch-0.1.42.jar:/usr/lib/hadoop/lib/junit-4.5.jar:/usr/lib/hadoop/lib/kfs-0.2.2.jar:/usr/lib/hadoop/lib/log4j-1.2.15.jar:/usr/lib/hadoop/lib/mockito-all-1.8.2.jar:/usr/lib/hadoop/lib/oro-2.0.8.jar:/usr/lib/hadoop/lib/servlet-api-2.5-20081211.jar:/usr/lib/hadoop/lib/servlet-api-2.5-6.1.14.jar:/usr/lib/hadoop/lib/slf4j-api-1.4.3.jar:/usr/lib/hadoop/lib/slf4j-log4j12-1.4.3.jar:/usr/lib/hadoop/lib/xmlenc-0.52.jar:/usr/lib/hadoop/lib/jsp-2.1/jsp-2.1.jar:/usr/lib/hadoop/lib/jsp-2.1/jsp-api-2.1.jar:/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/bin/../conf:/etc/zookeeper::/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/bin/../lib/ant-contrib-1.0b3.jar:/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/bin/../lib/ant-eclipse-1.0-jvm1.2.jar:/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/bin/../lib/avro-1.5.3.jar:/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/bin/../lib/avro-ipc-1.5.3.jar:/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/bin/../lib/avro-mapred-1.5.3.jar:/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/bin/../lib/commons-io-1.4.jar:/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/bin/../lib/jackson-core-asl-1.7.3.jar:/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/bin/../lib/jackson-mapper-asl-1.7.3.jar:/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/bin/../lib/jopt-simple-3.2.jar:/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/bin/../lib/ojdbc6.jar:/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/bin/../lib/paranamer-2.3.jar:/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/bin/../lib/snappy-java-1.0.3.2.jar:/usr/lib/hbase/bin/../conf:/usr/java/jdk1.6.0_16/lib/tools.jar:/usr/lib/hbase/bin/..:/usr/lib/hbase/bin/../hbase-0.90.1-Intel.jar:/usr/lib/hbase/bin/../hbase-0.90.1-Intel-tests.jar:/usr/lib/hbase/bin/../lib/activation-1.1.jar:/usr/lib/hbase/bin/../lib/asm-3.1.jar:/usr/lib/hbase/bin/../lib/avro-1.3.3.jar:/usr/lib/hbase/bin/../lib/commons-cli-1.2.jar:/usr/lib/hbase/bin/../lib/commons-codec-1.4.jar:/usr/lib/hbase/bin/../lib/commons-el-1.0.jar:/usr/lib/hbase/bin/../lib/commons-httpclient-3.1.jar:/usr/lib/hbase/bin/../lib/commons-lang-2.5.jar:/usr/lib/hbase/bin/../lib/commons-logging-1.1.1.jar:/usr/lib/hbase/bin/../lib/commons-net-1.4.1.jar:/usr/lib/hbase/bin/../lib/core-3.1.1.jar:/usr/lib/hbase/bin/../lib/guava-r06.jar:/usr/lib/hbase/bin/../lib/hadoop-core.jar:/usr/lib/hbase/bin/../lib/hbase-0.90.1-cdh3u0.jar:/usr/lib/hbase/bin/../lib/jackson-core-asl-1.5.2.jar:/usr/lib/hbase/bin/../lib/jackson-jaxrs-1.5.5.jar:/usr/lib/hbase/bin/../lib/jackson-mapper-asl-1.5.2.jar:/usr/lib/hbase/bin/../lib/jackson-xc-1.5.5.jar:/usr/lib/hbase/bin/../lib/jasper-compiler-5.5.23.jar:/usr/lib/hbase/bin/../lib/jasper-runtime-5.5.23.jar:/usr/lib/hbase/bin/../lib/jaxb-api-2.1.jar:/usr/lib/hbase/bin/../lib/jaxb-impl-2.1.12.jar:/usr/lib/hbase/bin/../lib/jersey-core-1.4.jar:/usr/lib/hbase/bin/../lib/jersey-json-1.4.jar:/usr/lib/hbase/bin/../lib/jersey-server-1.4.jar:/usr/lib/hbase/bin/../lib/jettison-1.1.jar:/usr/lib/hbase/bin/../lib/jetty-6.1.26.jar:/usr/lib/hbase/bin/../lib/jetty-util-6.1.26.jar:/usr/lib/hbase/bin/../lib/jruby-complete-1.0.3.jar:/usr/lib/hbase/bin/../lib/jsp-2.1-6.1.14.jar:/usr/lib/hbase/bin/../lib/jsp-api-2.1-6.1.14.jar:/usr/lib/hbase/bin/../lib/jsp-api-2.1.jar:/usr/lib/hbase/bin/../lib/jsr311-api-1.1.1.jar:/usr/lib/hbase/bin/../lib/log4j-1.2.16.jar:/usr/lib/hbase/bin/../lib/protobuf-java-2.3.0.jar:/usr/lib/hbase/bin/../lib/servlet-api-2.5-6.1.14.jar:/usr/lib/hbase/bin/../lib/servlet-api-2.5.jar:/usr/lib/hbase/bin/../lib/slf4j-api-1.5.8.jar:/usr/lib/hbase/bin/../lib/slf4j-log4j12-1.5.8.jar:/usr/lib/hbase/bin/../lib/stax-api-1.0.1.jar:/usr/lib/hbase/bin/../lib/thrift-0.2.0.jar:/usr/lib/hbase/bin/../lib/xmlenc-0.52.jar:/usr/lib/hbase/bin/../lib/zookeeper.jar:/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/bin/../sqoop-1.4.1-incubating.jar:/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/bin/../sqoop-test-1.4.1-incubating.jar: 12/03/06 15:05:58 INFO zookeeper.ZooKeeper: Client environment:java.library.path=/usr/java/jdk1.6.0_16/jre/lib/amd64/server:/usr/java/jdk1.6.0_16/jre/lib/amd64:/usr/java/jdk1.6.0_16/jre/../lib/amd64:/usr/java/packages/lib/amd64:/lib:/usr/lib 12/03/06 15:05:58 INFO zookeeper.ZooKeeper: Client environment:java.io.tmpdir=/tmp 12/03/06 15:05:58 INFO zookeeper.ZooKeeper: Client environment:java.compiler=<NA> 12/03/06 15:05:58 INFO zookeeper.ZooKeeper: Client environment:os.name=Linux 12/03/06 15:05:58 INFO zookeeper.ZooKeeper: Client environment:os.arch=amd64 12/03/06 15:05:58 INFO zookeeper.ZooKeeper: Client environment:os.version=2.6.18-194.el5 12/03/06 15:05:58 INFO zookeeper.ZooKeeper: Client environment:user.name =wbian 12/03/06 15:05:58 INFO zookeeper.ZooKeeper: Client environment:user.home=/home/wbian 12/03/06 15:05:58 INFO zookeeper.ZooKeeper: Client environment:user.dir=/home/wbian 12/03/06 15:05:58 INFO zookeeper.ZooKeeper: Initiating client connection, connectString=localhost:2181 sessionTimeout=180000 watcher=hconnection 12/03/06 15:05:58 INFO zookeeper.ClientCnxn: Opening socket connection to server localhost/127.0.0.1:2181 12/03/06 15:05:58 INFO zookeeper.ClientCnxn: Socket connection established to localhost/127.0.0.1:2181, initiating session 12/03/06 15:05:58 INFO zookeeper.ClientCnxn: Session establishment complete on server localhost/127.0.0.1:2181, sessionid = 0x135e6c8eb0e000a, negotiated timeout = 40000 12/03/06 15:05:59 INFO zookeeper.ZooKeeper: Initiating client connection, connectString=localhost:2181 sessionTimeout=180000 watcher=hconnection 12/03/06 15:05:59 INFO zookeeper.ClientCnxn: Opening socket connection to server localhost/127.0.0.1:2181 12/03/06 15:05:59 INFO zookeeper.ClientCnxn: Socket connection established to localhost/127.0.0.1:2181, initiating session 12/03/06 15:05:59 INFO zookeeper.ClientCnxn: Session establishment complete on server localhost/127.0.0.1:2181, sessionid = 0x135e6c8eb0e000b, negotiated timeout = 40000 12/03/06 15:05:59 INFO client.HConnectionManager$HConnectionImplementation: Closed zookeeper sessionid=0x135e6c8eb0e000b 12/03/06 15:05:59 INFO zookeeper.ZooKeeper: Session: 0x135e6c8eb0e000b closed 12/03/06 15:05:59 INFO zookeeper.ClientCnxn: EventThread shut down 12/03/06 15:05:59 INFO mapreduce.HBaseImportJob: Creating missing column family cf 12/03/06 15:05:59 INFO client.HBaseAdmin: Started disable of testtable 12/03/06 15:06:01 INFO client.HBaseAdmin: Disabled testtable 12/03/06 15:06:01 INFO client.HBaseAdmin: Started enable of testtable 12/03/06 15:06:03 INFO client.HBaseAdmin: Enabled table testtable 12/03/06 15:06:03 INFO jvm.JvmMetrics: Initializing JVM Metrics with processName=JobTracker, sessionId= 12/03/06 15:06:03 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable 12/03/06 15:06:04 INFO filecache.TrackerDistributedCacheManager: Creating hadoop-core-0.20.2-Intel.jar in /tmp/hadoop-wbian/mapred/local/archive/5031318791855030283_136410111_450030624/file/usr/lib/hadoop-0.20-work-8150874651517300637 with rwxr-xr-x 12/03/06 15:06:04 INFO filecache.TrackerDistributedCacheManager: Cached file:///usr/lib/hadoop-0.20/hadoop-core-0.20.2-Intel.jar as /tmp/hadoop-wbian/mapred/local/archive/5031318791855030283_136410111_450030624/file/usr/lib/hadoop-0.20/hadoop-core-0.20.2-Intel.jar 12/03/06 15:06:04 INFO filecache.TrackerDistributedCacheManager: Cached file:///usr/lib/hadoop-0.20/hadoop-core-0.20.2-Intel.jar as /tmp/hadoop-wbian/mapred/local/archive/5031318791855030283_136410111_450030624/file/usr/lib/hadoop-0.20/hadoop-core-0.20.2-Intel.jar 12/03/06 15:06:04 INFO filecache.TrackerDistributedCacheManager: Creating hbase-0.90.1-Intel.jar in /tmp/hadoop-wbian/mapred/local/archive/4713627029477210743_1483051184_454450624/file/usr/lib/hbase-work-7387926945951189334 with rwxr-xr-x 12/03/06 15:06:05 INFO filecache.TrackerDistributedCacheManager: Cached file:///usr/lib/hbase/hbase-0.90.1-Intel.jar as /tmp/hadoop-wbian/mapred/local/archive/4713627029477210743_1483051184_454450624/file/usr/lib/hbase/hbase-0.90.1-Intel.jar 12/03/06 15:06:05 INFO filecache.TrackerDistributedCacheManager: Cached file:///usr/lib/hbase/hbase-0.90.1-Intel.jar as /tmp/hadoop-wbian/mapred/local/archive/4713627029477210743_1483051184_454450624/file/usr/lib/hbase/hbase-0.90.1-Intel.jar 12/03/06 15:06:05 INFO filecache.TrackerDistributedCacheManager: Creating zookeeper-3.3.3-Intel.jar in /tmp/hadoop-wbian/mapred/local/archive/-8512320636944104909_1432731519_453969624/file/usr/lib/zookeeper-work--2216285026564392901 with rwxr-xr-x 12/03/06 15:06:05 INFO filecache.TrackerDistributedCacheManager: Cached file:///usr/lib/zookeeper/zookeeper-3.3.3-Intel.jar as /tmp/hadoop-wbian/mapred/local/archive/-8512320636944104909_1432731519_453969624/file/usr/lib/zookeeper/zookeeper-3.3.3-Intel.jar 12/03/06 15:06:05 INFO filecache.TrackerDistributedCacheManager: Cached file:///usr/lib/zookeeper/zookeeper-3.3.3-Intel.jar as /tmp/hadoop-wbian/mapred/local/archive/-8512320636944104909_1432731519_453969624/file/usr/lib/zookeeper/zookeeper-3.3.3-Intel.jar 12/03/06 15:06:05 INFO mapred.JobClient: Running job: job_local_0001 12/03/06 15:06:05 INFO db.OracleDBRecordReader: Time zone has been set to GMT 12/03/06 15:06:05 INFO zookeeper.ZooKeeper: Initiating client connection, connectString=localhost:2181 sessionTimeout=180000 watcher=hconnection 12/03/06 15:06:05 INFO zookeeper.ClientCnxn: Opening socket connection to server localhost/127.0.0.1:2181 12/03/06 15:06:05 INFO zookeeper.ClientCnxn: Socket connection established to localhost/127.0.0.1:2181, initiating session 12/03/06 15:06:05 INFO zookeeper.ClientCnxn: Session establishment complete on server localhost/127.0.0.1:2181, sessionid = 0x135e6c8eb0e000c, negotiated timeout = 40000 12/03/06 15:06:05 WARN hbase.ToStringPutTransformer: Could not insert row with null value for row-key column: ods.prod_inst_id 12/03/06 15:06:05 WARN hbase.ToStringPutTransformer: Could not insert row with null value for row-key column: ods.prod_inst_id 12/03/06 15:06:05 WARN hbase.ToStringPutTransformer: Could not insert row with null value for row-key column: ods.prod_inst_id 12/03/06 15:06:05 WARN hbase.ToStringPutTransformer: Could not insert row with null value for row-key column: ods.prod_inst_id 12/03/06 15:06:05 WARN hbase.ToStringPutTransformer: Could not insert row with null value for row-key column: ods.prod_inst_id 12/03/06 15:06:05 WARN hbase.ToStringPutTransformer: Could not insert row with null value for row-key column: ods.prod_inst_id 12/03/06 15:06:05 WARN hbase.ToStringPutTransformer: Could not insert row with null value for row-key column: ods.prod_inst_id 12/03/06 15:06:05 WARN hbase.ToStringPutTransformer: Could not insert row with null value for row-key column: ods.prod_inst_id 12/03/06 15:06:05 WARN hbase.ToStringPutTransformer: Could not insert row with null value for row-key column: ods.prod_inst_id 12/03/06 15:06:05 INFO mapreduce.AutoProgressMapper: Auto-progress thread is finished. keepGoing=false 12/03/06 15:06:05 INFO mapred.Task: Task:attempt_local_0001_m_000000_0 is done. And is in the process of commiting 12/03/06 15:06:05 INFO mapred.LocalJobRunner: 12/03/06 15:06:05 INFO mapred.Task: Task 'attempt_local_0001_m_000000_0' done. 12/03/06 15:06:05 WARN mapred.FileOutputCommitter: Output path is null in cleanup 12/03/06 15:06:05 INFO filecache.TrackerDistributedCacheManager: Deleted path /tmp/hadoop-wbian/mapred/local/archive/-8678307515482551097_1594736111_1499475154/file/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/lib/ant-contrib-1.0b3.jar 12/03/06 15:06:05 INFO filecache.TrackerDistributedCacheManager: Deleted path /tmp/hadoop-wbian/mapred/local/archive/-7566775285572470667_488739095_1499475154/file/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/lib/ant-eclipse-1.0-jvm1.2.jar 12/03/06 15:06:05 INFO filecache.TrackerDistributedCacheManager: Deleted path /tmp/hadoop-wbian/mapred/local/archive/-5900444546989813954_-1041994625_1499475154/file/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/lib/avro-1.5.3.jar 12/03/06 15:06:05 INFO filecache.TrackerDistributedCacheManager: Deleted path /tmp/hadoop-wbian/mapred/local/archive/-9103367164376534268_-1831525490_1499475154/file/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/lib/avro-ipc-1.5.3.jar 12/03/06 15:06:05 INFO filecache.TrackerDistributedCacheManager: Deleted path /tmp/hadoop-wbian/mapred/local/archive/2030881177462672170_-1969891931_1499475154/file/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/lib/avro-mapred-1.5.3.jar 12/03/06 15:06:05 INFO filecache.TrackerDistributedCacheManager: Deleted path /tmp/hadoop-wbian/mapred/local/archive/-6191124054453207271_1286956530_1499475154/file/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/lib/commons-io-1.4.jar 12/03/06 15:06:05 INFO filecache.TrackerDistributedCacheManager: Deleted path /tmp/hadoop-wbian/mapred/local/archive/156540855680099969_1155742037_1499475154/file/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/lib/jackson-core-asl-1.7.3.jar 12/03/06 15:06:05 INFO filecache.TrackerDistributedCacheManager: Deleted path /tmp/hadoop-wbian/mapred/local/archive/6171713928332799985_919028471_1499475154/file/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/lib/jackson-mapper-asl-1.7.3.jar 12/03/06 15:06:05 INFO filecache.TrackerDistributedCacheManager: Deleted path /tmp/hadoop-wbian/mapred/local/archive/9219607508400540429_438125413_1499475154/file/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/lib/jopt-simple-3.2.jar 12/03/06 15:06:05 INFO filecache.TrackerDistributedCacheManager: Deleted path /tmp/hadoop-wbian/mapred/local/archive/-8063610095302874565_-765134359_1306675507/file/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/lib/ojdbc6.jar 12/03/06 15:06:05 INFO filecache.TrackerDistributedCacheManager: Deleted path /tmp/hadoop-wbian/mapred/local/archive/-1734959024390222106_-2070933226_1499475154/file/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/lib/paranamer-2.3.jar 12/03/06 15:06:05 INFO filecache.TrackerDistributedCacheManager: Deleted path /tmp/hadoop-wbian/mapred/local/archive/-1080511038660326174_-881975024_1499475154/file/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/lib/snappy-java-1.0.3.2.jar 12/03/06 15:06:05 INFO filecache.TrackerDistributedCacheManager: Deleted path /tmp/hadoop-wbian/mapred/local/archive/-3578110887859214983_1021750853_1499474154/file/home/wbian/sqoop-1.4.1-incubating__hadoop-0.20/sqoop-1.4.1-incubating.jar 12/03/06 15:06:05 INFO filecache.TrackerDistributedCacheManager: Deleted path /tmp/hadoop-wbian/mapred/local/archive/5031318791855030283_136410111_450030624/file/usr/lib/hadoop-0.20/hadoop-core-0.20.2-Intel.jar 12/03/06 15:06:05 INFO filecache.TrackerDistributedCacheManager: Deleted path /tmp/hadoop-wbian/mapred/local/archive/4713627029477210743_1483051184_454450624/file/usr/lib/hbase/hbase-0.90.1-Intel.jar 12/03/06 15:06:05 INFO filecache.TrackerDistributedCacheManager: Deleted path /tmp/hadoop-wbian/mapred/local/archive/-8512320636944104909_1432731519_453969624/file/usr/lib/zookeeper/zookeeper-3.3.3-Intel.jar 12/03/06 15:06:06 INFO mapred.JobClient: map 100% reduce 0% 12/03/06 15:06:06 INFO mapred.JobClient: Job complete: job_local_0001 12/03/06 15:06:06 INFO mapred.JobClient: Counters: 6 12/03/06 15:06:06 INFO mapred.JobClient: FileSystemCounters 12/03/06 15:06:06 INFO mapred.JobClient: FILE_BYTES_READ=6766860 12/03/06 15:06:06 INFO mapred.JobClient: FILE_BYTES_WRITTEN=6900442 12/03/06 15:06:06 INFO mapred.JobClient: Map-Reduce Framework 12/03/06 15:06:06 INFO mapred.JobClient: Map input records=9 12/03/06 15:06:06 INFO mapred.JobClient: Spilled Records=0 12/03/06 15:06:06 INFO mapred.JobClient: SPLIT_RAW_BYTES=87 12/03/06 15:06:06 INFO mapred.JobClient: Map output records=9 12/03/06 15:06:06 INFO mapreduce.ImportJobBase: Transferred 0 bytes in 3.0211 seconds (0 bytes/sec) 12/03/06 15:06:06 INFO mapreduce.ImportJobBase: Retrieved 9 records.