Reply
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 ?

 

A

Cloudera Employee
Posts: 211
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.
Announcements