Insert into query showing error

[devdas]

Im trying to insert data from table with 7 columns to table with 37 columns

[-werners-]

If you define a column list for an insert, Databricks will assign the corresponding default value instead. If there is no default value defined, it will insert null.

However, if one of those columns is not nullable, an error is raised.

Can you check if Client_Name is nullable in the delta lake table?

[devdas]

Thanks for the reply!

yes i did checked the client_name , all columns are nullable

 

is there any way i can make client_name and remaining columns values as null ,if yes what is the query

[-werners-]

afaik it should do that.

What version of databricks are you on?

[devdas]

webapp_2023-06-03_03.32.06Z_master_

[-werners-]

I mean databricks 11.3 etc. Can be seen on the cluster. Or databricks sql serverless etc

[devdas]

11.3 LTS (includes Apache Spark 3.3.0, Scala 2.12)

[-werners-]

well, should work... can you try without the column selection on WithoutDups delta table?

[devdas]

[-werners- · Accepted solution]

https://github.com/delta-io/delta/pull/1743

Spark 3.4 no longer requires users to provide all columns in insert-by-name queries.

Can you test with spark 3.4?

[Vartika]

Hi @Ranjith Marakal​,

Thank you for posting your question in our community! We are happy to assist you.

To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers your question?

This will also help other community members who may have similar questions in the future. Thank you for your participation and let us know if you need any further assistance! 

[irishplatinum]

Thanks for sharing, nice content. Irish Platinum