drop table Test1;
create table Test1 (
   `time` time(month, day, hour, min),
   user   string,
   val    long
);
create view select count, avg(val) from Test1;



drop table Test1Mem;
create table Test1Mem (
   `time` time(month, day, hour, min),
   user   string,
   val    long
) storage mem;
create view select count, avg(val) from Test1Mem;



drop table Test1None;
create table Test1None (
   `time` time(month, day, hour, min),
   user   string,
   val    long
) storage none;
create view select count, avg(val) from Test1None;



drop table CountDistinctTable;
CREATE TABLE CountDistinctTable
   (`time` TIME(DAY,HOUR,MIN,SEC),
    category STRING,
    song_id STRING,
    user STRING,
    rating STRING)
STORAGE default
PROPERTIES
    drill  = true,
    store  = true,
    strict = true
;
CREATE VIEW SELECT COUNT FROM CountDistinctTable;
CREATE VIEW SELECT COUNT FROM CountDistinctTable GROUP BY song_id;
CREATE VIEW SELECT COUNT FROM CountDistinctTable GROUP BY category;
CREATE VIEW SELECT COUNT FROM CountDistinctTable GROUP BY category, song_id;
CREATE VIEW SELECT COUNT FROM CountDistinctTable GROUP BY `time`;
CREATE VIEW SELECT COUNT FROM CountDistinctTable GROUP BY `time`, song_id;
CREATE VIEW SELECT COUNT FROM CountDistinctTable GROUP BY `time`, category;
CREATE VIEW SELECT COUNT FROM CountDistinctTable GROUP BY `time`, category, song_id;
CREATE VIEW SELECT COUNT FROM CountDistinctTable WHERE `time`;
CREATE VIEW SELECT COUNT FROM CountDistinctTable WHERE `time` GROUP BY song_id;
CREATE VIEW SELECT COUNT FROM CountDistinctTable WHERE `time` GROUP BY category;
CREATE VIEW SELECT COUNT FROM CountDistinctTable WHERE `time` GROUP BY category, song_id;
CREATE VIEW SELECT COUNT FROM CountDistinctTable WHERE `time` GROUP BY `time`;
CREATE VIEW SELECT COUNT FROM CountDistinctTable WHERE `time` GROUP BY `time`, song_id;
CREATE VIEW SELECT COUNT FROM CountDistinctTable WHERE `time` GROUP BY `time`, category;
CREATE VIEW SELECT COUNT FROM CountDistinctTable WHERE `time` GROUP BY `time`, category, song_id;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctTable;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctTable GROUP BY song_id;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctTable GROUP BY category;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctTable GROUP BY category, song_id;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctTable GROUP BY `time`;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctTable GROUP BY `time`, song_id;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctTable GROUP BY `time`, category;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctTable GROUP BY `time`, category, song_id;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctTable WHERE `time`;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctTable WHERE `time` GROUP BY song_id;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctTable WHERE `time` GROUP BY category;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctTable WHERE `time` GROUP BY category, song_id;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctTable WHERE `time` GROUP BY `time`;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctTable WHERE `time` GROUP BY `time`, song_id;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctTable WHERE `time` GROUP BY `time`, category;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctTable WHERE `time` GROUP BY `time`, category, song_id;



drop table CountDistinctApproxTable;
CREATE TABLE CountDistinctApproxTable
   (`time` TIME(DAY,HOUR,MIN,SEC),
    url STRING,
    user STRING)
STORAGE default
PROPERTIES
    drill  = true,
    store  = true,
    strict = true
