ql/src/test/queries/clientpositive/create_view_translate.q

--! qt:dataset:src
drop view if exists v_n7;
drop view if exists w;

create view v_n7 as select cast(key as string) from src;
describe formatted v_n7;

create view w as select key, value from (
  select key, value from src
) a;
describe formatted w;

drop view v_n7;
drop view w;


-- HIVE-4116 Can't use views using map datatype.

CREATE TABLE items (id INT, name STRING, info MAP<STRING,STRING>);

explain
CREATE VIEW priceview AS SELECT items.id, items.info['price'] FROM items;
CREATE VIEW priceview AS SELECT items.id, items.info['price'] FROM items;

select * from priceview;