[SPARK-4529] [SQL] support view with column alias

Support view definition like

CREATE VIEW view3(valoo) 
TBLPROPERTIES ("fear" = "factor")
AS SELECT upper(value) FROM src WHERE key=86;

[valoo as the alias of upper(value)]. This is missing part of SPARK-4239, for a fully view support.
What exactly is going on here?  Have we been doing this wrong all along? or is this a Hive version specific thing?