I am confusing about the following result. Why the hive table has so many NULL value ?
hive> select * from managers; OK fergubo01m,BS1,31,20,10,10NULLNULLNULLNULLNULL woodji01m,CH1,28,19,9,9NULLNULLNULLNULLNULL paborch01m,CL1,29,10,19,19NULLNULLNULLNULLNULL lennobi01m,FW1,14,5,9,9NULLNULLNULLNULLNULL deaneha01m,FW1,5,2,3,3NULLNULLNULLNULLNULL fergubo01m,NY2,33,16,17,17NULLNULLNULLNULLNULL Time taken: 0.107 seconds, Fetched: 6 row(s) This is my create table code : create table managers (managerID string, teamID string, g int, w int, l int, x int); managers.txt in HDFS structure fergubo01m,BS1,31,20,10,10 woodji01m,CH1,28,19,9,9 paborch01m,CL1,29,10,19,19 lennobi01m,FW1,14,5,9,9 deaneha01m,FW1,5,2,3,3 fergubo01m,NY2,33,16,17,17 Loading data from HDFS to hive code LOAD DATA INPATH '/managers.txt' OVERWRITE TABLE managers; What’s wrong with these NULL value?
