Phoenix on Hbase existing table - Upper/lowercase on col name

[#1]

Hello,

I create a phoenix view on an existing Hbase table wher all hte col family name are lowercas. the to be able to query it I have to put all the time " before and after every column name. It's a little bit annoysing, do you have a workaroung? 🙂

Thanks, Michel

[#2 · Accepted solution]

As sql dialect keywords are case insensitive , so Double quotes(") just helps parser to avoid converting them back to upper case.

May be you can create a another view over your current view with case insensitive column name. You may check the actual syntax on the site, JFYR

create view view2(col1 integer, col2 integer) as select "col1","col2" from view1;