[PARQUET-677] Quoted identifiers in column names

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: parquet-mr
• Assignee: Unassigned
• Reporter: Michael Styles
• Created: 15/Aug/16 12:40
• Updated: 23/Jun/24 03:28

Description

Add the ability to quote identifiers for columns in a table. This would allow column names to contain arbitrary characters such as spaces. Hive supports these types of identifiers using backquotes. For example,

create table parquet_table (`Session Token` string) stored as parquetfile;

However, attempting to insert a new row into this table results in an error.

insert into parquet_table values ('1234-45')

org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.IllegalArgumentException: field ended by ';': expected ';' but got 'token' at line 1: optional string Session Token

I would suggest using backquotes in Parquet as well.