Advertisement
Guest User

Untitled

a guest
Jan 27th, 2016
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. sqoop import --connect jdbc:mysql://localhost/sqoop --username sqoop --password sqoop --table customers --warehouse-dir testingsqoop -m 1 --fields-terminated-by ',' --enclosed-by "'" --lines-terminated-by "n"
  2.  
  3. sqoop create-hive-table --connect jdbc:mysql://localhost/sqoop --username sqoop --password sqoop --table customers --hive-table customers --fields-terminated-by "," --enclosed-by "'" --lines-terminated-by "n"
  4.  
  5. load data inpath '/user/cloudera/testingsqoop/customers/*' into table customers;
  6.  
  7. NULL  'Richard'  'Hernandez'  'XXXXXXXXX'  'XXXXXXXXX'  '6303 Heather Plaza'  'Brownsville'  'TX'  '78521'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement