Josh, I had looked through the documentation <https://phoenix.apache.org/views.html> and all the tests (core/../end2end) on CREATE/ALTER VIEW usage. I could not find appropriate documentation around this.
I am trying to ALTER VIEW as below and it doesn't seem to be supported. Here the STRVALUE is one of column in the original View. Appreciate any pointers. ALTER VIEW MY_VIEW_NAME ADD NUMVALUE DECIMAL TO_NUMBER(STRVALUE) On Fri, Jul 31, 2020 at 7:53 PM Josh Elser <els...@apache.org> wrote: > Yes. Please see the docs which illustrate how to create views. > > On 7/28/20 2:12 AM, Arun J wrote: > > Team, > > Can we create or alter a view to add a column which is pseudo columns > > such as > > > > # FULLNAME from other columns such as FIRSTNAME + LASTNAME > > # NUMVALUE from other columns TO_NUMBER(STRVALUE) > > > > This would be quite helpful to avoid changing data types everytime in > > the client query. > > > > Thanks in advance. > > JAK >