The Troubleshooting tips ("Sqoop requires JDK on Kylo sandbox") works. It just needs one additional step, to have the user update the Ambari settings for Sqoop. Otherwise, once the cluster or hdfs components are restarted, the change will be overwritten by the default value and lost.
1. Run the sqoop import using out-of-the-box settings. i.e., with the 0.9.0.1 hdp sandbox, attempt to run a Sqoop import.
2. Notice that step 3 (Import Sqoop) fails.
3. Note that the nifi-app.log file indicates an ERROR due to a missing JDK.
ERROR orm.CompilationManager: Please install a JDK and set $JAVA_HOME to use it.
4. Make the changes as specified in the existing Troubleshooting guide (updates to hadoop-env.sh)
5. Re-run the sqoop feed.
6. Notice that it now works.
all steps have green complete marks
the sqoopimport folder in hdfs should have content
7. Restart the Ambari cluster.
8. Repeat step 5 and 6.
9. Notice that it now fails in step 3, as per test step above.
10. Go to the Ambari admin.
11. Open the Sqoop component and click the configs tab.
12. Make the change suggested in the doc update (set JAVA_HOME as per step 4 above).
13. Save the changes to Sqoop in Ambari.
14. Restart the Sqoop client as indicated by the Ambari UI.
15. Repeat step 5.
16. Notice that it now works.
17. Repeat step 7.
18. Repeat step 5.
19. Notice that it still works.
pull request created for this work (3/27/18)