Hey There, I was trying to use Skewed tables but I am facing the issue that it is not creating separate files for the skewed data. Even with a simple example I am having the same issue. The hive version is 0.11.
create table t(col1 string, col2 string); load data local inpath '/home/hadoop/a.txt' into table t; create table t1(r1 string, r2 string) skewed by (r2) on ('a'); insert into table t1 select * from t; The contents of a.txt are : 1^Aa 2^Ab 3^Ac 4^Aa 5^Ab 6^Aa I see only single file. /user/hive/warehouse/t1/000000_0 Any pointers on what I am doing wrong?