Hive - permission denied

Hopsworks.ai
#1

Hello,

I’m facing an issue with Hive when trying to create an external table. I would like to load some CSV file into Hive and I’ve been following the documentation. When creating a table I’m met with a permission denied error:

hive-error
hive-error1290×916 567 KB

I’m a data owner in the project and I was able to create ORC tables without any trouble.
Thank you in advance for your help.

#2

Hi jjeanjean,

You need to select the correct database before creating the table.
so run: spark.sql("use <project name>")
before the sql create.