New Contributor
Posts: 4
Registered: ‎10-12-2017

Symbols in Column name

[ Edited ]

I have a requirement where the column Name is something like this "Availability%", now I tried backticks, quotes etc.. nothing works and still throws error. 


when I use this column in the select query it works, but when I pack the select query in a view, it throws "invalid column" error.



Is there a possibility this will work in Impala ?



Cloudera Employee
Posts: 824
Registered: ‎03-23-2015

Re: Symbols in Column name

It will not work, you should remove all special characters in column names. There is no workarounds as far as I know.