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?