Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Create a external table using azure storage

Highlighted

Create a external table using azure storage

New Contributor

Hello guys,

I am trying to create the table below using but i am receiving the error: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [admin] does not have [ALL] privilege on [wasb://test@stgmdmspark.blob.core.windows.net]

I already add the property with storage key to core-site.xml and also:

<property>
  <name>fs.azure.secure.mode</name>
  <value>true</value>
</property>
<property>
  <name>fs.azure.cred.service.urls</name>
  <value>{URL}</value>
</property>

here is my hql:

Create external table test(
id int,
name string)
stored as ORC
location 'wasb://test@stgmdmspark.blob.core.windows.net';

Any ideas?