[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.
Since we may need some further modification in the TreeNode, I'd like to separate that from this part and do that in `createPlanForView()`. I'm not sure, we can discuss this further.
For case problem, Hive stores the table name with the original text without turn it into lowercase. And I think it is not necessary to convert that here. We can push this to reference resolving, as it already was there.