;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctApproxTable;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctApproxTable GROUP BY url;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctApproxTable GROUP BY `time`;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctApproxTable GROUP BY `time`, url;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctApproxTable WHERE `time`;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctApproxTable WHERE `time` GROUP BY url;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctApproxTable WHERE `time` GROUP BY `time`;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctApproxTable WHERE `time` GROUP BY `time`, url;
CREATE VIEW SELECT APPROX COUNT DISTINCT(user, 9) FROM CountDistinctApproxTable;
CREATE VIEW SELECT APPROX COUNT DISTINCT(user, 9) FROM CountDistinctApproxTable GROUP BY url;
CREATE VIEW SELECT APPROX COUNT DISTINCT(user, 9) FROM CountDistinctApproxTable GROUP BY `time`;
CREATE VIEW SELECT APPROX COUNT DISTINCT(user, 9) FROM CountDistinctApproxTable GROUP BY `time`, url;
CREATE VIEW SELECT APPROX COUNT DISTINCT(user, 9) FROM CountDistinctApproxTable WHERE `time`;
CREATE VIEW SELECT APPROX COUNT DISTINCT(user, 9) FROM CountDistinctApproxTable WHERE `time` GROUP BY url;
CREATE VIEW SELECT APPROX COUNT DISTINCT(user, 9) FROM CountDistinctApproxTable WHERE `time` GROUP BY `time`;
CREATE VIEW SELECT APPROX COUNT DISTINCT(user, 9) FROM CountDistinctApproxTable WHERE `time` GROUP BY `time`, url;

CREATE TABLE CountDistinctApproxLargeTable
   (`time` TIME(DAY,HOUR,MIN,SEC),
    url STRING,
    user STRING)
STORAGE default
PROPERTIES
    drill  = true,
    store  = true,
    strict = true
;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctApproxLargeTable;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctApproxLargeTable GROUP BY url;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctApproxLargeTable GROUP BY `time`;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctApproxLargeTable GROUP BY `time`, url;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctApproxLargeTable WHERE `time`;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctApproxLargeTable WHERE `time` GROUP BY url;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctApproxLargeTable WHERE `time` GROUP BY `time`;
CREATE VIEW SELECT COUNT DISTINCT(user) FROM CountDistinctApproxLargeTable WHERE `time` GROUP BY `time`, url;
CREATE VIEW SELECT APPROX COUNT DISTINCT(user, 13) FROM CountDistinctApproxLargeTable;
CREATE VIEW SELECT APPROX COUNT DISTINCT(user, 13) FROM CountDistinctApproxLargeTable GROUP BY url;
CREATE VIEW SELECT APPROX COUNT DISTINCT(user, 13) FROM CountDistinctApproxLargeTable GROUP BY `time`;
CREATE VIEW SELECT APPROX COUNT DISTINCT(user, 13) FROM CountDistinctApproxLargeTable GROUP BY `time`, url;
CREATE VIEW SELECT APPROX COUNT DISTINCT(user, 13) FROM CountDistinctApproxLargeTable WHERE `time`;
CREATE VIEW SELECT APPROX COUNT DISTINCT(user, 13) FROM CountDistinctApproxLargeTable WHERE `time` GROUP BY url;
CREATE VIEW SELECT APPROX COUNT DISTINCT(user, 13) FROM CountDistinctApproxLargeTable WHERE `time` GROUP BY `time`;
CREATE VIEW SELECT APPROX COUNT DISTINCT(user, 13) FROM CountDistinctApproxLargeTable WHERE `time` GROUP BY `time`, url;



drop table TopNTable;
CREATE TABLE TopNTable
   (`time` TIME(DAY,HOUR,MIN,SEC),
    song_id STRING,
    user STRING)
STORAGE default
PROPERTIES
    drill  = true,
    store  = true,
    strict = true
;
CREATE VIEW SELECT COUNT FROM TopNTable;
CREATE VIEW SELECT COUNT FROM TopNTable GROUP BY song_id;
CREATE VIEW SELECT COUNT FROM TopNTable GROUP BY `time`;
CREATE VIEW SELECT COUNT FROM TopNTable GROUP BY `time`, song_id;
CREATE VIEW SELECT COUNT FROM TopNTable WHERE `time`;
CREATE VIEW SELECT COUNT FROM TopNTable WHERE `time` GROUP BY song_id;
CREATE VIEW SELECT COUNT FROM TopNTable WHERE `time` GROUP BY `time`;
CREATE VIEW SELECT COUNT FROM TopNTable WHERE `time` GROUP BY `time`, song_id;



