Question

How to change the delimiter in Sqoop?

Answer 1

You can change delimiter in SQOOP command.

By default, it takes delimiter as a tab but if you want to explicitly define it you need to use this command.

--fields-terminated-by <char>

Example

sqoop import \ 
      --connect jdbc:mysql://127.0.0.1:3306/GRHadoop \ 
      --username root \ 
      --password cloudera \ 
      --table sitecustomer \ 
      --fields-terminated-by '|' \ 
      --lines-terminated-by "\n" \ 
      --target-dir /user/cloudera/GR/Sqoop/sitecustomer_data \ 
      --m 1;

Answer 2

--fields-terminated-by <char>

Answer 3

Hi,

You can also follow this following query below:

sqoop import-all-tables --connect “jdbc:mysql://nn01.itversity.com:3306/retail_db” 
–username retail_dba 
–password itversity 
–hive-import 
–hive-database rgex12 
–as-textfile 
–fields-terminated-by ‘|’