Create view in Hive with spaces in column names

Question

In Hive 0.7, is there any way to create a view with spaces in the column name? In SQL Server I'd do:

CREATE VIEW test_vw
AS 
SELECT col_name as [col name with spaces]
FROM   test_tbl;

Is there a hive equivalent?

We need the view with names for use by end user tools.

Answer 1

From Hive documentation:

In Hive 0.12 and earlier, only alphanumeric and underscore characters are allowed in table and column names.

In Hive 0.13 and later, column names can contain any Unicode character (see HIVE-6013). Any column name that is specified within backticks (`) is treated literally

Answer 2

You can use

CREATE VIEW test_vw
AS 
SELECT col_name as `col name with spaces`
FROM   test_tbl;