How to run insert overwrite queries from a Okera-enabled spark cluster
Could not execute ddl...because its length is longer than the max supported length (64)
Problems accessing Parquet files with complex MAP data types
Using a token sent from spark config in Databricks with a Legacy Okera-enabled cluster
Hive query is failing with physical out of memory issue
GRANT SELECT Failed: ERROR - Data too long
How to use a LATERAL VIEW in Presto
Running SELECT count(*) on Hive returns no output.
Accessing tables from Okera-enabled EMR for which there is no native ODAS support.
Create a table that is partitioned on a column

Could not execute ddl...because its length is longer than the max supported length (64)

July 07, 2023 20:41
Updated

Problem

DDL operations on table generate an error message.

code=INVALID_REQUEST msg=Could not execute ddl. detail=AnalysisException: Cannot grant to table '<DB>.<TB>  because its length is longer than the max supported length (64).

Answer

This is a hard limit. Rename the table so the dataset <DB_NAME>.<TABLE_NAME> does not exceed 64 characters.

Comments

0 comments

Please sign in to leave a comment.

Articles in this section

Related articles