Support Questions

Find answers, ask questions, and share your expertise

Symbols in Column name

avatar
Explorer

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

1 REPLY 1

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