[ https://issues.apache.org/jira/browse/DRILL-7342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16905017#comment-16905017 ]
benj commented on DRILL-7342: ----------------------------- To avoid other surprise of this type, please look list of different rules applying in columns header of CSV with Drill at DRILL-7001 > Drill replacing spaces with underlines in the column names of text files with > headers > ------------------------------------------------------------------------------------- > > Key: DRILL-7342 > URL: https://issues.apache.org/jira/browse/DRILL-7342 > Project: Apache Drill > Issue Type: Bug > Reporter: Denys Ordynskiy > Priority: Major > > Drill doesn't allow to query csvh columns with spaces. > *Description:* > Update Drill ctas format option to generate text file with header: > {noformat} > set `store.format` = 'csvh'; > {noformat} > Create table with column names having spaces: > {noformat} > create table dfs.tmp.`csv table with spaces` (`Full Name`) as select 'James > Bond' from (values(1)); > {noformat} > Drill wrote column name with space: > {noformat} > hadoop fs -cat '/tmp/csv table with spaces/0_0_0.csvh' > {noformat} > |Full Name| > |James Bond| > Try to query this table without column name: > {noformat} > select * from dfs.tmp.`csv table with spaces`; > {noformat} > |{color:#ff0000}*Full_Name*{color}| > |James Bond| > {color:#ff0000}*Drill replaced space with underline.*{color} > Try to select `Full Name` column with space: > {noformat} > select `Full Name` from dfs.tmp.`csv table with spaces`; > {noformat} > Drill > |Full Name| > | | > When I changed space to underline, query returned the data: > {noformat} > select `Full_Name` from dfs.tmp.`csv table with spaces`; > {noformat} > |Full_Name| > |James Bond| > Drill can create csvh text files with spaces in the column names. But it's > impossible to request data using the original column name. > *Expected result* > Space should be available character in the column names. -- This message was sent by Atlassian JIRA (v7.6.14#76016)