Guest User

Untitled

a guest
Aug 31st, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.76 KB | None | 0 0
  1. Error when creating a table with Sqoop
  2. $ sqoop create-hive-table --connect jdbc:oracle:thin:@//dbserver:1521/masterdb
  3. --username myuser --table DBFUNC1.R1_EVOLUTION
  4. --fields-terminated-by ',' -P
  5.  
  6. SQL> describe BFUNC1.R1_EVOLUTION;
  7.  
  8. OWNER_ID NOT NULL NUMBER(38)
  9. AI_CODE NOT NULL CHAR(3)
  10. TA_NUMBER NOT NULL NUMBER(38)
  11. RULE NOT NULL CHAR(4)
  12. F_CLASS NOT NULL CHAR(8)
  13. EVOLUTION_ID NOT NULL NUMBER(38)
  14. CREATION_MODIFID NUMBER(38)
  15. DISC_MODIFID NUMBER(38)
  16.  
  17. CREATION_DATETIME CHAR(19)
  18. ENDED_DATETIME CHAR(19)
  19. EVOLUTION_STATE CHAR(1)
  20.  
  21. $ sqoop import --connect jdbc:oracle:thin:@//dbserver:1521/masterdb --username myuser --table DBFUNC1.R1_EVOLUTION --where 'rownum=1' --verbose -P
Add Comment
Please, Sign In to add comment