Column name: character '#' not supported

1
votes

I am trying to create a hive table with a column name ending with '#' but I am getting the following error.

ParseException line 1:linenum character '#' not supported here

How can I fix this?

1
hivecharacterspecial-charactershiveqlcreate-table

1 Answers

1
votes

Read what documentation says:

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. Within a backtick string, use double backticks (``) to represent a backtick character.

Use backticks like this:

select 1 as `#column with #`;

Result:

#column with #  
1

If you create table with such column, then it will be possible to query only using backticks. This is not convenient though quite possible.