Troubleshooting & Tips Sqoop Import needs step to update Ambari config

Description

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.
Testing:

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.

Environment

hdp sandbox

Activity

Show:
Nick Longinow
March 27, 2018, 7:59 PM

pull request created for this work (3/27/18)

Assignee

Unassigned

Reporter

Nick Longinow

Labels

None

Reviewer

None

Story point estimate

None

Time tracking

0m

Time remaining

1h

Components

Priority

Medium
Configure