Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- my question is can't we export the data which has space from hdfs to mysql usong sqoop export command?
- The data which i used
- 1201, adi, sen manager, 30000, it
- 1201, pavan, jun manager, 5000, cs
- 1203, santhosh, junior, 60000, mech
- i created table like
- create table emp(id BIGINT,name varchar(20),desg varchar(20),salary BIGINT,dept varchar(20));
- sqoop command -- sqoop export
- --connect jdbc:mysql://127.0.0.1/mydb
- --username root
- --table emp
- --m 1
- --export-dir /mydir
- --input-fields-terminated-by ','
- --input-lines-terminated-by 'n'
- result: numberformatexception input string:'1201'
- can't parse the data
- i discussed in forum, they said trim the space but i wants to know that automatically trim the spaces while perform sqoop export.
- can somebody give suggestions on this?
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement