Member since
04-11-2020
1
Post
0
Kudos Received
0
Solutions
04-11-2020
08:45 PM
how to import from mysql to hdfs escaping all double quotes by "\" and wrap all the data by single quote I tried to run this query by it doesn't escape double quotes: sqoop import \ --connect jdbc:mysql: xyz \ --username ru \ --password xyz \ --table sgosai_test1 \ --fields-terminated-by '-' \ --lines-terminated-by ':' \ --target-dir /user/sgosai2703/solxyz \ --m 1 \ --escaped-by \\ \ --optionally-enclosed-by \'
... View more
Labels: