Explicit conversion is done using cast (x as bigint)
You said: As a matter of interest what is the underlying storage for
Integer?
This is dictated on disk by the input format the "temporal in memory
format" is dictated by the serde, an integer could be stored as "1",
"1" , as dictated by the
As a matter of interest how does how cast columns from say String to
Integer implicitly?
For example the following shows this
create table s(col1 String);
insert into s values("1");
insert into s values("2");
Now create a target table with col1 being integer
create table o (col1 Int);
insert