Hive file:/path/to/hiveddl.sql does not exist.

[#1]

Environment: HDP on AWS EC2 instances.

Problem: When trying to execute a hive ddl script, we get the error file does not exist. Upon checking the file exists and also has the read write privileges.

Root Cause: The directory where the script exists does not have read write permission to the user.

Solution: Open the directory permission to include the necessary read, write permission to the user.

Following is a screenshot that shows the problem and solution used to fix it.

[#2]

This could be the potential solution for this "hive script does not exist" question as well:

https://community.hortonworks.com/questions/25588/hive-script-error-script-does-not-exists-error.htm...