question

HazarathReddyBoreddy-5353 avatar image
0 Votes"
HazarathReddyBoreddy-5353 asked PRADEEPCHEEKATLA-MSFT commented

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

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

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

azure-databricks
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @HazarathReddyBoreddy-5353,

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

0 Votes 0 ·
PRADEEPCHEEKATLA-MSFT avatar image PRADEEPCHEEKATLA-MSFT PRADEEPCHEEKATLA-MSFT ·

Hello @HazarathReddyBoreddy-5353,

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.

0 Votes 0 ·

0 Answers