Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-26-2023 10:01 PM
@nishin kumar :
The error message indicates that there is a Spark exception while executing the SQL statement. There could be several reasons for this error. Here are a few things you can try to troubleshoot this issue:
- Check if the table exists: Make sure that the table you are trying to apply table access control to exists in the database. You can check this by running the following command:
SHOW TABLES <database_name>;Replace <database_name> with the name of your database.
- Check if the table is accessible: Make sure that the table is accessible from your cluster. You can test this by running a simple SQL query on the table:
SELECT * FROM <database_name>.<table_name> LIMIT 10;- Replace <database_name> and <table_name> with the name of your database and table respectively.
- Check the SQL syntax: Double-check the SQL statement you are running to make sure that there are no syntax errors. You can also try running the same SQL statement in the Databricks SQL endpoint to see if it works.
- Check the cluster logs: Check the cluster logs to see if there are any error messages related to the Spark exception. You can find the cluster logs in the Azure portal by going to the Databricks workspace and selecting the "Clusters" tab. Click on the cluster name and select "Logs" from the menu.