hive> use showbucket;
hive> create table emp_demo (Id int, Name string , Salary float) row format delimited fields terminated by ',' ;
hive> load data local inpath '/home/codegyani/hive/emp_details' into table emp_demo;
hive> set hive.enforce.bucketing = true;
hive> create table emp_bucket(Id int, Name string , Salary float) clustered by (Id) into 3 buckets row format delimited fields terminated by ',' ;
hive> insert overwrite table emp_bucket select * from emp_demo;