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 NOVEMBER 08, 2019

Applies to:

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

Symptoms

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>



Cause

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
Symptoms
Cause
Solution


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