AnalysisException: Table test_yearly_delta does not support dynamic overwrite in batch mode

Hazarath Reddy Boreddy 1

we are trying to overwrite the table by using sql
command like this

INSERT
OVERWRITE TABLE prod.test_yearly_delta
select ...... from table

PRADEEPCHEEKATLA 91,326 Reputation points Moderator

2021-09-15T08:02:19.12+00:00
Hello @Hazarath Reddy Boreddy ,

Welcome to the Microsoft Q&A platform.

In order to investigate further, could you please share the below details:

Azure Databricks Runtime which you are using?

Share the code which you are trying to create table as CTAS by using spark sql?

Stack trace (complete) error message which you are experiencing along with the screenshot?

Meanwhile, you can checkout the similar issue addressed here: https://github.com/delta-io/delta/issues/348
PRADEEPCHEEKATLA 91,326 Reputation points Moderator

2021-09-20T05:53:21.58+00:00

Hello @Hazarath Reddy Boreddy ,

Just checking in if you have had a chance to see the previous response. We need the following information to understand/investigate this issue further.

Your answer