Re: Column type conversion in Hive

2016-03-21 Thread Edward Capriolo
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

Column type conversion in Hive

2016-03-20 Thread Mich Talebzadeh
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