drop table TopNApproxTable;
CREATE TABLE TopNApproxTable
   (`time` TIME(DAY,HOUR,MIN,SEC),
    song_id STRING,
    user STRING)
STORAGE default
PROPERTIES
    drill  = true,
    store  = true,
    strict = true
;
CREATE VIEW SELECT COUNT FROM TopNApproxTable GROUP BY song_id;
CREATE VIEW SELECT COUNT FROM TopNApproxTable GROUP BY `time`, song_id;
CREATE VIEW SELECT COUNT FROM TopNApproxTable WHERE `time` GROUP BY song_id;
CREATE VIEW SELECT COUNT FROM TopNApproxTable WHERE `time` GROUP BY `time`, song_id;
CREATE VIEW SELECT APPROX TOP(song_id, 10, 30) FROM TopNApproxTable GROUP BY song_id;
CREATE VIEW SELECT APPROX TOP(song_id, 10, 30) FROM TopNApproxTable GROUP BY `time`, song_id;
CREATE VIEW SELECT APPROX TOP(song_id, 10, 30) FROM TopNApproxTable WHERE `time` GROUP BY song_id;
CREATE VIEW SELECT APPROX TOP(song_id, 10, 30) FROM TopNApproxTable WHERE `time` GROUP BY `time`, song_id;



drop table TopNApproxLargeTable;
CREATE TABLE TopNApproxLargeTable
   (`time` TIME(DAY,HOUR,MIN,SEC),
    song_id STRING,
    user STRING)
STORAGE default
PROPERTIES
    drill  = true,
    store  = true,
    strict = true
;
CREATE VIEW SELECT COUNT FROM TopNApproxLargeTable GROUP BY song_id;
CREATE VIEW SELECT COUNT FROM TopNApproxLargeTable GROUP BY `time`, song_id;
CREATE VIEW SELECT COUNT FROM TopNApproxLargeTable WHERE `time` GROUP BY song_id;
CREATE VIEW SELECT COUNT FROM TopNApproxLargeTable WHERE `time` GROUP BY `time`, song_id;
CREATE VIEW SELECT APPROX TOP(song_id, 10, 100) FROM TopNApproxLargeTable GROUP BY song_id;
CREATE VIEW SELECT APPROX TOP(song_id, 10, 100) FROM TopNApproxLargeTable GROUP BY `time`, song_id;
CREATE VIEW SELECT APPROX TOP(song_id, 10, 100) FROM TopNApproxLargeTable WHERE `time` GROUP BY song_id;
CREATE VIEW SELECT APPROX TOP(song_id, 10, 100) FROM TopNApproxLargeTable WHERE `time` GROUP BY `time`, song_id;



drop table PathTable;
CREATE TABLE PathTable
   (`time` TIME(DAY,HOUR,MIN,SEC),
    country STRING,
    user STRING,
    url PATH('/'))
STORAGE default
PROPERTIES
    drill  = true,
    store  = true,
    strict = true
