[SPARK-4239] [SQL] support view in HiveQl

Currently still not support view like 

CREATE VIEW view3(valoo) 
TBLPROPERTIES ("fear" = "factor")
AS SELECT upper(value) FROM src WHERE key=86;

because the text in metastore for this view is like

select `_c0` as `valoo` from (select upper(`src`.`value`) from `default`.`src` where ...) `view3`

while catalyst cannot resolve _c0 for this query.
For view without colname definition in parentheses, it works fine.