CREATE DATABASE tv;
CREATE VIEW tv.testView as SELECT * FROM srcpart;
DESCRIBE FORMATTED tv.testView;

ALTER VIEW tv.testView AS SELECT value FROM src WHERE key=86;
DESCRIBE FORMATTED tv.testView;

ALTER VIEW tv.testView AS
SELECT * FROM src
WHERE key > 80 AND key < 100
ORDER BY key, value
LIMIT 10;
DESCRIBE FORMATTED tv.testView;

DROP VIEW tv.testView;
DROP DATABASE tv;