set hive.mapred.supports.subdirectories=true;

create table original (key STRING, value STRING);

describe formatted original;

alter table original SKEWED BY (key) ON (1,5,6);

describe formatted original;

drop table original;

create database skew_test;

create table skew_test.original2 (key STRING, value STRING) ;

describe formatted skew_test.original2;

alter table skew_test.original2 SKEWED BY (key, value) ON ((1,1),(5,6));

describe formatted skew_test.original2;

drop table skew_test.original2;

create table skew_test.original3 (key STRING, value STRING) SKEWED BY (key, value) ON ((1,1),(5,6));

describe formatted skew_test.original3;

alter table skew_test.original3 not skewed;

describe formatted skew_test.original3;

drop table skew_test.original3;

drop database skew_test;