The `delete` named column in your retailSKU table is actually a reserved word, and that's the central point of the issue. When Sqoop's building out the query, its currently not escaping the column names with backticks (``) which is necessary when not intending to mean using a reserved word ( https://dev.mysql.com/doc/refman/5.7/en/keywords.html). Would it be possible for you to alter the column name on the source retailSKU table, or pass a custom query instead which uses the right escape syntax, via --query: http://archive.cloudera.com/cdh5/cdh/5/sqoop/SqoopUserGuide.html#_free_form_query_imports ? Edit: Just noticed you've mentioned that free-form works just fine. ... View more

While MultipleInputs was designed for such a thing, your requirement is unique in that you need to process the same input 2x but with different params each time. It seems a bit redundant to me given that you can do it in a single task run vs. 2x the I/O cost… But I believe the way you can solve your identifier problem is by writing your own InputFormat wrapper over the existing InputFormat, which generates special types of InputSplit objects (wrapper over regular FileSplit classes). These input splits need to add in your identifiers as an extra field, and you can extract and cast the same from your context.getInputSplit() in the map-end to then differentiate the input. ... View more

When an RS exits, it logs a lot of content from the many threads it runs. Your log snippet is just the post-exit-decision messages, as you can note from the several "exiting" messages. Please instead pass us your entire log file, or look for the entire line and its following exception stack trace matching the word "FATAL", which would be in a line well before these logs appear. ... View more

What directory are you looking under for the keytab files? Ensure to look under the most recent role-related directory. Note that you don't need to access these directories directly and that you can find the same process files under CM at CM -> [Service] -> Instances tab -> [Instance of the service roles you are interested in] -> Processes tab -> In the files section, keytab should be available for download. ... View more