@saranvisa @Freakabhi    I tried the same with Teradata but it throws an error    [Teradata Database] [TeraJDBC 15.10.00.26] [Error 6706] [SQLState HY000] The string contains an untranslatable character.   Did i add the parameter right ?   PFB my sqoop command   sqoop import --connect jdbc:teradata://xx.xx.xx/DATABASE=xxx --username xxx -P --query "SELECT TOP 1000 regexp_replace(load_hash_key_val,'^M',''),regexp_replace(load_hash_data_val,'^M','') FROM db.tble_name where 1=1 AND \$CONDITIONS" --target-dir /hadoop/test -m1   Any suggestions please ?   Thanks in advance. ... View more