Advertisement
Guest User

Untitled

a guest
Jul 11th, 2016
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. sqoop export --connect jdbc:oracle:thin:@//<myserver>:<port>/<database> --username <myun> -P --table <schema>.<table> --export-dir <myhdfsdir> --input-fields-terminated-by ',' --lines-terminated-by 'n' --fields-terminated-by ','
  2.  
  3. My Hive Table My Oracle Table
  4. col_A STRING col_A VARCHAR2
  5. col_B INT col_B NUMBER
  6. col_C INT col_C NUMBER
  7. col_D STRING col_D VARCHAR2
  8. col_E STRING col_E VARCHAR2
  9. col_F STRING col_F VARCHAR2
  10. col_G STRING col_G VARCHAR2
  11. col_H INT col_H NUMBER
  12. col_I STRING col_I VARCHAR2
  13. col_J INT col_J NUMBER
  14. col_K STRING col_K VARCHAR2
  15. col_L STRING col_L VARCHAR2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement