user@master ~ $ hadoop fs -mkdir export user@master ~ $ cat >> data << EOF 3,Bye 4,Over EOF user@master ~ $ hadoop fs -put data export user@master ~ $ hadoop fs -cat export/data 3,Bye 4,Over
user@master ~ $ export DBID=帳號 user@master ~ $ sqoop export --connect "jdbc:sqlserver://sql.3du.me;database=$DBID" --table MSSQL_DATA --username $DBID -P --export-dir /user/$(whoami)/export Enter password: 輸入密碼
13/12/22 14:40:41 INFO manager.SqlManager: Using default fetchSize of 1000 13/12/22 14:40:41 INFO tool.CodeGenTool: Beginning code generation 13/12/22 14:40:42 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM [MSSQL_DATA] AS t WHERE 1=0 13/12/22 14:40:43 INFO orm.CompilationManager: HADOOP_HOME is /opt/hadoopmr ... 略 ... 13/12/22 14:41:35 INFO mapreduce.ExportJobBase: Transferred 0 bytes in 47.51 seconds (0 bytes/sec) 13/12/22 14:41:35 INFO mapreduce.ExportJobBase: Exported 2 records.
SELECT * FROM MSSQL_DATA;由 HDFS 匯出到 MSSQL_DATA 資料表的結果:(多出兩筆記錄)