I am unable to execute code examples given in the learning path. I understand it could be due to access issue. How do I change the working directory to User folder for creating/uploading/read/write etc? By default everything is on driver node.

Even a simple

CREATE DATABASE IF NOT EXISTS dbacademy;

USE dbacademy

gives 100 lines of error.

Error in SQL statement: AnalysisException: org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:com.amazonaws.services.s3.model.AmazonS3Exception: Forbidden; request: HEAD https:/.......If I can't create a table, how do I upload data to the table?