-- set of tests HIVE-9481
drop database if exists x314n cascade;
create database x314n;
use x314n;

CREATE TABLE pageviews (userid VARCHAR(64), link STRING, source STRING) PARTITIONED BY (datestamp STRING, i int) CLUSTERED BY (userid) INTO 256 BUCKETS STORED AS ORC;
--datestamp is a static partition thus should not be supplied by producer side
INSERT INTO TABLE pageviews PARTITION (datestamp='2014-09-23',i)(userid,i,datestamp,link) VALUES ('jsmith', 7, '2014-07-12', '7mail.com');

drop database if exists x314n cascade;