I created a bucket table and then display the data, the result show all NULL value. what the problem? Please see above picture and the following commands.
create table user01.faraday (Year int, month string, knots float) clustered by (year) into 10 buckets;
LOAD DATA LOCAL INPATH '/user/user01/DA440_LabFiles/wind_Faraday.csv' INTO TABLE user01.faraday;
select * from user01.faraday limit 5;
the data file wind_Faraday.csv did have data which is not NULL.
Who can help?