Warren, Glad that worked. I'm not really sure if Sqoop2 has a feature to do that. You might be able to reduce the number of mappers down to 1 using throttlers. When using Hue or the Sqoop2 client, the number of throttlers during the extraction phase and load phase can be numerically defined. If left blank or 0 is provided, then the execution framework may ignore it. If you throttle the number of extractors to 1, then you'll have 1 mapper perform the extraction. If you throttle the number of loaders to 1, you'll have at most 1 loader write to HDFS. If that doesn't work, your best bet is performing the concatenation yourself as you've described. ... View more

Hey there, I don't think there's a good way of doing this in Sqoop2 yet (https://issues.apache.org/jira/browse/SQOOP-1074). However, it seems the conversion is failing in the driver and not the connector. Could you provide the schema of your table? ... View more

Unfortunately, that would require a custom output format, which is currently not supported in Sqoop 1. You might be able to get away with writing a custom storage format for HCatalog.   This seems like an interesting feature to add in Sqoop2 though: https://issues.apache.org/jira/browse/SQOOP-1346. ... View more

You can set permissions through Hue via the file browser. There should be a Chmod/Chown button above the file listing. Are you logged in as warren.lastname user? Would you be able to run the job with the "verbose" option from the command line? Or, possibly, provide the Sqoop logs and task logs to see what happened? ... View more

By the way, what version of CDH are you using? ... View more

Hey there, It seems you shouldn't have to do this, but adding "--append" to your command might help. -Abe ... View more

This is a problem with Hue and SQLite in a multithreaded environment. A workaround to have this error be intermittent is to provide options='{"timeout": 30}' in the database section of your hue.ini. This should restrict locks to 30 seconds. ... View more