Unable to execute Self Learning Path codes

[jay_kum]

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?

[Kaniz]

Hi @ jay.kum! My name is Kaniz, and I'm the technical moderator here. Great to meet you, and thanks for your question! Let's see if your peers on the community have an answer to your question first. Or else I will follow up with my team and get back to you soon.Thanks.

[jay_kum · Accepted solution]

Thanks, it is sorted. Needed write access.

[Anonymous]

@jay.kum​ - Fantastic! Thanks for letting us know. 🙂