topic Re: Insert into query showing error in Data Engineering

Insert into query showing error

devdas — Thu, 08 Jun 2023 06:13:53 GMT

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

Re: Insert into query showing error

-werners- — Thu, 08 Jun 2023 08:06:41 GMT

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?

Re: Insert into query showing error

devdas — Thu, 08 Jun 2023 08:53:58 GMT

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

Re: Insert into query showing error

-werners- — Thu, 08 Jun 2023 08:57:45 GMT

afaik it should do that.

What version of databricks are you on?

Re: Insert into query showing error

devdas — Thu, 08 Jun 2023 09:05:18 GMT

webapp_2023-06-03_03.32.06Z_master_

Re: Insert into query showing error

-werners- — Thu, 08 Jun 2023 09:23:17 GMT

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

Re: Insert into query showing error

devdas — Thu, 08 Jun 2023 09:27:05 GMT

11.3 LTS (includes Apache Spark 3.3.0, Scala 2.12)

Re: Insert into query showing error

-werners- — Thu, 08 Jun 2023 09:32:18 GMT

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

Re: Insert into query showing error

devdas — Thu, 08 Jun 2023 10:36:15 GMT

Re: Insert into query showing error

-werners- — Thu, 08 Jun 2023 10:42:38 GMT

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?

Re: Insert into query showing error

Vartika — Fri, 09 Jun 2023 10:08:49 GMT

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!

Re: Insert into query showing error

irishplatinum — Fri, 16 Jun 2023 02:36:02 GMT

Thanks for sharing, nice content. Irish Platinum