question Phoenix on Hbase existing table - Upper/lowercase on col name in Archives of Support Questions (Read Only)

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

michelsumbul — Thu, 11 Aug 2016 20:18:58 GMT

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

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

asinghal — Thu, 11 Aug 2016 20:29:00 GMT

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;