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

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.