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;