Quoted identifiers in column names
- Dominant language
- Java
- Stars
- 3.1k
- Forks
- 1.6k
- Avg merge
- 3d 12h
- Merged PRs (30d)
- 33
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.
**Reporter**: [Michael Styles](https://issues.apache.org/jira/secure/ViewProfile.jspa?name=ptkool)
**Note**: *This issue was originally created as [PARQUET-677](https://issues.apache.org/jira/browse/PARQUET-677). Please see the [migration documentation](https://issues.apache.org/jira/browse/PARQUET-2502) for further details.*
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by reproducing the Hive example with the `Session Token` column and the failing insert into `parquet_table`. Trace the Parquet Java handling involved in the schema and insert path; done means quoted identifiers containing spaces are accepted and the insert succeeds without the reported field-name error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 38/100