sqoop的问题：sqoop import --connect jdbc:oracle:thin
sqoop import --connect jdbc:oracle:thin:@192.168.90.249:1521:dyfls --username dyfls --password dyfls --query "select lpad(fid,20-length(fid),0) as fid,FDATE,FCOMPANYID,FSTOREID,FGROUPCODE,FCOMPRODUCTCODE,FPRODUCTCODE,FNAME,FSPECIFICATION,FHABITAT,FUNIT,FCALCULATE,FRECIPESORT,FPROVIDER,FZJM,FORMULATION,FSALECATEGORY,FCHAINCODE,FSORT1,FSORT2,FSORT3,FSORT4,FSORT5,FCOSTPRICE,FSTORAGECOUNT,FSTORAGEAMOUNT,FRETAILPRICE,FMAXPRICE,FMINPRICE,FLASTPRICE from T_DA_STORAGEDETAILS where fdate={d '2013-01-01'} AND \$CONDITIONS " --hbase-table dyfls.T_DA_STORAGEDETAILS --column-family data --hbase-row-key fid --split-by fid帮我看看呗 可能你对这个还不是很熟悉，你参考一下这个内容：HDFS和RDBMS交互专用工具sqoop http://www.aboutyun.com/thread-5523-1-1.html
页:
[1]