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?

Reply via email to