Details
Description
Failure while accessing the data from Hive view with Map datatype.
CREATE TABLE IF NOT EXISTS `test` (id INT, name STRING, attrs MAP<STRING,STRING>);
drop view if exists testview;
create view testview as
select test.name,test.attrs["mKey"]
from test;
select * from testview;
exception:
hive> select * from testview;
FAILED: SemanticException line 1:31 mismatched input '.' expecting FROM near '`test`' in from clause
in definition of VIEW testview [
select `test`.`name`,test`test`.`attrs`attrs["mKey"]
from `hivetest`.`test`
] used as testview at Line 1:14