topic Re: Getting Error when Inserting data into table with the column as bigint in Data Engineering

Getting Error when Inserting data into table with the column as bigint

Jits — Tue, 02 May 2023 15:17:49 GMT

Hi All,

I am creating table using Databricks SQL editor. The table definition is

DROP TABLE IF EXISTS [database].***_test;

CREATE TABLE [database].***_jitu_test

(

id bigint

)

USING delta

LOCATION 'test/raw/***_jitu_test'

TBLPROPERTIES ('delta.minReaderVersion'='1','delta.minWriterVersion'='2','delta.feature.allowColumnDefaults' = 'supported');

Table gets create successfully. When I do insert

insert into [database].***_test (id ) values (1);

It give error.

Java.lang.Integer cannot be cast to java.lang.Long

I don't want to so cast because then in every column with bigint I have to write cast. I tried using below with now luck. is there configuration I have to set or its the issue with product

--SET ansi_mode = true;

--SET spark.sql.ansi.enabled=true;

Re: Getting Error when Inserting data into table with the column as bigint

-werners- — Wed, 03 May 2023 09:00:26 GMT

can you try with values(1L)?

The L part specifies the number is a longType.

https://spark.apache.org/docs/latest/sql-ref-literals.html#numeric-literal

Re: Getting Error when Inserting data into table with the column as bigint

Anonymous — Fri, 19 May 2023 06:39:21 GMT

Hi @jitendra goswami

We haven't heard from you since the last response from @Werner Stinckens r, and I was checking back to see if her suggestions helped you.

Or else, If you have any solution, please share it with the community, as it can be helpful to others.

Also, Please don't forget to click on the "Select As Best" button whenever the information provided helps resolve your question.