Databricks Delta table Insert Data Error

[eric2]

When trying to insert data into the Delta table in databricks, an error occurs as shown below. [TASK_WRITE_FAILED] Task failed while writing rows to abfss://cont-01@dlsgolfzon001.dfs.core.windows.net/dir-db999_test/D_RGN_INFO_TMP.

In SQL, the results of Select statements other than Insert into are displayed in table form, but an error occurs when Insert is used.

Please tell me how to resolve this error.

[-werners-]

how do you try to insert the data into the delta table?

Can you share the statement?

[eric2]

Thank you for trying to solve the problem together. 

I try to use SQL Query in Notebook.

I'd like to tell you the query I'm using, but it's difficult to share.

-Step1 Create TableA
A table called A was created as shown below, and the location was designated as a specific blob storage path.

-Step2 Insert Data
The approximate content of the query is to insert data from tables B and C into table A.

Create Table tableA (

    Col1   as int

    Col2   as int

    Col3   as string

    Col4   as string

) using delta location 'Blob storage path'

Insert into tableA

select

    B.Col1      AS Col1

    B.Col2      AS Col2

    C.Col1      AS Col3

    C.Col2      AS Col4

from tableB B

Left outer join tableC C

[-werners-]

seems ok to me, have you tried to display the data from table A and also the B/C join?