;
CREATE VIEW SELECT COUNT FROM PathTable;
CREATE VIEW SELECT COUNT FROM PathTable GROUP BY url;
CREATE VIEW SELECT COUNT FROM PathTable GROUP BY country;
CREATE VIEW SELECT COUNT FROM PathTable GROUP BY country, url;
CREATE VIEW SELECT COUNT FROM PathTable GROUP BY `time`;
CREATE VIEW SELECT COUNT FROM PathTable GROUP BY `time`, url;
CREATE VIEW SELECT COUNT FROM PathTable GROUP BY `time`, country;
CREATE VIEW SELECT COUNT FROM PathTable GROUP BY `time`, country, url;
CREATE VIEW SELECT COUNT FROM PathTable WHERE url;
CREATE VIEW SELECT COUNT FROM PathTable WHERE url GROUP BY url;
CREATE VIEW SELECT COUNT FROM PathTable WHERE url GROUP BY country;
CREATE VIEW SELECT COUNT FROM PathTable WHERE url GROUP BY country, url;
CREATE VIEW SELECT COUNT FROM PathTable WHERE url GROUP BY `time`;
CREATE VIEW SELECT COUNT FROM PathTable WHERE url GROUP BY `time`, url;
CREATE VIEW SELECT COUNT FROM PathTable WHERE url GROUP BY `time`, country;
CREATE VIEW SELECT COUNT FROM PathTable WHERE url GROUP BY `time`, country, url;
CREATE VIEW SELECT COUNT FROM PathTable WHERE `time`;
CREATE VIEW SELECT COUNT FROM PathTable WHERE `time` GROUP BY url;
CREATE VIEW SELECT COUNT FROM PathTable WHERE `time` GROUP BY country;
CREATE VIEW SELECT COUNT FROM PathTable WHERE `time` GROUP BY country, url;
CREATE VIEW SELECT COUNT FROM PathTable WHERE `time` GROUP BY `time`;
CREATE VIEW SELECT COUNT FROM PathTable WHERE `time` GROUP BY `time`, url;
CREATE VIEW SELECT COUNT FROM PathTable WHERE `time` GROUP BY `time`, country;
CREATE VIEW SELECT COUNT FROM PathTable WHERE `time` GROUP BY `time`, country, url;
CREATE VIEW SELECT COUNT FROM PathTable WHERE `time`, url;
CREATE VIEW SELECT COUNT FROM PathTable WHERE `time`, url GROUP BY url;
CREATE VIEW SELECT COUNT FROM PathTable WHERE `time`, url GROUP BY country;
CREATE VIEW SELECT COUNT FROM PathTable WHERE `time`, url GROUP BY country, url;
CREATE VIEW SELECT COUNT FROM PathTable WHERE `time`, url GROUP BY `time`;
CREATE VIEW SELECT COUNT FROM PathTable WHERE `time`, url GROUP BY `time`, url;
CREATE VIEW SELECT COUNT FROM PathTable WHERE `time`, url GROUP BY `time`, country;
CREATE VIEW SELECT COUNT FROM PathTable WHERE `time`, url GROUP BY `time`, country, url;



drop table PerfSlow;
CREATE TABLE PerfSlow
   (`time` TIME(WEEK,DAY,HOUR,MIN,SEC),
    page PATH('/'),
    loadTime LONG(1))
STORAGE default
PROPERTIES
    drill  = true,
    store  = true,
    strict = true
