Hi all,  i'm traying to do a sqoop export from hdfs to mysql of data of a hive table.  The export works fine for a subset of rows (11 / 14) but return error when a row contains in a string field the single quote character (for example 'Data Science' with ' included) .    The script I'm using is:    sqoop export --connect=xxx --username=yyyy --password=blabla --table=tableMysql --input-null-non-string=-999 --input-null-string="" --export-dir='/user/hive/warehouse/xx.db/tableHive' --input-fields-terminated-by='\001' --input-lines-terminated-by='\n'   I try using the option --input-optionally-enclosed-by , --input-enclosed-by or --input-escaped-by without success. How I have to set the options?   Thank you     ... View more

Hi all,  I have done the CCA159 exam and the resull was fail for 3 errors. One of these errors is "Incorrect schema" and the corrisponding exercise was the creation of a view.  Also others guys had the same error on the similar exercise  although they were sure that they had done the exercise correctly.  I also think I did it correctly.  Someone can tell me if the correct solution is the the creation of a table even if the exercise require a view?   ... View more