AnsweredAssumed Answered

What's wrong with my bucket table?

Question asked by sun.frank on May 18, 2016
Latest reply on May 20, 2016 by sun.frank


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?