;
CREATE VIEW SELECT COUNT FROM PerfSlow;
CREATE VIEW SELECT COUNT FROM PerfSlow GROUP BY loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow GROUP BY page;
CREATE VIEW SELECT COUNT FROM PerfSlow GROUP BY page, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow GROUP BY `time`;
CREATE VIEW SELECT COUNT FROM PerfSlow GROUP BY `time`, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow GROUP BY `time`, page;
CREATE VIEW SELECT COUNT FROM PerfSlow GROUP BY `time`, page, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE loadTime GROUP BY loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE loadTime GROUP BY page;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE loadTime GROUP BY page, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE loadTime GROUP BY `time`;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE loadTime GROUP BY `time`, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE loadTime GROUP BY `time`, page;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE loadTime GROUP BY `time`, page, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE page;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE page GROUP BY loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE page GROUP BY page;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE page GROUP BY page, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE page GROUP BY `time`;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE page GROUP BY `time`, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE page GROUP BY `time`, page;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE page GROUP BY `time`, page, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE page, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE page, loadTime GROUP BY loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE page, loadTime GROUP BY page;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE page, loadTime GROUP BY page, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE page, loadTime GROUP BY `time`;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE page, loadTime GROUP BY `time`, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE page, loadTime GROUP BY `time`, page;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE page, loadTime GROUP BY `time`, page, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time`;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time` GROUP BY loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time` GROUP BY page;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time` GROUP BY page, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time` GROUP BY `time`;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time` GROUP BY `time`, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time` GROUP BY `time`, page;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time` GROUP BY `time`, page, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time`, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time`, loadTime GROUP BY loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time`, loadTime GROUP BY page;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time`, loadTime GROUP BY page, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time`, loadTime GROUP BY `time`;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time`, loadTime GROUP BY `time`, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time`, loadTime GROUP BY `time`, page;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time`, loadTime GROUP BY `time`, page, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time`, page;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time`, page GROUP BY loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time`, page GROUP BY page;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time`, page GROUP BY page, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time`, page GROUP BY `time`;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time`, page GROUP BY `time`, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time`, page GROUP BY `time`, page;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time`, page GROUP BY `time`, page, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time`, page, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time`, page, loadTime GROUP BY loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time`, page, loadTime GROUP BY page;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time`, page, loadTime GROUP BY page, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time`, page, loadTime GROUP BY `time`;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time`, page, loadTime GROUP BY `time`, loadTime;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time`, page, loadTime GROUP BY `time`, page;
CREATE VIEW SELECT COUNT FROM PerfSlow WHERE `time`, page, loadTime GROUP BY `time`, page, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow GROUP BY loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow GROUP BY page;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow GROUP BY page, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow GROUP BY `time`;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow GROUP BY `time`, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow GROUP BY `time`, page;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow GROUP BY `time`, page, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE loadTime GROUP BY loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE loadTime GROUP BY page;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE loadTime GROUP BY page, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE loadTime GROUP BY `time`;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE loadTime GROUP BY `time`, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE loadTime GROUP BY `time`, page;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE loadTime GROUP BY `time`, page, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE page;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE page GROUP BY loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE page GROUP BY page;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE page GROUP BY page, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE page GROUP BY `time`;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE page GROUP BY `time`, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE page GROUP BY `time`, page;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE page GROUP BY `time`, page, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE page, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE page, loadTime GROUP BY loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE page, loadTime GROUP BY page;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE page, loadTime GROUP BY page, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE page, loadTime GROUP BY `time`;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE page, loadTime GROUP BY `time`, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE page, loadTime GROUP BY `time`, page;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE page, loadTime GROUP BY `time`, page, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time`;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time` GROUP BY loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time` GROUP BY page;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time` GROUP BY page, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time` GROUP BY `time`;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time` GROUP BY `time`, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time` GROUP BY `time`, page;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time` GROUP BY `time`, page, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time`, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time`, loadTime GROUP BY loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time`, loadTime GROUP BY page;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time`, loadTime GROUP BY page, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time`, loadTime GROUP BY `time`;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time`, loadTime GROUP BY `time`, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time`, loadTime GROUP BY `time`, page;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time`, loadTime GROUP BY `time`, page, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time`, page;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time`, page GROUP BY loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time`, page GROUP BY page;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time`, page GROUP BY page, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time`, page GROUP BY `time`;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time`, page GROUP BY `time`, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time`, page GROUP BY `time`, page;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time`, page GROUP BY `time`, page, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time`, page, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time`, page, loadTime GROUP BY loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time`, page, loadTime GROUP BY page;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time`, page, loadTime GROUP BY page, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time`, page, loadTime GROUP BY `time`;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time`, page, loadTime GROUP BY `time`, loadTime;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time`, page, loadTime GROUP BY `time`, page;
CREATE VIEW SELECT AVG(loadTime) FROM PerfSlow WHERE `time`, page, loadTime GROUP BY `time`, page, loadTime;



drop table PerfFast;
CREATE TABLE PerfFast
   (`time` TIME(WEEK,DAY,HOUR,MIN,SEC),
    page PATH('/'),
    loadTime LONG(1))
STORAGE default
PROPERTIES
    drill  = true,
    store  = true,
    strict = true
;
CREATE VIEW SELECT COUNT FROM PerfFast;
CREATE VIEW SELECT AVG(loadTime) FROM PerfFast;

