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.
This could be the potential solution for this "hive script does not exist" question as well: