@Andrea L like Michael Young said, Sqoop doesn't suppot importing from or exporting to Hive. it's also recommanded to use the export/import hive queries to move your data between two hive, check this out: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+ImportExport however, the CSV method can generate problems of separator or even if the data is numerous it would be necessary to group them in one CSV file, which is not reassuring. ... View more

I've left a possible solution as a separate answer. Doing all the processing with a Python script is not ideal, as you'd need your own Hadoop/Hive client libraries and all you'd use NiFi for is executing the external Python script. However if you just need some custom processing during the flow, you can use ExecuteScript (link in my other answer) with Jython, I have some examples on my blog. ... View more