My Oracle Support Banner

Creating a Table from the Pyspark2 Shell using Spark SQL Fails with "(message:User <USERNAME> does not have privileges for CREATETABLE)" (Doc ID 2540520.1)

Last updated on APRIL 17, 2023

Applies to:

Big Data Appliance Integrated Software - Version 4.12.0 and later
Linux x86-64


Creating a table from the pyspark2 shell using Spark SQL with something like:

However the same query successfully creates a table when executed by the <ADMIN_USER>


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.