The Sqoop Import Tool uses

The current use of Sqoop is to import data from Oracle into HBase.

sqoop Import--connect jdbc:oracle:thin:@192.168.193.37:1521:hispacedb --username hwmarket  --password hwmarket37--m 1--query "Select G.imei,g.id as Sign, to_char (g.logindate, ' Yyyy-mm-dd hh24:mi:ss ') as CR Tdate,g.buildnumber,g.modelnumber,g.firmwarever as Firmware,g.hispacenumber,g.cno,to_char (G.updateTime, ' Yyyy-mm-dd hh24:mi:ss ') as UpdateTime, G.net,g.source, ' density, ' screens from L_logonlog_egame g where \$ CONDITIONS " --columns imei,sign,crtdate,buildnumber,modelnumber,firmware,hispacenumber,cno,updatetime,net, Source,density,screen--hbase-create-table--hbase-table  Span style= "Background-color:rgb (255,255,255); Color:rgb (0,0,0); font-family: ' Microsoft Jas Black '; Font-size:14px;font-style: Normal;font-weight:normal;text-align:left; " >h_active_device_info_gamecenter  --hbase-row-key IMEI--column-family Data

Some of the specific parameters can be see the Sqoop official website API,

Pour the data speed or very fast 1kw data in 10 minutes can be imported to complete.

In addition, it is found that sqoop from Oracle import into hbase can not change the fields in HBase, must be consistent with the field name on this side of Oracle, do not know if it is not my own use of the problem, if there is understood can share under.

The Sqoop Import Tool uses