Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Error when creating a table with Sqoop
- $ sqoop create-hive-table --connect jdbc:oracle:thin:@//dbserver:1521/masterdb
- --username myuser --table DBFUNC1.R1_EVOLUTION
- --fields-terminated-by ',' -P
- SQL> describe BFUNC1.R1_EVOLUTION;
- OWNER_ID NOT NULL NUMBER(38)
- AI_CODE NOT NULL CHAR(3)
- TA_NUMBER NOT NULL NUMBER(38)
- RULE NOT NULL CHAR(4)
- F_CLASS NOT NULL CHAR(8)
- EVOLUTION_ID NOT NULL NUMBER(38)
- CREATION_MODIFID NUMBER(38)
- DISC_MODIFID NUMBER(38)
- CREATION_DATETIME CHAR(19)
- ENDED_DATETIME CHAR(19)
- EVOLUTION_STATE CHAR(1)
- $ 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